Recent Posting Problems

Spotted any errors or found anything that doesn't work?
Post Reply
User avatar
zengargoyle
Posts: 1200
Joined: Sun 05.29.2005 10:16 pm

Recent Posting Problems

Post by zengargoyle » Sun 10.29.2006 6:38 am

OMG!!!!

get this!!!

PHP-Fusion had the post_id column of the database set to smallint which is limited to 65535. well, we have more than 65535 posts now! woot!

so new posts were failing because it couldn't create a bigger number. i changed the column to a plain 'int' which should give us up to 4294967295 posts.

at least i'm pretty sure that is what was going on.

update:
seems to have worked....
Last edited by zengargoyle on Sun 10.29.2006 6:40 am, edited 1 time in total.

User avatar
ss
Posts: 1656
Joined: Fri 11.18.2005 10:07 am
Native language: English speaking family

RE: Recent Posting Problems

Post by ss » Sun 10.29.2006 7:12 am

>>> 4294967295 posts. :o

A for arigatou
D for dancing
H for horse

testing .... ;)

User avatar
clay
Site Admin
Posts: 2811
Joined: Fri 01.21.2005 9:39 am
Location: Florida
Contact:

RE: Recent Posting Problems

Post by clay » Sun 10.29.2006 7:26 am

The Dancin' Horse does it again.

EDIT: It worked
Last edited by clay on Sun 10.29.2006 7:26 am, edited 1 time in total.

User avatar
tanuki
Posts: 2302
Joined: Sun 09.25.2005 9:00 pm
Location: South America

RE: Recent Posting Problems

Post by tanuki » Sun 10.29.2006 8:22 am

4294967295 posts? At this rate, that's only giving us a rough estimate of 131071 years without problems! Don't you think about our great-great-great-great-great-....-great-grandchildren?
Last edited by tanuki on Sun 10.29.2006 8:25 am, edited 1 time in total.
僕の下手な日本語を直してください。

ashitaka
Posts: 456
Joined: Sun 10.30.2005 1:08 pm

RE: Recent Posting Problems

Post by ashitaka » Thu 11.30.2006 11:25 am

Well actually if you include the average post counts plus new members and returning members it would be 131070.9999999998 years.

miho-sempai
Posts: 48
Joined: Tue 11.21.2006 11:44 am
Native language: English
Location: Pacific NW - buried under rain

RE: Recent Posting Problems

Post by miho-sempai » Thu 11.30.2006 1:02 pm

That's still a long time. xD

datdo
Posts: 400
Joined: Mon 07.03.2006 11:24 pm

RE: Recent Posting Problems

Post by datdo » Thu 11.30.2006 2:57 pm

....why would you use a smallint? Conserve space? Minimalism? what makes a smallint better than an int?

Post Reply