| 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? |