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.

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

500 network error


Go to End


2 Posts   2027 Views

Avatar
JMagnusson

Community Member, 29 Posts

11 October 2013 at 8:10pm

Hi.
I got this error when I tried to use IDOM:
<code>
ERROR [User Error]: Couldn't run query:
SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."ShowInSearch", "File"."SortOrder", "File"."Secured", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName"
FROM "File"
WHERE (`File`.ID IN (11))
ORDER BY "SortOrder" ASC

Unknown column '11' in 'where clause'
</code>

The number (now 11) increases every time I try to upload a new image - seems to be some kind of counter.
Has anyone had this problem before, or knows how to solve it?

Best regards,
Johan

Avatar
JMagnusson

Community Member, 29 Posts

11 October 2013 at 11:35pm

I am running SS version 2.4. I forgot to mention that before. I would have used 3.1 if it wasn't for that I need a specific module to work.

I haven't found out whats causing this problem. But I have to move on, so I did a fresh SilverStripe installation and I have found out that there is no problem before I add an extension to LeftAndMain which I use to remove the Help link in the top menu. I will hide the Help button with css instead. Works too.

But it would be interesting to know what I have been doing wrong, so here are some more info:

This is the line in mysite/_config.php that caused the problem:
<code>
Object::add_extension('LeftAndMain', 'MyLeftAndMainDecorator');
</code>

And this is the content of the file mysite/code/MyLeftAndMainDecorator.php :
<code>
<?php
class MyLeftAndMainDecorator extends LeftAndMainDecorator {
function init() {
CMSMenu::remove_menu_item('Help');
}
}
</code>

Best regards,
Johan