Upgrade error: from 3.4.9.0 to 3.5.0.0

Software Support
1

When I upgrade ojs from 3.4.9.0 to 3.5 by the web, there is an error below.

Please help me. Thanks.

Describe the issue or problem

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘journals’ already exists (Connection: mysql, SQL: create table journals (journal_id bigint not null auto_increment primary key, path varchar(32) not null, seq float(53) not null default ‘0’ comment ‘Used to order lists of journals’, primary_locale varchar(28) not null, enabled smallint not null default ‘1’ comment ‘Controls whether or not the journal is considered "live" and will appear on the website. (Note that disabled journals may still be accessible, but only if the user knows the URL.)’, current_issue_id bigint null) default character set utf8 collate ‘utf8_general_ci’)

Apache blog:

[Wed Jun 25 16:40:15.560536 2025] [lbmethod_heartbeat:notice] [pid 139365:tid 139365] AH02282: No slotmem from mod_heartmonitor
[Wed Jun 25 16:40:15.560810 2025] [mpm_event:notice] [pid 139365:tid 139365] AH00489: Apache/2.4.62 (Unix) OpenSSL/3.0.16 configured – resuming normal operations
[Wed Jun 25 16:40:15.560820 2025] [core:notice] [pid 139365:tid 139365] AH00094: Command line: ＇/www/server/apache/bin/httpd＇
[Thu Jun 26 08:21:06.509722 2025] [mpm_event:notice] [pid 139365:tid 139365] AH00493: SIGUSR1 received. Doing graceful restart
[Thu Jun 26 08:21:06.554676 2025] [ssl:warn] [pid 139365:tid 139365] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Thu Jun 26 08:21:06.570748 2025] [lbmethod_heartbeat:notice] [pid 139365:tid 139365] AH02282: No slotmem from mod_heartmonitor
[Thu Jun 26 08:21:06.571014 2025] [mpm_event:notice] [pid 139365:tid 139365] AH00489: Apache/2.4.62 (Unix) OpenSSL/3.0.16 configured – resuming normal operations
[Thu Jun 26 08:21:06.571028 2025] [core:notice] [pid 139365:tid 139365] AH00094: Command line: ＇/www/server/apache/bin/httpd＇

php blog:

