Database error

[Steff]

I deleted a file type thinking it was a duplicate in the "allowed file types" but the file type was JPG not jpg and I can now see that they are treated separately.
However if I try and add a new file type for JPG I get this database error

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE VB_ppgal_filetypes SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`extension` = 'JPG',
`filesize` = '7500000',
`width` = '400',
`height` = '400',
`min_width` = '300',
`min_height` = '300',
`enabled` = '1',
`extensionid` = '5'
WHERE extensionid = '5';

MySQL Error : Duplicate entry 'JPG' for key 2

It seems that the data is still in the database and refuses to be altered... can you help?

[Chuck S]

is there anything else in the error?

Content visible to verified customers only.

I do not see anything wrong off hand with that query. I can understand duplicate errors but this is an update command so there should be no duplicate. Your essentially updating the record for extensionid 5.

[Steff]

Yeah seems strange.
Here's the full error:

Database error in vBulletin 4.1.5:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO VB_ppgal_filetypes
(`extension`, `filesize`, `width`, `height`, `min_width`, `min_height`, `enabled`)
VALUES
('JPG', '25000000', '7000', '7000', '400', '400', '1');

MySQL Error : Duplicate entry 'JPG' for key 2
Error Number : 1062
Request Date : Thursday, September 8th 2011 @ 10:54:08 PM
Error Date : Thursday, September 8th 2011 @ 10:54:08 PM
Script : Log in - Picture Penzance Forum - vBulletin Admin Control Panel
Referrer : Log in - Picture Penzance Forum - vBulletin Admin Control Panel
IP Address : 212.139.80.74
Username : Halfhidden
Classname : vB_Database
MySQL Version : 5.0.91-community

I've just looked at the database thinking that perhaps it was still live... but this is the screen shot of the vb_ppgal_filetype tables:

So I'm a bit puzzled as to where the error is coming from as there clearly is no duplicate

[Chuck S]

That is a different mysql query that is an insert command.

You can send me a url and admin login and an explanation of what your doing in an email through the contact us link in our site header.

[Steff]

Yeah.. no probs. As it is late here I'll do this in the morning (about 4am for you)
I'll try and be as informative as I can in the explanation.

[Chuck S]

No problem will check our Helpdesk and respond accordingly