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!!!
Search
Member List
Calendar
Help
/
Login Problems after Upgrade from 1.0.6 to 1.0.7RC1
