8
   

What the heck is this A2K error message?

Forums: able2know, Computers, Sql, a2k, Forum Help
Email this Topic • Print this Page
 
 
boomerang
 
Reply Tue 4 Nov, 2008 04:49 pm
I've been trying to post to my "middle class" thread and when I hit reply I get a page of strangeness. This is the first block of a huge long page of text:

Quote:
object(Exception)#32 (6) { ["message:protected"]=> string(249) "_doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE MDB2_STATEMENT_mysql_f593ba122a230bcf54a37065188dfa46 USING @0, @1, @2, @3, @4, @5] [Native code: 1062] [Native message: Duplicate entry '124667-1-0-89' for key 2] " ["string:private"]=> string(0) "" ["code:protected"]=> int(-3) ["file:protected"]=> string(51) "/home/a2korg/a2kincludes/classes/database.class.php" ["line:protected"]=> int(91) ["trace:private"]=> array(3) { [0]=> array(6) { ["file"]=> string(47) "/home/a2korg/a2kincludes/classes/post.class.php" ["line"]=> int(299) ["function"]=> string(3) "set" ["class"]=> string(8) "database" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(83) "insert into posts(topicId, userId, text, ip, postTime,position) values(?,?,?,?,?,?)" [1]=> &array(6) { [0]=> string(6) "124667" [1]=> string(2) "42" [2]=> string(56) "Test. I'm having problems posting to this thread....." [3]=> string(14) "76.115.140.106" [4]=> string(19) "2008-11-04 22:46:29" [5]=> int(89) } } } [1]=> array(6) { ["file"]=> string(48) "/home/a2korg/a2kincludes/classes/topic.class.php" ["line"]=> int(41) ["function"]=> string(8) "addReply" ["class"]=> string(11) "postManager" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(post)#23 (21) { ["_parser:private"]=> &object(parser)#24 (2) { ["_parser:private"]=> NULL ["_bbcode:private"]=> object(StringParser_BBCode)#25 (24) { ["_parserMode"]=> int(1) ["_codes"]=> array(13) { ["b"]=> array(8) { ["name"]=> string(1) "b" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(3) "" ["end_tag"]=> string(4) "" } ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["i"]=> array(8) { ["name"]=> string(1) "i" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(3) "" ["end_tag"]=> string(4) "" } ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["u"]=> array(8) { ["name"]=> string(1) "u" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(24) "" ["end_tag"]=> string(7) "" } ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["color"]=> array(8) { ["name"]=> string(5) "color" ["callback_type"]=> string(16) "callback_replace" ["callback_func"]=> array(2) { [0]=> &object(parser)#24 (2) { ["_parser:private"]=> NULL ["_bbcode:private"]=> object(StringParser_BBCode)#25 (24) { ["_parserMode"]=> int(1) ["_codes"]=> array(13) { ["b"]=> array(8) { ["name"]=> string(1) "b" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(3) "" ["end_tag"]=> string(4) "" } ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["i"]=> array(8) { ["name"]=> string(1) "i" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(3) "" ["end_tag"]=> string(4) "" } ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["u"]=> array(8) { ["name"]=> string(1) "u" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(24) "" ["end_tag"]=> string(7) "" } ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["color"]=> array(8) { ["name"]=> string(5) "color" ["callback_type"]=> string(16) "callback_replace" ["callback_func"]=> array(2) { [0]=> *RECURSION* [1]=> string(10) "parseColor" } ["callback_params"]=> NULL ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["size"]=> array(8) { ["name"]=> string(4) "size" ["callback_type"]=> string(16) "callback_replace" ["callback_func"]=> array(2) { [0]=> *RECURSION* [1]=> string(9) "parseSize" } ["callback_params"]=> NULL ["content_type"]=> string(6) "inline" ["allowed_within"]=> array(5) { [0]=> string(4) "root" [1]=> string(8) "listitem" [2]=> string(5) "block" [3]=> string(6) "inline" [4]=> string(4) "link" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["quote"]=> array(8) { ["name"]=> string(5) "quote" ["callback_type"]=> string(16) "callback_replace" ["callback_func"]=> array(2) { [0]=> *RECURSION* [1]=> string(10) "parseQuote" } ["callback_params"]=> NULL ["content_type"]=> string(5) "block" ["allowed_within"]=> array(2) { [0]=> string(4) "root" [1]=> string(5) "block" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["code"]=> array(8) { ["name"]=> string(4) "code" ["callback_type"]=> string(10) "usecontent" ["callback_func"]=> array(2) { [0]=> *RECURSION* [1]=> string(9) "parseCode" } ["callback_params"]=> NULL ["content_type"]=> string(5) "block" ["allowed_within"]=> array(2) { [0]=> string(4) "root" [1]=> string(5) "block" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["list"]=> array(8) { ["name"]=> string(4) "list" ["callback_type"]=> string(16) "callback_replace" ["callback_func"]=> array(2) { [0]=> *RECURSION* [1]=> string(9) "parseList" } ["callback_params"]=> NULL ["content_type"]=> string(4) "list" ["allowed_within"]=> array(3) { [0]=> string(4) "root" [1]=> string(5) "block" [2]=> string(8) "listitem" } ["not_allowed_within"]=> array(0) { } ["flags"]=> array(0) { } } ["*"]=> array(8) { ["name"]=> string(1) "*" ["callback_type"]=> string(14) "simple_replace" ["callback_func"]=> NULL ["callback_params"]=> array(2) { ["start_tag"]=> string(4) "
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 8 • Views: 2,833 • Replies: 20
No top replies

 
littlek
 
  1  
