My Pipeline Works, Dashboard Does Not

[danlee73]

Hello Fellow Sugar Members,

Since upgrading to Sugar 4.2.1 my dashboard simply appears to be blank. No errors, just blank. However, the My Pipeline functionality on the home page works fine. I have checked other threads and cannot seem to find an answer.

My log file since upgrading is empty.

I am running a WAMP stack with:
W2K3
Apache 2.0.54
PHP 5.0.4
MySQL 4.1.13

Any help much appreciated

[kbrill]

Switch your debugging level in your log like this

Open log4php.properties and make it look like this.

log4php.appender.A2=LoggerAppenderRollingFile
log4php.appender.A2.MaxFileSize=10MB
log4php.appender.A2.MaxBackupIndex=5
log4php.appender.A2.layout=LoggerLayoutTTCC
log4php.appender.A2.layout.ContextPrinting="true"
log4php.appender.A2.layout.DateFormat="%c"
log4php.appender.A2.File=./sugarcrm.log

//log4php.rootLogger=fatal, A2
//log4php.rootLogger=error, A2
//log4php.rootLogger=warn, A2
//log4php.rootLogger=info, A2
log4php.rootLogger=debug, A2

[danlee73]

Hey thanks for that.

I turned on the debug logging, which didn't really reveal any errors, but showed me the queries that were being executed. This is what it boils down to:

a) my version of MySQL 4.1.13 does not like the LONGTEXT field - any time I try to update it, even using PHPMyAdmin, it simply does not update (see this thread)
b) the dashboard functionality attempts to write to the DASHBOARD table, into a field that is LONGTEXT
c) if you change the two fields in DASHBOARD from LONGTEXT to MEDIUM TEXT, then delete the entries in that table, then it all works.

All fixed

And as a bonus, thanks to kbrill, I now know how to change the debug levels.

THANKS!!

[djnoah]

I wonder if my particular problem has to do with this...

I am only having a problem viewing the flash images in the pipeline / dashboard; everything else works fine. i believe this is not a browser issue because another instance of SugarCRM that i installed on a different host displays the images with no problems. I tried Kbrill's fix above with no change. Any ideers? Thanks