DB Error: Table xxxxxx.articles' doesn't exist

Software Support
1

Hello,
“Huston I have o problem” :slight_smile:

After OJS try to upgrade from 2.4.7-1 to 3.1.1 there is problem: "DB Error: Table ‘xxxxxx.articles’ doesn’t exist

I don’t have php database backup :frowning: … so any possible help… how to solve it???

2

Hi @wegisss,

Have you run the upgrade script? See docs/UPGRADE for details.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hello, I found a problem and fixxed it.
But now at the end of upgrading to 3.1.1 I’m getting this message:
" A database error has occurred: Unknown column ‘u.gossip’ in ‘field list’ "

It hapend when I tryed to run;
UPDATE users u, (SELECT user_id, GROUP_CONCAT(DISTINCT setting_value SEPARATOR ’ ') AS groupedGossips FROM user_settings WHERE setting_name = ‘gossip’ AND setting_value <> ‘’ GROUP BY user_id) us SET u.gossip = us.groupedGossips WHERE us.user_id = u.user_id

Any ideas how to fix it?

4

Hi @wegisss,

What version of MySQL or MariaDB are you using?

Regards,
Alec Smecher
Public Knowledge Project Team

5

Hi @wegisss

The new column “gossip” for the DB table “users” is defined here pkp-lib/common.xml at ojs-3_1_1-0 · pkp/pkp-lib · GitHub.
This script should be executed during the upgrade here: https://github.com/pkp/ojs/blob/master/dbscripts/xml/upgrade.xml#L55.
Then later, at this place in the upgrade: https://github.com/pkp/ojs/blob/master/dbscripts/xml/upgrade.xml#L195, the old gossip settings should be moved to that new column: https://github.com/pkp/ojs/blob/master/dbscripts/xml/upgrade/3.1.1_update.xml#L46-L51.

It seems like the first change, addition of the new column to the DB table “users”, when executing the common.xml during the upgrade, is not applied for you for some reason.
Could you please double check that you have all these code lines in your code?
And also, do you start your upgrade always with the clean OJS 2.4.x backup? – not to start the upgrade on a data on which the upgrade was already tried once…
And finally, do you use the command line “php tools/upgrade.php upgrade” for the upgrade? If so, how does the log in the terminal look like (all the scripts that are run during the upgrade are displayed…)?

Best,
Bozana