PhotoPost Community - Database error

PhotoPost Community (http://www.photopost.com/forum/)

- Installs and Upgrade - vBulletin 4 (http://www.photopost.com/forum/installs-upgrade-vbulletin-4/)

- - Database error (http://www.photopost.com/forum/installs-upgrade-vbulletin-4/146459-database-error.html)

Steff

September 8th, 2011 04:01 PM

Database error

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?

Chuck S

September 8th, 2011 04:46 PM

is there anything else in the error?

Code:

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

September 8th, 2011 04:58 PM

1 Attachment(s)

Yeah seems strange.
Here's the full error:

Quote:

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

September 8th, 2011 05:41 PM

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

September 8th, 2011 06:08 PM

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

September 9th, 2011 07:30 AM

No problem will check our Helpdesk and respond accordingly

All times are GMT -5. The time now is 05:26 AM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97