Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

DB Error 1054 - attaching images

Hi Everyone,

I am now using OSTicket v1.10 (901e5ea) 

Everytime I attach an image and send an update to clients, they receive the following error via email.

I have seen this was happening in v1.10RC but I am running the stable version.

Anyone else see this before and know of a fix?  I cannot find one searching the forums.

Thanks and see the full error attached in the text file.

===============================================================

DB Error #1054[SELECT page.*, count(topic.page_id) as topics FROM ost_content page LEFT JOIN ost_help_topic topic 

Comments

  • Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance.  The more information you give us the better we will be able to assist you. Thank you.

    This error does not appear to have anything to do with your subject.
    No attached text file.
    I have never seen this. Have you modified the core files?  
    Are you running any forth coming features from github?
  • Hi:
    • Not sure why the text file did not upload but I will upload it once more
    • No core files have been modified
    • This is not from github it was fro the OSTicket download site.
    The subject line is based on what I have tested.

    I have tested and the only time this error appears is when I attach an image to an incident.
    OSTicket_Error.txt
    883B
  • Here is the error

    DB Error #1054[SELECT page.*, count(topic.page_id) as topics FROM ost_content page LEFT JOIN ost_help_topic topic ON(topic.page_id=page.id) WHERE page.content_id=6 GROUP By page.id]

    Unknown column 'page.content_id' in 'where clause'



    ---- Backtrace ----

    #0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1054', '[SELECT page.*,...')

    #1 (root)/include/class.page.php(40): db_query('SELECT page.*, ...')

    #2 (root)/include/class.page.php(25): Page->load('6', false)

    #3 (root)/include/class.page.php(227): Page->Page('6')

    #4 (root)/scp/login.php(26): Page::lookup('6')

    #5 (root)/scp/staff.inc.php(54): require('/share/MD0_DATA...')

    #6 (root)/scp/staff.inc.php(75): staffLoginPage('Authentication ...')

    #7 (root)/scp/tickets.php(17): require('/share/MD0_DATA...')

    #8 (root)/scp/index.php(17): require('/share/MD0_DATA...')

    #9 {main}
  • HI any thoughts as to the cause of this error?

    Thanks in Advance
  • How are you "attaching an image to an incident"?
Sign In or Register to comment.