Page 1 of 2 12 LastLast
Results 1 to 20 of 28

Thread: Database errors with sidebars on custom pages.

  1. #1
    Join Date
    Oct 2004
    Posts
    197

    Default Database errors with sidebars on custom pages.

    This doesnt happen everytime but I have been getting these emails all day from about every user on the site. The problems started when I modified my forumhome and my forumdisplay to use the cmps sidebars. Here is the error email:

    Database error in vBulletin 3.5.0:

    Invalid SQL:

    INSERT INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, injournal)
    VALUES
    ('867fe0a984ba69447bace99aa0d25336', 0, '172.130.248.199', '45c2f2aeb167f5a6f42627f288184dcb', 1132971945, '/forum/', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7 (ax)', 0, -1);

    MySQL Error : Duplicate entry '867fe0a984ba69447bace99aa0d25336' for key 1
    Error Number : 1062
    Date : Friday, November 25th 2005 @ 08:25:47 PM
    Script : http://www.trackpads.com/forum/
    Referrer : http://www.theadminzone.com/forums/s...d.php\?t=14628
    IP Address : 172.130.248.199
    Username : Unregistered
    Classname : vb_database
    Thanks again,

    -Jason

  2. #2
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Bumpola, bug submitted etc etc. I got 88 of these this morning!! Help!

  3. #3
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,609

    Default Re: Database errors with sidebars on custom pages.

    Jason,

    That type of error is really Brian's forte.... when you disable the CMPS columns the errors also stop?

  4. #4
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Yeah, but i want to keep them. CMPS is awesome now that I am getting good at it

  5. #5
    Join Date
    Jan 2004
    Posts
    3,185

    Default Re: Database errors with sidebars on custom pages.

    Seems like its trying to update the session twice on one page maybe?

    This is really brians type of thing, he should be back tomorrow.

    I'd suggest keeping it disabled for now.
    Zachery
    I may or may not do things.

  6. #6
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Cant looks sooo good, my members will adapt to the every challenging environment at trackpads.com

    I apprecaite all the help!

    -Jason

  7. #7
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Database errors with sidebars on custom pages.

    How long ago did you integrate these other pages? The instructions were just changed about 2 weeks ago or so to prevent that exact error.

  8. #8
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Over the thanksgiving day weekend and I followed it to a T. I will recheck tonight when I get home (work now)

    Thanks again for all of this,

    -Jason

  9. #9
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    I think I found the bug, I am using 'forumhome' as the page identifier. Is that perchance something vb also uses?

  10. #10
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Ah dang, that wasnt it. I will recheck when I get home, darnit!

  11. #11
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,609

    Default Re: Database errors with sidebars on custom pages.

    Quote Originally Posted by trackpads
    Ah dang, that wasnt it. I will recheck when I get home, darnit!
    ... but I do like that db error page you created.

    "You broke it!"

  12. #12
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    I got it off vb.org, it was hilarious when I saw it!!

  13. #13
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Brian,

    I checked the instructions here:

    http://www.vbadvanced.com/membersare...tid=4&pageid=6

    And I followed them to the letter but no luck,

    Thanks again,

    -Jason

  14. #14
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Yup, still no luck, double checked everything and it still shows.

    Thanks again,

    -Jason

  15. #15
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Database errors with sidebars on custom pages.

    Would you mind submitting a support ticket so I can have a look then?

  16. #16
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Quote Originally Posted by Brian
    Would you mind submitting a support ticket so I can have a look then?
    Already had one in!

  17. #17
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Bump

  18. #18
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Bump

  19. #19
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    Quote Originally Posted by Brian
    Would you mind submitting a support ticket so I can have a look then?
    I did, it was closed, so I reopened it

  20. #20
    Join Date
    Oct 2004
    Posts
    197

    Default Re: Database errors with sidebars on custom pages.

    I am bumping for sheer joy now

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. keep getting database errors
    By CnB in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 09-22-2005, 08:15 PM
  2. database errors
    By rinkrat in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 03-28-2005, 11:25 AM
  3. Database errors
    By Mythotical in forum Troubleshooting / "How do I..." Questions
    Replies: 6
    Last Post: 02-07-2005, 04:10 PM
  4. Database Errors
    By javageek in forum Troubleshooting / "How do I..." Questions
    Replies: 8
    Last Post: 01-10-2005, 02:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •