Upgrade from 2.10.19 to 3.08 DB structure error

Questions & Problems about Installing or Upgrading with Version 3 phpList.
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Upgrade from 2.10.19 to 3.08 DB structure error

Postby edgar1 » 6:38am, Tue 23 Sep, 2014

Hi,
I upgraded and did a database structure check, all ok but the user_attribute:

user_attribute php_user_attribute No userindex (userid)
attindex (attributeid)
attuserid (userid,attributeid)

user_attribute
user_attribute

exist
attributeid No
userid No
value No

so I can't see any subscribers. Opened phpMyadmin, the users are in a table php_user_user
There is also 4 tables left with a different prefix from the old database, they are empty.
I checked the config.php file but don't really know if there is anything wrong in it.

Thanks
edgar1
phpList newbie
 
Posts: 3
Joined: 6:27am, Tue 23 Sep, 2014

Re: Upgrade from 2.10.19 to 3.08 DB structure error

Postby Dragonrider » 8:39am, Tue 23 Sep, 2014

Not come across this before, have you updated your database from 2.10.x to 3.0.8 using the offered update database link?
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: Upgrade from 2.10.19 to 3.08 DB structure error

Postby edgar1 » 8:55am, Tue 23 Sep, 2014

yes, I did apply the update that was offered after upgrading.
edgar1
phpList newbie
 
Posts: 3
Joined: 6:27am, Tue 23 Sep, 2014

Re: Upgrade from 2.10.19 to 3.08 DB structure error

Postby edgar1 » 12:40pm, Tue 23 Sep, 2014

Looks ok now, had to rename some tables, which still had the names from the 2.10.19 version. Also a few permission issues. Did another DB check and now it's running, with users/attributes and lists showing up. Fingers crossed it'll stay that way... :D
thanks, edgar1
edgar1
phpList newbie
 
Posts: 3
Joined: 6:27am, Tue 23 Sep, 2014


Return to Installing and Upgrading

Who is online

Users browsing this forum: No registered users and 0 guests