Paul, I'm trying everything that I know to get this up, but I'm missing something. I've done fresh installs on both drupal and phplist. I see the checkbox for drupal in phplist, and I can see the newsletter tab under user, but I'm getting multiple errors all of the same sort as below. As it indicates, I can't find the phplist_access table. Please take a moment to help me. It is critical that I get this functioning.
user warning: Table 'wingand_Drupal_V2.phplist_access' doesn't exist query: SELECT lid FROM phplist_access WHERE lid=2 AND rid IN (2) in /hsphere/local/home/wingandaprayer/a-wing-and-a-prayer.org/sites/all/modules/phplist/phplist.module on line 719.
Comments
Comment #1
robatk commentedMaybe I can save some poor sap like me a couple of days of work by this post. Be sure that you have the latest readme.txt and run the sql code at the end of the page in your phpmyadmin. Never mind that it says that it is for an upgrade. At the time of this writing, I'm using phpList 2.10.10 and Drupal 6.13 on a pristine installation. I was getting non-stop errors until I ran this sql, but now I'm happy.
Comment #2
paulbeaney commentedHi robatk,
Glad you got the module working, but I don't understand why it gave you so much hassle - the {phplist_access} table is automatically created when you activate the module, so (in theory) you should never have to create it manually. I have just tested it again myself to confirm that this is indeed the case.
Sorry the support is sporadic, but please understand that I do my best. Time is a precious commodity of which I have very little.
Regards,
- Paul
Comment #3
robatk commentedHi Paul,
Found the correct upgrade and will give it a go. Of all the little annoyances that can really suck up time, I got going on two different download links
http://drupal.org/project/modules?text=phplist
http://drupal.org/project/phplist
and the one shows an old file, not the dev mod in question. It just drove me to distraction. Wasn't aware of an issue here.
Comment #4
paulbeaney commentedImplicit from #543466: User warning: Duplicate entry that this problem has been resolved.