#124 Article module install fails with "unknown error"

[Chris]

There is a mysql bug where you cannot insert an empty
string into a column which is of "text" type, where
that column has been defined as "not null".

Essentially, it regards the empty string as a null
and returns an error.

With the Article Manager, the error is returned as
follows:

SQL: insert mod_article (title, section_order,
mainarticle, rank, created_username, created_id,
updated_username, updated_id, created_date,
updated_date, allow_comments, allow_anonymous, hits,
expiration_date, publication_date, wordcount, pages,
template, editlock, edituser, approved, version,
announce, id) values ('Article Manager Demo
Article', 'a:1:
{i:0;i:1;}', '1', '50', 'eloi', '1', 'eloi', '1', '200
2-12-05 13:51:40', '2002-12-05
15:29:24', '0', '0', '16', '2007-12-05
00:00:00', '2002-12-05
00:00:00', '54', '1', 'Blank', '0', '0', '1', '0', '1'
, 1)
unknown error

But using a client app to attempt that insert returns
the message:

[localhost] ERROR 1364: Field 'summary' doesn't have
a default value

Unfortunately, you can't assign a default value to
the "text" column type; therefore, you have to
provide a value with each insert.

I fixed both inserts after the first table
declaration, but then there was another similar
error: the last column in the table could not be
null, so I appended the following insert values to
both inserts:

, '', '', '', 0

Then the first insert after the second (sections)
table had problems. This time the error
said "image_directory" could not be null, but the
reported SQL statement (in the error message) looks
nothing like the statement in the install.sql file
(But there is only one insert with "Article Manager
Demo Section")

At this point I called it quits.

The mysql bug details are at:
http://bugs.mysql.com/bug.php?id=5013

Chris.

[Chris]

Logged In: YES
user_id=1190477

I should have said...

phpws 0.10.2
apache 2.0.55
windows xp
php 5.0.3
mysql 5.0.15

Fresh install of the CMS with core modules only; then
unzip version 3.0 of Article Manager into mods directory
and attempt to install it.

I did notice other discussion threads that mentioned they
couldn't locate a working copy of this module for 0.10.x
on George's website (and both my downloads wouldn't
extract either) but then others commented that the
downloads from sourceforge were fine.

I used the sourceforge download when I got this bug.