Website was working 3 days ago, now I am getting mysqli errors. Why and what changed?

Asked by:
MatthewCrist / 8 Points
Time:
2013-07-18 9:03 am EST
Category:
Website
Hits:
607
I made an update to my website on Sunday. The site completely works on local and was working perfectly fine on the early morning hours of Monday (7/15/2013). Now I am getting all kinds of errors with MySQLi and sessions. What changed and why? I have not made any changes since this time.

To ask this user for more information, please first login.

To submit an answer, please login.

I've checked all my error logs and there are no issues with regards to MySQL statement errors. It is as if the server is rejecting my connection to the server.
MatthewCrist
8 Points
2013-07-18 09:14 am EST
I've reset the user and the password connecting to the database. This has not resolved the issue.
MatthewCrist
8 Points
2013-07-18 09:24 am EST
So here's the issue:

I call mysql_stmt->fetch_result, which is apparently no longer valid. Why this was changed without informing us of the change is beyond me at this point. I'm sure if there was a change that occurred in PHP config, we should have at least been informed. I am forced to rewrite portions of my site in order to get it to function properly, which means I must mysql_stmt->bind_result in order to acquire the results. This is frustrating to say the least, but I can fix the issue.
MatthewCrist
8 Points
2013-07-18 12:01 pm EST
http://php.net/manual/en/mysqli-stmt.get-result.php

Native driver not enabled?
MatthewCrist
8 Points
2013-07-18 12:13 pm EST
I created a phpinfo file and seen that mysqlind is not listed as your mysqli driver anymore. Are there any plans to reenable this as my current website will no longer function without and consider this change to be a deal breaker for me?
MatthewCrist
8 Points
2013-07-18 02:15 pm EST
They are calling it a programming error. <.<

This topic is thoroughly documented as the mysqli_stmt::get_result is a function that is defined in the native driver which is disabled or not built into the last update they did. Regardless, support sucked, and it was like talking to a brick wall.
MatthewCrist
8 Points
2013-07-18 08:29 pm EST

Best answer chosen by User

1

JacobN
Staff
3,713 Points
2013-07-18 10:55 pm EST
Hello MatthewCrist, and thanks for your question, and sorry for the troubles!

Did you attempt to change the version of PHP on your account either Sunday or Monday? It looks like I found a bug in the cPanel PHP version switcher, which commented in the .htaccess file on your account the version of PHP to use, but it didn't actually include the proper AddHandler command to make that change active.

I've gone ahead and put your account to PHP 5.4 which I assume is what you must have been using prior to these problems, as PHP 5.3 and below on our server were not compiled with mysqlnd which is required for the mysqli_stmt::get_result() PHP method.

You particular server should have this problem fixed now, and I talked to our senior system administration team to ensure this bug is resolved across all of our other servers as well.

Please let us know if you're still experiencing any issues at all!

- Jacob

To submit a comment on this answer, please first login.

ANSWERS

0

johnpaulb-whh2
Staff
12,339 Points
2013-07-18 4:53 pm EST
Hello MathewCrist,

Thank you for your questions. Last night we updated the PHP version on your server from PHP 5.3 to version 5.3.27. If you are experiencing issues with this version, reverting your PHP version back to 5.2 in cpanel may help.

We are happy to assist you further, but when I navigated to your site there is a maintenance page up. I will need to replicate and see the specific error to provide a more detailed fix.

Please respond with the full error message, or put the site back up so I can replicate the error.

Also, since this is a public forum, if you want to provide more information in a secure setting, you can contact Live Tech Support.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul

To submit a comment on this answer, please first login.

Site is updated. You can notice the issue on the right. I have updated the front section to accept a different form of querying results currently.
MatthewCrist
8 Points

2013-07-18 4:57 pm EST
Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.
}