Database failure. Please refer to sugarcrm.log for details.

[libramassimo]

Hey guys. I created a new module and then i added in "icon" i think it was called. Now when i try and save it comes up with this error:

Database failure. Please refer to sugarcrm.log for details.

What must one do? Please help.

[sts]

You should have a look into sugarcrm.log. This is a text file. You can find it in the Sugar root directory.

As an alternative you can download it via admin->"Diagnostic Tool" if you don't have access to that file. Deselect all check boxes except "SugarCRM Log File" and click on "Execute Diagnostic" then.

[libramassimo]

this is what it says ? Not sure what to do to try and resolve the problem ?

[sts]

At what date+time did you have the problem? I need this information as exact as possible to see which error messages are coming from that problem.

[libramassimo]

date 2011/09/12 and time i would have to say close to around 11:20am. my time . (currently 11.52 now)

[sts]

One message that I see multiple times in the files is this one:

09/12/11 12:18:40 [5932][1][FATAL] MySQL error 1054: Unknown column 'object_image' in 'order clause'

Do you know that field "object_image"? Sugar tries to access a data base field with that name which does not exist.

This message I found only once. I don't know for sure but I think this is not relevant for that case:

09/12/11 12:15:24 [5932][1][FATAL] Error fetching relationship from cache products_accounts

One message that comes 1000 times, but without relevance for that actual problem:

09/12/11 12:24:53 [5932][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Europe/Helsinki. Please set date.timezone="Europe/Helsinki" in php.ini!

Here you should do the configuration in php.ini as described in the message to get rid of those messages in future.

[libramassimo]

yes, im sure this is the problem: Unknown column 'object_image' in 'order clause' cause i thought u had to insert an image for someone to open it and read it.

How do i access php.ini to change it? Thanks yet again for all your help! Without your help i dont think i would have managed to do much!! Once again THANK YOU!

[sts]

php.ini is a configuration file of your PHP installation. You should find it in the root directory of the PHP installation.

[libramassimo]

Ok thanks for that! I know this is going off the topic but i would just like to ask you. i have created a module called buying history and then under accounts sub panel and they fill out the form and save it and then it saves it there. But i cant open it what must i create in order to open up the form that was filled in so that i can read it? For example in the accounts sub panel there is calls. Fill out the form etc. and save and then to view it u click on the phone icon.

[sts]

Normally there is a field called "name" in every module (you can label it different off course). If this field is shown in ListView it is shown as a link which opens the DetailView. So I think you should check your ListView settings.
(If this is not sufficient I'd suggest to open a new thread for this problem and discuss it there.)