kppk-kcomm2: document: database error

[rajaiskandar]

error when uploading document http://10.23.140.43/kcomm/document/upload/657

Database Error

A database error occurred while performing the requested procedure. Please review the database error below for more information.

system/libraries/drivers/Database/Mysql.php [371]:

There was an SQL error: Unknown column 'access' in 'field list' - INSERT INTO documents (id, title, description, keyword, event_date, link, creator, latest_rev_no, reference_no, date_updated, datetime, access, dataset_id) VALUES (NULL, 'Snapshot Guide for Guest User to Navigate K-Commodities', '

This is quick snapshot guide for guest users to navigate K-Commodities \n

\n

There are 3 parts: \n

1. \nRegistration and login as guest user
   1. \nRegister as Guest Account using an email account (as username) and identification number (as password)
   2. \nWait for the activiation email from the Administrator
   3. \nLogin as Guest Account using email account and identification number \n
2. \nNavigating the Menu
   1. \nSelect the Commodity from the Top Menu
   2. \nSelect the Activity from the Left Menu
   3. \nSelect the specific Dataset and the Dashboard for it \n
3. \nViewing the contents which may contain the following
   1. \nData in Table format
   2. \nData in Chart format
   3. \nData in Spreadsheet format
   4. \nData in Map format
   5. \nNews Headlines \n \n

', 'guide, guest', '1970-01-01 04:36:36 pm', '', 'rajaiskandarshah', 1, '', '2010-06-25', '2010-06-25', '1', '657')

[smfadhil]

fix for server 43 and live server: ALTER TABLE documents ADD access ENUM( '0', '1' ) NOT NULL;

[rajaiskandar]

ok done.