WampServer

I installed wampserver2.0b and everything seemed to be working fine. I created a database in phpmyadmin and when I try to enter some SQL commands for that database I get this error

import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: format (FAQ 2.8)

could someone please tell me how I can fix this.

Hi,

There may be a syntax error in the SQL command. Can you please post the exact command you entered.

For comparison, try installing and using the MySQL Administrator or SQLyog and test the same command in another MySQL client application.

Regards,

toivo
Sydney, Australia

How did you run your command?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

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` ) ;

dunno exactly but ur prpablly on the wrong storage engine..

open ur my.ini file in c:/wamp/mysql/mysql5.00.45/ and the file my or my.ini


change ur deafult storage engine to MyISAM instead of INNODB

ALSO u show be importing this code i would think ... save it as a text file...

go to phpmyadmin and press import and select ur text file ...

I searched for my.ini in my wamp folder and the only result was in C:\wamp\bin\mysql\mysql5.0.51a

within that file I changed

default-storage-engine=MyISAM

and then saved the SQL command as a text file and tried to import it but I got the same error. I tried to just enter the SQL command like I had earlier but that too gave the same error as before.

INSERT INTO `phpbb_styles_imageset_data` ( `image_id`, `image_name`, `image_filename`, `image_lang`, `image_height`, `image_width`, `imageset_id` )
VALUES



see this?

this needs a table called phpbb_styles_imageset_data already to be made.

u sure ur not missing some code?

I tried entering just a part of the code and I still get the error.

This is what I tried

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;