Notes Detail View Missing from Webpage

[linuxboxsolutions]

Hi everyone,

I'm having a problem where my Notes Detail View is not showing up when I click on a note to view it. The detail view is configured correctly. I don't know when they stopped showing up. But if I access sugarcrm6 from a mobile app on my android the notes show up fine. Also what I have noticed is when trying to view the notes everything below the header menus are missing. Even the footer copywright is gone and it's only on this one page. I tried to run a repair on the database hoping it would help but I get sugar telling me to execute:


/* Table : cases */
/*COLUMNS*/
/*MISSING IN DATABASE - - ROW*/
/* INDEXES */
ALTER TABLE cases add column f f DEFAULT 'f' NULL auto_increment,add column NULL ,add column NULL ;
/* Table : bugs */
/*COLUMNS*/
/*MISSING IN DATABASE - - ROW*/
/* INDEXES */
ALTER TABLE bugs add column f f DEFAULT 'f' NULL auto_increment,add column NULL ,add column NULL ;
/* Table : notes */
/*COLUMNS*/
/*MISSING IN DATABASE - - ROW*/
/* INDEXES */
ALTER TABLE notes add column f f DEFAULT 'f' NULL auto_increment,add column NULL ,add column NULL ;


But when trying to execute it gives errors saying the mysql syntax is wrong. I don't know what happened here.

[eitrix]

you must have deleted some fields but the definition of those fields in the files are left. My suggestion is, check custom/Extension/modules/Notes/Ext/Vardefs and delete all the fiels that mention fields that don't exist anymore.

Do the same for Cases and Bugs, since i see you have a problem there too.

After that do quick repair and rebuild and it should continue to work.