Loading...
 

MySQL5

To use MySQL5 with Tiki, you need to use Tiki version 1.9.3 or later.


Why?
"The following are new reserved words in MySQL 5.0: ASENSITIVE, CALL, CONDITION, CONNECTION, CONTINUE, CURSOR, DECLARE, DETERMINISTIC, EACH, ELSEIF, EXIT, FETCH, GOTO, INOUT, INSENSITIVE, ITERATE, LABEL, LEAVE, LOOP, MODIFIES, OUT, READS, RELEASE, REPEAT, RETURN, SCHEMA, SCHEMAS, SENSITIVE, SPECIFIC, SQL, SQLEXCEPTION, SQLSTATE, SQLWARNING, TRIGGER, UNDO, UPGRADE, WHILE."
Source: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

Tiki had been using "reads" as a field in its DB structure. This works fine in Mysql 3 & 4.



A consequence of this: if you upgrade your Tiki, you need to run the database upgrade script (ex.: 1.8 to 1.9.sql) please note : if upgrading from 1.9.3 to 1.9.4, you still need to run this script, which is designed to be ran multiple times.



Page last modified on Wednesday 29 November 2006 15:38:25 GMT-0000