Hi,
I’m a new phpList user. I am trying to migrate a database from an old server to a new one.
I can see my subscriber lists and all that and everything seems to be working except that I get the this error when trying to create a campaign:
" Fatal error: Unable to create campaign, did you forget to upgrade the database? "
Okay, so I think the database has been upgraded. In fact when I first imported and logged in it asked to be upgraded and I did so. But still there is this error when trying to start a new campaign. Interestingly, I can continue one of the old campaign in the drafts, and send test emails out.
Any thoughts?
@skyleuba you can try verifying the database structure as there might be something wrong with the message table,
menu system > verify database structure
@skyleuba It looks like your original phplist database was too old to be updated to 3.5.5.
Depending on how far you have got with this, it might be best to upgrade your original phplist to the latest release, then transfer the database, if that is possible.
Otherwise you will have to add that column and any indexes to the database manually. The database schema is in file admin/structure.php.
But there may be other database changes that have not been applied which are not yet causing any problems, which is why upgrading the original database is safer.