Page 1 of 1

Unknown column 'news_url' in 'field list'

Posted: Wed Feb 08, 2012 7:59 pm
by 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

Re: Unknown column 'news_url' in 'field list'

Posted: Thu Feb 09, 2012 9:07 am
by 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);

Re: Unknown column 'news_url' in 'field list'

Posted: Fri Feb 10, 2012 7:02 pm
by xroads
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: 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.

Re: Unknown column 'news_url' in 'field list'

Posted: Tue Aug 14, 2012 7:23 am
by 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

Re: Unknown column 'news_url' in 'field list'

Posted: Thu Oct 09, 2014 8:50 pm
by 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: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?

Re: Unknown column 'news_url' in 'field list'

Posted: Fri Oct 10, 2014 7:35 am
by 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.

Re: Unknown column 'news_url' in 'field list'

Posted: Fri Oct 10, 2014 7:51 am
by velden
chandra wrote: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.

[solved] Re: Unknown column 'news_url' in 'field list'

Posted: Fri Oct 10, 2014 2:56 pm
by twwitt
That worked. Thanks a ton!