Topics

1

Installation problems / Error after upgrade from 2.5.1-beta to 2.5.1

« on: February 27, 2014, 01:24:34 pm »

Hello,

After upgrading from 2.5.1-beta to 2.5.1 by following the update-instructions, there is an error occuring while retrieving e-mail (IMAP, from imap.gmail.com).

In the logging the error is logged as mentioned at the end of this post.

Before upgrading, so while using 2.5.1-beta, the e-mail retrieving didn't work at all (no errors logged), although the settings (like the fetch-limit) were set OK (unlimited). It's a clean install of 2.5.1-beta.

Is anyone experiencing the same problems? Anyone a suggestion for solving this problem?

Thanks for your replies!

-----------LOG------------

Session "default" started at 2014-02-27T16:11:14+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'e.conversation_last' in 'where clause'' -
                 SELECT SQL_CALC_FOUND_ROWS * FROM fo_objects o
                 INNER JOIN  fo_mail_contents e ON e.object_id = o.id
                 
                 
                 WHERE
                    EXISTS (
                                     SELECT object_id FROM fo_sharing_table sh
                                     WHERE o.id = sh.object_id
                                     AND sh.group_id  IN (
                                                    SELECT permission_group_id FROM fo_contact_permission_groups WHERE contact_id = 2
                                                    )
                               )
                   AND    true
                   AND o.object_type_id = 22
                   AND `o`.`trashed_on` = '0000-00-00 00:00:00' AND `o`.`archived_on` = '0000-00-00 00:00:00'  AND e.account_id = '3'   AND e.conversation_last = 1 AND  e.state IN ('0','5')
                ORDER BY `received_date` DESC
                 LIMIT 0 , 50
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'e.conversation_last' in 'where clause''' in D:\inetpub\vhosts\XXXX\environment\library\database\adapters\AbstractDBAdapter.class.php:392
    Stack trace:
    #0 D:\inetpub\vhosts\XXXX\environment\library\database\adapters\AbstractDBAdapter.class.php(310): AbstractDBAdapter->prepareAndExecute('?    ?SELECT...', NULL)
    #1 D:\inetpub\vhosts\XXXX\environment\library\database\DB.class.php(213): AbstractDBAdapter->executeAll('?    ?SELECT...', NULL)
    #2 D:\inetpub\vhosts\XXXX\application\models\ContentDataObjects.class.php(484): DB::executeAll('?    ?SELECT...')
    #3 D:\inetpub\vhosts\XXXX\plugins\mail\application\models\mail_contents\MailContents.class.php(290): ContentDataObjects->listing(Array)
    #4 D:\inetpub\vhosts\XXXX\plugins\mail\application\controllers\MailController.class.php(2598): MailContents->getEmails('3', 'received', 'all', 'all', Array, '0', '50', '`received_date`', 'DESC', Array, NULL, 1)
    #5 D:\inetpub\vhosts\XXXX\plugins\mail\application\controllers\MailController.class.php(2563): MailController->getEmails(Array, Array, '0', '50', '`received_date`', 'DESC', Array, 1)
    #6 D:\inetpub\vhosts\XXXX\environment\classes\controller\Controller.class.php(76): MailController->list_all()
    #7 D:\inetpub\vhosts\XXXX\environment\classes\controller\PageController.class.php(62): Controller->execute('list_all')
    #8 D:\inetpub\vhosts\XXXX\environment\classes\Env.class.php(129): PageController->execute('list_all')
    #9 D:\inetpub\vhosts\XXXX\init.php(173): Env::executeAction('mail', 'list_all')
    #10 D:\inetpub\vhosts\XXXX\index.php(9): require('D:\inetpub\vhos...')
    #11 {main}

2

How To's / No authenticate dialog 'administration'

« on: October 27, 2013, 06:43:43 am »

Using version 2.3.2.1 on my own server with PHP version 5.5.

I've a problem after selecting the option 'Authenticate administration' in administration/configuration/general.

When I go to the 'administration' (while logged in as a SuperAdministrator) I don't get the authentication dialog that should appear according to the helptext displayed at the option 'Authenticate administration'. A message telling that the user has no permission is displayed.

It feels like that the user is locked-out of accessing administration. (And that's needed to de-select the option.)

Anyone having tips for solving this problem. (Either de-selecting the option or in getting the authentication dialog.)

Additional information :
- Problem occurs in 'fresh' installations, not in upgraded installations.
- The problem occurs in different browsers.
- Superadministrator-account (with the name 'admin') has the problem, an user with administrator-account hasn't got the trouble. (So, for now I de-activated the option through another account.)