Database Error

  • I found this in my error log:

    WordPress database error 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 'and ost_ticket.status = 'open' GROUP BY ost_ticket.ticket_id ORDER BY ost_ticket' at line 5 for query SELECT ost_ticket.user_id,ost_ticket.number,ost_ticket.created, ost_ticket.updated, ost_ticket.ticket_id, ost_ticket.status,ost_ticket.isanswered,ost_ticket__cdata.subject,ost_ticket__cdata.priority_id, ost_department.dept_name
      FROM ost_ticket
      LEFT JOIN ost_ticket__cdata ON ost_ticket__cdata.ticket_id = ost_ticket.ticket_id
      INNER JOIN ost_department ON ost_department.dept_id = ost_ticket.dept_id
      WHERE ost_ticket.user_id = and ost_ticket.status = 'open' GROUP BY ost_ticket.ticket_id ORDER BY ost_ticket.ticket_id DESC LIMIT 0, 7 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/key4ce-osticket-bridge/osticket-wp.php'), require_once('/plugins/key4ce-osticket-bridge/includes/versionData.php'), require_once('/plugins/key4ce-osticket-bridge/includes/database.php')

    https://www.ads-software.com/plugins/key4ce-osticket-bridge/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author m.tiggelaar

    (@mtiggelaar)

    when do you get this?
    as i can confirm there’s no sql error in ticket list, ticket view

    reply and new ticket still got some sql related errors we are resolving

    Thread Starter Interpolat Solutions

    (@jmdziba)

    I’m getting this whenever I access the support page on WP front-end.

    Plugin Author m.tiggelaar

    (@mtiggelaar)

    hmm, and what osTicket version do you have?

    Thread Starter Interpolat Solutions

    (@jmdziba)

    v1.9.1

    Plugin Author m.tiggelaar

    (@mtiggelaar)

    odd,
    and you can’t view any ticket ? or does it still show tickets even tho you got that error?

    Thread Starter Interpolat Solutions

    (@jmdziba)

    I can view the tickets, yes.

    Plugin Author m.tiggelaar

    (@mtiggelaar)

    Hello,

    Sorry for my long silence.
    we are very close to releasing version 1.1

    99% of all warnings and errors in debug mode have been fixed. (i’m assuming also yours).

    we also added additional email features as native OSTicket functionality (reading mail addresses from group members).

    best of all: shortcode will be implemented with the 1.1 update resolving theme issues (and issues of not being able to update more frequent). (currently having it working in our dev environment).

    I expect to release 1.1 shortly.
    Again: sorry for the delay, we are really trying to make this plugin work and removing all the bugs (mostly reported by you, thank you for that).

    Thread Starter Interpolat Solutions

    (@jmdziba)

    You’ve done great work with this plugin. One of the most frustrating experiences I’ve had in working with WordPress is that as a non-coder myself, I have seen great plugin ideas sit and die because the original author could not, for one reason or another, carry on developing the plugin, and no-one else was able or willing to pick it up and carry it on. So I am extremely grateful that you have taken on this great plugin and have committed to making it superb. Thank you.

    Plugin Author m.tiggelaar

    (@mtiggelaar)

    Hello,

    New update is out.
    Please make sure you replace the ticket page text with the new shortcode:
    [addosticket]

    It seems the update didn’t update this.

    Please let me know if you still got the mysql db issue.

    regards,
    Marco

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database Error’ is closed to new replies.