Vardefs difference - getting white screens in various admin pages

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Doing a Quick Repair and the VarDefs are different from the database (it provides a 356 line script).
It provides a script that when run thru SuiteCRM fails with:
Database failure. Please refer to XXXXXX.log for details. (I removed my domain name but also can’t find a file named this). Where do I find this file? It’s not the standard logs.
The SQL file it produces is an html file. How the heck do I run that against the database? I ran the script that it produces in phpmyadmin directly (copy and pasted the screen which is not html but sql script) and it errored out.
Running 7.11.20

image
image1285×318 13 KB

#2

BTW, this was an install that was installed fresh on a new host but had the db and file structure copied from another host.

#3

Two parts:

1-About the log: SuiteCRM log is normally place in your web root folder. The name of the file is specified in Admin->System Settings->Logger Settings.
There, you will probably find the same error as shown in phpmyadmin.

2-About the QuickRepair. It does synchronized DB with files. If it finds any difference, it builds that box with necessary SQL queries. Normally, just executing them from there should work.

3- About the Query itself. Apparently there isn’t an error in the syntax of the query itself. Can you check if you Database has the table “users_feeds” and the column “rank”? If something is missing, there might be something wrong during the installation of the CRM or the migration of files.

#4

The table is here but the length of ‘rank’ is empty. I have tried to manually change to (11) and by a table import. But when I hit Go it returns the same even though the alter command clearly shows the 11 length and does not error out.

#5

You mentioned

BTW, this was an install that was installed fresh on a new host but had the db and file structure copied from another host.

What version are you using on the original version you copied the DB from?

#6

I had upgraded both to 7.11.21.

#7

i ended up reinstalling the new host and upgraded. and the vardefs script ran successfully. I mustve missed a step on the upgrade between systems. thank you for your time.