View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015527||phpList 3 application||Configuration||public||18-08-10 12:44||21-06-18 14:00|
|Priority||normal||Severity||minor||Reproducibility||have not tried|
|Status||resolved||Resolution||unable to reproduce|
|Summary||0015527: Upgrading database from 2.11.5 to 2.11.5|
|Description||Database error 1064 while doing query 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 'repeat repeatinterval integer default 0' at line 1|
Error, unable to rename column "repeat" in the table phplist_message to be "repeatinterval"
Please do this manually, refer to http://mantis.phplist.com/view.php?id=9001 for more information
that will have to go into documentation.
It has to do with a table column being called "repeat" which in earlier versions wasn't a reserved word, but since Mysql 4 is.
So, older databases may have the "repeat" column in the phplist_message table, which has to be renamed "repeatinterval"