Page 1 of 1
[SOLVED] News and extra fields problem in 1.6.3
Posted: Fri Aug 07, 2009 1:20 pm
by 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
Re: News and extra fields problem in 1.6.3
Posted: Mon Oct 19, 2009 2:59 pm
by 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.
Re: News and extra fields problem in 1.6.3
Posted: Mon Oct 19, 2009 6:41 pm
by 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.
Re: News and extra fields problem in 1.6.3
Posted: Wed Oct 21, 2009 9:35 am
by nils73
jubasolo wrote:
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