Database Error
18-03-2009 by caldin1986When I try & run the SQL script for the web directory I get the following error: Error SQL query: -- -- Dumping data for table `subcategories` -- INSERT INTO `subcategories` (`id`, `title`, `titlu`, `category`) VALUES (1, 'Animation', 1), (2, 'Architecture', 1), (3, 'Art History', 1), (4, 'Bodyart', 1), (5, 'Celebreties' 1), (6, 'Classical Studies', 1), (7, 'Comics', 1), (8, 'Crafts', 1), (9, 'Design', 1), (10, 'Digital', 1), (11, 'Employment', 1), (12, 'Entertainment', 1), (13, 'Fashion', 1), (14, 'Graphic Design', 1), (15, 'Illustration', 1), (16, 'Literature', 1), (17, 'Movies', 1), (18, 'Music', 1), (19, 'Online Writing' 1), (20, 'People', 1), (21, 'Photography', 1), (22, 'Radio', 1), (23, 'Television', 1), (24, 'Typography', 1), (25, 'Video', 1), (26, 'Visual Arts', 1), (27, 'Board Games', 2), (28, 'Card Games', 2), (29, 'Coin Operated', 2), (30, 'Computer Games', 2), (31, 'Console Games', 2), (32, 'Conventions', 2), (33, 'Developers and Publishers', 2), (34, 'Dice Games', 2), (35, 'Fantasy Sport', 2), (36, 'Gambiling', 2), (37, 'G[...] MySQL said: #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 '1), (6, 'Classical Studies', 1), (7, 'Comics', 1), (8, 'Crafts', 1), (9, 'De' at line 6 Anyone with an Idea how I should make it work?
I don't understand where the problem is, the syntax seems to be in order. However, I exported the database from Redportal and add it to the download. Now it should work. Please download the Redtie Web Directory again and run the database.sql file.