1
Feng Office 2 / Re: Email Issue
« on: February 01, 2012, 05:24:13 pm »
See the cache/log.php and:
SELECT `uid` FROM `fo_mail_contents` WHERE `account_id` = 3 AND `imap_folder_name` = 'INBOX' AND id = (SELECT max(id) FROM `fo_mail_contents` WHERE `account_id` = 3 AND `state` < 2)
#1054 - Unknown column 'id' in 'where clause'
Change 'id' field by 'uid' (2 coincidences)
SELECT `uid` FROM `fo_mail_contents` WHERE `account_id` = 3 AND `imap_folder_name` = 'INBOX' AND uid = (SELECT max(uid) FROM `fo_mail_contents` WHERE `account_id` = 3 AND `state` < 2)
Showing rows 0 - 0 ( 1 total, Query took 0.0012 sec)
I am not sure that it's the final solution but the id does not exist in 2.0 rc3.
I am trying to find where is generate the query.
PD: sorry but my english is not very good looking
SELECT `uid` FROM `fo_mail_contents` WHERE `account_id` = 3 AND `imap_folder_name` = 'INBOX' AND id = (SELECT max(id) FROM `fo_mail_contents` WHERE `account_id` = 3 AND `state` < 2)
#1054 - Unknown column 'id' in 'where clause'
Change 'id' field by 'uid' (2 coincidences)
SELECT `uid` FROM `fo_mail_contents` WHERE `account_id` = 3 AND `imap_folder_name` = 'INBOX' AND uid = (SELECT max(uid) FROM `fo_mail_contents` WHERE `account_id` = 3 AND `state` < 2)
Showing rows 0 - 0 ( 1 total, Query took 0.0012 sec)
I am not sure that it's the final solution but the id does not exist in 2.0 rc3.
I am trying to find where is generate the query.
PD: sorry but my english is not very good looking
