[Phpgroupware-tracker] [bugs #8006] Problems when updating to version 0.9.16.0001

[Dr. Christian Böttger]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #8006] Latest Modifications:

Changes by: 
                Dr. Christian Böttger <address@hidden>
'Date: 
                Wed 04/21/04 at 07:32 (Europe/Berlin)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | skwashd


------------------ Additional Follow-up Comments ----------------------------
is this still valid?






/**************************************************************************/
[bugs #8006] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8006>
Project: phpGroupWare
Submitted by: 0
On: Thu 03/04/04 at 12:56

Category:  API - Admin
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  7 - High
Resolution:  None
Assigned to:  skwashd
Status:  Open
Component Version:  TGZ
Platform Version:  GNU/Linux - SuSE
Reproducibility:  Every Time


Summary:  Problems when updating to version 0.9.16.0001

Original Submission:  when adding a new user, phpgroupware gives back the 
message:
------------------------------------------------------------

1.
Database error: Invalid SQL: INSERT INTO phpgw_accounts (account_lid, 
account_type, account_pwd,account_firstname, account_lastname, account_status, 
account_expires,person_id,account_quota) VALUES 
('pruebas','u','e10adc3949ba59abbe56e057f20f883e','123456','123456','A',-1,128,-1)
MySQL Error: 1054 (Unknown column 'account_quota' in 'field list')

File: 
/srv/www/htdocs/devonics/phpgroupware/phpgwapi/inc/class.accounts_sql.inc.php
Line: 383
------------------------------------------------------------------
the other:

Database error: Invalid SQL: SELECT contact_note_type.note_type_id AS 
note_type_id, contact_note_type.description AS note_description FROM 
phpgw_contact_note_type AS contact_note_type
MySQL Error: 1100 (Table 'contact_note_type' was not locked with LOCK TABLES)

File: path/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1322

-------------------------------------------------------------

I have updated of version 0.9.14.006 to version 0.9.16.000. If I make a new 
installation, nonupdate, works well. Exists some solution?


Follow-up Comments
------------------


-------------------------------------------------------
Date: Wed 04/21/04 at 07:32         By: cboettger
is this still valid?

-------------------------------------------------------
Date: Thu 03/25/04 at 09:56         By: cedric
For the (Unknown column 'account_quota' in 'field list') error, I manually add 
the column to my MySQL database with this sql script in mysql:

use phpgroupware;
alter table phpgw_accounts add account_quota int default -1 ;


-------------------------------------------------------
Date: Wed 03/24/04 at 16:22         By: cedric
I get the same error too:

Database error: Invalid SQL: UPDATE phpgw_accounts SET 
account_firstname='Cédric', account_lastname='Delfosse', account_status='A', 
account_expires=-1, account_lid='cedric', person_id=665, account_quota=-1 WHERE 
account_id=599439
MySQL Error: 1054 (Unknown column 'account_quota' in 'field list')

File: /var/www/phpgroupware/phpgwapi/inc/class.accounts_sql.inc.php
Line: 103

Session halted.


-------------------------------------------------------
Date: Thu 03/18/04 at 19:33         By: cw
there was a bug that caused some version of mysql to quietly fail to update 
(mysql didn't error AND didn't perform the operation) but this is the first 
I've heard of an error like yours.  If you can try the update again on .16.001 
it will probably go better.

  I don't know if something can or has been done to correct broken installs.  
You can patch it up by installing a second clean install of .16 and adding the 
fields missing to the tables manualy.  

-------------------------------------------------------
Date: Thu 03/11/04 at 15:00         By: cw
For the first, did you go into setup and update tables?

for the second, please see 
https://savannah.gnu.org/bugs/index.php?func=detailitem&item_id=8000












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8006>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/