logo       

Mysql errors on upgrade to 9.14.509: msg#00150

web.phpgroupware.general

Subject: Mysql errors on upgrade to 9.14.509

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>
Google Custom Search

News | FAQ | advertise