[SOLVED] 1050 Table xz685_comprofiler already exists

I recently updated 1.9 to 2.0. When I run the CB db checker CB stops working and I get this:

1050 Table '.\kiwiseb\xzz_comprofiler' already exists SQL=ALTER TABLE `xzz_comprofiler` ENGINE = 'InnoDB'

How do I fix that? thx

Navigate to _comprofiler_fields within phpmyadmin and ensure none of your fields "table" columns have the actual table prefix. They should all be "#__" and not "xzz_".

They all are "#__". What next?

Ensure your MYSQL user that you've supplied the username/password to Joomla has correct permissions within phpmyadmin. Alter table should not throw a table already exists error as that doesn't make any sense unless a function permission is being rejected. The alternative is to manually edit your CB database tables and change the Engine to Innodb (the tool is trying to change CBs engine to the now used Innodb). What MYSQL version do you have?

I cannot imagine this being a permission problem because no other component has a problem. I use 5.5.32 and PHP 5.4.19.

Anyway, would you be able to give my the SQL statement I would need to run for the manual update? I cannot go through each and every single CB table by hand. Thanks

I cannot imagine this being a permission problem because no other component has a problem.

Depends on if your components run an ALTER TABLE query and if they output or suppress the error if it occurs. MYSQL version looks ok though. I was unable to duplicate your issue and the tool changed the engine from MyISAM to InnoDB fine.

Anyway, would you be able to give my the SQL statement I would need to run for the manual update? I cannot go through each and every single CB table by hand. Thanks

You only need to change CBs tables. There's no query to change the Engine for all of them in a single query. It has to be done table by table. The query to do this for one of the CB tables is provided in your error as follows.