Search the Community
Showing results for tags 'sql syntax error'.
Hello everybody, last night I was creating by inserting new discounts in the "price catalog rules" paragraph when I accidentally clicked on the reorder by date and the following error appeared: You have an error in your SQL syntax; for the right syntax to use near 'from DESC LIMIT 0, 50' at line 11 what can I do? I have already performed a complete restore of the site but nothing .. ideas? I should resolve by Friday ...
Hi all, Really hoping someone can help me out with this one. I've been banging my head on the walls. 🥺 As mentioned in the title, I'm trying to update the 'alias' field in the ps_address table in my database. Currently it simply says "My address" but I need it to be in Japanese and read "自分の住所". I've tried to run this SQL command : However it just tells me I'm not very familiar with SQL. Can anyone tell me how to fix this? Thanks in advance
Hi, I'm a complete novice at all this...would someone please assist me with the following: Error while inserting data in the database: 'SET NAMES \\\'utf8\\\'' 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 \'\\\'utf8\\\'\' at line 1(Error: : 1064) And I'm using Linux based hosting. Thank you very much, G