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

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

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

Couldn't run query Error

2 Posts 1493 Views

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?

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.

Return to top