This appears when tring to install. these two tables never get created,
user warning: 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 'CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY u query: CREATE TABLE IF NOT EXISTS kudos_granted ( id int(10) unsigned NOT NULL auto_increment, kudo_id int(10) unsigned NOT NULL, uid int(10) unsigned NOT NULL, content_type varchar(50) NOT NULL, content_id int(10) unsigned NOT NULL, created timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY uid (uid), KEY kudos_id (kudo_id,uid,content_type,content_id), KEY content_type_content_id (content_type,content_id) ); in /mounted-storage/home61b/sub007/sc38323-GXLT/thebakery.ws/includes/database.mysql.inc on line 172.
user warning: 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 'CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQU query: CREATE TABLE IF NOT EXISTS kudos_info ( id int(11) NOT NULL, `name` varchar(50) NOT NULL, label varchar(50) NOT NULL, `status` tinyint(4) NOT NULL default '1', comments tinyint(4) NOT NULL default '0', icon_give varchar(150) NOT NULL, icon_rescind varchar(150) NOT NULL, icon_disabled varchar(150) NOT NULL, created timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY `name` (`name`) ); in /mounted-storage/home61b/sub007/sc38323-GXLT/thebakery.ws/includes/database.mysql.inc on line 172.
Comments
Comment #1
socki commentedWhat version of MySql are you running? This appears to work fine on MySql 5.
Comment #2
socki commentedComment #3
xyberviri commentedI was using a preinstall version on servage that used mysql Server version: 4.0.26-standard for the database, i tried this on 5 on another host and didn't have any issues.
Comment #4
socki commented