help help custom fields not writing

[Meyer]

hi there

only in my leads module is this happening.
when i enter data just the norlmal leads info is written to the database and not the custom fields. have done all the repairs on the admin

[chrislynch8]

Hi,

Did you create the fields in that instance of sugar of did you install them from a dev instance.
Can you see the fields in the Database using phpmyadmin or some other program that will let you access the DB

Rgds
Chris

[Meyer]

hi. yes i can see the fields and if i put in information on the back end it shouws in sugar

cheers

[RandyLee]

I can't see your problem in latest release build 520f, any more information for this?

[andopes]

hi there

only in my leads module is this happening.
when i enter data just the norlmal leads info is written to the database and not the custom fields. have done all the repairs on the admin

Hi Meyer

Edit the file modules/DynamicFields/DynamicField.php and add this piece of code

 $fh = fopen('customfields.log.txt', 'w');
fwrite($fh, "query: $query\nqueryInsert: $queryInsert\n\n");
fclose($fh); 
  

just after the line

             $queryInsert .= " ) VALUES $values )"; 
  

Try to save other records, the open the file customfields.log.txt at the root of your sugar installation.
Try to execute the queries on phpMyAdmin. Let us know if you face any error message.

Regards

[Meyer]

hi there

Does in need to be php admin or could it be done from sql yog as well
because from sql yog the query went through without a problem adding the data to the tables and showing in sugar.

[Meyer]

new updated info

One the is a relationship there is no problem updating the custom fields etc. i can change them and go crazy and it writes all changes to the database and shows in sugar.

It is when you create a new lead that nothing happens. then you have to first at the back end enter data, after that the module works

regards

Paul