Unable to add issues in webclient and windows client

Submitted by sschueller on 2011-09-05

Fresh install

Client and Server: 1.0-beta1
Database version: 1.0.001
PHP version: 5.3.3-7+squeeze3 (apache2handler)
Web server: Apache/2.2.16 (Debian)
Database server: MySQL 5.1.49-3

When adding an issue with required fields filled in I get the following error:

Unexpected Error
An unexpected error occured while processing the request.

The issues will appear in the issues table but nothing in the issues_stubs. Can't delete or edit he issue from the clients.

The log contains (absolute path removed for privacy):

Unhandled System_Db_Exception: Prepared statement needs to be re-prepared in /public_html/system/db/mysqli/engine.inc.php on line 129
Stack trace:
#0 /public_html/system/db/mysqli/engine.inc.php(90): System_Db_Mysqli_Engine->executeStatement('SELECT ch.chang...', Array)
#1 /public_html/system/db/connection.inc.php(238): System_Db_Mysqli_Engine->query('SELECT ch.chang...', Array)
#2 /public_html/system/db/connection.inc.php(380): System_Db_Connection->queryArgs('SELECT ch.chang...', Array)
#3 /public_html/client/issuedetails.inc.php(98): System_Db_Connection->queryPageArgs('SELECT ch.chang...', 'ch.change_id AS...', 20, 0, Array)
#4 /public_html/system/web/component.inc.php(100): Client_IssueDetails->execute()
#5 /public_html/system/web/view.inc.php(247): System_Web_Component->run()
#6 /public_html/client/index.html.php(6): System_Web_View->insertComponent('Client_IssueDet...')
#7 /public_html/system/web/view.inc.php(284): include('/home/zimtdesig...')
#8 /public_html/system/web/view.inc.php(217): System_Web_View->executeTemplate()
#9 /public_html/system/web/component.inc.php(102): System_Web_View->render()
#10 /public_html/system/web/application.inc.php(77): System_Web_Component->run()
#11 /public_html/system/core/application.inc.php(206): System_Web_Application->execute()
#12 /public_html/system/bootstrap.inc.php(124): System_Core_Application->run()
#13 /public_html/client/index.php(60): System_Bootstrap::run('Common_Applicat...', 'Client_Index')
#14 {main}

Any suggestion on what I can try?

Thanks

This issue seems to have been resolved in the current trunk.

Thanks

According to this post on stackoverflow, this is related to a strange bug in MySQL. Perhaps transactions added in trunk somehow fix this.

Regards,
Michał