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

Submitted by:  None
Submitted on:  Thu 04 Mar 2004 12:56:16 PM UTC  
 
Item Group: 0.9.16.005Category: API - Admin
Severity: 3 - NormalPriority: 7 - High
Status: NonePrivacy: Public
Assigned to: Lars Piepho <lpiepho>Open/Closed: Open
Component Version: TGZOperating System: GNU/Linux - SuSE
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

(Jump to the original submission 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>
Project 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>
Project 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>
Project 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>
Project 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>
Project 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

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 5 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Tue 29 Dec 2015 06:58:36 PM UTCandy1978Dependencies-=>bugs #46779 is dependent
Tue 17 May 2005 01:19:06 PM UTCcwItem Group0.9.16.000 release=>0.9.16.005
Wed 21 Apr 2004 08:55:25 AM UTCcboettgerAssigned tocboettger=>lpiepho
Wed 21 Apr 2004 08:02:34 AM UTCskwashdAssigned toskwashd=>cboettger
Wed 21 Apr 2004 07:32:47 AM UTCcboettgerAssigned toNone=>skwashd

Back to the top


Powered by Savane 3.1-cleanup1