New mail not showing in Inbox

[gueland]

 :DI am using Roundcube Webmail 0.8.3 on a qmail server.  I have new mail in my new folder on qmail but no new mail messages are showing in Roundcube.

Can you help?  I am using Qmailtoaster on CentOS 5.8 with PHP 5.3.18.

[SKaero]

Enable imap_debug and post the log.

[gueland]

This is the entire imap log in /var/www/roundcube/logs after I enabled it.

[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0006 OK STATUS Completed.
[12-Nov-2012 20:56:38 -0600]: [65F1] C: A0007 STATUS INBOX.Trash (MESSAGES UNSEEN)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: * STATUS "INBOX.Trash" (MESSAGES 0 UNSEEN 0)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0007 OK STATUS Completed.
[12-Nov-2012 20:56:38 -0600]: [65F1] C: A0008 STATUS INBOX.Archive (MESSAGES UNSEEN)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: * STATUS "INBOX.Archive" (MESSAGES 0 UNSEEN 0)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0008 OK STATUS Completed.
[12-Nov-2012 20:56:38 -0600]: [65F1] C: A0009 LOGOUT
[12-Nov-2012 20:56:38 -0600]: [65F1] S: * BYE Courier-IMAP server shutting down
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0009 OK LOGOUT completed

[gueland]

Here is what "tail errors" gives me:

[12-Nov-2012 20:56:35 America/Winnipeg] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3e8118ab96692537f4a186e98b6724d0a5efa0d4c FROM 'SELECT * FROM accounts WHERE user_id=?']
[Native code: 1146]
[Native message: Table 'roundcubemail.accounts' doesn't exist]

[12-Nov-2012 20:56:35 -0600]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3e8118ab96692537f4a186e98b6724d0a5efa0d4c FROM 'SELECT * FROM accounts WHERE user_id=?']
[Native code: 1146]
[Native message: Table 'roundcubemail.accounts' doesn't exist]
in /var/www/roundcube/program/include/rcube_mdb2.php on line 296 (GET /?_task=mail)

[gueland]

here are the tables in roundcubemail database:

+-------------------------+
| Tables_in_roundcubemail |
+-------------------------+
| cache                   |
| cache_index             |
| cache_messages          |
| cache_thread            |
| contactgroupmembers     |
| contactgroups           |
| contacts                |
| dictionary              |
| events                  |
| events_cache            |
| events_caldav           |
| forgot_password         |
| identities              |
| reminders               |
| searches                |
| session                 |
| users                   |
+-------------------------+

[SKaero]

The imap log shows that the server isn't finding any messages, the error log seems to show that the accounts plugin isn't setup correctly.

[gueland]

My fault for not setting up the sql script from the accounts plugin.  But now, after setting it up, I can see my new messages, but my old ones have disappeared!

[gueland]

Also, my fault.  My script to sync the mail in the old server to the new one had an error.  I forgot to add the "/" after everything (a problem when cutting and pasting between text files, excel and back)  The server seems to be running fine now.