Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

column_controller.sql error


guanche

Recommended Posts

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?

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...