Error on Users Detail view

**aheuermann** · 2006-10-20, 05:48 PM

I was edititng the labels in the field layout of the Users Detail view and after pressing save i could tell it was hanging. I waited a while and it did not stop so I hit stop and then I got a syntax error on my detailview and editview page when I tried to load them.

It had added this to the beginnig of my /custom/modules/users/language/en_us.lang.php file.

is the last user with administrator access. At least one user must be an administrator.';

PHP Code:

 <?php

// Creation date: 2006-08-14 15:47:16

// Module: Users

// Language: en_us

 
;

is the last user with administrator access.    At least one user must be an administrator.';

new password\&quot; and \&quot;confirm password\&quot; values do not match.';

My Account&quot;.';

br&gt;Finding optimum connection variables.';

br&gt;Found optimum settings.    Press the button below to apply them to your Mailbox.';

--with-imap-ssl&quot; in the configuration.';

do not delete.';

 

$mod_strings['ERR_DELETE_RECORD'] = 'A record number must be specified to delete the account.';

$mod_strings['ERR_EMAIL_NO_OPTS'] = 'Could not find optimum settings for Inbound Email.';

$mod_strings['ERR_ENTER_CONFIRMATION_PASSWORD'] = 'Please enter your password confirmation.';

$mod_strings['ERR_ENTER_NEW_PASSWORD'] = 'Please enter your new password.';

$mod_strings['ERR_ENTER_OLD_PASSWORD'] = 'Please enter your old password.';

$mod_strings['ERR_IE_FAILURE1'] = '[Click here to return]';

$mod_strings['ERR_IE_FAILURE2'] = 'There was a problem connecting to the Email Account.  Please check your settings and try again.';

$mod_strings['ERR_INVALID_PASSWORD'] = 'You must specify a valid username and password.';

$mod_strings['ERR_LAST_ADMIN_1'] = 'The user name &quot;';

$mod_strings['ERR_LAST_ADMIN_2'] = '&quot; is the last user with administrator access.    At least one user must be an administrator.';

$mod_strings['ERR_PASSWORD_CHANGE_FAILED_1'] = 'User password change failed for ';

$mod_strings['ERR_PASSWORD_CHANGE_FAILED_2'] = ' failed.    The new password must be set.';

$mod_strings['ERR_PASSWORD_INCORRECT_OLD_1'] = 'Incorrect old password for user ;

I commented it out to get rid of the syntax error and the page actually loaded but now when I load the Users detailview with a user who is not admin, I get the following error at the bottom.

Retrieving record by id users_signatures:af41f16d-24b6-c98a-39dc-44be8b53f594 found Query Failed:SELECT users_signatures.* , users_signatures_cstm.* FROM users_signatures LEFT JOIN users_signatures_cstm ON users_signatures.id = users_signatures_cstm.id_c WHERE users_signatures.id = 'af41f16d-24b6-c98a-39dc-44be8b53f594' LIMIT 0,1::MySQL error 1146: Table 'sugarcrm.users_signatures_cstm' doesn't exist

I have a custom field but it is located in Users_cstm, I did not edit anything involving a user signature so I am not sure why it is looking for that table. I tried rebuilding relationships, database, ext.., and I havent had any luck finding anything in the custom extension files regarding this. Any suggestions would be greatly appreciated!!!

**aheuermann** · 2006-10-24, 06:59 PM

Originally Posted by aheuermann

I was edititng the labels in the field layout of the Users Detail view and after pressing save i could tell it was hanging. I waited a while and it did not stop so I hit stop and then I got a syntax error on my detailview and editview page when I tried to load them.

It had added this to the beginnig of my /custom/modules/users/language/en_us.lang.php file.

is the last user with administrator access. At least one user must be an administrator.';

PHP Code:

 <?php

// Creation date: 2006-08-14 15:47:16

// Module: Users

// Language: en_us

 
;

is the last user with administrator access.    At least one user must be an administrator.';

new password\&quot; and \&quot;confirm password\&quot; values do not match.';

My Account&quot;.';

br&gt;Finding optimum connection variables.';

br&gt;Found optimum settings.    Press the button below to apply them to your Mailbox.';

--with-imap-ssl&quot; in the configuration.';

do not delete.';

 

$mod_strings['ERR_DELETE_RECORD'] = 'A record number must be specified to delete the account.';

$mod_strings['ERR_EMAIL_NO_OPTS'] = 'Could not find optimum settings for Inbound Email.';

$mod_strings['ERR_ENTER_CONFIRMATION_PASSWORD'] = 'Please enter your password confirmation.';

$mod_strings['ERR_ENTER_NEW_PASSWORD'] = 'Please enter your new password.';

$mod_strings['ERR_ENTER_OLD_PASSWORD'] = 'Please enter your old password.';

$mod_strings['ERR_IE_FAILURE1'] = '[Click here to return]';

$mod_strings['ERR_IE_FAILURE2'] = 'There was a problem connecting to the Email Account.  Please check your settings and try again.';

$mod_strings['ERR_INVALID_PASSWORD'] = 'You must specify a valid username and password.';

$mod_strings['ERR_LAST_ADMIN_1'] = 'The user name &quot;';

$mod_strings['ERR_LAST_ADMIN_2'] = '&quot; is the last user with administrator access.    At least one user must be an administrator.';

$mod_strings['ERR_PASSWORD_CHANGE_FAILED_1'] = 'User password change failed for ';

$mod_strings['ERR_PASSWORD_CHANGE_FAILED_2'] = ' failed.    The new password must be set.';

$mod_strings['ERR_PASSWORD_INCORRECT_OLD_1'] = 'Incorrect old password for user ;

I commented it out to get rid of the syntax error and the page actually loaded but now when I load the Users detailview with a user who is not admin, I get the following error at the bottom.

Retrieving record by id users_signatures:af41f16d-24b6-c98a-39dc-44be8b53f594 found Query Failed:SELECT users_signatures.* , users_signatures_cstm.* FROM users_signatures LEFT JOIN users_signatures_cstm ON users_signatures.id = users_signatures_cstm.id_c WHERE users_signatures.id = 'af41f16d-24b6-c98a-39dc-44be8b53f594' LIMIT 0,1::MySQL error 1146: Table 'sugarcrm.users_signatures_cstm' doesn't exist

I have a custom field but it is located in Users_cstm, I did not edit anything involving a user signature so I am not sure why it is looking for that table. I tried rebuilding relationships, database, ext.., and I havent had any luck finding anything in the custom extension files regarding this. Any suggestions would be greatly appreciated!!!

Has anyone experienced this problem???

**ggolin** · 2007-02-05, 08:17 PM

Seeing a similar issue when trying to edit an admin user. Upon a save of the profile the system displays the following error:

The user name "greg" is the last user with administrator access. At least one user must be an administrator.

Please click the browser back button and fix the error.

I tried adding another user with the administrative privilege, however doing so did not solve the problem. I still cannot edit my account.

GG