Jump to:

7940 Posts in 1543 Topics by 946 members

DataObjectManager Module

SilverStripe Forums » DataObjectManager Module » 500 network error

Discuss the DataObjectManager module, and the related ImageGallery module.

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

Page: 1
Go to End
Author Topic: 587 Views
  • JMagnusson
    Avatar
    Community Member
    29 Posts

    500 network error Link to this post

    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

  • JMagnusson
    Avatar
    Community Member
    29 Posts

    Re: 500 network error Link to this post

    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

    587 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.