Hi all,I'm getting spammed by alerts@domain.com with this error message:

Table 'osticket.ost_draft' doesn't exist<br />

<br />

---- Backtrace ----<br />

#0

C:\inetpub\wwwroot\osTicket\upload\include\mysqli.php(169):

osTicket->logDBError('DB Error #1146', '[INSERT INTO os...')<br />

#1

C:\inetpub\wwwroot\osTicket\upload\include\class.draft.php(91):

db_query('INSERT INTO ost...')<br />

#2

C:\inetpub\wwwroot\osTicket\upload\include\class.draft.php(109):

Draft->save(0, Array, Array)<br />

#3

C:\inetpub\wwwroot\osTicket\upload\include\ajax.draft.php(22):

Draft->create(Array, Array)<br />

#4

C:\inetpub\wwwroot\osTicket\upload\include\ajax.draft.php(199):

DraftAjaxAPI->_createDraft(Array)<br />

#5 : DraftAjaxAPI->createDraft('ticket.note.113')<br

/>

#6

C:\inetpub\wwwroot\osTicket\upload\include\class.dispatcher.php(145):

call_user_func_array(Array, Array)<br />

#7

C:\inetpub\wwwroot\osTicket\upload\include\class.dispatcher.php(38):

UrlMatcher->dispatch('ticket.note.113', Array)<br />

#8

C:\inetpub\wwwroot\osTicket\upload\include\class.dispatcher.php(120):

Dispatcher->resolve('ticket.note.113', Array)<br />

#9

C:\inetpub\wwwroot\osTicket\upload\include\class.dispatcher.php(38):

UrlMatcher->dispatch('/draft/ticket.n...', NULL)<br />

#10 C:\inetpub\wwwroot\osTicket\upload\scp\ajax.php(172):

Dispatcher->resolve('/draft/ticket.n...')<br />

#11 {main}

Additional details:

Mail Sending: SMTPMail Fetching: IMAP PollingPHP Version: 5.3OS: Windows Server 2008 R2Client/Staff UI: BothURL: Any ticket creation/viewing/editing URL

Any ideas?

This is the interesting part: "Table 'osticket.ost_draft' doesn't exist"Please provide additional info and also tell us if you upgraded your osTicket installation recently or modified your database or so:http://forum.osticket.com/d/discussion//please-read-before-requesting-assistance#latest

Hey Chefkeks, thanks for taking a look.Briefly, our mail exchange server had a catastrophic failure a while back. I won't go into details other than to say a team of Microsoft techs couldn't bring it back to life and it had to be rebuilt. It was also, for reasons unknown to me, hosting osTicket over IIS.Anyway, I looked for a recovery procedure on the wiki but couldn't find anything. I managed to recover the database from a backup and setup osTicket again pointing to the database. Other than this, everything appears to work fine.Any other details that would be helpful? I'll provide as much as I can.

Make a backup before you do anything I or some other member of the forum suggest and use a clean machine for testing purposes - don't do the stuff on your live system! ;) My suggestion would be:- Install a test installation of osTicket and have a look at the database. Compare the new database to your database. - Copy the missing table "ost_draft" and other tables that are also missing to your database.Alternatively you can do this:- Install a test installation of osTicket.- Export all the data of your database- Import the data (do not overwrite the complete new test database - so that the tables that are missing will be there afterwards)This is maybe a bit tricky, but with one of my suggestions and a bit technical knowledge etc. it should be possible to get a working osTicket without any errors and all your data.

Okay, great, that sounds like a plan.I'll try them out and let you know how I got on.Thanks.

Write a Reply...