[Solved] SQL Error in Control Panel in 2.0.1

[LTJ]

Once again hello.

As I mentioned I still have the same error as dino and not the 1064 above.
When removing (like dino pointed out) the collate is the way to resolve the error, it would be nice to have an "official" statement what exactly to do and why the database tables are missing (dino is missing them as well) causing the issue.

What's the intention of the SQL code if it can be removed !?

Some more light on this would be really helpful ...

Thanks,
Joe

[infograf768]

As far as I understand , the COLLATE statement is not necessary anyway as this table is (should be!) created on an already utf8 collated db.

Change in
administrator/components/com_joomfish/classes/JCacheStorageJFDB.php

around line 110

Code: Select all

. "\n ) CHARACTER SET utf8 COLLATE utf8_general_ci";

to

Code: Select all

. "\n ) CHARACTER SET utf8";

[spiteful_troll]

Hi.
Unfortunately solutions which were suggested here don't wokr for me.

My trouble:

In Control Panel appears such message:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8' at line 8 SQL=CREATE TABLE IF NOT EXISTS `jos_dbcache` ( `id` varchar ( 32 ) NOT NULL default '', `groupname` varchar ( 32 ) NOT NULL default '', `expire` datetime NOT NULL default '0000-00-00 00:00:00', `value` MEDIUMBLOB NOT NULL default '', PRIMARY KEY ( `id`,`groupname` ), KEY ( `expire`,`groupname` ) ) CHARACTER SET utf8
CREATE TABLE IF NOT EXISTS `jos_dbcache` ( `id` varchar ( 32 ) NOT NULL default '', `groupname` varchar ( 32 ) NOT NULL default '', `expire` datetime NOT NULL default '0000-00-00 00:00:00', `value` MEDIUMBLOB NOT NULL default '', PRIMARY KEY ( `id`,`groupname` ), KEY ( `expire`,`groupname` ) ) CHARACTER SET utf8 "

My parameters:

JoomFish 2.0.2
Joomla 1.5.9
PHP erstellt für: Linux asklepios.ispgateway.de 2.6.27.7-grsec #25 SMP Mon Feb 16 16:37:38 CET 2009 i686
Datenbankversion: 3.23.58-log
Datenbanksortierung: N/A (mySQL < 4.1.2)
PHP-Version: 5.2.6
Webserver: Apache/1.3 (Unix) mod_ssl/2.8.28 OpenSSL/0.9.8f AuthPG/1.3 FrontPage/5.0.2.2635

Help me please.
Thank you very much!

[baigtsa]

PROBLEM:
I got a 500 when accessing Control Panel (2.02)
JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where key_name = 'jfContent'' at line 1 SQL=show index from jos_jf_content where key_name = 'jfContent'


SOLUTION:

Change administrator/components/com_joomfish/helpers/controllerHelper.php at line 109
-----------------------------------------------------------------------------
FROM:
-----------------------------------------------------------------------------

Code: Select all

      if (!isset($data['jfContent'])){
         $sql = "ALTER TABLE `#__jf_content` ADD INDEX `combo` ( `reference_id` , `reference_field` , `reference_table` )" ;
         $db->setQuery($sql);
         $db->query();      
         $sql = "ALTER TABLE `#__jf_content` ADD INDEX `jfContent` ( `language_id` , `reference_id` , `reference_table` )" ;
         $db->setQuery($sql);
         $db->query();
         $sql = "ALTER TABLE `#__jf_content` ADD INDEX `jfContentLanguage` (`reference_id`, `reference_field`, `reference_table`, `language_id`)" ;
         $db->setQuery($sql);
         $db->query();
         
      }

-----------------------------------------------------------------------------
TO:
-----------------------------------------------------------------------------

Code: Select all

      if (!isset($data['combo'])){
         $sql = "ALTER TABLE `#__jf_content` ADD INDEX `combo` ( `reference_id` , `reference_field` , `reference_table` )" ;
         $db->setQuery($sql);
         $db->query();
      }
      if (!isset($data['jfContent'])){         
         $sql = "ALTER TABLE `#__jf_content` ADD INDEX `jfContent` ( `language_id` , `reference_id` , `reference_table` )" ;
         $db->setQuery($sql);
         $db->query();
      }
      if (!isset($data['jfContentLanguage'])){
         $sql = "ALTER TABLE `#__jf_content` ADD INDEX `jfContentLanguage` (`reference_id`, `reference_field`, `reference_table`, `language_id`)" ;
         $db->setQuery($sql);
         $db->query();
         
      }

-----------------------------------------------------------------------------
Alex Baigts.

[caro84g]

Hi,

are you posting a hack for an outdated version of Joom!Fish?

We're at 2.0.3 now

Regards, Carolien

[plusangel]

baigtsa's modification working in 2.0.4 version as well.

I had the same problem with control panel.

thanks