Install error
| Project: | Kudos |
| Version: | 5.x-1.6 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | won't fix |
When i try to install Kudos i only get the following two errormessages:
*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 /srv/www/htdocs/life.epb/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 /srv/www/htdocs/life.epb/includes/database.mysql.inc on line 172.
When i take a look in my Database, there are only the two following tables after the installation:
kudos_cached, kudos_info_types.
The tables kudos_info and kudos_granted are missing.
Additional Infos:
* jQuery Update is Installed correctly
* MySQL-Database: 4.0.18
Does anyone have an idea?
greetings from Hamburg
jonas
#1
Hello,
It appears that you are using a rather old version of MySql. Unfortuneately I do not have access to that version of Mysql. You could try to create the table manually and then do an export of the schema so that we can see the difference.
-T
#2
i have installed kudos on another server where i can use MySQL 5. Then i exported the following tables with "MYSQL 4 compatibility" in phpMyAdmin (see screenshot): kudos_cached, kudos_info_types, kudos_info and kudos_granted
Now i can setup kudos at /admin/settings/kudos and /admin/content/kudos
But when i visit the contenttypes that kudos may be given to, i get another error Message:
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 'SELECT 1 FROM kudos_granted g WHERE g.kudo_id = i.id and g.cont query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , (SELECT 1 FROM kudos_granted g WHERE g.kudo_id = i.id and g.content_type = 'node' AND g.content_id = 856 AND g.uid = 1) as given FROM kudos_info i JOIN kudos_info_types t ON i.id = t.kudo_id AND t.node_type = 'ziel' WHERE i.status = 1 in /srv/www/htdocs/life.epb/includes/database.mysql.inc on line 172.
#3
When i take i look at the tablestructur i can see a differece in the table kudos_granted:
At MySQL 4:
field: type:
created timestamp(14)
(see screenshot)
At MySQL 5:
field: type:
created timestamp
#4
At this point with drupal going with purely mysql 5, and without an adequet testing environment for mysql 4 available it would be difficult to correct this.
Let me know if this is still a problem, and if you had any work around, but otherwise i'm going to leave it as is.