March 17, 2016 at 6:53 pm
Hi there,
I have decided to go live with my website but I get SQL errors when exporting my database. Im not too sure what it means but it says its a syntax error.
Is there anything I can do to fix this up? Or a step to avoid it?
Thanks,error is shown below
SQL query:
INSERT INTO wp_options (option_id, option_name, option_value, autoload) VALUES (185, ‘virtue_premium’, ‘a:352:{s:8:”last_tab”;s:1:”1″;s:12:”boxed_layout”;s:4:”wide”;s:12:”header_style”;s:6:”shrink”;s:13:”header_height”;s:3:”120″;s:22:”side_header_menu_width”;s:9:”33.333333″;s:13:”sticky_header”;s:1:”1″;s:20:”shrink_center_header”;s:1:”0″;s:27:”shrink_center_header_height”;s:3:”120″;s:15:”m_sticky_header”;s:1:”0″;s:11:”logo_layout”;s:8:”logohalf”;s:21:”x1_virtue_logo_upload”;a:5:{s:3:”url”;s:77:”http://localhost/abbas/wordpress/wp-content/uploads/2016/02/logo-final-01.png”;s:2:”id”;s:2:”94″;s:6:”height”;s:3:”192″;s:5:”width”;s:3:”381″;s:9:”thumbnail”;s:85:”http://localhost/abbas/wordpress/wp-content/uploads/2016/02/logo-final-01-150×150.png”;}s:21:”x2_virtue_logo_upload”;a:5:{s:3:”url”;s:80:”http://localhost/abbas/wordpress/wp-content/uploads/2016/02/logo-final-HR-01.png”;s:2:”id”;s:2:”95″;s:6:”height”;s:3:”797″;s:5:”width”;s:4:”1583″;s:9:”thumbnail”;s:88:”http://localhost/ab%5B…%5D
MySQL said: Documentation
#1064 – 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 17