I have about 25 installs of WP running in various places, and I had little or no problem installing them, which is why upon installing mingus for our friend here, I was surprised to get a huge amount of errors, does anyone know what is causing this (and this is just the first screens worth of errors:
Database error: [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 ‘( ID int(10) unsigned NOT NULL auto_increment, post_author ]
CREATE TABLE ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) NOT NULL default ‘0’, post_date datetime NOT NULL default ‘0000-00-00 00:00:00’, post_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’, post_content text NOT NULL, post_title text NOT NULL, post_category int(4) NOT NULL default ‘0’, post_excerpt text NOT NULL, post_lat float, post_lon float, post_status enum(‘publish’,’draft’,’private’) NOT NULL default ‘publish’, comment_status enum(‘open’,’closed’) NOT NULL default ‘open’, ping_status enum(‘open’,’closed’) NOT NULL default ‘open’, post_password varchar(20) NOT NULL default ”, post_name varchar(200) NOT NULL default ”, to_ping text NOT NULL, pinged text NOT NULL, post_modified datetime NOT NULL default ‘0000-00-00 00:00:00’, post_modified_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’, post_content_filtered text NOT NULL, PRIMARY KEY (ID), KEY post_date (post_date), KEY post_date_gmt (post_date_gmt), KEY post_name (post_name), KEY post_status (post_status) )
Database error: [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 ‘(post_author, post_date, post_date_gmt, post_content, post_titl]
INSERT INTO (post_author, post_date, post_date_gmt, post_content, post_title, post_modified, post_modified_gmt) VALUES (‘1’, ‘2004-08-17 12:00:11’, ‘2004-08-17 17:00:11’, ‘Welcome to WordPress. This is the first post. Edit or delete it, then start blogging!’, ‘Hello world!’, ‘2004-08-17 12:00:11’, ‘2004-08-17 17:00:11’)