Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: mysql error number: 1054

    got an error in sql,
    can some1 help me with this:

    Database error in vBulletin 2.2.9:

    Invalid SQL: UPDATE user SET
    posts=posts+1,
    usertitle='Administrator',replys=replys+1,lastpost ='1069881564' WHERE userid='1'
    mysql error: Unknown column 'replys' in 'field list'

    mysql error number: 1054

    plz let me now what here's wrong and how i can fix it.

    Grtz DaSoNiC

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ---> Unknown column 'replys' in 'field list'

    does the user table contain a column called replys?

    if not, then that's your problem

    if it does, then i dunno


    rudy
    http://r937.com/

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    Yes it have,

    replys int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •