muwp installation error..

lse12
(@lse12)

21 years, 6 months ago

I want to install muwp(multiuser wordpress).
in the step 2
I have met this problem…error.
error message is so long. I pasted just one of the error message lines.
———————-
WordPress database error: [You have an error in your SQL syntax near ‘/mwp_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(55’ at line 1]
CREATE TABLE wp_/mwp_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default ”, category_nicename varchar(200) NOT NULL default ”, category_description text NOT NULL, category_parent int(4) NOT NULL default ‘0’, PRIMARY KEY (cat_ID), UNIQUE KEY cat_name (cat_name), KEY category_nicename (category_nicename) )

Viewing 4 replies - 1 through 4 (of 4 total)

Anonymous

21 years, 5 months ago

I’ve received this error as well. I’m using mysql 3.23.58, apache 1.3.33, and php 4.1.
I don’t have connection errors, just dozens of mysql errors, the first of which is:
WordPress database error: [You have an error in your SQL syntax near ‘-inst_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(5’ at line 1]
CREATE TABLE wp_wp-inst_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default ”, category_nicename varchar(200) NOT NULL default ”, category_description text NOT NULL, category_parent int(4) NOT NULL default ‘0’, PRIMARY KEY (cat_ID), UNIQUE KEY cat_name (cat_name), KEY category_nicename (category_nicename) )
and the last of which is:
WordPress database error: [You have an error in your SQL syntax near ‘-inst_comments SET comment_type=’pingback’, comment_content = REPLACE(comment_co’ at line 1]
UPDATE wp_wp-inst_comments SET comment_type=’pingback’, comment_content = REPLACE(comment_content, ”, ”) WHERE comment_content LIKE ‘%’

rikardon
(@rikardon)

21 years, 5 months ago

I’m having the exact same problem. Has anyone found a solution to this yet?

Mark Cahill
(@lagmeister)

21 years, 4 months ago

I had the problem and had to change the table prefix in wp-settings – for some reason it was picking up a backslash (could magic quotes be turned on here?) that was blowing up the table create script.

Donncha O Caoimh (a11n)
(@donncha)

21 years, 3 months ago

You’re not installing it correctly – if “wp-inst” is in the url you’re calling during the install replace it with “main”. It doesn’t exist in the filesystem but mod_rewrite will handle the request correctly if it’s installed. You shouldn’t need to change any table prefix.