Missing tables in a deployed database

streagle · **Missing tables in a deployed database -** 11-10-2007, 08:18 AM

Our administrator deployed a kayako database version 3.11.01 and connected the kayako site to it. Now we try to import data in it from our old 3.11.00 and discover that it is missing several tables:

swadcampaigns
swadhitlogs
swadsearchqueries
swalertactions
swalertrules
swattachmentchunks
swattachments
swattachmenttypes
swauditlogs

Is this normal or something with the database deployment got wrong and didn't create theese tables?

craigbrass · 11-10-2007, 09:36 AM

Well all you need to do to upgrade is upload the new files, go to /setup/ using your browser, click Upgrade and run through the tool. There is no need to import in. It would be a good idea to restore 3.11.00 and then retry the upgrade.

streagle · 11-10-2007, 10:05 AM

My mistake - we import data from our old helpdesk system into kayako. And the import script returns error that theese tables are missing. Why are they missing?

streagle · 11-10-2007, 10:17 AM

Scratch that - we found our missing tables. When our administrator tried to rename the database he failed, but mysql transfered part of the tables to the new named database. And those tables are our missing tables.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can i add new tables to existing kayako database	vineethshyam	SupportSuite, eSupport and LiveResponse	4	26-09-2006 08:00 AM
Import eSupport database into SupportSuite	one9	SupportSuite, eSupport and LiveResponse	0	02-09-2006 03:32 AM

craigbrass Offline Senior Member Posts: 5,552 Join Date: Jun 2005 Location: Cumbria, UK	11-10-2007, 09:36 AM Well all you need to do to upgrade is upload the new files, go to /setup/ using your browser, click Upgrade and run through the tool. There is no need to import in. It would be a good idea to restore 3.11.00 and then retry the upgrade. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

streagle Offline Member Posts: 34 Join Date: Aug 2007 Location: Bulgaria	11-10-2007, 10:05 AM My mistake - we import data from our old helpdesk system into kayako. And the import script returns error that theese tables are missing. Why are they missing?

streagle Offline Member Posts: 34 Join Date: Aug 2007 Location: Bulgaria	11-10-2007, 10:17 AM Scratch that - we found our missing tables. When our administrator tried to rename the database he failed, but mysql transfered part of the tables to the new named database. And those tables are our missing tables.