Snapshot vs. Site File Monitor Admin Add-on

[Donn]

I am interested in keeping track of files on my cart.

With that said, i checked out the add-ons, and found two that seemed to be solutions:

Site File Monitor


and

Snapshot

They seem the same, mostly. As far as the documentation showed, the biggest difference is that Site File Monitor can be run as a cron job, besides manually through the Admin. (Maybe the other can as well? It didn't say so, though.)

Anyone have any experience with these modules?

I tried installing the SnapShot module, but couldn't.

The SQL commands are in a PHP file, and wouldn't work. It seems the DB is not being accessed with my two letter prefix before the database name. Any help with that would be great, also...

Unless I should just skip to the other module....and proceed from there...

[skipwater]

Snap Shot has some of sitemonitor code so yes the both of them are similar.

I tried installing the SnapShot module, but couldn't.

The SQL commands are in a PHP file, and wouldn't work. It seems the DB is not being accessed with my two letter prefix before the database name. Any help with that would be great, also...

install-sql-snapshot-v1.php uses application_top.php so that should load zc database info. You are running it in your named-admin folder?

There is a support thread but there is not much in it.
http://www.zen-cart.com/forum/showthread.php?t=118261

Skip

[Donn]

I am interested in keeping track of files on my cart.

With that said, i checked out the add-ons, and found two that seemed to be solutions:

Site File Monitor


and

Snapshot

They seem the same, mostly. As far as the documentation showed, the biggest difference is that Site File Monitor can be run as a cron job, besides manually through the Admin. (Maybe the other can as well? It didn't say so, though.)

Anyone have any experience with these modules?

I tried installing the SnapShot module, but couldn't.

The SQL commands are in a PHP file, and wouldn't work. It seems the DB is not being accessed with my two letter prefix before the database name. Any help with that would be great, also...

Unless I should just skip to the other module....and proceed from there...

OK....I finally had the time to look at this once again.

I am learning to work with MYSQL slowly....

I see what was wrong:
My cart's database has a prefix on it.

When I went in and added 'R5_' (the prefix I used) to all the occurences of the named tables in the install-sql-snapshot-v1.php install file, such as configuration_group (to---> R5_configuration_group), I re-ran the php file by pointing my browser at it, as specified in the instructions, and it worked.

I also see now I could have extracted the SQL and executed them with ZC, or on the server database utility.

so....
IF YOUR DATABASES USE A PREFIX, YOU MUST ALTER THE PHP FILE TO USE THIS MOD AS-IS**

[gjh42]

That is a common recommendation: copy and paste the SQL in ZC admin > Tools > Install SQL Patches, and run it that way. This automatically adds the correct prefix if needed without you having to think about it.