Login Problems after Upgrade from 1.0.6 to 1.0.7RC1

[MasterTH]

Hello,

sry for my bad english, but nuxwin suggested me to post this problem in the english spoken section. German Thread

First, i know thats not really good to use an RC in a productive environment, but in past i made good expiriences with RCs from ispcp, also nightly versions.

Now the problem,
I updated my ISPCP-Installation vom 1.0.6 to 1.0.7 on sunday. After that, the login into the Admin-Section wasn't possible. I always encouter into following Error-Message

Code:

Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. - Query: SELECT `admin_id`, `created_by`, `admin_type` FROM `admin` WHERE `admin_id` = ? ;

After this i recieve an email from system:

Code:

Dear admin,

An exception with the following message was raised in file
/var/www/ispcp/gui/include/sql.php (Line: 90):

=================================================================

Cannot execute queries while other unbuffered queries are active.
Consider using PDOStatement::fetchAll(). Alternatively, if your code
is only ever going to run against mysql, you may enable query
buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
- Query:
SELECT
*
FROM
`custom_menus`
WHERE
`menu_level` = 'admin'
;

=================================================================

Debug backtrace:
---------------

File: /var/www/ispcp/gui/include/admin-functions.php (Line: 144)
Function: exec_query()
File: /var/www/ispcp/gui/admin/index.php (Line: 188)
Function: gen_admin_mainmenu()

Additional information:
----------------------

Http User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 ( .NET CLR 3.5.30729)
Request Uri: /admin/index.php
Remote Addr: 79.240.206.86
Server Addr:

after this, i thougt make an reupgrade to 1.0.6 will fix my problems, but this wasn't really good. After that no Mail-Access was possible. So i went back to 1.0.7RC1. I found out that the problem was in double-crypting the passwords in the database. After replacing the mail_users table with a backup the regeneration process for mailboxes set the right passwords.


my server is running under etch, php5.2.0-etch8... (if u need something else, please ask me, i'll try to give it to you)


Yesterday i searched a long time in google and this forum. Then i tried to change

Code:

        if (version_compare(PHP_VERSION, '5.2.5', '<')) {
            if (preg_match('/(ALTER |CREATE |DROP |GRANT |REVOKE |FLUSH )/i',
                $stmt)) {

                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, true);
            } else {
                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, false);
            }
        }

into

Code:

        if (version_compare(PHP_VERSION, '5.2.5', '<')) {
            if (preg_match('/(ALTER |CREATE |DROP |GRANT |REVOKE |FLUSH )/i',
                $stmt)) {

                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, true);
            } else {
                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, true);
            }
        }

after this i always recieve the message, that passwords incorrect. but i know there's an option to set a new password. tried this for an domain-account. Entered the new sent password, nothing happens, just get back to the login-page.


Right now, the Admin-Login doesn't work, and i don't know what else to do...


Please help. Thanks a lot!!!