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
Quote:
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?