Home  |  Forums  |  914 Info  |  Blogs
 
914World.com - The fastest growing online 914 community!
 
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG. This site is not affiliated with Porsche in any way.
Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners.
 

Welcome Guest ( Log In | Register )

> Help, Getting SQL errors when sending PM's
Grimstead
post Apr 28 2006, 02:06 PM
Post #1


Cheaky Monkey
***

Group: Members
Posts: 835
Joined: 20-March 05
From: Corona, Ca
Member No.: 3,789
Region Association: Southern California



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????
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
 
Reply to this topicStart new topic
Replies(1 - 12)
rmital
post Apr 28 2006, 02:07 PM
Post #2


Northeast optimist
***

Group: Members
Posts: 1,947
Joined: 12-December 05
From: Park Ridge, NJ
Member No.: 5,268



me too....
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Allan
post Apr 28 2006, 02:08 PM
Post #3


Teenerless Weenie
*****

Group: Members
Posts: 8,373
Joined: 5-July 04
From: Western Mesopotamia
Member No.: 2,304
Region Association: Southern California



It means the person you are trying to pm has you blocked.... (IMG:style_emoticons/default/biggrin.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Grimstead
post Apr 28 2006, 02:09 PM
Post #4


Cheaky Monkey
***

Group: Members
Posts: 835
Joined: 20-March 05
From: Corona, Ca
Member No.: 3,789
Region Association: Southern California



HA! But I even tried a test message to myself, so there!

Oh wait, I don't like me either, nevermind (IMG:style_emoticons/default/headbang.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Andyrew
post Apr 28 2006, 02:10 PM
Post #5


Spooling.... Please wait
**********

Group: Members
Posts: 13,376
Joined: 20-January 03
From: Riverbank, Ca
Member No.: 172
Region Association: Northern California



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
drewvw
post Apr 28 2006, 02:16 PM
Post #6


new england car guy
***

Group: Members
Posts: 1,631
Joined: 24-February 06
From: Boston, MA
Member No.: 5,630
Region Association: North East States



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....
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Apr 28 2006, 04:22 PM
Post #7


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None



The message ID is capable of storing 2,147,483,647 message. (IMG:style_emoticons/default/ohmy.gif) So the problem is not in the DB. Please post your MySQL errors in this thread.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Grimstead
post Apr 28 2006, 04:33 PM
Post #8


Cheaky Monkey
***

Group: Members
Posts: 835
Joined: 20-March 05
From: Corona, Ca
Member No.: 3,789
Region Association: Southern California



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Apr 28 2006, 04:41 PM
Post #9


Resident German
*************************

Group: Admin
Posts: 41,680
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



i *think* i fixed it (hey mark! (IMG:style_emoticons/default/bye1.gif) ) ...

the index was corrupted and stuck at the same number, had to repair the index file ...
(IMG:style_emoticons/default/type.gif) Andy
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Apr 28 2006, 04:41 PM
Post #10


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None



I like to watch. (IMG:style_emoticons/default/drooley.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Grimstead
post Apr 28 2006, 04:42 PM
Post #11


Cheaky Monkey
***

Group: Members
Posts: 835
Joined: 20-March 05
From: Corona, Ca
Member No.: 3,789
Region Association: Southern California



Good news is I just got a PM from Andy! (IMG:style_emoticons/default/clap56.gif)

The Bad news is he told me to (IMG:style_emoticons/default/pissoff.gif) (IMG:style_emoticons/default/sad.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Apr 28 2006, 04:44 PM
Post #12


Resident German
*************************

Group: Admin
Posts: 41,680
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



QUOTE(Grimstead @ Apr 28 2006, 03:42 PM) *

Good news is I just got a PM from Andy! (IMG:style_emoticons/default/clap56.gif)

The Bad news is he told me to (IMG:style_emoticons/default/pissoff.gif) (IMG:style_emoticons/default/sad.gif)

(IMG:style_emoticons/default/slap.gif)


(IMG:style_emoticons/default/w00t.gif) Andy
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Grimstead
post Apr 28 2006, 04:45 PM
Post #13


Cheaky Monkey
***

Group: Members
Posts: 835
Joined: 20-March 05
From: Corona, Ca
Member No.: 3,789
Region Association: Southern California



(IMG:style_emoticons/default/poke.gif) (IMG:style_emoticons/default/wink.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 10th June 2024 - 04:18 PM