• Welcome to Simple Machines Community Forum. Please login or sign up.

Handle MySQL "version_comment" bug a little better...

Started by shawnb61, November 24, 2017, 02:33:14 PM

Previous topic - Next topic

shawnb61

November 24, 2017, 02:33:14 PM Last Edit: November 24, 2017, 07:35:10 PM by shawnb61
This is more a MySQL bug, but since it is an SMF supported version of MySQL, we might want to at the very least handle it more gracefully. 

Certain versions of MySQL 5.0.x have a bug where they will return a hard error when certain system variables are SELECTed. 

More info on the MySQL bug here:
https://bugs.mysql.com/bug.php?id=15684

We query version_comments, one of the impacted variables, in smf_db_get_engine().

Two SMF 2.0.15+ support cases here:
https://www.simplemachines.org/community/index.php?topic=557279.0
https://www.simplemachines.org/community/index.php?topic=557246.0

We may want to consider handling this error more gracefully.   

Note that I believe the ONLY functions impacted are the 'Administration Center' and 'Support and Credits'.  Which don't really do anything, so users can work around this pretty easily. 

Hope this makes sense.  Any questions, let me know.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Arantor

There's even precedent for this - look for the MySQL 5.0.51-52 patch.
No good deed goes unpunished
All helpful urges should be circumvented

albertlast


Arantor

No good deed goes unpunished
All helpful urges should be circumvented

Advertisement: