plus2
11-12-2006, 02:55 PM
I have just done a new install of V2.0 pro and am trying to load common_categories thru Administration panel. I have removed the 2 lines of text beginning with: TRUNCATE TABLE `{prefix}sequences`; . I have uploaded the file via Admin panel and I get this message:
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 'INSERT INTO `dir_categories` (`id`, `id_editor`, `id_parent`, `title`, `descr' at line 1
INSERT INTO `dir_categories` (`id`, `id_editor`, `id_parent`, `title`, `description`, `status`, `meta_description`, `meta_keywords`, `path`, `order`, `locked`, `unique_tpl`, `level`, `num_cols`, `neighbour`) VALUES (1, 0, 0, 'Arts', 'Arts Directory', 'active', '', '', 'arts', 1, '0', '0', 1, NULL, NULL);
I have not changed the file at all other than to remove the 2 sentences as recommended in this forum. I'm running PHP 4.4.4 and My SQL 4.1.21.
Your help would be greatly appreciated.
Thanks
Mike
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 'INSERT INTO `dir_categories` (`id`, `id_editor`, `id_parent`, `title`, `descr' at line 1
INSERT INTO `dir_categories` (`id`, `id_editor`, `id_parent`, `title`, `description`, `status`, `meta_description`, `meta_keywords`, `path`, `order`, `locked`, `unique_tpl`, `level`, `num_cols`, `neighbour`) VALUES (1, 0, 0, 'Arts', 'Arts Directory', 'active', '', '', 'arts', 1, '0', '0', 1, NULL, NULL);
I have not changed the file at all other than to remove the 2 sentences as recommended in this forum. I'm running PHP 4.4.4 and My SQL 4.1.21.
Your help would be greatly appreciated.
Thanks
Mike