I have a problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • amroawad
    Member
    • Oct 2007
    • 61

    I have a problem

    I have installed my forum but when I click on my name to see my profile it tells me I have a database error.

    But everything else is working!

    Can you tell me whats wrong?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • amroawad
      Member
      • Oct 2007
      • 61

      #3
      Database errorThe Suggest A Forum database has encountered a problem.Please try the following:
      • Load the page again by clicking the Refresh button in your web browser.
      • Open the suggestaforum.com home page, then try to open another page.
      • Click the Back button to try another link.
      The suggestaforum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
      We apologise for any inconvenience.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • amroawad
          Member
          • Oct 2007
          • 61

          #5
          <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
          <html>
          <head>
          <title>Suggest A Forum Database Error</title>
          <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
          <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://suggestaforum.com/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 Suggest A Forum 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="/">suggestaforum.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 suggestaforum.com forum technical staff have been notified of the error, though you may <a href="mailto:[email protected]">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>

          <!--
          Database error in vBulletin 3.6.8:
          Invalid SQL:
          SELECT
          userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
          IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
          language.phrasegroup_wol AS phrasegroup_wol,
          language.phrasegroup_user AS phrasegroup_user,
          language.phrasegroup_messaging AS phrasegroup_messaging,
          language.phrasegroup_itrader AS phrasegroup_itrader,
          language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
          language.phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
          language.phrasegroup_global AS phrasegroup_global,
          language.options AS lang_options,
          language.languagecode AS lang_code,
          language.charset AS lang_charset,
          language.locale AS lang_locale,
          language.imagesoverride AS lang_imagesoverride,
          language.dateoverride AS lang_dateoverride,
          language.timeoverride AS lang_timeoverride,
          language.registereddateoverride AS lang_registereddateoverride,
          language.calformat1override AS lang_calformat1override,
          language.calformat2override AS lang_calformat2override,
          language.logdateoverride AS lang_logdateoverride,
          language.decimalsep AS lang_decimalsep,
          language.thousandsep AS lang_thousandsep

          FROM user AS user
          LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
          LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

          WHERE user.userid = 1;
          MySQL Error : Unknown column 'language.phrasegroup_itrader' in 'field list'
          Error Number : 1054
          Date : Thursday, January 24th 2008 @ 11:09:14 PM
          Script : http://suggestaforum.com/member.php?...etinfo&amp;u=1
          Referrer : http://suggestaforum.com/
          IP Address : 87.210.58.159
          Username :
          Classname : vB_Database
          -->

          </body>
          </html>

          Comment

          • nexialys
            Senior Member
            • May 2004
            • 2183
            • 1.1.x

            #6
            Hum, actually ,you have vBulletin 3.6.8, so at first you did not post your message in the proper forum (we're in the 3.7 forum here!)

            we see the error here:
            Code:
            MySQL Error : Unknown column 'language.phrasegroup_itrader' in 'field list'
            ... you will have to uninstall iTrader or ask the author for support on this hack, because this error is related to that hack, not vBulletin itself.
            oh no, i'm not going with Xenforo... come on, i'm better than that... i stick with Wordpress... rofl

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...