Hello,
Could somebody please help, i am just about getting my head around OSC !!
But when it comes to MYSQL well i do get a bit lost, i have just installed the Links Manager V1.5 and it all looks good, then i got to this bit of the installation:
------------------------------------
Further SQL CHANGES:
------------------------------------
1. Run this extra MySql statement to get control over the categories diplayed per row.
INSERT INTO `configuration` VALUES (2140, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many Link categories to list per row', 6502, 20, '2006-12-10 15:10:49', '2003-07-19 00:52:14', NULL, NULL);
----------------------------
2. To get the 'Our Link-Information' - Configuration into the
OSC Configuration,
Execute the SQL:
Add Links Manager ToConfig.sql
I have completed no 1 and got this:
Error
SQL query:
INSERT INTO `configuration`
VALUES ( 2140, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many Link categories to list per row', 6502, 20, '2006-12-10 15:10:49', '2003-07-19 00:52:14', NULL , NULL )
MySQL said:
#1062 - Duplicate entry '2140' for key 1
I have browsed the query AND mysql SAID :
SQL query:
SELECT *
FROM `configuration`
WHERE CONCAT_WS( "-", 2140, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many Link categories to list per row', 6502, 20, '2006-12-10 15:10:49', '2003-07-19 00:52:14', NULL , NULL ) = "2140"
ORDER BY 2140 , 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many Link categories to list per row', 6502, 20, '2006-12-10 15:10:49', '2003-07-19 00:52:14', NULL , NULL
LIMIT 0 , 30
MySQL said:
#1054 - Unknown column '2140' in 'order clause'
Also i am totally lost with what 2 mean could anybody explain in english what i have to do ???
Thanks a Million
Darren