TOPIC: Crash after installation in a migrated site

Hi,

after installation of CComment Lite 5.0.4 my Joomla 3.2.1 test website has crashed. Instead of articles and modules there is only an error report appearing:

"1054 Unknown column 'component' in 'where clause' SQL=SELECT * FROM `j25_comment_setting` WHERE component = 'com_content' "

Maybe the reason lies in the history of my website. I have started it with Joomla 1.5 and migrated it with Jupdate to 2.5. When I updated testing versions of the website to Joomla 3.x, there were some problems which have been solved in Joomla 3.2.

Now it seems that there are still problems possible with components, for example with CComments...

I can't comment on other components, but what has happened is that when you installed ccomment the tables were not properly updated. Look at sql/install.mysql.sql file and you'll see the correct table structure. then look at the tables you have on your site. Make the necessary modifications with phpmyadmin and it will start to work. You just need to add the missing tables and to change the old colums.
Additionally in the script.php you'll see the ALTER tables that we do when we detect an old version.
Regards,
Daniel

Unfortunately I am not experienced enough to check and change database tables. Is there an easier solution available?

There is no easier solution. Once the db gets "corrupted" one needs to correct the errors. One can correct the errors by adding and changing the fields that are missing from the db.

the only other easier solution would be to delete the tables and install ccomment again. But this way you actually lose the comments and I guess that yo don't want this.

Regards,
Daniel