Idea Error - 1050

Hi dear,
I cant complete the installation of kunena 1.7.1 by this error:

Table 'wcs_kunena_version' already exists SQL=CREATE TABLE `WCS_kunena_version` ( `id` int(11) NOT NULL auto_increment, `version` varchar(20) NOT NULL, `versiondate` date NOT NULL, `installdate` date NOT NULL, `build` varchar(20) NOT NULL, `versionname` varchar(40) NULL, `state` text NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

You have mismatch between database prefix and prefix setting in Joomla. Database uses lower case when your site thinks that it's using upper case. Is this Joomla 1.7?

Hi Matias
Yes it is joomla 1.7, and i agree with you because my sufix on data base is WCS_ and i have a couple problem when i try to install third part aplications in my joomla plataform, i leave somes topics in diferents forums about this issue, i want to change my sufix of WCS_ to the default sufix jos_ but nobody explain to me how can i do that, can you help me with it?
Thank so much i apreciate it.

I would go to phpMyAdmin and look what's the database prefix in the real tables.

If it is lower case, you just need to change prefix from Global Configuration > Server > Database Settings > Database Tables Prefix to wcs_ (lower case).

If the tables are in upper case, you need to rename them (can be easily done in phpMyAdmin) and do the above step with the new prefix after doing this.

Hi Matias
I fix the problem with the suffix in the data base already, the front end of my web is good, now when im try to log in to back end this errors come out:

500 - Se ha producido un error.

Table 'worldcross.jos_languages' doesn't exist SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name FROM jos_content AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by ORDER BY a.hits DESC LIMIT 0, 5

Volver al panel de control

Table 'worldcross.jos_languages' is not related to Kunena. The rest of the error message also has nothing to do with Kunena. This indicates that the problem is a Joomla problem or something caused by another Joomla extension.