Announcement

Collapse
No announcement yet.

Error in database

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

  • geovadim
    replied
    All is ok, I think the forum made his automatic scheduled task and the next day all was ok... It was not necessary anymore to run "repair tables".

    Leave a comment:


  • Steve Machol
    replied
    MySQL error: 134 = Record was already deleted (or record file crashed)

    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all
    errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

    Leave a comment:


  • geovadim
    replied
    I upgraded to 3.6 RC 1. Now I get no error when pressing "Go advanced" button. I get an error when trying to view member list:

    Database error in vBulletin 3.6.0 Release Candidate 1:

    Invalid SQL:

    SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

    ,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

    , lastactivity AS lastvisittime


    FROM user AS user
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)

    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)



    WHERE 1=1
    AND user.usergroupid IN (-1,6,8,20,7,2,22,5)
    ORDER BY user.username asc
    LIMIT 0, 30;

    MySQL Error : Eroarea 134 obtinuta din handlerul tabelei
    Error Number : 1030
    Date : Thursday, July 13th 2006 @ 12:06:31 AM
    Script : http://www.onlinesport.ro/forum/memberlist.php
    Referrer : http://www.onlinesport.ro/forum/index.php
    IP Address : 193.25.104.164
    Username : Vadim
    Classname : vB_Database

    Leave a comment:


  • geovadim
    replied
    I reuploaded all non-image files in Ascii, after that I disabled the plugins.

    The same error occurs...

    Leave a comment:


  • Colin F
    replied
    First I recommend reuploading all the default vBulletin non-image files in ASCII mode, overwriting your current files. Also, turn off plugins globally in your vBulletin Options. Does this problem still occur then?

    Leave a comment:


  • geovadim
    replied
    Is there a way to solve this? The support ticket is not in user anymore?

    Leave a comment:


  • geovadim
    replied
    I use no custonization.

    The error shows when pressing "go advanced" from fast reply.

    I created a new style and the error is the same.

    Leave a comment:


  • Floris
    replied
    Did you customize your files?
    Change the MySQL database table(s) field(s)?
    Do you run any plugins?

    Leave a comment:


  • geovadim
    started a topic Error in database

    Error in database

    I receive on my admin account some errors from users. Is the same error:

    Database error in vBulletin 3.6.0 Beta 4:

    Invalid SQL:

    SELECT post.postid, post.title, post.pagetext, post.dateline, post.userid, post.visible AS postvisible,
    IF(user.username, user.username, post.username) AS username,
    thread.threadid, thread.title AS threadtitle, thread.postuserid, thread.visible AS threadvisible,
    forum.forumid, forum.password
    FROM post AS post
    LEFT JOIN user AS user ON (post.userid = user.userid)
    INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
    INNER JOIN forum AS forum ON (thread.forumid = forum.forumid)
    WHERE post.postid IN ();

    MySQL Error : Aveti o eroare in sintaxa RSQL linga ')' pe linia 9
    Error Number : 1064
    Date : Friday, July 7th 2006 @ 06:27:44 PM
    Script : http://www.onlinesport.ro/forum/newr...treply&t=21160
    Referrer :
    IP Address : 85.186.136.241
    Username : ZEROSASE
    Classname : vB_Database
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X