Hello,

I just downloaded from github the v.4.0.6 of Pro_News. I uploaded the files and when attempting to install, I get the following install error:

includes/db/db.php

CMS Warning line 70: On /admin.php?op=modules&install=Pro_News While executing query "CREATE TABLE IF NOT EXISTS bwa_pronews_articles ( id int(11) NOT NULL auto_increment, catid int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', intro text NULL, content text NULL, image varchar(255) NULL default '', caption varchar(255) NULL default '', allow_comment tinyint(1) NOT NULL default '1', postby varchar(50) NOT NULL default '', postby_show tinyint(1) NOT NULL default '1', posttime varchar(14) NULL, show_cat tinyint(1) NULL default '1', active tinyint(1) NULL default '0', approved tinyint(1) NULL default '0', viewable text NULL, topic_id int(10) NULL, display_order tinyint(1) NULL default '0', alanguage varchar(30) NOT NULL, album_id int(11) NOT NULL default '0', album_cnt tinyint(1) NOT NULL default '0', album_seq tinyint(1) NOT NULL default '0', slide_show tinyint(1) NOT NULL default '0', image2 varchar(255) NOT NULL default '', caption2 varchar(255) NOT NULL default '', user_fld_0 varchar(255) NOT NULL default '', user_fld_1 varchar(255) NOT NULL default '', user_fld_2 varchar(255) NOT NULL default '', user_fld_3 varchar(255) NOT NULL default '', user_fld_4 varchar(255) NOT NULL default '', user_fld_5 varchar(255) NOT NULL default '', user_fld_6 varchar(255) NOT NULL default '', user_fld_7 varchar(255) NOT NULL default '', user_fld_8 varchar(255) NOT NULL default '', user_fld_9 varchar(255) NOT NULL default '', counter mediumint(9) NULL default '0', score int(11) NOT NULL default '0', ratings int(11) NOT NULL default '0', df_topic int(10) default '0', cal_id int(11) NULL default '0', associated text NOT NULL, display tinyint(1) NOT NULL default '1', updtby varchar(50) NULL default '', updttime varchar(14) NULL default '', seod varchar(255) NOT NULL default ''); PRIMARY KEY (id), KEY (topic_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIMARY KEY (id), KEY (topic_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 46 In: /home/craig/public_html/hidden.com/www/includes/classes/installer.php on line: 56

I did a search of the database and I found the following new tables created by the installer:
bwa_pronews_cats
bwa_pronews_sections

Help please! Thanks.

HI.

My guess is the error is with the newest (and last) field in cms_pronews_articles.

I think the quickest fix is to open modules/Pro_News/cpg_inst.php and on line 132 remove the NOT so that it reads

seod varchar(255) NULL default '');

Let me know if that works, and I'll fix up the next release.

Assuming this is a new install of Pro_News, a simple retry of the install should work. If not you may have to delete the already create db files via phpMyAdmin.

Sorry for the trouble, And thanks for letting me know.

No problem. This was a new install and not an upgrade, and it was the first thing installed into a DF4 database that I had just installed.

I was in a bind over a time constraint so I went ahead and removed the two new tables and installed the v.4 or Pro_News. It installed fine, as expected of course,

I will test this fix out on a new install later today to see if it works. Thanks!