column_controller.sql error

[guanche]

I installed the Column Controller w/ Admin v2.0 but when I run the sql statement in PhpMyAdmin I get this:

 

Error



SQL-query :  



INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) 

VALUES (



'14', 'Column Controller', 'Configure Column width which boxes will display and where.', '14', '0'

) 



MySQL said: 





Duplicate entry '14' for key 1

 

Has anyone else gotten the same? What should I do to fix it?

[radders]

Yes and fixed it after viewing another thread.

Simply change almost all occurances in the contribution of the number 14 by the number 15. 14 is now used by another application.

[guanche]

Thank You David!

[Beridox]

Hi!

 

I installed the version:

Column Controller w Admin v2.1

changed all the files and when i try to import the sql i get an error:

 

SQL-query :

 

INSERT INTO configuration_group( configuration_group_id, configuration_group_title,

 

configuration_group_description, sort_order, visible )

VALUES (

 

'15', 'Column Controller', 'Configure Column width which boxes will display and where.',

 

'15', '0'

)

 

MySQL said:

 

 

Duplicate entry '15' for key 1

 

When i look under the admin page .

 

I can see the "Column Controller" under "Tools" but when i open it I see the sessions options (and I still have "sessions" under "configuration" "sessions")

 

What shall i do?

 

Thanks in advance.

 

/Anneli

[radders]

In your database (using phpmyadmin) browse the table configuration_group. 15 is usually the first free slot. That is why I suggested that number. Maybe your is already used for something else. There's no reason not to use 16 afaik.

hth

David

[Beridox]

Hi!

 

I change to "16" in the column_controller.sql file and I could import the file. :D

 

But....

 

When i check the adminpages i have

"Configuration"/"Sessions" with both sessions and all the options f?r column controller and when i check the "Tools"/"Column Controller" i have the options for Column Controller and session.

It?s seem to work, but should it look like that? :shock:

 

 

Have I made some misstake in one of the *.php files?

 

 

/Anneli

[Beridox]

Me again!

 

I changed all the "15" to "16" in column_controller.php and now i have nothing under "Tools"/"column controller" but i have everything under "Configuration"/"Sessions" (both sessions and the column controller).

 

Help!

Feels like I am lost here.

 

/Anneli

[Beridox]

I feel like an idiot.

 

I didnt see all the places in the sql file that needed to be changed.

 

It works now!

Everything in its right place.

:D

 

Thanks.

 

 

/Anneli