Learn Japanese with JapanesePod101.com

View topic - Recent Posting Problems

Recent Posting Problems

Spotted any errors or found anything that doesn't work?

Recent Posting Problems

Postby 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
zengargoyle
 
Posts: 1200
Joined: Sun 05.29.2005 10:16 pm

RE: Recent Posting Problems

Postby ss » Sun 10.29.2006 7:12 am

>>> 4294967295 posts. :o

A for arigatou
D for dancing
H for horse

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

RE: Recent Posting Problems

Postby 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
clay
Site Admin
 
Posts: 2809
Joined: Fri 01.21.2005 9:39 am
Location: Florida

RE: Recent Posting Problems

Postby 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.
僕の下手な日本語を直してください。
User avatar
tanuki
 
Posts: 2302
Joined: Sun 09.25.2005 9:00 pm
Location: South America

RE: Recent Posting Problems

Postby 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

RE: Recent Posting Problems

Postby miho-sempai » Thu 11.30.2006 1:02 pm

That's still a long time. xD
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

Postby 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


Return to Problems

Who is online

Users browsing this forum: No registered users and 2 guests

cron