Re: Mysql errors on upgrade to 9.14.509

Should I manually run the failed sql statements and then continue with
updating the applications? Or is there a way to rerun the global update
again, from the setup admin page? If I login to setup at this point, it
thinks that all tables and applications have been updated successfully.
Thanks,
Tom Ed White

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