PHP database error when creating new ticket.

  • Resolved hardylane

    (@hardylane)


    10 years, 3 months ago

    Hi… we’re getting this error when creating a new ticket:

    [08-Feb-2016 20:13:19 Europe/London] WordPress database error Unknown column ‘isdefault’ in ‘where clause’ for query SELECT id FROM wp_js_ticket_departments WHERE isdefault = 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Chorlton_Players_50th_v2/page.php’), get_template_part, locate_template, load_template, require(‘/themes/Chorlton_Players_50th_v2/content-page.php’), theme_get_content, the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, JSSTshortcodes->show_main_ticket, JSSTincluder::include_slug, include_once(‘/plugins/js-support-ticket/modules/js-support-ticket-controller.php’), jssupportticketController->__construct, jssupportticketController->handleRequest, JSSTincluder::include_file, include_once(‘/plugins/js-support-ticket/modules/ticket/controller.php’), JSSTticketController->__construct, JSSTticketController->handleRequest, JSSTincluder::include_file, include_once(‘/plugins/js-support-ticket/modules/ticket/tpls/staffmyticket.php’), JSSTdepartmentModel->getDefaultDepartmentID

    Any ideas?

    https://ww.wp.xz.cn/plugins/js-support-ticket/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author JoomSky

    (@rabilal)

    10 years, 3 months ago

    Hi,

    Please run this query in phpmyadmin.

    ALTER TABLE wp_js_ticket_departments ADD COLUMN isdefault tinyint NOT NULL DEFAULT ‘0’ AFTER status;

    Regards,
    Ahmad Bilal

    Thread Starter hardylane

    (@hardylane)

    10 years, 3 months ago

    Still getting this:

    [09-Feb-2016 13:02:55 Europe/London] WordPress database error Unknown column ‘isdefault’ in ‘where clause’ for query SELECT id FROM wp_js_ticket_departments WHERE isdefault = 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Chorlton_Players_50th_v2/page.php’), get_template_part, locate_template, load_template, require(‘/themes/Chorlton_Players_50th_v2/content-page.php’), theme_get_content, the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, JSSTshortcodes->show_main_ticket, JSSTincluder::include_slug, include_once(‘/plugins/js-support-ticket/modules/js-support-ticket-controller.php’), jssupportticketController->__construct, jssupportticketController->handleRequest, JSSTincluder::include_file, include_once(‘/plugins/js-support-ticket/modules/ticket/controller.php’), JSSTticketController->__construct, JSSTticketController->handleRequest, JSSTincluder::include_file, include_once(‘/plugins/js-support-ticket/modules/ticket/tpls/staffmyticket.php’), JSSTdepartmentModel->getDefaultDepartmentID

    Thread Starter hardylane

    (@hardylane)

    10 years, 3 months ago

    Ahh not to worry… manually added the column and all is now well… cheers!!

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

The topic ‘PHP database error when creating new ticket.’ is closed to new replies.