Unknown column 'news_url' in 'field list'

[xroads]

I tried to post a news article and I received a message saying Unknown column 'news_url' in 'field list'. I upgraded to 1.10.3 prior to posting to see if the message would go away. WHen I did the upgrade it said my database was up to date. Is there a way to verify this? It seems as though a column is missing from my DB.

Thank You

[uniqu3]

news_url was added in 1.9.x series i think so you might missed something.
You can alter/add this through your PhpMyAdmin with:

Code: Select all

ALTER TABLE YOURCMSMSPREFIX_module_news ADD news_url VARCHAR(255);

[xroads]

news_url was added in 1.9.x series i think so you might missed something.
You can alter/add this through your PhpMyAdmin with:

Code: Select all

ALTER TABLE YOURCMSMSPREFIX_module_news ADD news_url VARCHAR(255);

This worked thank you, is there a way to ensure that all of the db changes from the 1.9.x made it into my database. I was having another issue with my user permissions and I was think it may be related to the db not being updated.

[vilkis]

I had the same problem for some upgraded CMSMS sites. Moreover, changes was not been saved without warning when admin user edited article.
uniqu3 solution solved both of them. Thanks.
vilkis

[twwitt]

Hi -- I recently upgraded (progressively--doing several upgrades) an old CMSMS site from pre-1.9.x all the way up to the most current version). Now, I'm getting this message in the News Module:

Unknown column 'news_url' in 'field list'

I saw that this was answered awhile back with this solution:

uniqu3 wrote:
news_url was added in 1.9.x series i think so you might missed something.
You can alter/add this through your PhpMyAdmin with:
Code:
ALTER TABLE YOURCMSMSPREFIX_module_news ADD news_url VARCHAR(255);

However, I don't know how to actually add this code or exactly where or how to do it in PHPMyAdmin. Can anyone talk me through it?

[chandra]

To the first you should make a database backup.

Then login to your phpmyadmin.

Go to tab "SQL"

Insert the posted sql query.

After clicking "Ok" the work should be done .

Check if it works in CMSMS admin.

[velden]

To the first you should make a database backup.

Then login to your phpmyadmin.

Go to tab "SQL"

Insert the posted sql query.

After clicking "Ok" the work should be done .

Check if it works in CMSMS admin.

Probably need to select the proper database first.

[twwitt]

That worked. Thanks a ton!