Upgrading from 1.7.3 to 1.8.0.2

ab92014

HiI am attempting to upgrade OS Ticket 1.7.3 to 1.8.0.2. The upgrade script works perfectly fine, however when I sign back into the admin system to view tickets, ticket statistics (i.e. # of open etc.) are displayed but no actual tickets are.I have attempted to upgrade several times, but constantly receive the following error below via e-mail.OS: CentOSApache Version: 2.4.7PHP Version: 5.4.24Any help would be greatly appreciated!

Table .sup_ticket__cdata' doesn't exist

---- Backtrace ----

#0 (root)/include/mysqli.php(132): osTicket->logDBError('DB Error #1146', '[SELECT ticket....')

#1 (root)/include/staff/tickets.inc.php(250): db_query('SELECT ticket.t...')

#2 (root)/scp/tickets.php(626): require_once('/home/...')

#3 {main}

ntozier

Check your backup and look at /include/ost-config.php.Make sure that your database settings and table prefix match the new ost-config file.#Mysql Login infodefine('DBTYPE','mysql');define('DBHOST','localhost'); define('DBNAME','dbname');define('DBUSER','dbusername');define('DBPASS','dbuserpass');#Table prefixdefine('TABLE_PREFIX','sup_');

scianiac

I see to have the same issue, the cdata table simply doesn't exist. I looked at the install sql to see if I could manually add the table but there is no cdata table in the install sql.