Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
Vyper Offline
New Member
 
Posts: 2
Join Date: Oct 2006
Can't access articles after migration - 25-10-2006, 10:46 PM

Yesterday my webhost moved my site from one shared hosting server to another. Nevermind the reason why, but I was not notified in advance. This site hosted v3 and after the move nothing at all was working. When I contacted them they said it had something to do with the size of the database, so they told me they would fix it, and things appeared to be working.

However, I noticed today that when I click on any of the articles we had published in the past I would get the following error message:

Invalid SQL: SELECT * FROM `swkbarticles` AS kbarticles LEFT JOIN `swkbarticledata` AS kbarticledata ON (kbarticles.kbarticleid = kbarticledata.kbarticleid) WHERE kbarticles.kbarticleid = '18'; (Can't open file: 'swkbarticledata.MYI'. (errno: 138))
Fatal error: ERROR: You are not allowed to view this article or the article does not exist. in /home/username/public_html/support/modules/knowledgebase/client_knowledgebase.php on line 150


I tried checking and repairing the database but have had no luck. When I go into Repair/Optimize in the admin backoffice of v3 it shows swkbarticledata with table type blank, table rows zero, size as zero, and index size zero. I am not a programmer but it seems as if the articles did not get moved or something. So I'm totally lost at this point since I'm not sure what else to try.

Any ideas?
   
Reply With Quote
  (#2) Old
Vyper Offline
New Member
 
Posts: 2
Join Date: Oct 2006
25-10-2006, 10:49 PM

Oh, I forgot to add. Most of the table types indicated MyISAM. There about 5 labeled HEAP. swkbarticledata is the only blank one under type. I'm not sure what any of this means.
   
Reply With Quote
Reply

Tags
access, articles, migration

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Knowledgebase - number of articles count Swish SupportSuite, eSupport and LiveResponse 41 23-11-2008 11:08 AM
templates and user access control larshammer SupportSuite, eSupport and LiveResponse 15 15-02-2007 11:15 PM



Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
Help desk software by Kayako.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48