Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, biapar, Willr, Ingo, swaiba, simon_w

Couldn't run query Error


Reply


2 Posts   961 Views

Avatar
jarop

Community Member, 19 Posts

26 March 2011 at 12:29am

Hi,

i have the following problem when i moved with my db from a local system to the webserver.

When i want to visit a gallery in published version there is this error message:

[User Error] Couldn't run query: SELECT "ImageGalleryAlbum"."ClassName",
...
SortOrder DESC LIMIT 1 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 ') ORDER BY SortOrder DESC LIMIT 1' at line 1

Versions:
SS 2.4.5
MySQL on the Webserver: 5.0.51a
MySQL local: 5.5.8

Any idea?

Avatar
jarop

Community Member, 19 Posts

29 March 2011 at 1:10am

Ok, it works now.

The problem was in the name of the folder for the dom.