Announcement

Collapse
No announcement yet.

vBulletin Database Error

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

  • mehbara
    replied
    hello

    he said the rong from the hacks.... like what you said

    but

    I used this query..... maybe this is the rong ?

    CREATE TABLE threadredirect(
    threadid INT UNSIGNED NOT NULL default '0',
    expires INT UNSIGNED NOT NULL default '0',
    PRIMARY KEY ( threadid ) ,
    KEY expires( expires )
    );


    is that the rong or something else

    note:- I used this query from another topic

    Leave a comment:


  • Steve Machol
    replied
    Something's wrong with the database, possibly from a previous hack you had installed. Fill out a support ticket at:

    http://members.vbulletin.com/members...ontactform.php

    Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

    Leave a comment:


  • mehbara
    replied
    Hello I do it a gain and every thig good but Now this Error

    Database error in vBulletin 3.6.0:
    Invalid SQL:
    SELECT points, infraction.*, thread.title, thread.forumid, thread.postuserid, user.username,
    thread.visible AS thread_visible, post.visible, thread.postuserid, IF(ISNULL(post.postid) AND infraction.postid != 0, 1, 0) AS postdeleted
    FROM infraction AS infraction
    LEFT JOIN post AS post ON (infraction.postid = post.postid)
    LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
    LEFT JOIN user AS user ON (infraction.whoadded = user.userid)
    WHERE infraction.userid = 1
    ORDER BY infraction.dateline DESC
    LIMIT 5;
    MySQL Error : Column 'points' in field list is ambiguous
    Error Number : 1052
    Date : Tuesday, August 15th 2006 @ 12:51:40 PM
    Script : http://www.mehbara.com/vb/usercp.php
    Referrer :
    IP Address :
    Username :
    Classname : vb_database

    Leave a comment:


  • Steve Machol
    replied
    You didn't upgrade:

    Database error in vBulletin 3.6.0 Beta 3

    Leave a comment:


  • mehbara
    replied
    Other Error

    Database error in vBulletin 3.6.0 Beta 3:
    Invalid SQL:
    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount, deletedcount
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

    , threadredirect.expires

    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

    LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

    WHERE thread.threadid IN (0,1400,1427,1469,1146,1335,1169,1324,1165,1315,1286,1287,1233,1191,1161,1160)
    ORDER BY sticky DESC, lastpost DESC;
    MySQL Error : Table 'mehbarac_vb1.threadredirect' doesn't exist
    Error Number : 1146
    Date : Tuesday, August 15th 2006 @ 06:16:03 AM
    Script : http://www.mehbara.com/vbnew/forumdisplay.php?f=27
    Referrer : http://www.mehbara.com/vbnew/index.php
    IP Address :
    Username :
    Classname : vb_database

    Leave a comment:


  • Steve Machol
    replied
    This means you missed one or more upgrade steps. Try running this query:

    ALTER TABLE user ADD infractiongroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0';

    Leave a comment:


  • mehbara
    started a topic vBulletin Database Error

    vBulletin Database Error

    Hello

    I have this Error when i try to upgade 3.5.4 to 3.6.0

    >>>
    Database error in vBulletin 3.6.0 Beta 3:
    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 > 1155600003
    ORDER BY username ASC;
    MySQL Error : Unknown column 'infractiongroupid' in 'field list'
    Error Number : 1054
    Date : Monday, August 14th 2006 @ 06:15:03 PM
    Script : http://www. .com/vb/index.php
    Referrer :
    IP Address :
    Username :
    Classname : vb_database


    please help me
    Last edited by mehbara; Mon 14 Aug '06, 5:49pm.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X