ntozier

So just export the database and import, then login and done?

Can I do this after the installation of osTicket, or do I do this before installing osTicket?

Is there a step-by-step I can read?

ramrajone

I already have a new server setup with a fresh clean vanilla copy of osTicket v1.11.0-rc1 installed.

Can I skip step #3 and just import the old database into it?

Or do I need to wipe it, install osTicket 1.10.4 and then follow the steps above?

ntozier

Thanks guys, I attempted the upgrade, it told me "Something went wrong" then it took me to the 'upgrade complete'.

I tried going to the Admin panel, and got the same HTTP ERROR 500.

I looked in the logs, and I'm still running into that same error I posted above:

[Wed Jan 23 12:39:24.240392 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP Fatal error:  Class name must be a valid object or a string in /var/www/html/osticket/upload/include/class.forms.php on line 1088
[Wed Jan 23 12:39:24.240428 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP Stack trace:
[Wed Jan 23 12:39:24.240437 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   1. {main}() /var/www/html/osticket/upload/scp/index.php:0
[Wed Jan 23 12:39:24.240444 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   2. require() /var/www/html/osticket/upload/scp/index.php:17
[Wed Jan 23 12:39:24.240451 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   3. CustomQueue->getQuery() /var/www/html/osticket/upload/scp/tickets.php:531
[Wed Jan 23 12:39:24.240458 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   4. CustomQueue->getBasicQuery() /var/www/html/osticket/upload/include/class.queue.php:832
[Wed Jan 23 12:39:24.240465 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   5. CustomQueue->mangleQuerySet() /var/www/html/osticket/upload/include/class.queue.php:819
[Wed Jan 23 12:39:24.240473 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   6. CustomQueue->getSupportedMatches() /var/www/html/osticket/upload/include/class.queue.php:884
[Wed Jan 23 12:39:24.240480 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   7. CustomQueue::getSearchableFields() /var/www/html/osticket/upload/include/class.queue.php:309
[Wed Jan 23 12:39:24.240487 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   8. DynamicFormField->getImpl() /var/www/html/osticket/upload/include/class.queue.php:362
[Wed Jan 23 12:39:24.240494 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP   9. DynamicFormField->__call() /var/www/html/osticket/upload/include/class.queue.php:362
[Wed Jan 23 12:39:24.240501 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP  10. call_user_func_array:{/var/www/html/osticket/upload/include/class.dynamic_forms.php:600}() /var/www/html/osticket/upload/include/class.dynamic_forms.php:600
[Wed Jan 23 12:39:24.240509 2019] [:error] [pid 11896] [client 10.2.10.102:55220] PHP  11. FormField->getImpl() /var/www/html/osticket/upload/include/class.dynamic_forms.php:600

ramrajone

Come to think of it, I did do some customization in the Form tables in the database.

Damn. I wonder if there's a way if I can import everything but exclude the ost_form tables...

Thanks ramrajone.

So I built a quick shell script that allows me to rebuild the entire database structure, and ignore the data in the tables of the database that I customized. That way the customized tables will not be imported, just their structure; just because the initial errors I was getting were related to the "lists" and "form" related tables in the database, as those were the ones I had customized.

#!/bin/bash
PASSWORD="password"
HOST=localhost
USER=osticket
DATABASE=osticket
DB_FILE=dump.sql
EXCLUDED_TABLES=(
ost_form
ost_form_entry
ost_form_entry_values
ost_form_field
ost_help_topic_form
ost_list
ost_list_items
)

IGNORED_TABLES_STRING=''
for TABLE in "${EXCLUDED_TABLES[@]}"
do :
   IGNORED_TABLES_STRING+=" --ignore-table=${DATABASE}.${TABLE}"
done

echo "Dump structure"
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --single-transaction --no-data --routines ${DATABASE} > ${DB_FILE}

echo "Dump content"
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} ${DATABASE} --no-create-info --skip-triggers ${IGNORED_TABLES_STRING} >> ${DB_FILE}

So I did that, exported the database, then uploaded it and now I got different errors:

PHP Fatal error:  Uncaught exception 'DoesNotExist' in /var/www/html/osticket/upload/include/class.orm.php:1343\nStack trace:\n
#0 /var/www/html/osticket/upload/include/class.dynamic_forms.php(483): QuerySet->one()\n
#1 /var/www/html/osticket/upload/include/class.dynamic_forms.php(478): TicketForm::getNewInstance()\n
#2 /var/www/html/osticket/upload/include/class.ticket.php(2190): TicketForm::getInstance()\n
#3 /var/www/html/osticket/upload/include/class.queue.php(343): Ticket::getSearchableFields()\n
#4 /var/www/html/osticket/upload/include/class.queue.php(309): CustomQueue::getSearchableFields('Ticket')\n
#5 /var/www/html/osticket/upload/include/class.queue.php(884): CustomQueue->getSupportedMatches()\n
#6 /var/www/html/osticket/upload/include/class.queue.php(819): CustomQueue->mangleQuerySet(Object(QuerySet))\n
#7 /var/www/html/osticket/upload/include/class.queue.php(832): CustomQueue->getBasicQuery(false)\n
#8 /var/www/html/osticket/upload/scp/tickets.php(531): CustomQueue->getQuery(false, NULL)\n
#9 /var/www/html/osticket/upload/scp/index.php in /var/www/html/osticket/upload/include/class.orm.php on line 1343, referer: http://ops.nhsocal.com/scp/upgrade.php?c=4&r=21

Any ideas? What 'DoesNotExist'?

KevinTheJedi

Strange. Well at the moment I'm trying to dump everything except the "Form" related tables and use the vanilla structure of those tables. I'll see if that works.