Saturday, December 22, 2007

Joomla problem with incorrect SQL export

Today I had experienced a weird problem with my Joomla upload. After uploading to live server, my mod_smoothgallery from OsCandy was not displaying and StopPress Module that should be appear on top all other content was not displaying but was blocking all other so they can not be clicked. When I enter administration site, the menu was not displaying either. Because of that, I thought the problem was only effecting JavaScript related components and also related to files/folder permission mode. I tried to change mode the files and folders, but still there was no effect. And then I installed another instance of Joomla using Elefante Installer, an automated script installer provided by the hosting provider.

After installing fresh copy of Joomla, I check the administration menu bar, and there it was. And when I check the files permission are the same with the one I had. So, I tried to copy all the files to overwrite my site with no good result. Finally I found the problem was with the SQL export-import. I export SQL from my localhost development server by using HeidiSQL and apparently it gives incompatible format so when I import to the live server it was not importing properly. Thank goodness I was using Apace2Triad which comes with PhpMyAdmin so I just re-export from there and re-import from the live server's PhpMyAdmin. Voila! it worked perfectly again. So, the site can run smoothly from now.
Please visit the site at www.chinese-studies.org. We will updating more content in the future, so please visit often for you guys who interested in chinese cultures ;)