mysql 1054 - weird problem

[marjant]

Hello cool people.

When I create new user, everything goes smoothly.

When I try to edit the user (the same one or another it does not matter), whatever field I write something to, I get this:

Query Failed:Update users set user_name='laura.david', user_hash='9a871a2a1b44ce36da856605dd3c446c', authenticate_id=null, sugar_login='1', first_name='Laura', last_name='David', reports_to_id=null, is_admin='0', receive_notifications='1', description=null, date_modified='2009-02-10 10:46:18', modified_user_id='1', created_by='1b133003-2cbe-5564-eaee-485fbfd98ea8', title='Sales Support', department=null, phone_home=null, phone_mobile=null, phone_work=null, phone_other=null, phone_fax=null, status='Active', address_street=null, address_city=null, address_state=null, address_country=null, address_postalcode=null, user_preferences=null, deleted='0', portal_only='0', employee_status='Active', messenger_id=null, messenger_type=null, is_group='0', default_team=null WHERE ID = '3853a72b-c8fb-225f-16b5-4947d64fb811'::MySQL error 1054:

Can someone tell me where to look for the solution for this? What exactly is the error? How come I can do everything except write something for the second time?

Thank you very much for helping me,
Marjan

[andopes]

Hi marjant

Copy this query and execute it int phpMyAdmin
Let us know the error reported by phpMyAdmin

Kind regards

[marjant]

from mysql prompt:

mysql> Update users set user_name='laura.david', user_hash='9a871a2a1b44ce36da856605dd3c446c', authenticate_id=null, sugar_login='1', first_name='Laura', last_name='David', reports_to_id=null, is_admin='0', receive_notifications='1', description=null, date_modified='2009-02-10 10:46:18', modified_user_id='1', created_by='1b133003-2cbe-5564-eaee-485fbfd98ea8', title='Sales Support', department=null, phone_home=null, phone_mobile=null, phone_work=null, phone_other=null, phone_fax=null, status='Active', address_street=null, address_city=null, address_state=null, address_country=null, address_postalcode=null, user_preferences=null, deleted='0', portal_only='0', employee_status='Active', messenger_id=null, messenger_type=null, is_group='0', default_team=null WHERE ID = '3853a72b-c8fb-225f-16b5-4947d64fb811';

ERROR 1054 (42S22): Unknown column 'default_team' in 'field list'

Now I suspect it is a CE Teams module related thing which I just installed. http://www.sugarforge.org/projects/ce-teams

I asked the developers for help, but if you or someone else can give some advice I will be thankful.

Thank you,
Marjan

[crmsiva]

Go to "Admin -> Repair -> Quick Repair and Rebuild " and do the repair for Users module. This will fix the problem.

[marjant]

Go to "Admin -> Repair -> Quick Repair and Rebuild " and do the repair for Users module. This will fix the problem.

This is what I get when trying this:

Executing repair query: Query Failed:ALTER TABLE accounts add column team_id char(36) NULL ALTER TABLE users add column default_team char(36) NULL ALTER TABLE users add column default_team char(36) NULL ALTER TABLE users add column default_team char(36) NULL::MySQL error 1064:

Thank you for your answers,
Marjan

[andopes]

This is what I get when trying this:

Executing repair query: Query Failed:ALTER TABLE accounts add column team_id char(36) NULL ALTER TABLE users add column default_team char(36) NULL ALTER TABLE users add column default_team char(36) NULL ALTER TABLE users add column default_team char(36) NULL::MySQL error 1064:

Thank you for your answers,
Marjan

Which version are you using?
This is known bug in the older 5.x version.
When Repairing Database add a semi-colon ";" before the second "ALTER TABLE".

Cheers

[marjant]

Which version are you using?
This is known bug in the older 5.x version.
When Repairing Database add a semi-colon ";" before the second "ALTER TABLE".

Cheers

Here is what I did to fix this if anyone else has the same problem.

in mysql prompt you type this (you can also do it in phpmyadmin but I don't use that)

ALTER TABLE accounts add column team_id char(36) NULL /* Table : users */;
then Enter

ALTER TABLE users add column default_team char(36) NULL /* Table : users */;
then Enter

and you are ready to go.

Thank you all for your suggestions,
Marjan