Announcement

Collapse
No announcement yet.

datacase errors?

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

  • Zachery
    replied
    My friend did it to a user on one of my boards in beta 5 ^^ trust me it was a nightmare trying to figure it out because only Non Admin/Smod. and only some mods saw it ^^

    Leave a comment:


  • Steve Machol
    replied
    Good catch Zach!

    Leave a comment:


  • joeychgo
    replied
    My ,mistake, i corrected it..... thnks

    Leave a comment:


  • Zachery
    replied
    Yes

    Leave a comment:


  • joeychgo
    replied
    wait -- do whatwith userid? you lost me ---- OH you mean his number?

    Leave a comment:


  • Zachery
    replied
    Actually, he put a username into Tatchy goes to Conventry, and it needs to be a USERID which is a number.

    Remove otus from tatchy goes to converntry and replace it with their USERID not USERNAME.

    Leave a comment:


  • Steve Machol
    replied
    Reupload the original search. php and member.php files from the vB 3.0.0 zip file. Make sure you upload in ASCII and overwrite the ones on the server.

    Leave a comment:


  • joeychgo
    started a topic datacase errors?

    datacase errors?

    I placed a user on Tachy goes Coventry. Now I keep getting db errors...... like the one below......


    Database error in vBulletin 3.0.0:

    Invalid SQL:
    SELECT postid AS itemid, thread.forumid,
    IF(postuserid = 249, 'self', 'other') AS starter
    FROM post AS post
    INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
    LEFT JOIN deletionlog AS delpost ON(delpost.primaryid = post.postid AND delpost.type = 'post')
    WHERE postid IN(2514)
    AND delpost.primaryid IS NULL
    AND thread.open <> 10
    AND thread.visible = 1
    AND post.userid NOT IN (Otus)
    AND thread.postuserid NOT IN (Otus)

    mysql error: Unknown column 'Otus' in 'where clause'

    mysql error number: 1054

    Date: Saturday 17th of April 2004 03:55:06 PM
    Script: http://www.lincolnvscadillac.com/sea...?searchid=2211
    Referer: http://www.lincolnvscadillac.com/member.php?u=249
    Username: Otus
    IP Address: 24.189.45.25
Loading...
Working...
X