Can't post article

I just installed fresh copy of Pro_News on my local test site running
Apache 2.2.11
PHP 5.3.0
MySQL 5.1.40

No configuration changed. Tried to publish a test article and get this:

CMS Warning line 73: On /df10/admin.php?op=Pro_News&mode=add&do=save While executing query "INSERT INTO df10_pronews_articles VALUES(NULL, "1", "First Article", "This is my first article intro.", "This is the article itself.", "1256814714.7237.gif", "Mario", "1", "Madis", "1", "1256814910", "1", "1", "1", "1", NULL, "0", "", "2", "1", "0", "0", "1256814714.9411.jpg", "The A-Team is back", "", "", "", "", "", "", "", "", "", "", 0,0,0, "", "", "", "1")" the following error occured: Incorrect integer value: '' for column 'df_topic' at row 1 In: D:\Programmid\wamp\www\df10\modules\Pro_News\admin\admin_functions.php on line: 1168

The sql statement is a bid bad, as there is no field names given in the INSERT statement (may cause problems if people upgrade ProNews etc).

Madis please enter your server specs in your user profile!

- Madis

The sql statement is a bid bad, as there is no field names given in the INSERT statement (may cause problems if people upgrade ProNews etc).

Causes me problems, yes! But even if named, if I forget to add extra field I still get a potentially hidden, latent error, rather than one picked up and thrown in my face by MySQL. So I've not been sure that's really a better choice.

- Madis

MySQL 5.1.40

I don't have anything later than 5.0.x. So does 5.1 enforce strict? It seems that some parts of code put df_topics as 0, but some as NULL. Need to look into that - should be 0. (Adding df_topics was more trouble than it was worth - lots of demand, but not sure if anyone uses ...) Will let you know ...

Thanks for the report.

OK, I've managed to reproduce. I upgraded to MySQL 5.1(.37) but that didn't do it. (Although it did give me a number of "Deprecated" errors at top of the page, which destroy reDesign, so i had to resarch and fiox those first!)

So then I found how to enable STRICT_TRANS_TABLES and that did it. I found several more similar problems, besides the one you reported, so I've fixed them all. Will test in the morning and release.

Have also found a potentially serious bug (unrelated), so will re-release with all fixes asap.

Thanks again! (I'll keep my dev system in STRICT_TRANS_TABLES mode from now on! )

Great to hear that!


Actually there are some GROUP BY bugs with my localhost system in dragonfly itself, so it seems I don't have the best testing environment at the moment.

Madis please enter your server specs in your user profile!

Fixed version available for download.

Thanks again for the problem report.

Out of interest what are the changed files in 3.2.1 from 3.2.0?

As listed at bottom of Downloads page.

It was the changed files I was thinking of rather than the changes...

Heck, I can't remember! Lucky for you that I use Linux not Widnoze ... Even then it wasn't straightforward.

I presume you really meant 3.2.1.1 vs 3.2.1.0?:

Only in Pro_News 3.2.1.1/Pro_News/images/pro_news: left_scrollb.gif
Only in Pro_News 3.2.1.1/Pro_News/images/pro_news: left_scroll.gif
Only in Pro_News 3.2.1.1/Pro_News/images/pro_news: right_scrollb.gif
Only in Pro_News 3.2.1.1/Pro_News/images/pro_news: right_scroll.gif
File Pro_News 3.2.1.1/Pro_News/modules/Pro_News/admin/admin_functions.php differs
File Pro_News 3.2.1.1/Pro_News/modules/Pro_News/functions.php differs
File Pro_News 3.2.1.1/Pro_News/themes/default/style/pro_news.css differs
File Pro_News 3.2.1.1/Pro_News/themes/default/template/pronews/article/index2fcs.html differ
Only Pro_News 3.2.1.1/Pro_News/themes/default/template/pronews/article: index2fcs-nh.html

Fantastic thank you for that - didn't mean to give you more work!! (except that hack request though!)