Stoli Server SQL problems

[rssched]

Hi there, as of 7pm central or so today, my website has been having problems with sql queries (seems to be unresponsive or something). For example, i query the table to return the number of entries, and it returns 0 (when before it would query the correct amount). The table has 200+ entries and it doesn't see that.

Also every time I use the queries (4-5 times) nothing is returned. What could the problem be? I am on the Stoli server and this is making my website pretty much useless with the database access.

Thanks,
Ryan

 

[Smith6612]

Stoli is under some work at the moment which is causing some problems with cPanel and MySQL. x10Hosting is working to fix the problems though, so once things settled out your tables should begin to show up again.

 

[rssched]

thanks for the info. however, it seems the server is up and running normal according to this: http://forums.x10hosting.com/service-alerts/102789-stoli-cpanel-update.html

But my problem still exists. What could be causing the SQL not to retrieve results when it worked fine 7 hours ago and now it doesnt.

 

[Jarryd]

Hello, what is the host your are using to connect to the MySQL database?

 

[alexusg]

Before the SQL server went down I had the SQL host set to 'localhost', after the server went down I changed it to 'mysql-stoli.x10hosting.com' and things worked great. Just a heads up to anyone using CMS..

 

[Jarryd]

Hello, can you try changing it to localhost, just to test if there is an issue with the host? If it doesn't work, change it back.

 

[rssched]

thank you all for the tips. originally i used localhost, but that no longer worked. i changed that to "mysql-stoli.x10hosting.com" and everything is back to normal.

thanks!
-Ryan