User tracking mod

[knuckle-101]

Does anyone know if theres a way to get this mod to let you see what items have been added to a customers cart?

Recover Cart Sales will handle this for you available here http://www.zen-cart.com/index.php?ma...roducts_id=100 confirmed working in 1.3.9h

[Boggled]

Does the latest updated version in the downloads section (1.4.0) work with 1.3.9x carts or only with 1.5.0?

[knuckle-101]

Does the latest updated version in the downloads section (1.4.0) work with 1.3.9x carts or only with 1.5.0?

It is designed for V1.5.0 only.. For V1.3.9xx you will need to use the older version

[Rizla]

Well ain't that DANY!
Just installed it only to come here to find an aswere as to why the SQL failed on: table admin_pages does not exist LOL

Has this done any damage to my site??

[knuckle-101]

Well ain't that DANY!
Just installed it only to come here to find an aswere as to why the SQL failed on: table admin_pages does not exist LOL

Has this done any damage to my site??

No if you have not added the admin tables inside your SQL simply download the version for your ZenCart version upload and overwrite the files.

[Rizla]

Think I boobed even more than that Knuckle.... Sure I used the update SQL file first (early morning) Then attempted the main SQL file to be told Error.. Table exists on 999 or something (NOt at the PC with it on)

I have a DB backup from Wednesday so will only loose a couple of customer details or can I delete the tables manually?

I knew I should have waited till the weekend (

Also.. where is the version I need?

Thanks

[knuckle-101]

Think I boobed even more than that Knuckle.... Sure I used the update SQL file first (early morning) Then attempted the main SQL file to be told Error.. Table exists on 999 or something (NOt at the PC with it on)

I have a DB backup from Wednesday so will only loose a couple of customer details or can I delete the tables manually?

I knew I should have waited till the weekend (

Also.. where is the version I need?

Thanks

You do not have to run a full backup to remove the tables you inserted simply run the SQL Query below from the store admin located under the "Install SQL Patches" under tools menu

Or

You could execute it directly from your MySQL management phpMyAdmin or whatever your hosts allows you to use for MySQL management

Execute

DELETE FROM admin_pages WHERE  language_key = 'BOX_TOOLS_USER_TRACKING';
DELETE FROM admin_pages WHERE  language_key = 'BOX_TOOLS_USER_TRACKING_CONFIG';

To get the older version you have to use the Version for 1.3.7 which is located under the 1.5.0 version here http://www.zen-cart.com/index.php?ma...roducts_id=261

The older version does not use or overwrite core files and no vulnerabilities are found you should be able use this safely (Still Use At Own Risk)

Download the files and simply overwrite the 1.5.0 files, make your file changes as it states in the readme and you will be good to go.

[Rizla]

Hi Knuckle
Thanks for the reply... but it doesn't like "admin_pages"

Tried changing to "my_admin_name" but that fails too:

1146 Table 'metalpix_db1.admin_pages' doesn't exist

[knuckle-101]

Hi Knuckle
Thanks for the reply... but it doesn't like "admin_pages"

Tried changing to "my_admin_name" but that fails too:

1146 Table 'metalpix_db1.admin_pages' doesn't exist

Can you give some more specifics how you run the command inside the admin "Install SQL Patches" or the host panel? Have you looked at the tables inside your database and see if admin_pages exist?

What version of Zencart are you using?

[knuckle-101]

Just out of curiosity which SQL file did you use when you installed the mod?

new_install_user_tracking.sql or UPDATE_user_tracking.sql. After looking at a test store using 1.3.xxx and the install schema file there is no admin_pages table in the database in these versions so it seems you may have not installed the admin_pages alteration into the database at all, which in your error it says the tables does not exists.. Which would be what you want since your not using V1.5.0 which is only beta and not recommended for use anyway on a live site.

Either/Or the New Install and The Update SQL sheet inside Module folder for version 1.5.0 does not create admin_pages table for you (Only Updates) so I would be 99.8% certain the table does not exists hence there is nothing to worry about as far as the admin_pages insertion goes.