[Solved] NMS loses lists when moving to a new server
Posted: Wed Jun 18, 2008 9:18 pm
CMSMS version 1.3
NMS version 2.0
MySQL 5.0.45
I pushed a development site to a new server, and suddenly my Newsletter Made Simple lists all vanished.
Strangely, they were still in the database when I looked. But my NMS subscribe tag was returning "No lists found to subscribe to".
The key to this is that MySQL has the bizarre idea that database table and field names are case-sensitive. They helpfully call this an extension to the SQL standard. Bah.
Some of the NMS code refers to a table using a different case than the table create scripts.
You can tell MySQL to ignore case. Edit your my.cnf, and add the line:
And everything in this most excellent module should be good to go.
___Samuel___
NMS version 2.0
MySQL 5.0.45
I pushed a development site to a new server, and suddenly my Newsletter Made Simple lists all vanished.
Strangely, they were still in the database when I looked. But my NMS subscribe tag was returning "No lists found to subscribe to".
The key to this is that MySQL has the bizarre idea that database table and field names are case-sensitive. They helpfully call this an extension to the SQL standard. Bah.
Some of the NMS code refers to a table using a different case than the table create scripts.
You can tell MySQL to ignore case. Edit your my.cnf, and add the line:
Code: Select all
lower_case_table_names=1
___Samuel___