bugphpGroupWare - Bugs: bug #8006, Problems when updating to version...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #8006: Problems when updating to version 0.9.16.0001

Submitter:  None
Submitted:  Thu 04 Mar 2004 12:56:16 PM UTC
   
 
Category:  API - Admin Item Group:  0.9.16.005
Severity:  3 - Normal Priority:  7 - High
Status:  None Privacy:  Public
Assigned to:  lpiepho Open/Closed:  Open
Component Version:  TGZ Operating System:  GNU/Linux - SuSE
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Jump to the original submission

Tue 17 May 2005 01:27:15 PM UTC, comment #9: 

I think you will find this is now fixed.  It is related to lex fscking up the upgrade script, which meant that the update scripts where being run from 14.50x every time you try to update.

I committed a fix to stable cvs some time ago to fix it.

Dave Hall <skwashd>
Group administrator
Tue 17 May 2005 01:19:06 PM UTC, comment #8: 

i've had this issue on every .14->.16 upgrade i've tried.

Chris Weiss <cw>
Group administrator
Wed 21 Apr 2004 08:55:25 AM UTC, comment #7: 

I am not maintainer of filemanager...

Dr. Christian Böttger <cboettger>
Wed 21 Apr 2004 08:02:34 AM UTC, comment #6: 

Filemanager upgrade script related

Dave Hall <skwashd>
Group administrator
Wed 21 Apr 2004 07:32:47 AM UTC, comment #5: 

is this still valid?

Dr. Christian Böttger <cboettger>
Thu 25 Mar 2004 09:56:14 AM UTC, comment #4: 

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 ;

Cédric Delfosse <cedric>
Wed 24 Mar 2004 04:22:04 PM UTC, comment #3: 

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.

Cédric Delfosse <cedric>
Thu 18 Mar 2004 07:33:32 PM UTC, comment #2: 

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.

Chris Weiss <cw>
Group administrator
Thu 11 Mar 2004 03:00:16 PM UTC, comment #1: 

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

Chris Weiss <cw>
Group administrator
Thu 04 Mar 2004 12:56:16 PM UTC, 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?

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 4 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2005-05-17 cw Item Group0.9.16.000 release 0.9.16.005
2004-04-21 cboettger Assigned tocboettger lpiepho
2004-04-21 skwashd Assigned toskwashd cboettger
2004-04-21 cboettger Assigned toNone skwashd

Back to the top

Powered by Savane 3.13-f8d8.
Corresponding source code