Custom Fields all gone!

[rjuari]

Hello all,

Here is the story so far:
First there was a problem with our CRM sub-panels, it's showing up a very long lines of MySQL error.
After spending a couple of minutes reading the thread on the forum, someone suggested that it might be php version problem (We are still running php version 4).

A few minutes after that I got an email from my boss saying that he could not login. (there is this red line saying "Please replace the sugarCRM logo")
This happened because he installed a module, SugarCubed: Configurator Upgrades version 4.5.0f to be exact.
I was able to solve this problem by replacing the current index.php with the original index.php from the installation package.
However, when we login we didn't see any custom fields that my boss created before.
So... I replaced back the index.php thinking that this may cause the disappearing fields problem.

After a lot of stress, I finally know why the login error happened (for my case anyway).
Apparently this line : "© 2004-2007 SugarCRM Inc. All Rights Reserved." was changed to "© 2004-2006 SugarCRM Inc. All Rights Reserved." (notice the 2007 and 2006). I suspected this was caused by the configurator upgrades module, since I think I saw someone posted in the forum that the configurator module modified the index.php and it was created in 2006.

Now, does that module also modify any custom fields or any customasation by any chance?
My boss told me that before he installed the configurator module, he did a back up through Administrator > System > backups. Is that supposed to back up the custom fields, the databases as well? what's the purpose of that backup? How do I restore the file created from that backup method? Is the custom field stored in the database? where is it stored?

Is there any way I can restore the custom fields?

Sorry for asking a lot of questions. Any help would be much appreciated.

Thanks

EDIT:
Sorry, apparently the custom fields ARE THERE!!! BUT...the one that's missing are the custom values (for both custom drop down and default drop down).

[sacramentojoe]

Can you export them and re-import them?
Even though they might not show up, they are probably still in the table. (fields_meta_data)

[rjuari]

I've tried that too actually.
And it still doesn't show the custom fields.
Do you know where this table is stored?

[rjuari]

Anyone know if there is a way to repopulate the custom values of the drop down ?

[kbrill]

The selection items for those drop downs are in custom/include/language/en_us.lang.php.

In that backup he was asked for a directory and a file name, the backup is whereever he specified. It is simply a zip file of all the files. You could simply copy the custom directory from there.

[rjuari]

THANKS!!!! It's solved my problem.
I wouldn't have thought it will be stored in /include/language/en_us.lang.php.

Thanks again

[kbrill]

THANKS!!!! It's solved my problem.
I wouldn't have thought it will be stored in /include/language/en_us.lang.php.

Thanks again

No problem, glad it worked out for you. You really need to consider a real backup option if you don't already have one in place. The backup option in SugarCRM will not protect you in all cases. It's a quick and simple backup for the SugarCRM files only, you need to backup the database and the OS files as well.