not that I'm getting a complex ...

[Capellan]

But the Company of the Random Encounter download has been unavailable for over a week now. Is there a problem?

 

[EricNoah]

I'd say there's a big problem! And it's not just yours -- every single download returns an error like this:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
INSERT INTO local_linksdownloads (linkid, linkurl, username, userid, userip, userbrowser, usertime)
VALUES (
'219',
'http://www.enworld.org/modules.php?op=modload&name=Downloads&file=index&req=getit&lid=342',
'EricNoah',
'4',
'24.158.12.192',
'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)',
1087339442
)

mysql error: Duplicate entry '32767' for key 1

mysql error number: 1062

Date: Tuesday 15th of June 2004 06:44:04 PM
Script: http://www.enworld.org/forums/local_links.php?action=jump&id=219
Referer: http://www.enworld.org/forums/local_links.php?action=links&catid=17
Username: EricNoah

I will try to alert whoever deals with this kind of thing.

 

[Psionicist]

Interesting, because 32767 is quite a special number for computers. It's 2^15 if you count from 0, or the maximum value for a 16 bit signed integer. The page might be stuck at some limit in the database. If you change the entry/id field in the table (in the database) to accept larger values the problem might go away.

 

[Michael Morris]

Interesting, because 32767 is quite a special number for computers. It's 2^15 if you count from 0, or the maximum value for a 16 bit signed integer. The page might be stuck at some limit in the database. If you change the entry/id field in the table (in the database) to accept larger values the problem might go away.

Correct. 32767 is the maximum value for a standard integer. MySQL can handle larger values, but only if you set up the table for BIGINT (Big integers) when you create it.

Now, as to what's going on - I didn't install that particular add on to our site and so I'm not sure I should go poking around trying to fix it without some research.