After update I can not access my lists

ℹ️ Support
#1

Updated from phpList 2.1 to 3.2.0 then to 3.4.2.

After update to 3.2, I converted and initialized the databases and everything seemed to be OK, at least I got a “successful” prompt. I can see my old campaigns and view them with statistics

I then proceeded to update to 3.4.2. On startup I get no error messages.

The List names are all there but the number of subscribers shows as zero and I can not upload from a CSV file to any of them. The following message appears when I select Lists.

Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist
Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist
Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist
Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist
Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist
Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist
Database error 1146 while doing query Table ‘cavucomp_php1.phplist_user_user’ doesn’t exist

I have no idea what is wrong.

#2

@CAVUCO Did you try closing the browser and trying on a private window? That’s usually caused by a session problem.

1 Like
#3

Yes, tried a different browser too. Same result

#4

@CAVUCO Are you using the same config.php file as before the upgrades? it looks as if this line is incorrect. Maybe you had a different value before the upgrades

$usertable_prefix = 'phplist_user_';

You can use phpmyadmin or similar to confirm what the table name really is.

#5

That setting is what the old config.php file contained.

Does the database name end in “.sql.gz”?

My original file by this name < database name>.sql.gz exists in the backup folder above the new folder structure of public_html\lists.

Is this the right placement? Does phpmyadmin read a compressed file like that?

#6

That is a backup of the database, not the database itself. If you have phpmyadmin then you should be able to see what the tables are actually called, e.g.
image

#7

Your example is exactly what mine says. Is the prefix ‘phplist_’

Should I make the entry $usertable_prefix = ‘phplist_’;

#8

That worked. Thank you very much

1 Like