First time compile error missing audittrail.php

Ray Hendler · Post by **Ray Hendler** » Mon Nov 20, 2017 7:52 pm

After following all the steps in tutorial, set up DB, point of compile (to localhost/) I get the above error.
A search of the drive finds no file named Audittrail.php

sangnandar · Post by **sangnandar** » Mon Nov 20, 2017 8:55 pm

Check your audittrail setting under PHP -> General Options -> Audit Trail
It's likely you disable this setting while enable Audit Trail in Table Setup.

Ray Hendler · Post by **Ray Hendler** » Tue Nov 21, 2017 4:22 pm

Tx for the reply, I understand the logic. The two parts looked at ...
A. Tables setting. Only two tables thus far for trial, far to the right is column for Audit Trail box, both clear
B. PHP | General Settings. NO cache = ON, (default)
.....tried Track login, whether Checked or not, on save, displays could not compile "Missing Audittrail.php"
.....tried Enter a folder when empty or when I entered a folder "logs/" made no difference,
Am I missing another setting perhaps?

mobhar · Post by **mobhar** » Tue Nov 21, 2017 4:59 pm

If you are a registered user, then make sure update the template to the latest version from "Tools" -> "Update Template".

If you are not a registered user, then download the template file from this page: http://www.hkvstore.com/phpmaker/download.asp scroll down to that page and click on "Template file only", and then copy/replace the existing template file in "template" sub-folder under your PHPMaker folder target installation.

Make sure you have already remove the cache from "Tools" -> "Delete Template Cache" before regenerating ALL the script files again.

kirondedshem · Post by **kirondedshem** » Tue Nov 21, 2017 6:37 pm

I think some audit trail setting might be lingering in your project.

try downloading the demo project and see if it can compile successfully.
If it works then
try creating a new clean project and just connect to the database, DONT set any audit trail settings anywhere and compile and see if it works.
If that works, then check to see what the difference is and set your desired audit trail settings carefully

Ray Hendler · Post by **Ray Hendler** » Tue Nov 21, 2017 11:04 pm

@mobhar. Replaced the template file after clearing cache and it completed compile. THANK YOU.
@kirondedshem. The simple example I followed - used SQLYOG to set up the db. Will not start. So I will try your suggestion to find the missing link.

sangnandar · Post by **sangnandar** » Wed Nov 22, 2017 4:20 pm

Audit Trail consist of several parts:

It is an extension. You need to check Tools -> Extensions to enable and settings.
It is a "special table". PHP -> General Options -> Audit Trail. You have two options here, either use db table or log file for the audit. If you use db table you need to check that all columns needed for the audit are exist within the table.
It is a Table Settings. You have to enable it for every table you need to be audited.

Something goes wrong...check the above 3 parts one-by-one.

Ray Hendler · Post by **Ray Hendler** » Thu Nov 23, 2017 7:47 pm

I followed ALL THE ADVICE GIVEN, but then I found Mysql was reporting an error in Xampp dashboard.
Log off and on freed that up and all went as it should. Thanks all.