Page 1 of 1

Upgrade from 2.10.19 to 3.08 DB structure error

PostPosted: 6:38am, Tue 23 Sep, 2014
by edgar1
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

Re: Upgrade from 2.10.19 to 3.08 DB structure error

PostPosted: 8:39am, Tue 23 Sep, 2014
by Dragonrider
Not come across this before, have you updated your database from 2.10.x to 3.0.8 using the offered update database link?

Re: Upgrade from 2.10.19 to 3.08 DB structure error

PostPosted: 8:55am, Tue 23 Sep, 2014
by edgar1
yes, I did apply the update that was offered after upgrading.

Re: Upgrade from 2.10.19 to 3.08 DB structure error

PostPosted: 12:40pm, Tue 23 Sep, 2014
by edgar1
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