UPDATING Problem from 3.1.2.4 to 3.2.x even from 3.0.2.0

Software Support
1

ADOConnection.Execute(CREATE TABLE submission_galley_settings AS SELECT * FROM article_galley_settings WHERE setting_name <> ‘excludeDoi’ AND setting_…) % line 442, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php) Installer.executeSQL(CREATE TABLE submission_galley_settings AS SELECT * FROM article_galley_settings WHERE setting_name <> ‘excludeDoi’ AND setting_…) % line 437, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php) Installer.executeSQL(Array[3]) % line 395, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php) Installer.executeAction(Array[3]) % line 263, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php)

getting this error for updating OJS 3.2 from OJS 3.1.2.4

OS platform Linux
PHP version 7.4.11
Apache version Apache
Database driver mysqli
Database server version 10.3.24-MariaDB-log-cll-lve

Tried several time from 3.2.0 to 3.2.1.1 but failed to update.

Can help me to resolve.

Thanks.

Zahirul

2

Hi @Ahm_Zahirul_Alam,

I don’t see the actual error message there – it should be above what you’ve quoted.

Regards,
Alec Smecher
Public Knowledge Project Team

3

• A database error has occurred: Table ‘submission_galley_settings’ already exists

Display ERRORS ( ADOConnection.Execute(CREATE TABLE submission_galley_settings AS SELECT * FROM article_galley_settings WHERE setting_name <> ‘excludeDoi’ AND setting_…) % line 442, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php)

Installer.executeSQL(CREATE TABLE submission_galley_settings AS SELECT * FROM article_galley_settings WHERE setting_name <> ‘excludeDoi’ AND setting_…) % line 437, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php)

Installer.executeSQL(Array[3]) % line 395, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php)

Installer.executeAction(Array[3]) % line 263, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php)
)

Tried several times from the fresh database. If I delete “submission_galley_settings” table
then following error

  • A database error has occurred: Duplicate column name ‘email_id’

Display ERRORS(
ADOConnection.Execute( ALTER TABLE email_templates_data ADD email_id BIGINT ) % line 442, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php) Installer.executeSQL( ALTER TABLE email_templates_data ADD email_id BIGINT ) % line 437, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php) Installer.executeSQL(Array[13]) % line 395, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php) Installer.executeAction(Array[3]) % line 263, file: [Installer.inc.php](file://home/alamyhle/public_html/ojs/lib/pkp/classes/install/Installer.inc.php)

)

From fresh installation A database error has occurred: Table ‘submission_galley_settings’ already exists

I will be very happy to get the solution. It is noted that this is a multi journal site.

Thanks.

Zahirul

4

Hi @Ahm_Zahirul_Alam,

Are you trying to re-run an upgrade on a database that’s already experienced a failed upgrade? If so, you’ll get errors like this. If an upgrade fails, make sure to restore your database from backup before trying again.

Regards,
Alec Smecher
Public Knowledge Project Team