#1170 1.8 rc3 database upgrade - comments broken

v1.8RC
closed-invalid
Retest (6)
5
2004-02-17
2004-01-10
No

After upgrading from 1.7 to 1.8 rc3 and attempting to
add a comment I get the following error. It looks like
someone forgot to add comment_rating to tiki_comments.

error: Unknown column 'comment_rating' in 'field list'
in query:
insert into `tiki_comments`(`objectType`, `object`,
`commentDate`, `userName`, `title`, `data`, `votes`,
`points`, `hash`, `parentId`, `average`, `hits`,
`type`, `summary`, `smiley`, `user_ip`, `message_id`,
`in_reply_to`, `comment_rating` )

Discussion

  • Philippe Cloutier

    Logged In: YES
    user_id=738765

    I didn't look at this specifically but let's try...
    can you confirm you correctly used comments_fix scripts?

     
  • Terris Linenbach

    Logged In: YES
    user_id=155319

    I don't remember. Perhaps I missed that step in the upgrade
    instructions.

     
  • Philippe Cloutier

    • labels: 544454 --> Retest
    • assigned_to: nobody --> terris
    • status: open --> open-invalid
     
  • Chris Lusena

    Chris Lusena - 2004-01-19

    Logged In: YES
    user_id=955152

    It also happens for me, I did everything correctly I think,
    up to that
    point. (I had some DB problems after than (forgot passwd)
    so I had to do a reinstall or the tiki code after that to
    get it to work. I can view old comments, just can't create
    new ones.

    Is there a reset for comments? I don't have that many so
    blowing them
    away is an option for me at the moment.

     
  • Philippe Cloutier

    Logged In: YES
    user_id=738765

    Robin I'm assigning you this one in case you can give a hint.
    Upgrade instructions are on page Upgrade18
    You could probably reset emptying a *comment* DB table.

     
  • Philippe Cloutier

    • assigned_to: terris --> rlpowell
     
  • Philippe Cloutier

    • status: open-invalid --> closed-invalid
     
  • Philippe Cloutier

    Logged In: YES
    user_id=738765

    This must not be common because I didn't hear more about it.
    terris please reopen if you can reproduce following
    instruction on UpgradeTO18.

     

Log in to post a comment.