Fatal Error upgrading 1.7.1 to 1.8.0.2

skwaler

Hi,I am getting the following error upgrading 1.7.1 to 1.8.0.2.Guess i'm missing the attachment table, though not sure how. Any advice on fixing would be greatly appreciated.

Table 'ost.ATTACHMENT_TABLE' doesn't exist<br

/>

---- Backtrace ----

C:\inetpub\OST\upload\include\mysqli.php(132):

osTicket->logDBError('DB Error #1146', '[INSERT INTO AT...')

#1 C:\inetpub\OST\upload\include\upgrader\streams\core\d51f303a-dad45ca2.task.php(27):

db_query('INSERT INTO ATT...')

C:\inetpub\OST\upload\include\class.upgrader.php(371):

NewHtmlTemplate->run(30)

C:\inetpub\OST\upload\include\class.upgrader.php(122):

StreamUpgrader->doTask()

#4 C:\inetpub\OST\upload\scp\upgrade.php(39):

Upgrader->doTask()

#5 {main}

Fatal error: Uncaught exception 'Exception' in C:\inetpub\OST\upload\include\class.orm.php Stack trace: #0 C:\inetpub\OST\upload\include\class.dynamic_forms.php(119): VerySimpleModel->save(false) #1 C:\inetpub\OST\upload\include\class.dynamic_forms.php(133): DynamicForm->save() #2 C:\inetpub\OST\upload\include\upgrader\streams\core\dad45ca2-61c9d5d7.task.php(15): DynamicForm:(Array) #3 C:\inetpub\OST\upload\include\class.upgrader.php(371): DynamicFormLoader->run(30) #4 C:\inetpub\OST\upload\include\class.upgrader.php(122): StreamUpgrader->doTask() #5 C:\inetpub\OST\upload\scp\upgrade.php(39): Upgrader->doTask() #6 {main} thrown in C:\inetpub\OST\upload\include\class.orm.php on line 182

ntozier

This is the SQL to create the attachment table. Did you alter your installation after installing 1.7.1?(like maybe by moving attachments out of the database)CREATE TABLE `%TABLE_PREFIX%ticket_attachment` ( `attach_id` int(11) unsigned NOT NULL auto_increment, `ticket_id` int(11) unsigned NOT NULL default '0', `file_id` int(10) unsigned NOT NULL default '0', `ref_id` int(11) unsigned NOT NULL default '0', `ref_type` enum('M','R','N') NOT NULL default 'M', `created` datetime NOT NULL, PRIMARY KEY (`attach_id`), KEY `ticket_id` (`ticket_id`), KEY `ref_type` (`ref_type`), KEY `ref_id` (`ref_id`), KEY `file_id` (`file_id`)) DEFAULT CHARSET=utf8;note: change %TABLE_PREFIX% to the prefix you used. I find that most people use "ost_"