[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Dr. Christian Böttger
Subject: [Phpgroupware-tracker] [bugs #8006] Problems when updating to version
Date: Wed, 21 Apr 2004 03:32:50 -0400
User-agent: Mozilla/5.0 (compatible; Konqueror/3.2; Linux 2.4.21-202-default; X11; i686; de, address@hidden) (KHTML, like Gecko)

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>
                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: <>
Project: phpGroupWare
Submitted by: 0
On: Thu 03/04/04 at 12:56

Category:  API - Admin
Item Group: 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

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

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 
MySQL Error: 1054 (Unknown column 'account_quota' in 'field list')

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/
Line: 1322


I have updated of version to version 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 
MySQL Error: 1054 (Unknown column 'account_quota' in 'field list')

File: /var/www/phpgroupware/phpgwapi/inc/
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

For detailed info, follow this link:

  Message sent via/by Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]