User receives error when trying to log in.
Unexpected Error
An unexpected error occured while processing the request.
error log shows the following.
Type: Errors
Severity: Error Error
Date: 2/5/2014 6:41 am
Message: Unhandled System_Db_Exception: in /home/rvsuper8cpanel/public_html/webissues/system/db/mysqli/engine.inc.php on line 287
Stack trace:
#0 /home/rvsuper8cpanel/public_html/webissues/system/db/mysqli/engine.inc.php(110): System_Db_Mysqli_Engine->handleError(Object(mysqli))
#1 /home/rvsuper8cpanel/public_html/webissues/system/db/mysqli/engine.inc.php(90): System_Db_Mysqli_Engine->executeStatement('SELECT COUNT(*)...', Array)
#2 /home/rvsuper8cpanel/public_html/webissues/system/db/connection.inc.php(256): System_Db_Mysqli_Engine->query('SELECT COUNT(*)...', Array)
#3 /home/rvsuper8cpanel/public_html/webissues/system/db/connection.inc.php(356): System_Db_Connection->queryArgs('SELECT COUNT(*)...', Array)
#4 /home/rvsuper8cpanel/public_html/webissues/system/db/connection.inc.php(343): System_Db_Connection->queryScalarArgs('SELECT COUNT(*)...', Array)
#5 /home/rvsuper8cpanel/public_html/webissues/system/api/projectmanager.inc.php(632): System_Db_Connection->queryScalar('SELECT COUNT(*)...', 5, 2)
#6 /home/rvsuper8cpanel/public_html/webissues/client/projectstree.inc.php(63): System_Api_ProjectManager->getProjectsCount()
#7 /home/rvsuper8cpanel/public_html/webissues/system/web/component.inc.php(100): Client_ProjectsTree->execute()
#8 /home/rvsuper8cpanel/public_html/webissues/system/web/view.inc.php(247): System_Web_Component->run()
#9 /home/rvsuper8cpanel/public_html/webissues/client/index.html.php(22): System_Web_View->insertComponent('Client_Projects...')
#10 /home/rvsuper8cpanel/public_html/webissues/system/web/view.inc.php(284): include('/home/rvsuper8c...')
#11 /home/rvsuper8cpanel/public_html/webissues/system/web/view.inc.php(217): System_Web_View->executeTemplate()
#12 /home/rvsuper8cpanel/public_html/webissues/system/web/component.inc.php(102): System_Web_View->render()
#13 /home/rvsuper8cpanel/public_html/webissues/system/web/application.inc.php(77): System_Web_Component->run()
#14 /home/rvsuper8cpanel/public_html/webissues/system/core/application.inc.php(210): System_Web_Application->execute()
#15 /home/rvsuper8cpanel/public_html/webissues/system/bootstrap.inc.php(130): System_Core_Application->run()
#16 /home/rvsuper8cpanel/public_html/webissues/client/index.php(61): System_Bootstrap::run('Common_Applicat...', 'Client_Index')
#17 {main}
User name: tester2
Host name: 69.132.25.xxx
+1
I get the same error when logged as normal user. For admins login works fine.
Unhandled System_Db_Exception: Prepared statement needs to be re-prepared in /data/web/virtuals/61611/virtual/www/subdom/it/system/db/mysqli/engine.inc.php on line 287
Stack trace:
#0 /data/web/virtuals/61611/virtual/www/subdom/it/system/db/mysqli/engine.inc.php(129): System_Db_Mysqli_Engine->handleError(Object(mysqli_stmt))
#1 /data/web/virtuals/61611/virtual/www/subdom/it/system/db/mysqli/engine.inc.php(90): System_Db_Mysqli_Engine->executeStatement('SELECT COUNT(*)...', Array)
#2 /data/web/virtuals/61611/virtual/www/subdom/it/system/db/connection.inc.php(256): System_Db_Mysqli_Engine->query('SELECT COUNT(*)...', Array)
#3 /data/web/virtuals/61611/virtual/www/subdom/it/system/db/connection.inc.php(356): System_Db_Connection->queryArgs('SELECT COUNT(*)...', Array)
#4 /data/web/virtuals/61611/virtual/www/subdom/it/system/db/connection.inc.php(343): System_Db_Connection->queryScalarArgs('SELECT COUNT(*)...', Array)
#5 /data/web/virtuals/61611/virtual/www/subdom/it/system/api/projectmanager.inc.php(632): System_Db_Connection->queryScalar('SELECT COUNT(*)...', 5, 2)
#6 /data/web/virtuals/61611/virtual/www/subdom/it/client/projectstree.inc.php(63): System_Api_ProjectManager->getProjectsCount()
#7 /data/web/virtuals/61611/virtual/www/subdom/it/system/web/component.inc.php(100): Client_ProjectsTree->execute()
#8 /data/web/virtuals/61611/virtual/www/subdom/it/system/web/view.inc.php(247): System_Web_Component->run()
#9 /data/web/virtuals/61611/virtual/www/subdom/it/client/index.html.php(22): System_Web_View->insertComponent('Client_Projects...')
#10 /data/web/virtuals/61611/virtual/www/subdom/it/system/web/view.inc.php(284): include('/data/web/virtu...')
#11 /data/web/virtuals/61611/virtual/www/subdom/it/system/web/view.inc.php(217): System_Web_View->executeTemplate()
#12 /data/web/virtuals/61611/virtual/www/subdom/it/system/web/component.inc.php(102): System_Web_View->render()
#13 /data/web/virtuals/61611/virtual/www/subdom/it/system/web/application.inc.php(77): System_Web_Component->run()
#14 /data/web/virtuals/61611/virtual/www/subdom/it/system/core/application.inc.php(210): System_Web_Application->execute()
#15 /data/web/virtuals/61611/virtual/www/subdom/it/system/bootstrap.inc.php(130): System_Core_Application->run()
#16 /data/web/virtuals/61611/virtual/www/subdom/it/client/index.php(61): System_Bootstrap::run('Common_Applicat...', 'Client_Index')
#17 {main}
If you google around a bit, you will see that this is not a problem specific to WebIssues, but related to MySQL and PHP in general. I hope you can find some solution.
Regards,
Michał