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'?