Did you ever get this annoying error?

Save failed with the following error: 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 '' at line 1 SQL=INSERT INTO ***_contentitem_tag_map

It's caused by a faulty upgrade. The cure is simple, just run a query like this in phpMyAdmin:

INSERT INTO `databasename`.`xxxxx_tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`, `publish_up`, `publish_down`) VALUES ('1', '0', '0', '5', '0', '', 'ROOT', 'root', '', '', '1', '0', '0000-00-00 00:00:00', '1', '', '', '', '', '0', '0000-00-00 00:00:00', '', '0', '0000-00-00 00:00:00', '', '', '0', '', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

Be aware, that this is qualifying as a core hack. Make backups, tighten your safety belts, cross your fingers and do whatewer makes you feelin' safe Laughing

0
0
0
s2sdefault
Category: Joomla Troubleshooter