Re: Mysql errors on upgrade to 9.14.509

Tom Ed White (tomed@xxxxxxxxxxxxxx) wrote:
>
>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
>
The easiest thing to do is restore your backup/dump of your .006
database and start over.  otherwise I don't know


>> 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
>
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>Phpgroupware-users@xxxxxxx
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>

--
www.kbinx.com