[25-Jun-2025 23:58:44] WARNING: [pool www] child 286265, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (38.387212 sec), logging
[25-Jun-2025 23:58:44] NOTICE: child 286265 stopped for tracing
[25-Jun-2025 23:58:44] NOTICE: about to trace 286265
[25-Jun-2025 23:58:44] NOTICE: finished trace of 286265
[26-Jun-2025 01:01:35] WARNING: [pool www] child 278394, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (39.469829 sec), logging
[26-Jun-2025 01:01:35] NOTICE: child 278394 stopped for tracing
[26-Jun-2025 01:01:35] NOTICE: about to trace 278394
[26-Jun-2025 01:01:35] NOTICE: finished trace of 278394
[26-Jun-2025 01:27:05] WARNING: [pool www] child 278398, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (37.197566 sec), logging
[26-Jun-2025 01:27:05] NOTICE: child 278398 stopped for tracing
[26-Jun-2025 01:27:05] NOTICE: about to trace 278398
[26-Jun-2025 01:27:05] NOTICE: finished trace of 278398
[26-Jun-2025 01:51:07] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 9 idle, and 28 total children
[26-Jun-2025 01:51:08] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 16 children, there are 8 idle, and 29 total children
[26-Jun-2025 01:51:09] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 32 children, there are 9 idle, and 31 total children
[26-Jun-2025 02:12:05] WARNING: [pool www] child 278416, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (32.392959 sec), logging
[26-Jun-2025 02:12:05] NOTICE: child 278416 stopped for tracing
[26-Jun-2025 02:12:05] NOTICE: about to trace 278416
[26-Jun-2025 02:12:05] NOTICE: finished trace of 278416
[26-Jun-2025 02:47:15] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 4 idle, and 37 total children
[26-Jun-2025 02:52:18] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 4 idle, and 37 total children
[26-Jun-2025 02:52:19] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 16 children, there are 9 idle, and 43 total children
[26-Jun-2025 03:16:48] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 1 idle, and 37 total children
[26-Jun-2025 03:16:49] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 16 children, there are 9 idle, and 45 total children
[26-Jun-2025 03:20:26] WARNING: [pool www] child 367447, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (33.157334 sec), logging
[26-Jun-2025 03:20:26] NOTICE: child 367447 stopped for tracing
[26-Jun-2025 03:20:26] NOTICE: about to trace 367447
[26-Jun-2025 03:20:26] NOTICE: finished trace of 367447
[26-Jun-2025 05:09:46] WARNING: [pool www] child 367453, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (32.715240 sec), logging
[26-Jun-2025 05:09:46] NOTICE: child 367453 stopped for tracing
[26-Jun-2025 05:09:46] NOTICE: about to trace 367453
[26-Jun-2025 05:09:46] NOTICE: finished trace of 367453
[26-Jun-2025 05:45:27] WARNING: [pool www] child 367455, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (30.133688 sec), logging
[26-Jun-2025 05:45:27] NOTICE: child 367455 stopped for tracing
[26-Jun-2025 05:45:27] NOTICE: about to trace 367455
[26-Jun-2025 05:45:27] NOTICE: finished trace of 367455
[26-Jun-2025 07:06:47] WARNING: [pool www] child 367437, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (38.827140 sec), logging
[26-Jun-2025 07:06:47] NOTICE: child 367437 stopped for tracing
[26-Jun-2025 07:06:47] NOTICE: about to trace 367437
[26-Jun-2025 07:06:47] NOTICE: finished trace of 367437
[26-Jun-2025 07:14:37] WARNING: [pool www] child 359259, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (31.530595 sec), logging
[26-Jun-2025 07:14:37] NOTICE: child 359259 stopped for tracing
[26-Jun-2025 07:14:37] NOTICE: about to trace 359259
[26-Jun-2025 07:14:37] NOTICE: finished trace of 359259
[26-Jun-2025 07:20:57] WARNING: [pool www] child 367444, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (39.242993 sec), logging
[26-Jun-2025 07:20:57] NOTICE: child 367444 stopped for tracing
[26-Jun-2025 07:20:57] NOTICE: about to trace 367444
[26-Jun-2025 07:20:57] NOTICE: finished trace of 367444
[26-Jun-2025 07:23:37] WARNING: [pool www] child 367447, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (30.942898 sec), logging
[26-Jun-2025 07:23:37] NOTICE: child 367447 stopped for tracing
[26-Jun-2025 07:23:37] NOTICE: about to trace 367447
[26-Jun-2025 07:23:37] NOTICE: finished trace of 367447
[26-Jun-2025 08:01:37] WARNING: [pool www] child 367458, script ＇/www/wwwroot/chinesecs.cn/index.php＇ (request: ＂GET /index.php＂) executing too slow (35.812871 sec), logging
[26-Jun-2025 08:01:37] NOTICE: child 367458 stopped for tracing
[26-Jun-2025 08:01:37] NOTICE: about to trace 367458
[26-Jun-2025 08:01:37] NOTICE: finished trace of 367458

2

Hi @heiland,

I think I see two problems:

  1. You seem to be hitting the “Install” button rather than the “Upgrade” button. The installer is trying to create the journals table, which will already exist.
  2. If your installation reports version 3.4.9, it means you’ve already tried and failed an upgrade to 3.5.0. Do you have the error message from the first time you tried to upgrade? If not, you’ll need to restore from backup before trying again.

I also suggest using the command-line upgrade tool, if possible; most web servers will stop the upgrade process from running via the web based on configured timeouts.

Regards,
Alec Smecher
Public Knowledge Project Team

4

Thank you for your help. When I upgrade the ojs from 3.4.9 to 3.5, (did not install), there is another error:

  • 发生了一个数据库错误(database error): SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘invitations’ already exists (Connection: mysql, SQL: create table invitations (invitation_id bigint not null auto_increment primary key, key_hash varchar(255) null, type varchar(255) not null, user_id bigint null, inviter_id bigint null, expiry_date datetime null, payload json null, status enum(‘INITIALIZED’, ‘PENDING’, ‘ACCEPTED’, ‘DECLINED’, ‘CANCELLED’) not null, email varchar(255) null comment ‘When present, the email address of the invitation recipient; when null, user_id must be set and the email can be fetched from the users table.’, context_id bigint null, created_at timestamp null, updated_at timestamp null) default character set utf8 collate ‘utf8_general_ci’)
5

and another error:

  • 发生了一个数据库错误: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘redirect’ in ‘site’ (Connection: mysql, SQL: alter table site modify redirect bigint null)