Announcement

Collapse
No announcement yet.

Database Errors

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

  • Database Errors

    Below you will see two error messages come to me.

    my host told me session and cpsession tables causes these errors.

    how do I fix them?

    thanks in advance

    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1186579949
    ORDER BY username ASC;

    MySQL Error : Got error 12 from storage engine Error Number : 1030
    Date : Wednesday, August 8th 2007 @ 04:47:30 PM
    Script : http://www.xxxxxxxx/forum/index.php
    Referrer : http://www.xxxxxxxxxxxx/
    IP Address : 212.156.xxx.xxx
    Username : xxxxxxxxxxx
    Classname : vb_database
    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_forumdisplay AS phrasegroup_forumdisplay,
    language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
    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, 4, user.languageid))

    WHERE user.userid = 401;

    MySQL Error : Table 'redlinefunclubinfo.user' doesn't exist Error Number : 1146
    Date : Wednesday, August 8th 2007 @ 01:25:04 PM
    Script : http://www.xxxxxxxxxxxxx/forum/forumdisplay.php?f=4
    Referrer :
    IP Address : 77.177.xxx.xxx
    Username :
    Classname : vb_database

  • #2
    This is a server issue, the system is out of memory that is allowed for MySQL to allocate. MySQL may need to be restarted or the server itself. You will need to contact your host about this.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Originally posted by Colin F View Post
      This is a server issue, the system is out of memory that is allowed for MySQL to allocate. MySQL may need to be restarted or the server itself. You will need to contact your host about this.

      thanx for the reply

      but my host told me my cpsession and session tables are open... and ı have to fix them !!!

      that is their answer and how can I?

      Comment


      • #4
        They will always be open. They are memory based tables. They do not cause the errors that you are experiencing. When MySQL is shut down, they will be deleted from the server and then recreated when it starts up again.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


        • #5
          I have just send them a message and add both ypur messages regarding my problem.

          So they return me with they are going to check my problem with all other system admins.

          try to keep you all informed...
          regards,

          Comment

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