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 #1064

Dear All,

Firstly thank you so much for the maximum effort that has been giving solving all community issues, you guys are actually doing grate job.

So, lets get to the porblem,

PHP version 5.6

phpMyAdmin -

this has been taken from the error log:

Cannot load the ionCube PHP Loader + Intrusion Protection from - it was built with configuration API220121212,NTS, whereas running engine is API220131226,NTS
Zend Guard Loader requires Zend Engine API version 220121212.
The Zend Engine API version 220131226 which is installed, is newer.
Contact Zend Technologies at for a later version of Zend Guard Loader.


  • and i received the following by email:

    [SELECT COUNT(*) FROM (SELECT A1.`ticket_id` FROM
    `ost_ticket` A1 WHERE A1.`dept_id` IN (4) AND ) __]


    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
    ') __' at line 1<br /> <br />

    ---- Backtrace ----<br />

    #0 (root)/include/mysqli.php(204):
    osTicket->logDBError('DB Error #1064', '[SELECT COUNT(*...')<br />

    #1 (root)/include/class.orm.php(3133): db_query('SELECT
    COUNT(*)...', true, true)<br />

    #2 (root)/include/class.orm.php(3189):
    MySqlExecutor->execute()<br />

    #3 (root)/include/class.orm.php(2644):
    MySqlExecutor->getRow()<br />

    #4 (root)/include/class.orm.php(1193):
    MySqlCompiler->compileCount(Object(QuerySet))<br />

    #5 (root)/scp/tickets.php(422):
    QuerySet->count()<br />

    #6 (root)/scp/index.php(17):
    require('/hermes/bosnawe...')<br />

    #7 {main}

    All of that happened after trying to use the advanced search,
    keep in mind that i cant even log on to get more information from

    i got error 500

    thanks in forward.


    Mohamed Khalil

  • What webserver are you running? version?
    Database engine? version?
  • Also "Cannot load the ionCube PHP Loader + Intrusion Protection from" is not related to osTicket.
  • After clearing the caches everything is okay i saw a another case who mentioned that there is a glitch in the Advanced Search i guess this is what happened in my case
  • Please check the Attached
Sign In or Register to comment.