Since upgrade website doesn't allow image upload and there's an editing error. [RESOLVED]

LeftBrain

I recently updated to the Vanilla 2.8.1

Now, when I try to post an image in a discussion and I click "choose a file", it lets me choose a file but it doesn't insert it in the discussion. Here's my forum.

http://chemistscorner.com/cosmeticsciencetalk/discussions

Any idea what is going on?

Also, I do not know why but when I try to edit someone's comments, I get the following error.

"{ "Code": 256, "Exception": "Unknown column 'Active' in 'field list'", "Class": "Gdn_ErrorException" }"

The edit goes through but this error still shows up. Any ideas?

Kaspar

Take a look here

https://open.vanillaforums.com/discussion/37048/unknown-column-active-in-field-list

LeftBrain

I read through the discussion but I don't understand what file I'm supposed to change or what code to put in.

Do you think you could explain it?

thanks

donshakespeare

Assuming this is your site, log in as boss, and hit these links.

The first should return a success message immediately, the second will ask you scan and fix, do just that!

http://chemistscorner.com/utility/update

http://chemistscorner.com/utility/structure

Kaspar

https://open.vanillaforums.com/discussion/comment/256507#Comment_256507

Do this

https://open.vanillaforums.com/discussion/comment/256505#Comment_256505

It is not a file (like config.php) you change - it is in your database.

1. When upgrading > Advice: Clone/copy your forum and database so that you can test upgrading on that
2. If the above /utility/update and utility/structure does not fix does not fix it - my understanding is you have to change/add in your database yourself - I strongly recommend to clone/copy your forum and database so that you can test changes on that before doing anything on your live forum/database.

LeftBrain

Well, I had my data base finally run the update / structure and database scan scripts that you suggested.

I still get an error "Unknown column 'Active' in 'field list'"

This happens whenever I try to edit a previously posted comment.

LeftBrain

Just to update anyone following this, I got it fixed by following this advice from @noszone

I've created a new column.

ALTER TABLE `GDN_Media`
  ADD COLUMN `Active` TINYINT(4) AFTER `ThumbPath`;

And the error message dissapear!

I'd also add that the problem of not being able to post images has also been fixed by doing this.