Bad data passed in;

[seansealey]

I don't know what caused it, but our production system has started passing the following message whenever we open specific Cases, Emails or Bugs.

"Bad data passed in; Return to Home"

This happens even on newly created on Bugs or Cases.

A previous posting alluded to an issue with the language pack, but I have not been able to find the English (US) language pack and reinstall that.

Our system runs on the following software:

» Operating system type and version (Linux Red Hat 3)
» Sugar Suite version (4.2.1d)
» Webserver type and version (Apache (unknown number))
» PHP version (5.0.2)
» MySQL server version (4.0.20)

What can I do to repair my system?

[ruchida]

What kind of URL is generated when you hit the case, bug, email in question?

Is there any log created in sugarcrm.log indicating the problematic URL?

For the short time, commenting out following lines in index.php may help. (if your SugarCRM is located in a safe place.)

 clean_special_arguments();
clean_incoming_data(); 
  

[seansealey]

That seemed to do the trick.

The following message keeps repeating in the log:

Sun Nov 19 17:03:49 2006,159 [4817] FATAL SugarCRM - SUGARBEAN: cannot find Real Key for custom field of type dropdown - cannot return Value.

I don't really know where I should go in the code, and fix this error.

/Sean

[ruchida]

That seemed to do the trick.

The following message keeps repeating in the log:

Sun Nov 19 17:03:49 2006,159 [4817] FATAL SugarCRM - SUGARBEAN: cannot find Real Key for custom field of type dropdown - cannot return Value.

I don't really know where I should go in the code, and fix this error.

/Sean

Did you put a non-English string to a field name of a custom field?

[seansealey]

I have no idea.

I only have the English language installed, so I don't know how I would install something that wasn't English.

/Sean

[seansealey]

Hmm, I think I found a problem, if not the problem.

When I run 'Repair Custom Fields' I get the following text:

SIMULATION MODE - NO CHANGES WILL BE MADE EXCEPT CLEARING CACHE

Scanning Bugs
Dropping Column category_c from bugs_cstm for module Bugs
Dropping Column error_category_c from bugs_cstm for module Bugs
2 field(s) missing from bugs_cstm
Adding Column Category_c to bugs_cstm
Adding Column Error_Category_c to bugs_cstm

How do I get rid of this error message. We are not using any custom fields in our system, but there must be a remnant of a reference somewhere.

/Sean

[ruchida]

Hmm, I think I found a problem, if not the problem.

When I run 'Repair Custom Fields' I get the following text:

SIMULATION MODE - NO CHANGES WILL BE MADE EXCEPT CLEARING CACHE

Scanning Bugs
Dropping Column category_c from bugs_cstm for module Bugs
Dropping Column error_category_c from bugs_cstm for module Bugs
2 field(s) missing from bugs_cstm
Adding Column Category_c to bugs_cstm
Adding Column Error_Category_c to bugs_cstm

How do I get rid of this error message. We are not using any custom fields in our system, but there must be a remnant of a reference somewhere.

/Sean

Are there any files under cache/dynamic_fields?
Is there bugs_cstm table in the database?

[seansealey]

Are there any files under cache/dynamic_fields?
Is there bugs_cstm table in the database?

Where do I find cache/dynamic_fields? There is no table of that name in the database.

There is a bugs_custm table in the database.

It has two rows each with three columns. Two of the columns have a value of NULL.

id_c Category_c Error_Category_c
1aa5010c-d5bf-14a1-d277-456c7e29c0f8 NULL NULL
7c2c6b35-0cd6-48fc-b25c-456db37afde1 NULL NULL

/Sean

[ruchida]

Where do I find cache/dynamic_fields? There is no table of that name in the database.

Hi,
It's in the Sugar install directory.

[seansealey]

Hi,
It's in the Sugar install directory.

Yes, there are three folders: Bugs, dynamic_fields, and Leads. And one file called modules.php

The Bugs folder has a file called fields.php that mentions the troublesome customs fields.

Can I delete the contents of the Cache folder, or at least all the contents of the dynamic_fields folder?

/Sean