Re: Error when running SQL query in phpmyadmin
Posted by:
grawat
(---.sify.net)
Date: April 18, 2008 08:21PM
This is command, and I to run it I just opened phpmyadmin in wampserver and clicked on the database then clicked on SQL pasted the command and clicked on Go and then I get the error. I ran the same command on the webhosting account I have and it ran just fine there.
INSERT INTO `phpbb_styles_imageset_data` ( `image_id`, `image_name`, `image_filename`, `image_lang`, `image_height`, `image_width`, `imageset_id` )
VALUES
(NULL, 'posts_ratings_star_s_0', 'posts_ratings_star_s_00.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_1', 'posts_ratings_star_s_00.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_2', 'posts_ratings_star_s_00.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_3', 'posts_ratings_star_s_05.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_4', 'posts_ratings_star_s_05.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_5', 'posts_ratings_star_s_05.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_6', 'posts_ratings_star_s_05.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_7', 'posts_ratings_star_s_05.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_8', 'posts_ratings_star_s_10.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_9', 'posts_ratings_star_s_10.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_s_10', 'posts_ratings_star_s_10.gif', '', '9', '8', '1'),
(NULL, 'posts_ratings_star_v_0', 'posts_ratings_star_v_00.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_1', 'posts_ratings_star_v_01.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_2', 'posts_ratings_star_v_02.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_3', 'posts_ratings_star_v_03.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_4', 'posts_ratings_star_v_04.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_5', 'posts_ratings_star_v_05.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_6', 'posts_ratings_star_v_06.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_7', 'posts_ratings_star_v_07.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_8', 'posts_ratings_star_v_08.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_9', 'posts_ratings_star_v_09.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_v_10', 'posts_ratings_star_v_10.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_0', 'posts_ratings_star_uv_00.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_1', 'posts_ratings_star_uv_01.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_2', 'posts_ratings_star_uv_02.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_3', 'posts_ratings_star_uv_03.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_4', 'posts_ratings_star_uv_04.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_5', 'posts_ratings_star_uv_05.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_6', 'posts_ratings_star_uv_06.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_7', 'posts_ratings_star_uv_07.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_8', 'posts_ratings_star_uv_08.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_9', 'posts_ratings_star_uv_09.gif', '', '20', '17', '1'),
(NULL, 'posts_ratings_star_uv_10', 'posts_ratings_star_uv_10.gif', '', '20', '17', '1');
CREATE TABLE phpbb_posts_ratings_votes (
user_id MEDIUMINT UNSIGNED NOT NULL,
user_ip VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
post_id MEDIUMINT UNSIGNED NOT NULL,
score TINYINT UNSIGNED NOT NULL DEFAULT '0',
standard_diviation SMALLINT UNSIGNED NOT NULL DEFAULT '0',
shadow BOOL NOT NULL DEFAULT '0',
time INT UNSIGNED NOT NULL,
PRIMARY KEY (user_id, post_id),
INDEX (post_id)
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE phpbb_posts_ratings_votes_chi (
user1_id MEDIUMINT UNSIGNED NOT NULL,
user2_id MEDIUMINT UNSIGNED NOT NULL,
time INT UNSIGNED NOT NULL,
chi TINYINT UNSIGNED NOT NULL,
diff TINYINT NOT NULL,
num TINYINT UNSIGNED NOT NULL,
PRIMARY KEY (user1_id, user2_id),
INDEX (time, num)
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE phpbb_posts_ratings_penalty (
user_id MEDIUMINT UNSIGNED NOT NULL,
poster_id MEDIUMINT UNSIGNED NOT NULL,
penalty TINYINT UNSIGNED NOT NULL,
PRIMARY KEY (user_id, poster_id)
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE phpbb_posts_ratings_modpoints (
time INT UNSIGNED NOT NULL,
user_id MEDIUMINT UNSIGNED NOT NULL,
post_id MEDIUMINT UNSIGNED NOT NULL,
points TINYINT UNSIGNED NOT NULL,
PRIMARY KEY (time, user_id),
INDEX (post_id)
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE phpbb_posts
ADD posts_ratings_score TINYINT UNSIGNED NOT NULL DEFAULT 0,
ADD posts_ratings_standard_diviation SMALLINT UNSIGNED NOT NULL DEFAULT 0,
ADD posts_ratings_shadowed BOOL NOT NULL DEFAULT 0,
ADD posts_ratings_penaltized BOOL NOT NULL DEFAULT 0,
ADD INDEX (posts_ratings_score, posts_ratings_shadowed);
ALTER TABLE `phpbb_posts_ratings_modpoints` ADD `post_id` MEDIUMINT UNSIGNED NOT NULL AFTER `user_id` ;
ALTER TABLE `phpbb_posts_ratings_modpoints` ADD INDEX ( `post_id` ) ;