Attached is a list of queries that need to be run in order to update existing installs to PHPList 2.10.1.

How I composed this list:

I did a dump of the .sql file that comes with PHPList and got rid of the tables not used by the phplist module.

I then created a dump of the phplist.mysql that comes with massmailer head (the one that is intended to work with 2.93).

I then created a dump of the database for the 2.10.1 dump, minus the extra tables.

I diff'd the two dumps and compared them.

After comparing them I composed this file and then ran this file on the database created with the current schema dump (the 2.93 one from Druapal HEAD).

I ran the composed update against the DB with to which I had earlier dumped the current schema.

Finally, I compared a dump of the (2.93 + update) schema and the newer, 2.10.1 schema. The columns matched (though not the order of the columns in the tables). In anycase, this sequence of alter table statements will make the present, 2.93 schema consistent with the 2.10.1. However, I only looked at existing tables. Further testing is encouraged to see if there weren't any new phplist tables added, that might be necessary for massmailer to function properly.

-Ankur

CommentFileSizeAuthor
phplist.update.mysql931 bytesankur

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented

ALTER TABLE phplist_user_user DROP drupalid;

We need that one. :)

killes@www.drop.org’s picture

killes@www.drop.org commented
Version: 4.6.x-1.x-dev »
Status: Needs review » Fixed

committed to HEAD (minus the line we need).

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
jesse_idc@civicspacelabs.com’s picture

jesse_idc@civicspacelabs.com commented
Version: » 4.6.x-1.x-dev
Category: task » bug
Status: Closed (fixed) » Active

Using the CVS massmailer.module and CVS phplist.module with the 2.10.1 phplist software and Ankur's added mysql alters listed here lead me to this problem: I can't create new lists. I get an error in watchdog that the "public" column in table "phplist_list" is missing.

So, I'm assuming you don't want to keep ALTER TABLE phplist_list DROP public; or else there is an update to massmailer.module that I am not finding.

Of course I'm having other problems with massmailer but we'll see if I can fix those on my own yet
-jesse@idcwebdev.com