Re: Mysql errors on upgrade to 9.14.509

That looks like a mysql privilege problem
iirc you'll need to issue a mysql command
similar to GRANT ALL on yourdatabase TO yourdbuser with password
you might want to check the syntax its been a while since i used mysql

Tom Ed White (tomed@xxxxxxxxxxxxxx) wrote:
>
>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:',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
>
>
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>Phpgroupware-users@xxxxxxx
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>

--
www.kbinx.com