Link Manager MYSQL Help

[DarrenDunnage]

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:

 

Could somebody please give the the idoits guide i have phpmyadmin i think i have to cut and paste INSERT INTO.......those two lines and run in mysql but whats number 2 saying ??

 

thanks

 

------------------------------------

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

[DarrenDunnage]

I have just run the query in MYSQL on the correct database, and this came up:

 

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'

 

 

 

In english what do i do ??

 

Rgds

Darren

[DarrenDunnage]

bump