Re: [Phpgroupware-users] Mysql errors on upgrade to 9.14.509

[Kevin Scott]

Tom Ed White (address@hidden) wrote:
>
>I added priviledges "references" "index" and "alter" to user phpgroupware.
>Now I am able to manually alter the table from the first error message
>without problems.
>Should I take all the failed sql statements and run them manually, or
>rerun the update program again? If I need to rerun the php code that
>updates the tables, how do I do that? When I log in as setup admin, it
>does not give me the option of upgrading the tables.
>BTW, there is a "phpgw" user that has always had the necessary
>priviledges. Here's a snippet from the phpgroupware install howto, section
>2.3:
>
>$ mysqladmin -u root -p create phpgroupware (enter root's password when
>prompted)$ mysql -u root -p
>mysql> grant all on phpgroupware.* to address@hidden identified by
>"my-db-passwd";mysql> exit;
>
>The phpgroupware user had all the same priviledges except for
>"references," "index," and "alter." The sequence of commands in the howto
>grants these priviledges to "phpgw," but not to "phpgroupware." The
>upgrade scripts need user "phpgroupware" to have these priviledges.
>Thanks,
>Tom Ed White

The values used in the docs are just examples.
whatever user and database name you have specified
in setup.header.inc is what you use for the GRANT ALL command
or visa versa. The values supplied are just defaults and should
probably be changed by you anyway.


>
>
>> 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 (address@hidden) 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:
>>>'address@hidden' to database 'phpgroupware')Database error:
>>>Invalid SQL: ALTER TABLE lang RENAME phpgw_lang MySQL Error: 1044
>>>(Access denied for user: 'address@hidden' to database
>>>'phpgroupware')Database error: Invalid SQL: ALTER TABLE languages
>>>RENAME
>> phpgw_languages
>>>MySQL Error: 1044 (Access denied for user: 'address@hidden' 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:
>>>'address@hidden' to database 'phpgroupware')Database error:
>>>Invalid SQL: ALTER TABLE phpgw_preferences
>> RENAME
>>>old_preferencesMySQL Error: 1044 (Access denied for user:
>>>'address@hidden' 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:
>> 'address@hidden' to
>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>phpgw_categories
>> ADD COLUMN
>>>last_mod int NOT NULLMySQL Error: 1044 (Access denied for user:
>> 'address@hidden' to
>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>phpgw_vfs MODIFY
>> content text
>>>MySQL Error: 1044 (Access denied for user: 'address@hidden' 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:
>> 'address@hidden' to
>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>phpgw_accounts ADD
>> COLUMN
>>>person_id intMySQL Error: 1044 (Access denied for user:
>>>'address@hidden' to database 'phpgroupware')Database error:
>>>Invalid SQL: ALTER TABLE phpgw_contact ADD
>> COLUMN ab_id
>>>varchar(4)MySQL Error: 1044 (Access denied for user:
>>>'address@hidden' 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:
>>>'address@hidden' 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:
>>>'address@hidden' 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
>>>address@hidden
>>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>
>>>
>>
>> --
>> www.kbinx.com
>>
>>
>>
>>
>> _______________________________________________
>> Phpgroupware-users mailing list
>> address@hidden
>> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>

--
www.kbinx.com