I have installed (fresh) latest Suitecrm 7.3 (from friday 16:19)
After Quick repair: Differences found between database and vardefs
After running script below: detaiviews of account & contacts not possible:
Smarty error in cache/modules/accountsORcontacts/detailview.tpl
/* Table : cases /
/COLUMNS/
/MISSING IN DATABASE - contact_created_by_id - ROW/
/ INDEXES */
ALTER TABLE cases add COLUMN contact_created_by_id char(36) NULL ;contact_created_by_id
Make a backup of the cache folder and then delete it. SuiteCRM should generate it again automatically.
I started with a fresh install. New database empty. I added 1 account & 1 contact. Before quick repair no problem. Problem starts when I run quick repair
The script below tried to add a field in the database. Why ??? It is a database that is created during installation.
After I run (exe) the script I get Smarty errors in detailviews. Maybe I can solve that by erasing de Cache map. But I want to correct the problem.
It seems that the defs that are created during installation are not in sync with the database that is created !
Anyone an idea ???
SCRIPT IN QUICK REPAIR THAT I EXECUTED:
/* Table : cases /
/COLUMNS/
/MISSING IN DATABASE - contact_created_by_id - ROW/
/ INDEXES */
ALTER TABLE cases add COLUMN contact_created_by_id char(36) NULL ;contact_created_by_id & try to a
I have found a workaround
DIRECT after installation and BEFORE adding a record, run quick repair twice.
The first time: run the scriptto change the database. The second time no script is suggested.
When I now add records and run quick repair no problems arise
I have the same problem. Iām running version 7.3.1.
I had to restore from earlier backup.
I can not find any bug reported.
Have you bug report it?
see my reply: workaround
I work with 7.3.1 too
No problem if you first install a fresh installation, direct repair 2x and then install your database & config & views