[Urgent!] MySQL Max Rows Problems

[Anon]

Hi!

I have a big problem, i'm having a forum on a hockeypage, and it uses mysql, the problem is that after 124 posts, it stops adding them to the database, I get no errors but nothing is inserted into the table,

please help me!

[Anon]

The key of table is type int whith auto_increment ???

[[deleted]]

Sounds liek the infamous 'tinyint primary_key auto_increment' problem.

You get errors (a sh*tload of them) but your script is configured to hide them.

Change your database model and replace ALL occurences of TINYINT with INT.

read more here:
http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=70

[smarlowe]

Wouldn't it be better if MySQL had a switch you had to throw to turn on tinyint for a column? I mean, it can't save that much to even use the stupid things, but look at the heartache and misery caused by it.

[[deleted]]

It would help if MySQL changed their policy from "it must be small and fast" to "it must work properly and reliably"

Tinyint has it's uses if you are really storing 0-255, like in IP octets, or people's ages. But it's near-useless for everything else, which unfortunately is 99% of all database apps.

/me adds tinyint to the list of evil things.