Code: Select all
Failed to execute SQL : SQL ALTER TABLE `phpbb_users` ADD `user_phoogle_map_center` varchar(255) NOT NULL default '(42, 3)'; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment` mediumtext NOT NULL; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment_bbcode_uid` varchar(8) NOT NULL default ''; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment_bbcode_bitfield` varchar(255) NOT NULL default ''; ALTER TABLE `phpbb_users` ADD `user_phoogle_icon` tinyint(3) unsigned NOT NULL default '3'; ALTER TABLE `phpbb_users` ADD `user_phoogle_allow` tinyint(1) unsigned NOT NULL default '1'; ALTER TABLE `phpbb_users` ADD `user_phoogle_show_me` tinyint(1) unsigned NOT NULL default '0'; CREATE TABLE `phpbb_phoogle_config` ( `map_id` int(11) NOT NULL auto_increment, `map_width` varchar(4) NOT NULL default '515', `width_measure` varchar(10) NOT NULL default 'px', `map_height` varchar(4) NOT NULL default '370', `height_measure` varchar(10) NOT NULL default 'px', `profile_map_width` varchar(4) NOT NULL default '400', `profile_width_measure` varchar(10) NOT NULL default 'px', `profile_map_height` varchar(4) NOT NULL default '300', `profile_height_measure` varchar(10) NOT NULL default 'px', `api_key` varchar(255) NOT NULL default '', `api_lang` char(2) NOT NULL default 'en', `show_control` varchar(5) NOT NULL default '1', `show_type` varchar(5) NOT NULL default '1', `terrain_map` varchar(5) NOT NULL default 'true', `traffic_over` varchar(5) NOT NULL default 'false', `control_type` varchar(5) NOT NULL default 'large', `show_scale` varchar(5) NOT NULL default '1', `show_overview` varchar(5) NOT NULL default '1', `show_gbar` varchar(5) NOT NULL default 'true', `init_zoom` tinyint(2) NOT NULL default '1', `user_zoom` tinyint(2) NOT NULL default '8', `zoom_limit` tinyint(2) NOT NULL default '17', `dbl_clk_zm` varchar(5) NOT NULL default 'true', `cont_zm` varchar(5) NOT NULL default 'true', `scr_whl_zm` varchar(5) NOT NULL default 'true', `map_center` varchar(255) NOT NULL default '(42, 3)', `auto_fit` tinyint(1) NOT NULL default '0', `use_special_markers` tinyint(1) NOT NULL default '1', `use_events` tinyint(1) NOT NULL default '1', `allow_coppa` tinyint(1) NOT NULL default '0', `marker_folder` varchar(100) NOT NULL default 'images/phoogle/markers/', `event_marker_folder` varchar(100) NOT NULL default 'images/phoogle/events/', `map_type` varchar(30) NOT NULL default 'G_NORMAL_MAP', `default_show` int(11) NOT NULL default '20', `dist_units` varchar(5) NOT NULL default 'miles', PRIMARY KEY (`map_id`) ); INSERT INTO `phpbb_phoogle_config` VALUES (1, 515, 'px', 370, 'px', 400, 'px', 300, 'px', 'ABQIAAAAySbm_RunOu_FTG_Dk8GrVhQxBlLipLklY7yW3TfPO8n_Opm0ahQW-KcosQ6nmxr4xpehzyixfwMW8w', 'en', 1, 1, 1, 0, 'large', 0, 0, 1, 1, 8, 17, 1, 1, 1, '(42, 3)', 0, 1, 1, 0, 'images/phoogle/markers/', 'images/phoogle/events/', 'G_NORMAL_MAP', 25, 'miles'); CREATE TABLE `phpbb_phoogle_events` ( `event_id` int(11) NOT NULL auto_increment, `event_map_center` varchar(255) NOT NULL default '', `event_marker` tinyint(3) NOT NULL default '0', `event_title` varchar(255) NOT NULL default '', `event_desc` varchar(255) NOT NULL default '', `event_desc_bbcode_uid` varchar(8) NOT NULL default '', `event_desc_bbcode_bitfield` varchar(255) NOT NULL default '', `event_start` varchar(30) NOT NULL default '', `event_end` varchar(30) NOT NULL default '', PRIMARY KEY (`event_id`) ) ; CREATE TABLE `phpbb_phoogle_events_markers` ( `marker_id` int(11) NOT NULL auto_increment, `marker_image` varchar(255) NOT NULL default '', `marker_width` varchar(5) NOT NULL default '15', `marker_height` varchar(5) NOT NULL default '15', `marker_x` varchar(5) NOT NULL default '7', `marker_y` varchar(5) NOT NULL default '15', `shadow_image` varchar(255) NOT NULL default '', `shadow_width` varchar(5) NOT NULL default '26', `shadow_height` varchar(5) NOT NULL default '15', PRIMARY KEY (`marker_id`) ) ; INSERT INTO `phpbb_phoogle_events_markers` VALUES (1, 'for_sale.png', '24', '21', '12', '21', 'for_sale_s.png', '44', '21'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (2, 'sport.png', '29', '30', '15', '30', 'sport_s.png', '42', '30'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (3, 'house1.png', '18', '21', '9', '21', 'house1_s.png', '34', '21'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (4, 'for_sale2.png', '24', '24', '12', '24', 'for_sale2_s.png', '42', '24'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (5, 'car_red.png', '18', '17', '9', '17', 'car_red_s.png', '31', '17'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (6, 'knife_fork.png', '32', '32', '16', '32', 'knife_fork_s.png', '50', '30'); CREATE TABLE `phpbb_phoogle_markers` ( `marker_id` int(11) NOT NULL auto_increment, `marker_image` varchar(255) NOT NULL default '', `marker_width` varchar(5) NOT NULL default '15', `marker_height` varchar(5) NOT NULL default '15', `marker_x` varchar(5) NOT NULL default '7', `marker_y` varchar(5) NOT NULL default '15', `shadow_image` varchar(255) NOT NULL default '', `shadow_width` varchar(5) NOT NULL default '26', `shadow_height` varchar(5) NOT NULL default '15', PRIMARY KEY (`marker_id`) ) ; INSERT INTO `phpbb_phoogle_markers` VALUES (1, 'admin.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (2, 'moderator.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (3, 'wink.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (4, 'eek.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (5, 'evil.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (6, 'twisted.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (7, 'surprised.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (8, 'geek.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (9, 'ubergeek.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (10, 'razz.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (11, 'smiley.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (12, 'cool.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_styles_imageset_data` VALUES ('', 'icon_contact_phoogle', 'icon_contact_phoogle.gif', '', '20', '20', '1'); failed : 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 '; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment` mediumtext NOT NULL; ALTE' at line 1
Code: Select all
INSERT INTO `phpbb_styles_imageset_data` VALUES ('', 'icon_contact_phoogle', 'icon_contact_phoogle.gif', '', '20', '20', '1');
Code: Select all
Incorrect integer value: " for column 'image_id' at row 1