SQL Group

[Birky]

Hi

 

I'm trying to use the contribution 'Edit auto-emails from admin backend' & am a bit stuck on the installation of the sql file.

 

I run the sql file through phpmyadmin but, keep getting the error message;-

 

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

SQL-query:

 

INSERT INTO `configuration_group`

VALUES ( 790, 'Email Templates', 'Email Text', 7, 1 )

MySQL said:

 

#1062 - Duplicate entry '790' for key 1

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 685

 

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

 

I've tried loads of differnet values but , keep getting the same error so my question is if someone knows how to find out what value I can use for key 1 as I haven't got that much experience with sql.

 

TIA for any help :huh:

[Beer Monster]

Hi

 

I'm trying to use the contribution 'Edit auto-emails from admin backend' & am a bit stuck on the installation of the sql file.

 

I run the sql file through phpmyadmin but, keep getting the error message;-

 

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

SQL-query:

 

INSERT INTO `configuration_group`

VALUES ( 790, 'Email Templates', 'Email Text', 7, 1 )

MySQL said: 

 

#1062 - Duplicate entry '790' for key 1

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 685

 

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

 

I've tried loads of differnet values but , keep getting the same error so my question is if someone knows how to find out what value I can use for key 1 as I haven't got that much experience with sql.

 

TIA for any help    :huh:

<{POST_SNAPBACK}>

 

Well, it looks like you already have an entry with the id value 790, why don't you just add the line manually?

[Birky]

Well, it looks like you already have an entry with the id value 790, why don't you just add the line manually?

<{POST_SNAPBACK}>

 

 

Thanks for the speedy reply .

 

According to the instructions, all I need to do is change the values in the install sql script and I'm sorted....do you know the sql command to list values currently being used? or failing that can you please tell this sql newbie hw to add the linew manually?

 

Thanks for your help

[Beer Monster]

Thanks for the speedy reply .

 

According to the instructions, all I need to do is change the values in the install sql script and I'm sorted....do you know the sql command to list values currently being used?  or failing that can you please tell this sql newbie hw to add the linew manually?

 

Thanks for your help

<{POST_SNAPBACK}>

SELECT * 
FROM `configuration_group`  LIMIT 0 , 1000

 

Should show you the whole table (unless theres more than 1000 rows)

 

Below the table you should see the insert new row link if you want to manually update the table!

[♥yesudo]

Use:

 

INSERT INTO `configuration_group`

VALUES ( '', 'Email Templates', 'Email Text', 7, 1 );

 

Then look in the table to see what number was allocated and you will then use that number for insertions into the configurations table - for that group.

[Birky]

Thanks guys for your help :thumbsup: