Table behaving badly.

[damocles]

We have a table that is behaving poorly, and I don’t know where to begin. It seems like leads_cstm will not allow any rewrite of data. We’ve successfully created new records but after the initial save no changes or updates can be saved, this includes our needed second save for the customization we’ve done. Until this is fixed we are back to using an archaic backup system.

Any help is greatly appreciated,

David

Apache 2, PHP 4.3.11, Mysql 4.1.1.16, Sugar 4.2.1d, Debian Standard

[sadek]

* Edit config.php and change the following directives
*** 'dump_slow_queries' => true,
*** 'slow_query_time_msec' => -1,
* Go to the problematic page that you suspect is causing the issue
* Clear the sugarcrm.log (or rename it)
* Perform the action that will generate the query
* Copy the sugarcrm.log to a new location
* Change the 'dump_slow_queries' and 'slow_query_time_msec' back to what they were set to before changing

Once you have done this, please attach your sugarcrm.log so I can take a look at the query being generated. It's probably failing, which is why you can't modify the custom fields.

-Sadek