Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - miguelazov

Pages: [1]
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 :P


Pages: [1]