Announcement

Collapse
No announcement yet.

Database Errors

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

  • YuSuF ErGiN
    replied
    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,

    Leave a comment:


  • Wayne Luke
    replied
    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.

    Leave a comment:


  • YuSuF ErGiN
    replied
    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?

    Leave a comment:


  • Colin F
    replied
    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.

    Leave a comment:


  • YuSuF ErGiN
    started a topic Database Errors

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X