Error while updating database settings
-
This is the error showing on my website. Can any1 help.
PHP Warning: mysql_set_charset(): Error executing query in D:\inetpub\vhosts\globalshospital.com\httpdocs\wp-includes\wp-db.php on line 780 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 ')) GROUP BY t1.event_hours_id ORDER BY FIELD(t3.menu_order,4,), t1.start, t1.end' at line 14 for query SELECT TIME_FORMAT(t1.start, '%H.%i') AS start, TIME_FORMAT(t1.end, '%H.%i') AS end, t1.event_id AS event_id, t1.before_hour_text AS description1, t1.after_hour_text AS description2, t2.post_title, t2.post_name, t3.post_title as weekday FROM wp_event_hours AS t1 LEFT JOIN wp_posts AS t2 ON t1.event_id=t2.ID LEFT JOIN wp_posts AS t3 ON t1.weekday_id=t3.ID WHERE t2.post_type='events' AND t2.post_status='publish' AND t3.post_type='timetable_weekdays' AND t3.post_status='publish' AND( (t3.menu_order=4 AND SUBTIME(t1.start, TIME('07:06:57'))>0) OR t3.menu_order IN()) GROUP BY t1.event_hours_id ORDER BY FIELD(t3.menu_order,4,), t1.start, t1.end LIMIT 5 made by require('D:\inetpub\vhosts\globalshospital.com\httpdocs\wp-blog-header.php'), require_once('D:\inetpub\vhosts\globalshospital.com\httpdocs\wp-includes\template-loader.php'), include('D:\inetpub\vhosts\globalshospital.com\httpdocs\wp-content\themes\imedica\page.php'), get_footer, locate_template, load_template, require_once('D:\inetpub\vhosts\globalshospital.com\httpdocs\wp-content\themes\imedica\footer.php'), get_footer, locate_template, load_template, require_once('D:\inetpub\vhosts\globalshospital.com\httpdocs\wp-content\themes\imedica\footer-default.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, upcoming_events_widget->widget
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
The topic ‘Error while updating database settings’ is closed to new replies.