[phpws-comm-auto] [ phpwebsite-comm-/mod/article-1766367 ] Incomplete install of Article Manager 4.0

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

/mod/article item #1766367, was opened at 2007-08-02 19:55
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=1766367&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
Private: No
Submitted By: Thijs J. Aartsma (tjaa)
Assigned to: Nobody/Anonymous (nobody)
Summary: Incomplete install of Article Manager 4.0

Initial Comment:
On a fresh install of Phpwebsite 1.3RC1 + Article Manager 4.0 the error logs showed that

- mod_article_version was not created in the database
- users_permission was not updated with AM-related content

Prior to boosting AM 4.0, Phpwebsite seemed to run error-free.

My system: MS Vista, Apache 2.2.4 (Win32), PHP 5.2.3, MySQL 5.0.41

Parts of the error-log:
14:50:52 08/02/07 Error [notice] [-18] SELECT  COUNT(*) FROM mod_article_version WHERE ( mod_article_version.vr_approved = '0' AND mod_article_version.draft = '0' AND mod_article_version.active = '1' )    [nativecode=1146 ** Table 'biophys.mod_article_version' doesn't exist]
14:52:00 08/02/07 Error [notice] [-2] CREATE TABLE mod_article_version (id INT NOT NULL PRIMARY KEY, source_id INT NOT NULL, key_id INT NOT NULL, title CHAR(80) NOT NULL binary, mainarticle SMALLINT NOT NULL, rank SMALLINT NOT NULL, created_username CHAR(20) NOT NULL binary, created_id INT NOT NULL, updated_username CHAR(20) NOT NULL binary, updated_id INT NOT NULL, created_date INT NOT NULL, updated_date INT NOT NULL, summary TEXT, allow_comments SMALLINT NOT NULL, allow_anonymous SMALLINT NOT NULL, hits INT NOT NULL, expiration_date INT NOT NULL, publication_date INT NOT NULL, wordcount SMALLINT NOT NULL, pagecount SMALLINT NOT NULL, template CHAR(50) NOT NULL binary, editlock SMALLINT NOT NULL, edituser INT NOT NULL, approved SMALLINT NOT NULL, version SMALLINT NOT NULL, announce SMALLINT NOT NULL, language CHAR(2) NOT NULL binary, is_base_article SMALLINT NOT NULL, pages TEXT, image_id INT NOT NULL, image_link CHAR(255) NOT NULL binary, image_caption CHAR(255) NOT NULL binary, draft SMALLINT NOT NULL, active SMALLINT NOT NULL, vr_creator int NOT NULL default 0, vr_editor int NOT NULL default 0, vr_create_date int NOT NULL default 0, vr_edit_date int NOT NULL default 0, vr_number smallint NOT NULL default 1, vr_current smallint NOT NULL default 0, vr_approved smallint NOT NULL default 0, vr_locked smallint NOT NULL default 0) [nativecode=1064 ** 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 'binary, mainarticle SMALLINT NOT NULL, rank SMALLINT NOT NULL, created_username ' at line 1
18:22:37 08/02/07 Error [notice] [-1401] Core - Users_Permission::getRestrictedGroups() - Edit permission column does not exist. [edit_article]



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

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