User preferences

[jonnywatson]

Hi,

Everytime a user logs out of the CRM this error is displayed:

Query Failed:INSERT into user_preferences set ::MySQL error 1064:

So no changes are saved....

Any ideas?

[vasi2me]

Hi Jonny,

I suggest you try Repair Database in Admin -> Repair.

Hopefully that should resolve the issue.

Thanks,
Vasi.

[jonnywatson]

just tried that....didnt seem to resolve it

[vasi2me]

Hi Jonny,

Can you post the complete Failed Query. information.

And also if you have done any customizations please let us know, what exactly might have caused this.

basically the User preferrences table will store the infromation about the Users Last Saved Search detals and his list view sort order etc.

Thanks,
Vasi

[jonnywatson]

Hi Jonny,

Can you post the complete Failed Query. information.

And also if you have done any customizations please let us know, what exactly might have caused this.

basically the User preferrences table will store the infromation about the Users Last Saved Search detals and his list view sort order etc.

Thanks,
Vasi

What i posted at the top is what message i get...

What i have been doing is creating customer modules....i have how ever had to re set up the tables in MySQL as they all got dropped by someone.....

But all is working correctly bar this user preference....I check the permission of the table and they are fine....and i have run the full repair script now too...nothing....from what i know about SQL is that error normally means that its a synatx issue...but i dont understand how all over a sudden the syntax is differenet....although i have recently upgraded to 5.0f from c.....could this have caused it?

[eggsurplus]

Turn on logging (log4php.properties) then recreate the error and check sugarcrm.log for the full sql.

[jonnywatson]

This is what i got from the sugarcrm.log file....


Mon Jul 14 13:43:38 2008,433 [9399] INFO SugarCRM - Query Execution Time:0.000212
Mon Jul 14 13:43:38 2008,434 [9399] INFO SugarCRM - Query:SELECT id, contents FROM user_preferences WHERE assigned_user_id = '1' AND category = 'global'
Mon Jul 14 13:43:38 2008,435 [9399] INFO SugarCRM - Query Execution Time:0.000186
Mon Jul 14 13:43:38 2008,435 [9399] DEBUG SugarCRM - Retrieve UserPreference : SELECT user_preferences.* FROM user_preferences WHERE user_preferences.id = 'cc1d15ee-45d1-76cc-e4d9-4829b68f7342' AND user_preferences.deleted=0
Mon Jul 14 13:43:38 2008,436 [9399] DEBUG SugarCRM - Limit Query:SELECT user_preferences.* FROM user_preferences WHERE user_preferences.id = 'cc1d15ee-45d1-76cc-e4d9-4829b68f7342' AND user_preferences.deleted=0 Start: 0 count: 1
Mon Jul 14 13:43:38 2008,436 [9399] INFO SugarCRM - Query:SELECT user_preferences.* FROM user_preferences WHERE user_preferences.id = 'cc1d15ee-45d1-76cc-e4d9-4829b68f7342' AND user_preferences.deleted=0 LIMIT 0,1
Mon Jul 14 13:43:38 2008,437 [9399] INFO SugarCRM - Query Execution Time:0.000189
Mon Jul 14 13:43:38 2008,438 [9399] INFO SugarCRM - Insert: INSERT into user_preferences set
n Jul 14 13:43:38 2008,436 [9399] INFO SugarCRM - Query:SELECT user_preferences.* FROM user_preferences WHERE user_preferences.id = 'cc1d15ee-45d1-76cc-e4d9-4829b68f7342' AND user_preferences.deleted=0 LIMIT 0,1
Mon Jul 14 13:43:38 2008,437 [9399] INFO SugarCRM - Query Execution Time:0.000189
Mon Jul 14 13:43:38 2008,438 [9399] INFO SugarCRM - Insert: INSERT into user_preferences set
Mon Jul 14 13:43:38 2008,438 [9399] INFO SugarCRM - Save: INSERT into user_preferences set
Mon Jul 14 13:43:38 2008,438 [9399] INFO SugarCRM - Query:INSERT into user_preferences set
Mon Jul 14 13:43:38 2008,439 [9399] INFO SugarCRM - Query Execution Time:0.000213
Mon Jul 14 13:43:38 2008,439 [9399] FATAL SugarCRM - MySQL error 1064:
Mon Jul 14 13:43:38 2008,438 [9399] INFO SugarCRM - Save: INSERT into user_preferences set
Mon Jul 14 13:43:38 2008,438 [9399] INFO SugarCRM - Query:INSERT into user_preferences set
Mon Jul 14 13:43:38 2008,439 [9399] INFO SugarCRM - Query Execution Time:0.000213
Mon Jul 14 13:43:38 2008,439 [9399] FATAL SugarCRM - MySQL error 1064:
Mon Jul 14 13:44:01 2008,753 [17635] INFO SugarCRM - Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Mon Jul 14 13:44:01 2008,754 [17635] INFO SugarCRM - Query Execution Time:0.000195

Doesnt make sense to me

[eggsurplus]

It looks like it's not even finishing the building of the query. Can you try to go to "My Account" and reset your User Preferences? Perhaps that'll do it.

[jonnywatson]

Just tried that and it logged me out....when i logged back in it asked to set the time zone...when i do this it kicks that error again....it does look like the SQL query isnt complete....could it just be the install? The rest of the system works perfectly bar the personlisation of it.....but it use to

[jonnywatson]

Something else to mention....i have just tried to do a repair on just the userpreference table and getting this error:

Clearing Vardefs from cache...done
Repair Database
Print Print Help Help
Processing database and vardef comparison...

Warning: RepairAndClear::include(modules/UserPreferences/vardefs.php) [function.RepairAndClear-include]: failed to open stream: No such file or directory in /home/jon/Public/SugarCE-Full-5.0.0c/modules/Administration/QuickRepairAndRebuild.php on line 169

Warning: RepairAndClear::include() [function.include]: Failed opening 'modules/UserPreferences/vardefs.php' for inclusion (include_path='/home/jon/Public/SugarCE-Full-5.0.0c/include/..:.:/usr/share/php:/usr/share/pear') in /home/jon/Public/SugarCE-Full-5.0.0c/modules/Administration/QuickRepairAndRebuild.php on line 169

Repairing DB for UserPreference
Database tables are synced with vardefs
Clearing Template files from cache...done
Clearing JS files from cache...done
Clearing Vardefs from cache...done
Clearing JS Language files from cache...done
Clearing Dashlet files from cache...done
Clearing Smarty templates from cache...done
Clearing XML files from cache...done
Rebuilding Audit Tables...
UserPreference not Audit Enabled...
Done
Rebuilding Extensions...
Rebuilding Language...en_us
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Rebuilding Menus...
Rebuilding User Page Section...
Rebuilding administration Section...
Rebuilding Relationships
Clearing language files from cache...done

Not sure if this is signifcante or anything.....