|
Mysql errors on upgrade to 9.14.509: msg#00150web.phpgroupware.general
Running debian woody with mysql 3.23.49 and php4 4.1.2 and apache 1.3.26 Upgrading from 006 to 509, I get the following mysql errors after updating the header.inc.php file: Database error: Invalid SQL: ALTER TABLE phpgw_vfs ADD COLUMN content text MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE lang RENAME phpgw_lang MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE languages RENAME phpgw_languages MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: CREATE TABLE phpgw_async (id varchar(255) NOT NULL, next int NOT NULL, times varchar(255) NOT NULL, method varchar(80) NOT NULL, data text NOT NULL, PRIMARY KEY(id))MySQL Error: 1050 (Table 'phpgw_async' already exists) Database error: Invalid SQL: ALTER TABLE phpgw_applications DROP COLUMN app_titleMySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_preferences RENAME old_preferencesMySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: CREATE TABLE phpgw_preferences (preference_owner int NOT NULL, preference_app varchar(25) NOT NULL, preference_value text NOT NULL, PRIMARY KEY(preference_owner,preference_app))MySQL Error: 1050 (Table 'phpgw_preferences' already exists) Database error: next_record called with no query pending. Database error: Invalid SQL: DROP TABLE old_preferences MySQL Error: 1051 (Unknown table 'old_preferences') Database error: Invalid SQL: ALTER TABLE phpgw_addressbook ADD COLUMN last_mod int NOT NULLMySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_categories ADD COLUMN last_mod int NOT NULLMySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_vfs MODIFY content text MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_async ADD COLUMN account_id int NOT NULL DEFAULT '0'MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_accounts ADD COLUMN person_id intMySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_contact ADD COLUMN ab_id varchar(4)MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_contact_person ADD COLUMN ab_id varchar(4)MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE phpgw_contact_org ADD COLUMN ab_id varchar(4)MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to database 'phpgroupware')Database error: Invalid SQL: INSERT INTO phpgw_contact (owner,access,cat_id,contact_type_id,ab_id) VALUES (7,'private',null,1,1)MySQL Error: 1054 (Unknown column 'ab_id' in 'field list') Session halted. I logged in to mysql as phpgroupware and tried some of the commands by hand, with the same errors resulting. Could I perhaps grant some priviledges to phpgroupware and try again? I have never done any manual setup/modifications to the phpgroupware tables, and have only used the install scripts. Logging in as setup admin, everything seems fine. I haven't tried upgrading applications yet. Logging in as a user, I get the following: Database error: Invalid SQL: UPDATE phpgw_async SET next=0,times='a:0:{}',method='none',data='a:3:{s:6:\"run_by\";s:8:\"fallback\";s:5:\"start\";i:1063467334;s:3:\"end\";i:0;}',account_id=0 WHERE id='##last-check-run##'MySQL Error: 1054 (Unknown column 'account_id' in 'field list') File: /var/www/phpgroupware/phpgwapi/inc/class.asyncservice.inc.php Line: 518 Session halted. Thanks, Tom Ed White |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: New contacts backend: 00150, Star Support Beheer |
|---|---|
| Next by Date: | Re: Mysql errors on upgrade to 9.14.509: 00150, Admin |
| Previous by Thread: | New contacts backendi: 00150, Alex Borges |
| Next by Thread: | Re: Mysql errors on upgrade to 9.14.509: 00150, Admin |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |