Error when upgrading from osTicket (v1.9.8.1) to (1.12)

chopstixZ

Hi,

I'm getting the following error when attempting an upgrade from 1.9.8.1 to 1.12.

[RENAME TABLE ost_ticket_lock TO ost_lock] Can't find file: './osticketdb/ost_ticket_lock.frm' (errno: 2 - No such file or directory)

Any help would be greatly appreciated.

RBGE

What version of PHP is on your server, along with the web server software you're using? Do you get any errors in your PHP or Apache (or whatever server you're using) logs, such as write or access errors?

chopstixZ

RBGE

I'm running the following:

PHP v5.4 or later - (7.2.19-0ubuntu0.18.04.1)
MySQLi extension for PHP- (module loaded)
MySQL v5.0 or later - (5.6.40)

The apache error logs display the following lines:

[Mon Jul 15 06:25:01.911732 2019] [mpm_prefork:notice] [pid 4506] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations
[Mon Jul 15 06:25:01.911765 2019] [core:notice] [pid 4506] AH00094: Command line: '/usr/sbin/apache2'
[Mon Jul 15 16:15:12.400897 2019] [php7:error] [pid 8504] [client 5.188.210.101:56765] script '/var/www/upload/echo.php' not found or unable to stat, referer: https://www.google.com/
[Mon Jul 15 18:14:03.560194 2019] [php7:error] [pid 11516] [client 124.251.44.162:2470] script '/var/www/upload/elrekt.php' not found or unable to stat
sh: 1: /usr/sbin/sendmail: not found
[Mon Jul 15 23:02:13.856689 2019] [php7:warn] [pid 8503] [client 203.201.139.122:57405] PHP Warning: session_destroy(): Session callback expects true/false return value in /var/www/upload/scp/logout.php on line 30, referer: http://helpdesk-dev.triplep.net/scp/logs.php
[Mon Jul 15 23:02:13.856731 2019] [php7:warn] [pid 8503] [client 203.201.139.122:57405] PHP Warning: session_destroy(): Session object destruction failed in /var/www/upload/scp/logout.php on line 30, referer: http://helpdesk-dev.triplep.net/scp/logs.php
sh: 1: /usr/sbin/sendmail: not found
[Mon Jul 15 23:04:52.087433 2019] [php7:warn] [pid 8504] [client 203.201.139.122:57454] PHP Warning: session_destroy(): Session callback expects true/false return value in /var/www/upload/scp/logout.php on line 30, referer: http://helpdesk-dev.triplep.net/scp/logs.php
[Mon Jul 15 23:04:52.087490 2019] [php7:warn] [pid 8504] [client 203.201.139.122:57454] PHP Warning: session_destroy(): Session object destruction failed in /var/www/upload/scp/logout.php on line 30, referer: http://helpdesk-dev.triplep.net/scp/logs.php
[Mon Jul 15 23:07:17.684330 2019] [mpm_prefork:notice] [pid 4506] AH00169: caught SIGTERM, shutting down
[Mon Jul 15 23:07:50.063771 2019] [mpm_prefork:notice] [pid 19311] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations
[Mon Jul 15 23:07:50.063830 2019] [core:notice] [pid 19311] AH00094: Command line: '/usr/sbin/apache2'

RBGE

chopstixZ You seem to have an unrelated issue with sendmail, but I'm noticing at the start you have errors about files echo.php and elrekt.php not being found. These aren't part of osTicket (or at least not 1.12 - were they present in a 1.9.x installation??) so I've no idea where those are coming from. It does look like Google has echo.php cached though ?

PHP version looks fine. Does it make any difference if you try to upgrtade to 1.10.6 first??

ntozier

Does your database have a table called ost_lock or ost_ticket_lock?

chopstixZ

Upgrading to 1.10 I get a weird blank Mailer Error (refer to screenshot attached).

I have both of those tables. Running a fresh upgrade off a new database backup I was getting a bunch of errors saying there was duplicate tables and columns. I was able to suppress them by removing the columns and tables. But now i'm stuck on the following error:

[INSERT INTO ost_thread (object_id, object_type, created) SELECT t1.ticket_id, 'T', t1.created FROM ost_ticket_thread t1 JOIN ( SELECT ticket_id, MIN(id) as id FROM ost_ticket_thread WHERE thread_type = 'M' GROUP BY ticket_id ) t2 ON (t1.ticket_id=t2.ticket_id and t1.id=t2.id) ORDER BY t1.created] Table 'osticketdb.ost_ticket_thread' doesn't exist.

I don't recall renaming/deleting that table while running the upgrade at all.

KevinTheJedi

@chopstixZ

First, you need to upgrade to PHP 5.6 in order to upgrade to v1.10.x or above.

Secondly, the error Can't find file: './osticketdb/ost_ticket_lock.frm' is from your database. Your database server cannot find the .frm file for the ost_ticket_lock table. You appear to be having database/database server issues that you need to resolve first. I googled this error and this is mostly caused by incorrect ownership/permissions on the files so I would start there.

Lastly, the error Table 'osticketdb.ost_ticket_thread' doesn't exist. is caused by an incorrect upgrade. You need to resolve all the other issues first before attempting to upgrade. You also need to restore to backup before you attempted any upgrade.

Cheers.