Hi Paul,

Hope this message finds you fabulous! I've just tried the upgrade to 6.x.-1.3 and have some problems.

I ran update.php, selected non-system roles and 'synchronise now"

Errors on visiting any user:

Receive in pink Looking for lists for email xxatxx.com
Looking up PHPlist id for email xxatxx.com

In dblog:

Table mydatabase.phplist_user_user_attribute doesn't exist query: REPLACE INTO phplist_user_user_attribute VALUES(28, 28173, 'on') in /home/public_html/sites/all/modules/phplist/phplist.module on line 1315.

Looking forward to your reply, and thank you.
Lilian

CommentFileSizeAuthor
#8 phplist.gif9.77 KBliliplanet
#8 roles.gif15.65 KBliliplanet

Comments

paulbeaney’s picture

paulbeaney commented

Hi Lilian,

I am *always* fabulous ;-)

Is 'mydatabase' your PHPlist database or your Drupal database? Have you checked in the database whether the table really does exist or not?

Regards,

- Paul

paulbeaney’s picture

paulbeaney commented
Status: Active » Closed (cannot reproduce)

Closing as no further information forthcoming.

liliplanet’s picture

liliplanet commented
Version: 6.x-1.3 » 7.x-1.x-dev
Status: Closed (cannot reproduce) » Active

Hi Paul,

Hope you are very well. Paul, I'm doing a clean install of your fabulous module to sync with the same phplist database (external server)

Un- and re-installed phplist.module but still receiving:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_database.phplist_user_user_attribute' doesn't exist: REPLACE INTO phplist_user_user_attribute VALUES(:did, :uid, :val); Array ( [:did] => 37 [:uid] => 28173 [:val] => on ) in _phplist_update_attribute() (line 1304 of /home/public_html/sites/all/modules/phplist/phplist.module).

my_database.phplist_user_user_attribute is on the Drupal installation ..

and checked in sql and can confirm it is not there, only table phplist_access exists

Do you perhaps have an idea of the direction I should take on how to fix this please?

Most appreciated! Lilian

liliplanet’s picture

liliplanet commented

Just a little update as maybe with this we can track down the problem :)

whenever a user visits user/xxx/newsletters the following:

Looking for lists available to user@mail.com

In dblog .. Notice: Use of undefined constant PHP_DEBUG - assumed 'PHP_DEBUG' in _phplist_get_lists() (line 1108 of /home/public_html/sites/all/modules/phplist/phplist.module).

Notice: Undefined property: stdClass::$mail in _phplist_get_lists() (line 1109 of /home/public_html/sites/all/modules/phplist/phplist.module).

paulbeaney’s picture

paulbeaney commented

Hi Lilian,

Sounds to me like you've not installed the right version of the module - the line numbers in your error messages don't tally with the latest version of D7-DEV. Please donwload again and see what happens?

Regards,

- Paul

liliplanet’s picture

liliplanet commented

Paul! fabulous news .. I've worked out in the past couple of days how to send a html fetch template (rss feeds) via phplist. Are you still interested?

Re the error, my site is an upgrade from D6, surely if I uninstall phplist (from database) I will lose the users newsletter preferences?

Have just deleted and uploaded fresh D7-dev and unfortunately still same errors.

Looking most forward to your reply :)

paulbeaney’s picture

paulbeaney commented

Hi Lilian,

I've worked out in the past couple of days how to send a html fetch template (rss feeds) via phplist. Are you still interested?

Thanks, but I no longer use PHPlist (hence why I am looking for co-maintainers for this module as I no longer have the time to develop it).

Notice: Use of undefined constant PHP_DEBUG - assumed 'PHP_DEBUG' in _phplist_get_lists() (line 1108 of /home/public_html/sites/all/modules/phplist/phplist.module).

You can fix this by changing PHP_DEBUG to PHPLIST_DEBUG at the line indicated. I am working on an updated D7 version which has the correction, but is still in progress so I can't update the release yet.

Base table or view not found: 1146 Table 'my_database.phplist_user_user_attribute' doesn't exist

Sounds like confusion over table prefixes - In your PHPlist database (NOT Drupal), what is the full name of the table which ends 'user_attribute', and what do you have your prefixes set to in the PHPlist module admin settings?

Regards,

- Paul

liliplanet’s picture

liliplanet commented
StatusFileSize
new roles.gif15.65 KB
new phplist.gif9.77 KB

Oh Paul, I've uninstalled and installed several times the Drupal phplist.module and even rebuilt my phplist database installation and actually now its pretty much a mess.

When I re-install with the devel.module and get a clean slate, the moment I enter the db details .. unable to click on any of the links ie External PHPlist configuration or List Access.

In the past couple of days

I've uninstalled phplist.module completely, removed all mention in the localhost database
Imported my users into a clean external phplist installation

Re-installed phplist.module and hmmm this is where I'm at now, cannot configure further than just adding the db details.

1. Where does the phplist.module save the users choice of newsletters?
2. Is there perhaps a way to remove the roles inserted by the module from the phplist installation and start again?

Attached Screenshots:

1. phplist.gif = cannot click on links to configure list access
2. roles.gif = example user in phplist installation seems to have additional roles ie Drupal role - 8 where is should only be Premium, Platinum etc. Is that correct?

If I can start from scratch in any way, most appreciate your assistance Paul, as this is quite urgent.

PS. sorry re your question ..

phplist_user_rss
phplist_user_user
phplist_user_user_attribute

liliplanet’s picture

liliplanet commented
Status: Active » Reviewed & tested by the community