Error No: 1064

Hi to all. I'm new and I have a problem.
I migrated a site to a shared hosting server and at first time everything was good. But suddenly I took this message:

Warning: str_replace() expects at least 3 parameters, 1 given in /home/xxxxxxx/public_html/index.php on line 53

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') = 'http:///'' at line 1
Error No: 1064
SELECT * FROM oc_store WHERE REPLACE(`url`) = 'http:///' in /home/xxxxxxx/public_html/system/database/mysql.php on line 50

Do you know what is it and how to fix it?

Thanks a lot!

jamp wrote:I migrated a site to a shared hosting server and at first time everything was good. But suddenly I took this message:

Code: Select all

Warning: str_replace() expects at least 3 parameters, 1 given in /home/xxxxxxx/public_html/index.php on line 53

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') = 'http:///'' at line 1
Error No: 1064
SELECT * FROM oc_store WHERE REPLACE(`url`) = 'http:///' in /home/xxxxxxx/public_html/system/database/mysql.php on line 50

Do you know what is it and how to fix it?

This is not a problem with any of your files.

Did your web site or web pages, or even your cpanel have trouble loading before it happened? Probably so, but it's nothing you did. It's the people running your web hosting.

Whenever you see an error that mentions SQL, it immediately means the people that run your web hosting are sitting behind a computer somewhere and playing stop and go with your server by flipping a switching on and off.

This happens with shared hosting when the web hosting crams too many accounts onto one server, and/or when servers are old and problematic.

I'm actually dealing with this issue at the moment, and I may have to switch to another web host if it continues.