Reply Tue 4 Nov, 2008 04:59 pm
@boomerang,
scrolling through that gives me a headache.
0 Replies
 
Thomas
 
  1  
Reply Tue 4 Nov, 2008 05:06 pm
@boomerang,
Looks like a database lookup gone bad to me. Did you try again? And if so, did it work the second time?
0 Replies
 
boomerang
 
  1  
Reply Tue 4 Nov, 2008 05:12 pm
Yes, I tried the same post two or three times then tried posting "test" and they all returned with the same message.
Rockhead
 
  1  
Reply Tue 4 Nov, 2008 05:14 pm
@boomerang,
I get that a lot.

It's insider hamsterspeak, but you gotta have a decoder ring...

Refresh, and it goes away.

(bootleg rings available...)
Thomas
 
  1  
Reply Tue 4 Nov, 2008 05:28 pm
@boomerang,
Hm ... either way, I have to capitulate. I don't know much about SQL.
boomerang
 
  1  
Reply Tue 4 Nov, 2008 05:30 pm
@Rockhead,
I tried "refresh" and it didn't do anything. When I went to "my posts" and looked up the thread it had not recorded the response.
0 Replies
 
jespah
 
  1  
Reply Tue 4 Nov, 2008 05:32 pm
@Thomas,
Thomas wrote:

Hm ... either way, I have to capitulate. I don't know much about SQL.


Yep, it's SQL, possibly a violation of a unique key requirement (this has nothing to do with posting).
0 Replies
 
boomerang
 
  1  
Reply Tue 4 Nov, 2008 05:48 pm
I just tried posting "This is a test" and the same thing happened.

Would someone else see what happens when you post to the thread?

http://able2know.org/topic/124667-1
jespah
 
  1  
Reply Tue 4 Nov, 2008 05:52 pm
@boomerang,
I sent a report straight to Robert.
boomerang
 
  1  
Reply Tue 4 Nov, 2008 05:54 pm
@jespah,
Thank you!
0 Replies
 
roger
 
  1  
Reply Tue 4 Nov, 2008 07:28 pm
@boomerang,
Well, I was able to post there.
boomerang
 
  1  
Reply Tue 4 Nov, 2008 07:32 pm
@roger,
Yeah! I posted! Thank you for checking, roger!
0 Replies
 
margo
 
  1  
Reply Tue 4 Nov, 2008 07:47 pm
@boomerang,
This all relates back to the time you killed the hamster, I'm afraid!

They have very long memories. You can expect intermittent problems for at least the next 10 years. Your card is marked, so to speak!
0 Replies
 
JTT
 
  1  
Reply Tue 4 Nov, 2008 07:59 pm
@boomerang,
Yup, as soon as I glanced at that page, the error leapt out at me. It's in line 21, but I ain't tellin' where.
0 Replies
 
boomerang
 
  1  
Reply Tue 4 Nov, 2008 08:02 pm
So..... what did I do that made this happen?
Thomas
 
  1  
Reply Tue 4 Nov, 2008 08:20 pm
@boomerang,
Nothing. The hamsters just don't like to work for you. So they sabotaged your post.
0 Replies
 
margo
 
  1  
Reply Tue 4 Nov, 2008 08:23 pm
@boomerang,
Quote:
So..... what did I do that made this happen?


Surely you remember killing the hamster? Shocked
0 Replies
 
ehBeth
 
  1  
Reply Tue 4 Nov, 2008 09:34 pm
@boomerang,
Set was having a bunch of troubles with a similar looking message just a bit back. He's taking a break for a few minutes. The air was blue.
Robert Gentel
 
  1  
Reply Tue 4 Nov, 2008 09:37 pm
@ehBeth,
If anyone runs into it, please send the topic id to us (through help desk is the best place to report bugs and errors). There's a bug we are working on fixing where the reply count gets out of sync and new replies throw errors, in the mean time it needs to be fixed manually so send us the topic ids and we'll fix them as we can.
 

Related Topics

How to use the new able2know - Discussion by Craven de Kere
New A2K feature requests. - Discussion by DrewDad
I'm the developer - Discussion by Nick Ashley
JIM NABORS WAS GOY? - Question by farmerman
A2K censors tags? - Discussion by hingehead
New A2K Bugs - Discussion by sozobe
New A2K annoyances - Discussion by sozobe
The a2k world is changing 3: about voting - Discussion by Craven de Kere
LOST & MISPLACED A2K people. - Discussion by msolga
Welcome to the 'New' My Posts - Discussion by Nick Ashley
The "I get folksonomy" club - Discussion by Robert Gentel
 
  1. Forums
  2. » What the heck is this A2K error message?
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.56 seconds on 04/19/2024 at 08:57:17
▲ ▼