1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

db error

Discussion in 'Forum Suggestions & Feedback' started by idk12, Mar 18, 2008.

  1. idk12

    idk12 Junior Member

    Joined:
    Mar 12, 2008
    Messages:
    166
    Likes Received:
    21
    I'm not sure weather this is just me or others aswell.

    but every so often either when I'm just looking around or trying to just get on the site i get a database error. theres no specific error its just a generic "the database has encountered a problem"

    just giving the heads up and seeing if anyone else gets this sometimes.
     
  2. CXYBQR

    CXYBQR Newbie

    Joined:
    Dec 28, 2007
    Messages:
    3
    Likes Received:
    0
    We need more information about the error, or the problem can't be solved.
     
  3. MR.blackhat

    MR.blackhat Regular Member

    Joined:
    Nov 4, 2007
    Messages:
    270
    Likes Received:
    46
    Occupation:
    Black Hat Marketer
    Location:
    USA
    i get this sometimes.......

    especially when i am reading something good and the site crashes or whatever...

    i hate that
     
  4. madinaz

    madinaz BANNED BANNED Premium Member

    Joined:
    Jan 12, 2008
    Messages:
    720
    Likes Received:
    1,274
    I get this on the top of my screen

    Warning: require(ajax.php) [function.require]: failed to open stream: No such file or directory in /home/blackh56/public_html/blackhat-seo/vbseo.php on line 1082

    Warning: require(ajax.php) [function.require]: failed to open stream: No such file or directory in /home/blackh56/public_html/blackhat-seo/vbseo.php on line 1082

    Fatal error: require() [function.require]: Failed opening required 'ajax.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackh56/public_html/blackhat-seo/vbseo.php on line 1082
     
  5. blackmark

    blackmark Registered Member

    Joined:
    Mar 7, 2008
    Messages:
    55
    Likes Received:
    8
    I also got the same error. I thought it was only me cause no one's complaining
     
  6. revax

    revax Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 15, 2007
    Messages:
    127
    Likes Received:
    0
    I'm getting this also, DB errors from time to time and the
    Warning: require(ajax.php) messages at the top of the page.
     
  7. blanko

    blanko Power Member

    Joined:
    Mar 16, 2008
    Messages:
    588
    Likes Received:
    125
    I have also been experiencing the same problem.
     
  8. idk12

    idk12 Junior Member

    Joined:
    Mar 12, 2008
    Messages:
    166
    Likes Received:
    21
    ok seriously posts like this are pointless.

    i posted all the info i had as you can from what i wrote.


    i also am getting this at top now.

     
    Last edited: Mar 19, 2008
  9. Diamond Damien

    Diamond Damien Owner BlackHatWorld Staff Member Jr. VIP

    Joined:
    Oct 27, 2005
    Messages:
    55,622
    Likes Received:
    12,440
    Home Page:
    Yesterday BHW was up and down for about 5 hours or so. I was working with my host to try to get the server stable and they couldn't for the life of them. The load reached 400 and this is a quad core server! Anyways in that time period I decided to try to make the leap and move to the new server and began changing the DNS name servers. My programmer was half way done transferring this site when the old server crapped out again. This happened twice after which time we couldn't move hosts :(

    We will try again tonight, in the mean time we had to disable the ajax.php and some other features to cut down on the load. Once we are on the new server I will update everyone!
    Thanks
    -Dave
     
  10. idk12

    idk12 Junior Member

    Joined:
    Mar 12, 2008
    Messages:
    166
    Likes Received:
    21
    thanx much diamond dave, thats what i had expected but never can be too sure.
     
  11. Diamond Damien

    Diamond Damien Owner BlackHatWorld Staff Member Jr. VIP

    Joined:
    Oct 27, 2005
    Messages:
    55,622
    Likes Received:
    12,440
    Home Page:
    It is also logging users out out even when they signed in at random times. I will try to have this fixed very soon.
     
  12. dellzip

    dellzip Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 25, 2008
    Messages:
    285
    Likes Received:
    29
    No im getting the same thing here also
     
  13. cashcorp

    cashcorp Regular Member

    Joined:
    Feb 8, 2008
    Messages:
    430
    Likes Received:
    270
    Home Page:


    HAHAHA I clicked to quote you and respond, and let you know that indeed it did this often. Anyways, I got logged out again before I could :p

    Thanks for the update Dave, I didnt know if wed been hacked again or what.
     
  14. Diamond Damien

    Diamond Damien Owner BlackHatWorld Staff Member Jr. VIP

    Joined:
    Oct 27, 2005
    Messages:
    55,622
    Likes Received:
    12,440
    Home Page:
    I know it's annoying. I had my programmer try again. It took 6 hours just to download this site and then import into the new server. Going from Cpanel to Plesk is also harder than originally anticipated. The mysql server was giving a large packet size error.

    //ERROR 1153 (08S01) at line 497: Got a packet bigger than 'max_allowed_packet' bytes

    So we had to abort the operation. This problem is getting way out of hand so tomorrow a professional data migration company is going to take over moving my sites. So if the forum shuts down suddenly you'll know why.
     
  15. dabandit

    dabandit Registered Member

    Joined:
    Feb 21, 2008
    Messages:
    87
    Likes Received:
    29
    All you had to do was increase "max_allowed_packet" in my.cnf under [mysqldump] assuming that your trying to dump the DB or worst case scenario tar your MySQL basedir via scp to the new server.
     
  16. idk12

    idk12 Junior Member

    Joined:
    Mar 12, 2008
    Messages:
    166
    Likes Received:
    21
    this is true as i have had to do it before.

    also you could download a php script called "big dump" you upload the script upload the db run the script and the script will import the db for you.
     
  17. Diamond Damien

    Diamond Damien Owner BlackHatWorld Staff Member Jr. VIP

    Joined:
    Oct 27, 2005
    Messages:
    55,622
    Likes Received:
    12,440
    Home Page:
    My programmer had increased the DB packetsize to 100M, but still error stayed.

    I have been working behind the scenes trying to get off this server as fast as possible. Sadly, everyday this week something has gone wrong. A data migration firm told me they would begin the migration on Wednesday night but didn't start the work and didn't hear back from them until Thursday night telling me that they could possibly begin migration next Wednesday!

    After that, Rackspace suggested using the "Plesk Migration Manager" which wasn't installed so they had to spend time installing it. My programmer was going to do the move today (Friday). However when he couldn't because there was a "Bug" with the migration manager. I had to send a ticket to rackspace and they in turn had to send a ticket to Plesk. Plesk took 8 hours to reply back with a fix and by this time my programmer was asleep.

    For the cherry I received a call on Wednesday from my Bank that someone stole my Credit Card number and started buying expensive items on overstock.com. I will see what tomorrow brings, I have never had this bad luck in my life. It's been one long week! :microwave

    P.S. Tomorrow we should be moved to the new server and shouldn't experience anymore weird site problems.. (Crossing my fingers) :)
     
  18. FleshJoe

    FleshJoe Power Member

    Joined:
    Mar 11, 2008
    Messages:
    551
    Likes Received:
    1,702
    Dave

    Appreciate this site very much, and sorry that its causing you so much pain. THANKS! And hopefully the move goes OK.
     
  19. idk12

    idk12 Junior Member

    Joined:
    Mar 12, 2008
    Messages:
    166
    Likes Received:
    21
    thanx for the update man, i just wish this wouldn't have been such a pain for you. either way good luck with the move. :)
     
  20. idk12

    idk12 Junior Member

    Joined:
    Mar 12, 2008
    Messages:
    166
    Likes Received:
    21
    are we on the new server now? because idk if its just me but i seem to be having an massive speed increase on page loads. :)