Title: Database Error
Last modified: August 21, 2016

---

# Database Error

 *  Resolved [NickPagano](https://wordpress.org/support/users/nickpagano/)
 * (@nickpagano)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/)
 * Hello,
 * I’m getting the follow error above the front-end ‘create ticket’ form:
 *     ```
       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]
       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
       ```
   
 * I’m still able to see the tickets though. Even on the form, I’m still able to
   use it to create a ticket. This error is just above it. The page is also stretched
   however. Any ideas?
 * [https://wordpress.org/plugins/key4ce-osticket-bridge/](https://wordpress.org/plugins/key4ce-osticket-bridge/)

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [m.tiggelaar](https://wordpress.org/support/users/mtiggelaar/)
 * (@mtiggelaar)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127493)
 * Hey,
 * Sorry for my late response.
    We where busy fixing alot of issues and new features
   for v1.1.3 which should be out within the next couple of days.
 * Your issue should be resolved then aswell (i will give a update notice when the
   new code is out).
 * My apologies for the slow reply and the current issue you have.
 * Regards,
    Marco
 *  Plugin Author [m.tiggelaar](https://wordpress.org/support/users/mtiggelaar/)
 * (@mtiggelaar)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127507)
 * Ok,
 * Issue has been resolved with the 1.1.3 update
    it happens when the user does 
   not exist before in the ticket list.
 * Our new update addresses this issue.
 * Regards,
    Marco
 *  Thread Starter [NickPagano](https://wordpress.org/support/users/nickpagano/)
 * (@nickpagano)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127508)
 * Thanks for the follow up. That worked. Though, I got this message when activating
   the plugin, just FYI:
 * `The plugin generated 1917 characters of unexpected output during activation.
   If you notice “headers already sent” messages, problems with syndication feeds
   or other issues, try deactivating or removing this plugin.`
 * Another question; Do you have any plans to make the front end form / page responsive?
 *  Plugin Author [m.tiggelaar](https://wordpress.org/support/users/mtiggelaar/)
 * (@mtiggelaar)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127509)
 * hmm alright, guessing the output is to do with the SMTP variables when you did
   not yet configure the DB.
 * you did not get any headers already sent once putted in the mysql information
   right?.
 * We will work that one upcoming week.
 * the front end part is mostly responsive as it is, tho i did not work on mobile
   format just tablet / pc etc.
 * There’s still more improvements to come when it comes to the front end.
    Most
   expected feature (once we made the base stable) would be a nice shortcode to 
   use in your contact pages (with capacha etc).
 *  Thread Starter [NickPagano](https://wordpress.org/support/users/nickpagano/)
 * (@nickpagano)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127522)
 * Yeah, you’re right, that was before I entered the info. It all seems find now.
 * And ok, thanks for the info and the quick reply.
 *  Plugin Author [m.tiggelaar](https://wordpress.org/support/users/mtiggelaar/)
 * (@mtiggelaar)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127545)
 * The plugin generated 1917 characters of unexpected output during activation. 
   If you notice “headers already sent” messages, problems with syndication feeds
   or other issues, try deactivating or removing this plugin.
 * has been fixed with version 1.1.4. (just pushed out).
 * Had to push out another version as 1.1.3 had a bug that crashed existing plugin
   users due to lack of prefix field.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Database Error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/key4ce-osticket-bridge_dddede.svg)
 * [Key4ce osTicket Bridge](https://wordpress.org/plugins/key4ce-osticket-bridge/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/key4ce-osticket-bridge/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/key4ce-osticket-bridge/)
 * [Active Topics](https://wordpress.org/support/plugin/key4ce-osticket-bridge/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/key4ce-osticket-bridge/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/key4ce-osticket-bridge/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 6 replies
 * 2 participants
 * Last reply from: [m.tiggelaar](https://wordpress.org/support/users/mtiggelaar/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-151/#post-5127545)
 * Status: resolved