View topic - Recent Posting Problems
Recent Posting Problems
7 posts
• Page 1 of 1
Recent Posting Problems
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....
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.
-
zengargoyle - Posts: 1200
- Joined: Sun 05.29.2005 10:16 pm
RE: Recent Posting Problems
by ss » Sun 10.29.2006 7:12 am
>>> 4294967295 posts. 
A for arigatou
D for dancing
H for horse
testing ....
A for arigatou
D for dancing
H for horse
testing ....
-
ss - Posts: 1656
- Joined: Fri 11.18.2005 10:07 am
- Native language: English speaking family
RE: Recent Posting Problems
by clay » Sun 10.29.2006 7:26 am
The Dancin' Horse does it again.
EDIT: It worked
EDIT: It worked
Last edited by clay on Sun 10.29.2006 7:26 am, edited 1 time in total.
-
clay - Site Admin
- Posts: 2806
- Joined: Fri 01.21.2005 9:39 am
- Location: Florida
RE: Recent Posting Problems
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.
僕の下手な日本語を直してください。
-
tanuki - Posts: 2302
- Joined: Sun 09.25.2005 9:00 pm
- Location: South America
RE: Recent Posting Problems
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.
- ashitaka
- Posts: 456
- Joined: Sun 10.30.2005 1:08 pm
- miho-sempai
- Posts: 48
- Joined: Tue 11.21.2006 11:44 am
- Location: Pacific NW - buried under rain
- Native language: English
RE: Recent Posting Problems
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?
- datdo
- Posts: 400
- Joined: Mon 07.03.2006 11:24 pm
7 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest
Click to sign up
