Single/Double Quotes when executing Raw SQL
Arvind Satyanarayan
Unknown column 'DIV' in 'field list' (code: 1054, sql state: 42S22, query: insert into dom_nodes (page_id, tag_name, parent_id, dom_id) values (1, "DIV", 2, 3)
Changing the double quotes around DIV to single quotes allows that query to execute, but it produces SQL syntax errors for more complex queries with escaped single quotes. And yet, if you look at the following error message, the SQL query it's attempting to run is completely valid (which I've verified by copying and pasting it in the MySQL console).
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 '\'; return true;', '20px', 'auto', 'transparent', '0px', '0px', 'normal', '2', '' at line 1 (code: 1064, sql state: 42000, query: insert into dom_nodes (style_bottom, style_background_position_y, style_padding_bottom, attr_onmouseout, style_margin_bottom, style_table_layout, style_background_color, style_border_top_left_radius, style_outline_width, style_font_weight, style_orphans, style_empty_cells, style_border_right_width, dom_id, attr_target, style_border_bottom_right_radius, style_position, attr_id, style_x, style_background_size, style_clip, style_border_left_width, style_max_height, tag_name, style_widows, style_text_indent, style_background_position_x, style_unicode_bidi, style_outline_style, style_background_clip, style_letter_spacing, style_border_top_color, style_z_index, style_font_variant, style_pointer_events, style_border_right_style, style_opacity, parent_id, style_border_bottom_left_radius, style_cursor, style_display, style_white_space, style_padding_top, style_clear, style_border_left_style, style_margin_top, attr_class, style_background_position, style_border_top_width, style_list_style_type, style_text_decoration, style_overflow_y, style_border_collapse, style_image_rendering, style_height, style_background_attachment, style_text_transform, style_page_break_inside, style_border_bottom_color, style_word_wrap, style_font_style, style_border_right_color, style_min_width, page_id, style_margin_right, style_visibility, style_border_left_color, style_direction, style_padding_right, style_list_style_position, style_text_align, style_background_origin, style_overflow_x, style_border_top_style, style_outline_color, style_text_shadow, attr_title, style_border_bottom_width, style_resize, style_width, style_font_size, style_page_break_before, style_word_spacing, style_min_height, style_margin_left, style_padding_left, style_color, style_background_repeat, style_vertical_align, attr_onmouseover, style_list_style_image, style_background_image, style_border_top_right_radius, style_overflow, style_y, style_border_spacing, style_border_bottom_style, style_float, style_text_rendering, style_page_break_after, style_font_family, style_max_width, style_text_overflow, attr_href, style_word_break) values ('auto', '0%', '1px', 'window.status=\'\'; return true;', '20px', 'auto', 'transparent', '0px', '0px', 'normal', '2', 'show', '0px', '120', '_blank', '0px', 'static', 'bsa_1974901', '0', 'auto auto', 'auto', '0px', 'none', 'A', '2', '0px', '0%', 'normal', 'none', 'border-box', 'normal', 'rgb(136, 136, 136)', 'auto', 'normal', 'auto', 'none', '1', '121', '0px', 'auto', 'block', 'normal', '1px', 'none', 'none', '20px', 'ad1 odd', '0% 0%', '0px', 'disc', 'none', 'hidden', 'separate', 'auto', '127', 'scroll', 'none', 'auto', 'rgb(136, 136, 136)', 'normal', 'normal', 'rgb(136, 136, 136)', '0px', '61', '0px', 'visible', 'rgb(136, 136, 136)', 'ltr', '1px', 'outside', 'center', 'padding-box', 'hidden', 'none', 'rgb(136, 136, 136)', 'none', 'executionists web design', '0px', 'none', '127', '11px', 'auto', '0px', '0px', '15px', '1px', 'rgb(136, 136, 136)', 'repeat', 'baseline', 'window.status = \'http://executionists.com\'; return true;', 'none', 'none', '0px', 'hidden', '0', '0px 0px', 'none', 'left', 'auto', 'auto', 'verdana, sans-serif', 'none', 'clip', 'http://stats.buysellads.com/click.go?z=1249867&b=1974901&g=&s=&sw=1440&sh=900&br=safari,533.3,mac&r=0.059903202345594764&link=http://executionists.com', 'normal'), ...)
Any ideas would be greatly appreciated!
-Arvind