mysql error while changing and deleting pictures
Permalink Browser Info Environment
Dear Sirs:
Thanks for your nice free add on.
I changed some pics in cu3er slide show and wile changing I deleted some pics in file manager. When I returned, en error came in that specific page.
An unexpected error occurred.
mysql 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=41 AND fvID= LIMIT 1")
Now i can not do anything in that specific page. No edit or dash board options and available only in that page.
1 Attachment
Thanks for your nice free add on.
I changed some pics in cu3er slide show and wile changing I deleted some pics in file manager. When I returned, en error came in that specific page.
An unexpected error occurred.
mysql 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=41 AND fvID= LIMIT 1")
Now i can not do anything in that specific page. No edit or dash board options and available only in that page.
1 Attachment
| Type: | Discussion |
|---|---|
| Status: | In Progress |
Duplicate support request answered athttp://www.concrete5.org/index.php?cID=380925...
When I try to see the message and how to fix the problem, get this error:
Ticket Content Restricted
This is an older legacy support ticket and is only available to the add-on developer and the ticket owner.
Ticket Content Restricted
This is an older legacy support ticket and is only available to the add-on developer and the ticket owner.
Hi
I've just grabbed the solution from there here it is:
--------------------------------------------------
It's trying to load a file that no longer exists since you deleted it. If you chose a fileset that wouldn't occur.
The only ways to fix the are:
1) use "versions" to roll back the affected page to a version without the affected block; or
2) uninstall the package completely and reinstall it
Hope this helps.
You can also check out more of our addons and themes athttp://c5extras.com
--------------------------------------------------
Hope that helps.
JZ
I've just grabbed the solution from there here it is:
--------------------------------------------------
It's trying to load a file that no longer exists since you deleted it. If you chose a fileset that wouldn't occur.
The only ways to fix the are:
1) use "versions" to roll back the affected page to a version without the affected block; or
2) uninstall the package completely and reinstall it
Hope this helps.
You can also check out more of our addons and themes athttp://c5extras.com
--------------------------------------------------
Hope that helps.
JZ
Hi.
Thanks for some clues.
Yesterday I got it working by uninstalling the package and reinstalling it. This time I put the slideshow as stack (I have the same slideshow in several pages), so now only one place to update/change pictures.
Thanks for some clues.
Yesterday I got it working by uninstalling the package and reinstalling it. This time I put the slideshow as stack (I have the same slideshow in several pages), so now only one place to update/change pictures.