(gs):MySQL 5 functions

  • This page was last modified on December 20, 2010, at 12:20.
The (mt) Community Wiki is a collaborative project. Any (mt) Media Temple customer or employee may contribute. Not all articles and/or content have been tested for accuracy by (mt) Media Temple.

For officially moderated and tested articles, be sure to visit our KnowledgeBase.

From (mt) Community Wiki

MySQL 5 functions are now fully available on the (gs) Grid-Service for PHP 5, across all Clusters. The MySQL Client version is 5.0.32. Any MySQL features available with that version are now working.

  • On Clusters 1-3, you can request access to the MySQL 5 Beta program. Please open a support request for further assistance.

Symptoms

You use MySQL 5 functions in your PHP script or web application, and receive a compatibility error. Sample error: 

Warning: mysqli_stmt::bind_result() [mysqli-stmt.bind-result]: Server returned unknown type 246.
Probably your client library is incompatible with the server version you use!

Diagnosis

You are likely using PHP 4 for that domain, or are on Clusters 1-3 and have not opted into the Beta program for MySQL 5.

Resolution

Make sure that you have your domain set to use PHP 5. See this article for instructions:

For Clusters 1-3, please open a support request for access to the MySQL 5 Beta program.

For specific coding issues, consult our user forums for further assistance.

Retrieved from "http://wiki.mediatemple.net/w/(gs):MySQL_5_functions"