Error on the Home page of : coastalstylemobilehairdressing.com.au
Permalink
mysqlt error: [1064: 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 'LIMIT 1' at line 1] in EXECUTE("SELECT fvFilename FROM FileVersions WHERE fID=24 AND fvID= LIMIT 1")
I cant work it out :-S
Any ideas?
I cant work it out :-S
Any ideas?
Are you moving the site from local to server? If so just make it sure that all the files and folders are uploaded correctly.
Rony
Rony
Looking at the actual SQL error, you can see that it's missing the actual fvID value in the SQL - so I don't think its a missing concrete5 file, it's missing a piece of data somewhere.
Perhaps a file block has gone a bit funny - maybe you can roll back the home page version to something earlier that doesn't have the link/block. Or maybe you can delete the actual file in the file manager that it's referring to (with an ID of 24), and that will stop the error message and allow you to add it again.
As Rony has asked, is this a migration? Or has the site been recently updated?
Perhaps a file block has gone a bit funny - maybe you can roll back the home page version to something earlier that doesn't have the link/block. Or maybe you can delete the actual file in the file manager that it's referring to (with an ID of 24), and that will stop the error message and allow you to add it again.
As Rony has asked, is this a migration? Or has the site been recently updated?
I think they were playing with the site and they played a bit too much, I think I should just delete the file and start that section again :-/
mesuva, please contact me via email asap: cheyne@dynamicwebhosting.com.au
can you help me? I am a bit stuck with this website CMS setup and cant really find it all.
thanks
can you help me? I am a bit stuck with this website CMS setup and cant really find it all.
thanks
Just to follow this up in case anyone is wondering why this error occurred - the problem was with the cu3er slideshow. I think it had a little trouble handling a case where a file or a file version had been deleted.
I had to find in the file:
/packages/cu3er/blocks/cu3er/controller.php
and put in a little conditional statement around the SQL statement (the one in the error message), to check if it actually had an fvID to put into the query. This fixed things up.
I had to find in the file:
/packages/cu3er/blocks/cu3er/controller.php
and put in a little conditional statement around the SQL statement (the one in the error message), to check if it actually had an fvID to put into the query. This fixed things up.
Other system requirements can be found here:
http://www.concrete5.org/documentation/background/system_requiremen...