Not able to install osticket on ubuntu 22.04

rohan_d5

I am trying to configure a new osTicket 1.18.1 on a separate server on ubuntu 22.04 and i also have old osticket version
v1.15.4 and i tried to take the mysql dump of old version to a newer osTicket 1.18.1 because i require the old data to be reflected in a newer osticket version during osticket installation it showed that MYSQL table prefix ost_ is already presented so i change to osnew_ now i have old db mysql table prefix and new table prefix also everything went fine but when i tried to open the new osticket portal it doesn't work at all just give errors like

Parse error: syntax error, unexpected single-quoted string ");", expecting ")" in /var/www/prod-ticket.example.com/upload/include/ost-config.php on line 51

When i check the ost-config.php the line 51 is already commented out

Is that because of old osticket version v1.15.4 mysql table prefix already presented or its not supported at all in
newer version of osticket osTicket 1.18.1.

Please help I am stuck and not able to fix the osticket portal.

KevinTheJedi

rohan_d5

All you need to do is do a full dump of the old database, create a new database on the new server, import the old db to the new db you created, then setup the new osTicket code (and new builds of any plugins/language packs you already have installed) on the new server (don’t install just simply unpack the code and place it where you want it), copy the old include/ost-config.php to the new include/ folder on the new server, update the config info to match the new database info (if changed), login to osTicket on the new server, and run the upgrader.

You also obviously need to have all the latest requirements installed on the new server (like PHP version, MySQL/MariaDB version, and Apache/LiteSpeed/IIS webserver).

Cheers.

durangod2

Hi, i think you went about doing this all wrong from the very beginning. I would have ported over the older version along with the db on the new server and then ran the updater to update the version. That way everything is done internally without having to peacemeal data like you are trying to do. It is possible to fix what you have done but it will take quite a bit of work and the database data is not something that should be peacemealed.

If you can i would wipe the new install, port over the older version with the db and then run the updater.

Assuming you want to use the same data with the same users and the same domain but just on a new server.

make a whole server backup of the old install
zip the files on the old server for the osticket install
export the whole db
unpack the zip file on the new server (assuming same folder)
create a new db on the new server with the same name as the old one
import the old db file to the new db

if everything is the same you should be able to fire up the osticket on the new server.

Run the osticket updater

Check here
https://docs.osticket.com/en/latest/Getting%20Started/Upgrade%20and%20Migration.html

Maybe Kevin has another option for you... 🙂