Announcement

Collapse
No announcement yet.

Website errors

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Website errors

    Please cut and paste any website errors you may receive when posting or browsing the forums.

    I attempted to install an upgrade to the chat room this morning and it fubar'd the database.

    I restored our latest nightly backup to get the website back up. There are a few database errors that I am trying to correct.

    If you get any error that says "Duplicate entry '0' for key 1", cut and paste the entire error display you get so I can correct the database table the error refers to.

  • #2
    All post that were made after 6am this morning were lost since the latest backup up was from 6am this morning.

    Comment


    • #3
      Chatbox is screwed. At least for me. Can't post anything in it.

      Comment


      • #4
        I tried to message Batman about NS vote count and got "Data base Error".

        Comment


        • #5
          Clicking on the "New Posts" button just takes me to a standard search page now.
          People with rubber pockets will steal soup!

          Comment


          • #6
            Originally posted by Neverhome
            Clicking on the "New Posts" button just takes me to a standard search page now.
            Ditto what Neverhome is getting.

            HB
            "Never argue with an idiot; people watching might not be able to tell the difference".

            Posts by Hornblower are merely opinions of Hornblower and are for entertainment only. Hornblower does not represent any railroad anywhere. Feel free to pass over any post that offends you.

            Comment


            • #7
              <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
              <html>
              <head>
              <title>YardLimits.com Database Error</title>
              <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
              <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
              <style type="text/css">
              <!--
              body { background-color: white; color: black; }
              #container { width: 400px; }
              #message { width: 400px; color: black; background-color: #FFFFCC; }
              #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
              .bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
              a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
              a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
              -->
              </style>
              </head>
              <body>
              <table cellpadding="3" cellspacing="5" id="container">
              <tr>
              <td><img src="http://www.yardlimits.com/forums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
              <td id="bodytitle" width="100%">Database error</td>
              </tr>
              <tr>
              <td class="bodytext" colspan="2">The YardLimits.com database has encountered a problem.</td>
              </tr>
              <tr>
              <td colspan="2"><hr /></td>
              </tr>
              <tr>
              <td class="bodytext" colspan="2">
              Please try the following:
              <ul>
              <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
              <li>Open the <a href="/?phpMyAdmin=RXP0FVS4PpSo2vJ53RegPfgNTD5">www.yardl imits.com</a> home page, then try to open another page.</li>
              <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
              </ul>
              </td>
              </tr>
              <tr>
              <td class="bodytext" colspan="2">The YardLimits.com - An Online Rail Labor Community forum technical staff have been notified of the error, though you may <a href="mailto:webmaster@yardlimits.com">contact them</a> if the problem persists.</td>
              </tr>
              <tr>
              <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
              </tr>
              </table>

              <form><input type="hidden" name="phpMyAdmin" value="RXP0FVS4PpSo2vJ53RegPfgNTD5" /><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.7.2:

              Invalid SQL:


              INSERT INTO vbpost_thanks
              (userid, username, date, postid)
              VALUES
              ('3209', 'Northern', 1220487085, 76525);

              Comment


              • #8
                mySQL query error: INSERT INTO vbgames_session (gname, gameid, gtitle, mname, mid, randgid, randgid2) VALUES ('tetris1JS', '808', 'Tetris', 'argo', '1654', '1', '1')

                mySQL error: Duplicate entry '0' for key 1
                mySQL error code:
                Date: Wednesday 03rd 2008f September 2008 0723 PM


                From the arcade

                Comment


                • #9
                  If it's electronic or female it's gonna give ya trouble!

                  This is what I got when I tried to log onto COLD FUSION on the arcade:

                  There is a SQL error.
                  You can contact the board administrator by clicking here

                  Error Returned

                  mySQL query error: INSERT INTO vbgames_session (gname, gameid, gtitle, mname, mid, randgid, randgid2) VALUES ('ColdFusionSte', '1471', 'Cold Fusion', 'nsevh', '2573', '1', '1')

                  mySQL error: Duplicate entry '0' for key 1
                  mySQL error code:
                  Date: Wednesday 03rd 2008f September 2008 0841 PM

                  We apologise for any inconvenience

                  Comment


                  • #10
                    The basic forum itself should be running fine now.

                    Add-ons and modifications may still contain errors.

                    I will be uninstalling all the add-ons and modifications, running an upgrade on the forum, and then re-install the add-ons and modifications. This process will take a few days (as my personal time allows). But until then, the basic functions of the forum should be fine. But the arcade, chatbox, thank you function, and other modifications that I have added over the last year may not work properly until I am finished upgrading and reinstalling.

                    I guess this is why they say always back up the database before installing something new - just in case the new addition fubars the database :tongue3:

                    It's too time consuming to write all the custom SQL statements that I need to fix the database errors in the add-ons and modifications. The basic forum alone required 75 new sql statements to fix just the base forum. The add-on would require almost triple that. So it will be much quicker to just uninstall them and re-install them. Losing that data is not as big of a deal as losing the forum data.

                    But this is actually how I have learned all I have about programming, database administration, and SQL - from having to get my hands dirty by getting under the hood of the database and programming after I have fubar'd something on the website.

                    Comment


                    • #11
                      The new posts button is working now. However the "deal" button in the blackjack is inop, not to mention I had run up my account to 10,856,939 just after 6 am the day of the crash. Any chance of getting that back?:wink3:
                      People with rubber pockets will steal soup!

                      Comment


                      • #12
                        I did a data base history and it showed you owed 11 million'

                        Comment


                        • #13
                          Heres another one fer ya, I get this when I hit the thanks button.


                          !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
                          <html>
                          <head>
                          <title>YardLimits.com Database Error</title>
                          <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
                          <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
                          <style type="text/css">
                          <!--
                          body { background-color: white; color: black; }
                          #container { width: 400px; }
                          #message { width: 400px; color: black; background-color: #FFFFCC; }
                          #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
                          .bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
                          a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
                          a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
                          -->
                          </style>
                          </head>
                          <body>
                          <table cellpadding="3" cellspacing="5" id="container">
                          <tr>
                          <td><img src="http://www.yardlimits.com/forums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
                          <td id="bodytitle" width="100%">Database error</td>
                          </tr>
                          <tr>
                          <td class="bodytext" colspan="2">The YardLimits.com database has encountered a problem.</td>
                          </tr>
                          <tr>
                          <td colspan="2"><hr /></td>
                          </tr>
                          <tr>
                          <td class="bodytext" colspan="2">
                          Please try the following:
                          <ul>
                          <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
                          <li>Open the <a href="/?phpMyAdmin=RXP0FVS4PpSo2vJ53RegPfgNTD5">www.yardl imits.com</a> home page, then try to open another page.</li>
                          <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
                          </ul>
                          </td>
                          </tr>
                          <tr>
                          <td class="bodytext" colspan="2">The YardLimits.com - An Online Rail Labor Community forum technical staff have been notified of the error, though you may <a href="mailto:webmaster@yardlimits.com">contact them</a> if the problem persists.</td>
                          </tr>
                          <tr>
                          <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
                          </tr>
                          </table>

                          <form><input type="hidden" name="phpMyAdmin" value="RXP0FVS4PpSo2vJ53RegPfgNTD5" /><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.7.2:

                          Invalid SQL:


                          INSERT INTO vbpost_thanks
                          (userid, username, date, postid)
                          VALUES
                          ('1319', 'Ghostrider', 1220665014, 76919);

                          Comment


                          • #14
                            Then don't hit the thanks button.:rofl3:

                            Casino is still down. I won't say how much I lost the other day, but I'm glad it was all forgiven, but not at the amount of trouble it has given Zeb. I get lost when my email won't work. Whew!! By the way Ghost, you gave me a bad email address, just like someone gives a fat chick a wrong phone number at the bar.:cheers:
                            Karl Marx - "FOR THE BUREAUCRAT, THE WORLD IS A MERE OBJECT TO BE MANIPULATED BY HIM"

                            Comment


                            • #15
                              mySQL query error: INSERT INTO vbgames_session (gname, gameid, gtitle, mname, mid, randgid, randgid2) VALUES ('breakout', '7', 'Breakout', 'Ghostrider', '1319', '1', '1')

                              mySQL error: Duplicate entry '0' for key 1
                              mySQL error code:
                              Date: Friday 05th 2008f September 2008 1156 PM

                              Comment

                              Working...
                              X