phplist version 2.10.10
drupal version 6.13
Perhaps this is just a configuration problem, but as I look at it, a bug seems more likely.
I have the following error:
user warning: Table 'wingand_list.drupphplist_list' doesn't exist query: SELECT DISTINCT l.id as lid, l.name as name, l.description as description, (SELECT userid FROM drupphplist_listuser t2 WHERE t2.listid=l.id AND userid=1091) as 'userid' FROM drupphplist_list l LEFT OUTER JOIN drupphplist_listuser t2 ON l.id = t2.listid WHERE active=1 ORDER BY listorder in /hsphere/local/home/wingandaprayer/a-wing-and-a-prayer.org/sites/all/modules/phplist/phplist.module on line 707.
The table prefix config is:
Table prefix: drupphplist_
User table prefix: phplist_user_
During the Drupal setup, I chose "drup" as a prefix. The phpList was installed with the default "phplist".
The above error points to 'wingand_list', which is the list db, but the extension, 'drupphplist_list' logically doesn't exist in that db as it doesn't know about the drup prefix. That is, unless, of course, it was created programmaticlly.
Although I don't know enough to understand what is actually going on, it was the tweak made in http://drupal.org/cvs?commit=212894 that suggested that it might be a bug. Hopefully, it is a simple config error, either way, I would really appreciate your help in making this work. Thanking you in advance.
Comments
Comment #1
robatk commentedComment #2
robatk commentedWhile I wait and hope (pray) for some assistance, I decided to try and resolve the problem by setting up a new db without the table prefix, but I have a list of sql errors and the mod won't run. So I was wondering if anyone has been able to get this running working with the latest upgrades? Anyone?
Comment #3
paulbeaney commentedImplicit by later issues that this has been resolved. Please update when progress is made to avoid cluttering up the issues queue.
Regards,
- Paul