Search
Left Quote    Treat your password like your toothbrush. Don't let anybody else use it, and get a new one every six months.
- Clifford Stoll    
Right Quote
 
[login] | [Register]
Forum Index » Site and Forum Bugs » Viewing Topic and Replies
Post Reply


        Viewing Topic: hold your breath, cross your fingers
  This user is offline  bs0d
  Subject: "hold your breath, cross your finger..." Posted: @ 3:25 am on Jun 30 2007   

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

Hold your breath, and cross your fingers. I think i got it?


-bs0d | AllSyntax.com
    Viewed: 10,776 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: hold your breath, cross your fi..." Posted: @ 3:26 am on Jun 30 2007    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

Heres the true test. A reply to the topic hold your breath...

Sweet, I think I fixed it all



Edited at 03:27:30 am on 06/30/07


-bs0d | AllSyntax.com

    Viewed: 10,773 Times | Reply to This | To top
  This user is offline  BoricuaLayz
  Subject: "re: hold your breath, cross your fi..." Posted: @ 3:32 am on Jun 30 2007    
Member #: 356
Rank: User - (30)
Since: 06/25/07
Posts: 44
From: Florida

im replying to c if it really works


******YAAAAAAAH HHHHHHH He Did it HOOT HOOT WHISTLE WHISTLE
lol so can we start putting up topics now



Edited at 03:32:44 am on 06/30/07


    Viewed: 10,769 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: hold your breath, cross your fi..." Posted: @ 3:34 am on Jun 30 2007    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

Yes, I believe so. Hmm, didnt you have an avatar?

So that everyone knows, I keep posts in two tables (like: posts and post_data). The error was, I had post_id auto_increment for both tables. Somehow, the auto_increment value got off between the two tables and the post info was given one id, while the post data was given another. The numbers could have got cross threaded as they stumble over eachother which may explain why some posts were coming up under the wrong topics and usernames even, and ultimately - not at all (though being stored in the DB).

The solution was a correction to what it should have been. Set auto_increment for post_id in the "posts&q uot; table, and remove the auto_increment from post_id in the "post_dat a" table. Then, just assign the post id from "posts&q uot; to "post_dat a" using mysql_insert_id ();

Glad to have that fixed; Hopefully that fixes all of the problems that were going on. I also hope that nothing that severe happens again. Im just suprised that it has not came up before.



Edited at 03:35:36 am on 06/30/07


-bs0d | AllSyntax.com

    Viewed: 10,762 Times | Reply to This | To top
  This user is offline  BoricuaLayz
  Subject: "re: hold your breath, cross your fi..." Posted: @ 3:39 am on Jun 30 2007    
Member #: 356
Rank: User - (30)
Since: 06/25/07
Posts: 44
From: Florida

no i think i might make one right now
that was kind of weird but glad you fixed it this site and forum is very helpful



Edited at 03:58:39 am on 06/30/07


    Viewed: 10,758 Times | Reply to This | To top
  This user is offline  shay
  Subject: "re: hold your breath, cross your fi..." Posted: @ 4:23 pm on Dec 11 2007    

Member #: 508
Rank: User - (1)
Since: 12/10/07
Posts: 1

  BoricuaLayz said...

< i> no i think i might make one right now
that was kind of weird but glad you fixed it this site and forum is very helpful

yes this site is helpful




    Viewed: 9,944 Times | Reply to This | To top
Viewing Page: 1 of 1


1 |

You must be logged in to post on the forums. Login or Register








"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank