Help - Search - Members - Calendar
Full Version: Help, Getting SQL errors when sending PM's
914World.com > The 914 Forums > 914World Garage
Grimstead
Here's what I get when I try to send a PM;

mySQL query error: INSERT INTO ibf_message_text (msg_date,msg_post,msg_cc_users,msg_sent_to_count,msg_post_key,msg_author_id,msg
_ip_address)
*Email guts*
SQL error: Duplicate entry '163111' for key 1
SQL error code:
Date: Friday 28th 2006f April 2006 01:03:50 PM

Any Ideas????
rmital
me too....
Allan
It means the person you are trying to pm has you blocked.... biggrin.gif
Grimstead
HA! But I even tried a test message to myself, so there!

Oh wait, I don't like me either, nevermind headbang.gif
Andyrew
the classifieds are down, and the main site was down for me a couple mins ago...

Give it time.. it'll either be fixed, or we'll have to go down again for a little...

lol
drewvw
Same. It looks as though the id column for the table is not getting auto incremented and is stuck on 163111.

Mark/Andy should be able to fix that when they have time....
McMark
The message ID is capable of storing 2,147,483,647 message. ohmy.gif So the problem is not in the DB. Please post your MySQL errors in this thread.
Grimstead
mySQL query error: INSERT INTO ibf_message_text (msg_date,msg_post,msg_cc_users,msg_sent_to_count,msg_post_key,msg_author_id,msg
_ip_address) VALUES(1146263572,'
**Email**
<br />','',2,'8bfb85f2f1d1d45fba19efed111b2135',3789,'24.130.218.2')

SQL error: Duplicate entry '163111' for key 1
SQL error code:
Date: Friday 28th 2006f April 2006 03:32:52 PM
SirAndy
i *think* i fixed it (hey mark! bye1.gif ) ...

the index was corrupted and stuck at the same number, had to repair the index file ...
type.gif Andy
McMark
I like to watch. drooley.gif
Grimstead
Good news is I just got a PM from Andy! clap56.gif

The Bad news is he told me to pissoff.gif sad.gif
SirAndy
QUOTE(Grimstead @ Apr 28 2006, 03:42 PM) *

Good news is I just got a PM from Andy! clap56.gif

The Bad news is he told me to pissoff.gif sad.gif

slap.gif


w00t.gif Andy
Grimstead
poke.gif wink.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2024 Invision Power Services, Inc.