22
« on: January 26, 2009, 03:32:43 pm »
Hi,
Thanks for the reply. I've enabled debug mode - here are the errors and stack-traces:
For issue #1:
Query failed with message 'Unknown column 'oid' in 'where clause''
Error params:
File: /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 386
Stack-trace:
#0 /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/adapters/AbstractDBAdapter.class.php(272): AbstractDBAdapter->prepareAndExecute('SELECT count(*)...', NULL)
#1 /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/DB.class.php(146): AbstractDBAdapter->execute('SELECT count(*)...', NULL)
#2 /srv/www/htdocs/networkmail.eu/extranet/test/application/controllers/ContactController.class.php(194): DB::execute('SELECT count(*)...')
#3 /srv/www/htdocs/networkmail.eu/extranet/test/application/controllers/ContactController.class.php(103): ContactController->countContactObjects('Internal Develo...', NULL, NULL)
#4 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/controller/Controller.class.php(69): ContactController->list_all()
#5 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/controller/PageController.class.php(62): Controller->execute('list_all')
#6 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/Env.class.php(125): PageController->execute('list_all')
#7 /srv/www/htdocs/networkmail.eu/extranet/test/init.php(148): Env::executeAction('contact', 'list_all')
#8 /srv/www/htdocs/networkmail.eu/extranet/test/index.php(9): require('/srv/www/htdocs...')
#9 {main}
For issue #3:
Same error as #1, stack-trace:
#0 /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/adapters/AbstractDBAdapter.class.php(272): AbstractDBAdapter->prepareAndExecute('SELECT 'Commen...', NULL)
#1 /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/DB.class.php(146): AbstractDBAdapter->execute('SELECT 'Commen...', NULL)
#2 /srv/www/htdocs/networkmail.eu/extranet/test/application/models/comments/Comments.class.php(75): DB::execute('SELECT 'Commen...')
#3 /srv/www/htdocs/networkmail.eu/extranet/test/application/controllers/DashboardController.class.php(71): Comments::getSubscriberComments(NULL, 'Internal Develo...')
#4 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/controller/Controller.class.php(69): DashboardController->index()
#5 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/controller/PageController.class.php(62): Controller->execute('index')
#6 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/Env.class.php(125): PageController->execute('index')
#7 /srv/www/htdocs/networkmail.eu/extranet/test/init.php(148): Env::executeAction('dashboard', 'index')
#8 /srv/www/htdocs/networkmail.eu/extranet/test/index.php(9): require('/srv/www/htdocs...')
#9 {main}
For isse #4:
Same error as #1 and 3, stack-trace:
#0 /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/adapters/AbstractDBAdapter.class.php(272): AbstractDBAdapter->prepareAndExecute('SELECT count(*)...', NULL)
#1 /srv/www/htdocs/networkmail.eu/extranet/test/environment/library/database/DB.class.php(146): AbstractDBAdapter->execute('SELECT count(*)...', NULL)
#2 /srv/www/htdocs/networkmail.eu/extranet/test/application/controllers/ContactController.class.php(194): DB::execute('SELECT count(*)...')
#3 /srv/www/htdocs/networkmail.eu/extranet/test/application/controllers/ContactController.class.php(103): ContactController->countContactObjects('Internal Develo...', NULL, NULL)
#4 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/controller/Controller.class.php(69): ContactController->list_all()
#5 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/controller/PageController.class.php(62): Controller->execute('list_all')
#6 /srv/www/htdocs/networkmail.eu/extranet/test/environment/classes/Env.class.php(125): PageController->execute('list_all')
#7 /srv/www/htdocs/networkmail.eu/extranet/test/init.php(148): Env::executeAction('contact', 'list_all')
#8 /srv/www/htdocs/networkmail.eu/extranet/test/index.php(9): require('/srv/www/htdocs...')
#9 {main}
As you can see it all points to a missing database column "oid".
I did run the 1.1 to 1.2 upgrade script after I'd updated the files (by visiting /public/upgrade), and it told me that my database was already up-to-date, so perhaps the database updates haven't been applied correctly?
For issue #5 - my bad I hadn't realised IMAP wasn't installed. However I should still have the option to edit the account, even if IMAP isn't supported. For example what if a user did legitimately create an account as IMAP when it should have been POP, but they didn't have IMAP on their server so you couldn't go back to change it, or delete the account?
A suggestion - why not detect if IMAP support is available, and if it isn't, only let users create POP accounts? You could use PHP's function_exists passing in "imap_open" to accomplish this.
Many thanks,
Andy