[SOLVED] News and extra fields problem in 1.6.3

[nils73]

I have updated from 1.5.8 to 1.6.3 of CMSMS and tried to insert a news for the first time. It did not work and gave me:

Code: Select all

DEBUG: SQL = INSERT INTO a5_module_news (news_id, news_category_id, news_title, news_data, summary, status, news_date, start_time, end_time, create_date, modified_date,author_id,news_extra) VALUES (6,'2','fdsfsda','dffds','sddsf','published','2009-08-07 15:17:26','2009-08-07 15:17:26',NULL,'2009-08-07 15:17:40','2009-08-07 15:17:40','1','asfasdfasdf')
Unknown column 'news_extra' in 'field list'

I assume it has something to do with extra fields but when I open up the tab where I have entered the extra fields nothing will show up. Other installs of CMSMS are running fine. Any ideas?

Regards,
Nils

[jubasolo]

The same problem applies when making a new install on for example Moindou version - at least if you do as I did: put up the cms with no News Module, and then installing News Module through Module manager. I get exactly the same message. But the solution seems to be to uninstall News Module through Extensions > Modules, and then simply installing it again. Not straight forward but very simple if you know how. I would be happy if this bug was fixed though.

[Peciura]

If MySQL server complains about missing collumn - insert it  :

Code: Select all

ALTER TABLE `a5_module_news` ADD `news_extra` varchar( 255 ) NULL ;

Well it is not missing in upgrade method. I IMO it is related to adodb lite, because it is not the first time when "AddColumnSQL" failed me.

[nils73]

But the solution seems to be to uninstall News Module through Extensions > Modules, and then simply installing it again.

That did the trick - as well as updating SQL-statement directly. But this one is by far smarter!

Thanks,
Nils