Peter M. Groen / knowledgetree

"Creation of a new thread fails with: 'DB error: unknown error'"
Fixed. change nullable fields on discussion_threads

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7388 c91229c3-7414-0410-bfa2-8a42b809f60b

"Scheduler's first run time not set correctly when registering task according to spec"
Changed the setFirstRunTime() to accept a date input instead of a unix timestamp.

KTS-2485
"Internationalise scheduler - daily/weekly/5mins, etc"
Changed the dropdown to use the internationalised wording for the label.

KTS-2496
"Remove unused fields from scheduler table"
Removed the unused DB fields.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7381 c91229c3-7414-0410-bfa2-8a42b809f60b

"Some database tables use unsigned int, but relations are mostly to signed int fields. This means foreign key constraints cannot be added easily."
Fixed. Meant to update folders table, not documents.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7331 c91229c3-7414-0410-bfa2-8a42b809f60b

"Some database tables use unsigned int, but relations are mostly to signed int fields. This means foreign key constraints cannot be added easily."
Fixed. Meant to update folders table, not documents.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7329 c91229c3-7414-0410-bfa2-8a42b809f60b

"Some database tables use unsigned int, but relations are mostly to signed int fields. This means foreign key constraints cannot be added easily."

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7311 c91229c3-7414-0410-bfa2-8a42b809f60b

"Scheduler: Change DB date format"
Changed the DB to use datetime instead of a unix timestamp.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7307 c91229c3-7414-0410-bfa2-8a42b809f60b

"Some database tables use unsigned int, but relations are mostly to signed int fields. This means foreign key constraints cannot be added easily."

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7306 c91229c3-7414-0410-bfa2-8a42b809f60b

"plugin_rss is not an innodb table"
Fixed.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7305 c91229c3-7414-0410-bfa2-8a42b809f60b

"Adding a folder descendant lookup table for search"
Added. 

Reviewed By: Kevin Fourie
Committed By: Conrad Vermeulen

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7304 c91229c3-7414-0410-bfa2-8a42b809f60b

"possibility to delete a document version"
Added a new transaction type for deleting a version of a document. The physical document is deleted but the DB record remains.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7270 c91229c3-7414-0410-bfa2-8a42b809f60b

"The search algorithm needs some work"
Implemented.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7148 c91229c3-7414-0410-bfa2-8a42b809f60b

"Add CheckedOut date so can track when documents were checked out"
Implemented.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7147 c91229c3-7414-0410-bfa2-8a42b809f60b

"Implement a Scheduler"
Added the upgrade patch.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7139 c91229c3-7414-0410-bfa2-8a42b809f60b

"Admin Version Notifier is displaying when it should not."
Fixed. Updated database.

Committed By: Kevin Fourie
Reviewed By: Jonathan Byrne



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7105 c91229c3-7414-0410-bfa2-8a42b809f60b

Committed By:
Reviewed By:

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6819 c91229c3-7414-0410-bfa2-8a42b809f60b

"KnowledgeTree pre-3.0 upgrade problems"
Updated.

Committed By: Kevin
Reviewed By: Conrad



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6644 c91229c3-7414-0410-bfa2-8a42b809f60b

"Upgrade fails from 3.3.3 Commercial to 3.3.6 Commercial"
This seems to be a better fix.

Reviewed By: Conrad

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6578 c91229c3-7414-0410-bfa2-8a42b809f60b

"Upgrade tool failing in 3.3.3 permission.sql"
Fixed.

Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6535 c91229c3-7414-0410-bfa2-8a42b809f60b

"SOAP Webservice Implementation"
Updated. Added required data structures.

Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6488 c91229c3-7414-0410-bfa2-8a42b809f60b

"added a folder_rename permission"
Implemented. Added a new permission ktcore.permissions.folder_rename.

Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6406 c91229c3-7414-0410-bfa2-8a42b809f60b

"added a folder_rename permission"
Implemented. Added a new permission ktcore.permissions.folder_rename.

Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6401 c91229c3-7414-0410-bfa2-8a42b809f60b

"Fieldsets should not be deleted, but flagged instead. "
Fixed. Added database changes.

Reviewed By: Conrad

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6394 c91229c3-7414-0410-bfa2-8a42b809f60b

"Implement Tag Cloud system. "
Implemented. Added in tables for install and update

Reviewed By: Conrad

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6321 c91229c3-7414-0410-bfa2-8a42b809f60b

"Implement RSS feed system"
Fixed. Added rss_plugin sequence table.

Reviewed By: Kevin, Conrad

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6284 c91229c3-7414-0410-bfa2-8a42b809f60b

"Issues when trying to introduce db constraints during upgrades"
Fixed. Deleting broken references prior to applying constraints.
Reviewed by: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6207 c91229c3-7414-0410-bfa2-8a42b809f60b

"Issues when trying to introduce db constraints during upgrades"
Fixed. Deleting broken references prior to applying constraints.
Reviewed by: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6206 c91229c3-7414-0410-bfa2-8a42b809f60b

"Issues when trying to introduce db constraints during upgrades"
Fixed. Deleting broken references prior to applying constraints.
Reviewed by: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6205 c91229c3-7414-0410-bfa2-8a42b809f60b

"Issues when trying to introduce db constraints during upgrades"
Fixed. Deleting broken references prior to applying constraints.
Reviewed by: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6204 c91229c3-7414-0410-bfa2-8a42b809f60b

"Issues when trying to introduce db constraints during upgrades"
Fixed. Deleting broken references prior to applying constraints.
Reviewed by: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6199 c91229c3-7414-0410-bfa2-8a42b809f60b

"Issues when trying to introduce db constraints during upgrades"
Fixed. Deleting broken references prior to applying constraints.
Reviewed by: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6198 c91229c3-7414-0410-bfa2-8a42b809f60b

"The structure.sql and data.sql files need to be updated for the new installer"
Updated. Somehow system-settings-to-text.sql was also ommitted so I added that too.

Reviewed By: Conrad



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6177 c91229c3-7414-0410-bfa2-8a42b809f60b

"Implement RSS feed system"
Implemented. Added sql structure for update.

Reviewed By: Kevin, Conrad

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6169 c91229c3-7414-0410-bfa2-8a42b809f60b

"Bug in 3.0.3.0 upgrade script"

Implemented Neil's fix



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6141 c91229c3-7414-0410-bfa2-8a42b809f60b

configuring tables as containing utf8 strings.


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6060 c91229c3-7414-0410-bfa2-8a42b809f60b

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@6056 c91229c3-7414-0410-bfa2-8a42b809f60b

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@5971 c91229c3-7414-0410-bfa2-8a42b809f60b

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@5964 c91229c3-7414-0410-bfa2-8a42b809f60b

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@5962 c91229c3-7414-0410-bfa2-8a42b809f60b

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@5935 c91229c3-7414-0410-bfa2-8a42b809f60b

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@5933 c91229c3-7414-0410-bfa2-8a42b809f60b