bugphpGroupWare - Bugs: bug #7450, table lock problem while adding...

 
 

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

bug #7450: table lock problem while adding accounts

Submitted by:  Philipp Kamps <fipsfuchs>
Submitted on:  Mon 26 Jan 2004 12:48:36 PM UTC  
 
Item Group: SVN trunk (dev code)Category: API - phpGroupware API
Severity: 6 - SecurityPriority: 7 - High
Status: NonePrivacy: Public
Assigned to: Philipp Kamps <fipsfuchs>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: NonePlanned Release: None
Fixed Release: 

Mon 26 Jan 2004 01:25:18 PM UTC, comment #3:

the call of save_contact_for_account() in class.account_ldap.inc.php results in errors. I'll write another bug report for this.

Philipp Kamps <fipsfuchs>In charge of this item.
Mon 26 Jan 2004 01:25:07 PM UTC, comment #2:

the call of save_contact_for_account() in class.account_ldap.inc.php results in errors. I'll write another bug report for this.

Philipp Kamps <fipsfuchs>In charge of this item.
Mon 26 Jan 2004 12:51:41 PM UTC, comment #1:

this error only occurres in combination with the ldap backend.

Philipp Kamps <fipsfuchs>In charge of this item.
Mon 26 Jan 2004 12:48:36 PM UTC, original submission:

This error occurred while adding a new account:

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: /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1326

Session halted.

Here the backtrace() output:

Array
(
[0] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/class.contacts_sql.inc.php
[line] => 638
[function] => get_contact_note_type
[class] => contacts
[type] => ->
[args] => Array
(
)

)

[1] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/class.contacts_sql.inc.php
[line] => 586
[function] => read_sessiondata
[class] => contacts
[type] => ->
[args] => Array
(
)

)

[2] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/common_functions.inc.php
[line] => 547
[function] => contacts_
[class] => contacts
[type] => ->
[args] => Array
(
)

)

[3] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/class.accounts.inc.php
[line] => 149
[function] => createobject
[args] => Array
(
[0] => phpgwapi.contacts
)

)

[4] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/class.accounts_ldap.inc.php
[line] => 675
[function] => save_contact_for_account
[class] => accounts
[type] => ->
[args] => Array
(
[0] => Array
(
[account_id] => 8
[account_lid] => philipp.kamps
[account_firstname] => Philipp
[account_lastname] => Kamps
[type] => u
[account_dn] => uid=philipp.kamps,ou=phpgw accounts,ou=people,ou=hannover,dc=probusiness,dc=de
[fullname] => Philipp Kamps
[homedirectory] => /home/pkamps
[loginshell] =>
[expires] => -1
[status] => A
)

)

)

[5] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/admin/inc/class.soaccounts.inc.php
[line] => 36
[function] => create
[class] => accounts
[type] => ->
[args] => Array
(
[0] => Array
(
[account_type] => u
[account_lid] => test
[account_firstname] => test
[account_lastname] => test
[account_passwd] => test
[status] => A
[account_status] => A
[old_loginid] =>
[account_id] => 0
[account_passwd_2] => test
[account_groups] => Array
(
[0] => 1000
)

[anonymous] =>
[changepassword] => 1
[account_permissions] => Array
(
[addressbook] => True
)

[homedirectory] => /tmp/
[loginshell] => /bin/bash
[account_expires_month] => 2
[account_expires_day] => 2
[account_expires_year] => 2004
[account_expires_never] =>
[domain] =>
[add_addbook] =>
[person_id] =>
[expires] => 1075683600
[account_expires] => 1075683600
)

)

)

[6] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/admin/inc/class.boaccounts.inc.php
[line] => 373
[function] => add_user
[class] => soaccounts
[type] => ->
[args] => Array
(
[0] => Array
(
[account_type] => u
[account_lid] => test
[account_firstname] => test
[account_lastname] => test
[account_passwd] => test
[status] => A
[account_status] => A
[old_loginid] =>
[account_id] => 0
[account_passwd_2] => test
[account_groups] => Array
(
[0] => 1000
)

[anonymous] =>
[changepassword] => 1
[account_permissions] => Array
(
[addressbook] => True
)

[homedirectory] => /tmp/
[loginshell] => /bin/bash
[account_expires_month] => 2
[account_expires_day] => 2
[account_expires_year] => 2004
[account_expires_never] =>
[domain] =>
[add_addbook] =>
[person_id] =>
[expires] => 1075683600
[account_expires] => 1075683600
)

)

)

[7] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/admin/inc/class.boaccounts.inc.php
[line] => 345
[function] => _add_user
[class] => boaccounts
[type] => ->
[args] => Array
(
[0] => Array
(
[account_type] => u
[account_lid] => test
[account_firstname] => test
[account_lastname] => test
[account_passwd] => test
[status] => A
[account_status] => A
[old_loginid] =>
[account_id] => 0
[account_passwd_2] => test
[account_groups] => Array
(
[0] => 1000
)

[anonymous] =>
[changepassword] => 1
[account_permissions] => Array
(
[addressbook] => True
)

[homedirectory] => /tmp/
[loginshell] => /bin/bash
[account_expires_month] => 2
[account_expires_day] => 2
[account_expires_year] => 2004
[account_expires_never] =>
[domain] =>
[add_addbook] =>
[person_id] =>
[expires] => 1075683600
[account_expires] => 1075683600
)

)

)

[8] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/phpgwapi/inc/common_functions.inc.php
[line] => 611
[function] => add_user
[class] => boaccounts
[type] => ->
[args] => Array
(
)

)

[9] => Array
(
[file] => /home/pkamps/eclipse/phpgw-0.9.16/index.php
[line] => 76
[function] => execmethod
[args] => Array
(
[0] => admin.boaccounts.add_user
)

)

)

Philipp Kamps <fipsfuchs>In charge of this item.

 

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
Mon 26 Jan 2004 01:25:18 PM UTCfipsfuchsOpen/ClosedOpen=>Closed
Mon 26 Jan 2004 12:52:14 PM UTCfipsfuchsAssigned toNone=>fipsfuchs
  Open/ClosedClosed=>Open
Mon 26 Jan 2004 12:51:41 PM UTCfipsfuchsOpen/ClosedOpen=>Closed
Mon 26 Jan 2004 12:49:02 PM UTCfipsfuchsSummaryLock problem while adding accounts=>table lock problem while adding accounts

Back to the top


Powered by Savane 3.1-cleanup1