[phpws-comm-auto] [ phpwebsite-comm-/mod/article-1481767 ] Article module install fails with "unknown error"

[SourceForge.net <no...@so...>]

/mod/article item #1481767, was opened at 2006-05-04 06:33
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=681146&aid=1481767&group_id=81360

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Chris (youcantry)
Assigned to: Nobody/Anonymous (nobody)
Summary: Article module install fails with "unknown error"

Initial Comment:
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.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=681146&aid=1481767&group_id=81360