User tracking mod

[craftzombie]

When I upload the sql file, this is what I get:

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'),')' at line 1
in:
[INSERT INTO configuration VALUES (NULL, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour? (each click will be recorded)', 999, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help would be greatly appreciated!
Thank You!!!

:)
-April

Zen Cart 1.3.5

[MeltDown]

Hi - I'm new to this great module and have a couple of questions and glitches.

Under the User Shopping Cart heading in admin/tools/user tracking I was seeing "no cart recorded" and "session expired" repeatedly and nothing else. This seemed a bit off so I ran an order to see what would be indicated. My existence was acknowledged (always nice) in terms of a recorded visit and my username displayed, however under User Shopping Cart "no cart recorded" was displayed, despite having placed an order.

Also, when I click on the "View Session" hyperlink, the admin closes and I'm sent to the admin login screen. This occurs each time.


Finally, does use of this module create a noticeable drag on resources? (as I've heard the Who's Online mod does)


Thanks in advance for any assistance, AND for this terrific module.

Tim

[rebekah]

When I upload the sql file, this is what I get:

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'),')' at line 1
in:
[INSERT INTO configuration VALUES (NULL, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour? (each click will be recorded)', 999, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help would be greatly appreciated!
Thank You!!!

:)
-April

Zen Cart 1.3.5

I get this error too. I don't know what I'm doing wrong. I edited the tpl_footer.php file and uploaded all the folders/files the instructions say to, but when I go to "Install SQL patches" in Admin and browse for the user_tracking_FULL_20060805.sql file and then hit "Upload" I get this error. Hope I didn't mess something up. If it's easier/better, I know how to get to phpmyadmin but I don't know what to do there. Help?

[craftzombie]

I get this error too. I don't know what I'm doing wrong. I edited the tpl_footer.php file and uploaded all the folders/files the instructions say to, but when I go to "Install SQL patches" in Admin and browse for the user_tracking_FULL_20060805.sql file and then hit "Upload" I get this error. Hope I didn't mess something up. If it's easier/better, I know how to get to phpmyadmin but I don't know what to do there. Help?

Hi Rebekah,
Hopefully someone will let us know whats up. I was able to get the sql file for the older verson to load just fine. But it must not work correctly with the newer files that we uploaded because I can't get User Tracking to work. Everything is showing up in my admin (i think!), but it's obviously not tracking anything because I had my first sale today (woo hoo!) and it showed nothing. I'm glad you mentioned that this happened to you too because I thought it was just me!

-April
:)

[MeltDown]

I get this error too. I don't know what I'm doing wrong. I edited the tpl_footer.php file and uploaded all the folders/files the instructions say to, but when I go to "Install SQL patches" in Admin and browse for the user_tracking_FULL_20060805.sql file and then hit "Upload" I get this error. Hope I didn't mess something up. If it's easier/better, I know how to get to phpmyadmin but I don't know what to do there. Help?

While I'm still having an issue with the User-Tracking correctly viewing the activity within the user shopping cart, (always just "Session Expired" or "No Cart Recorded") all other areas are working without error codes. I thought that your SQL issue might be due to how you are entering it. I had a similar problem but was able to by-pass it. Instead of browsing for the folder and uploading it, I copied the user_tracking_FULL_20060805.sql file and pasted it into the SQL Query Executor (Admin/Tools/Install SQL Patches) where it says "Enter the query to be executed:" and hit the send button.

I hope this helps to at least get you past this error and into the next

Tim

[craftzombie]

While I'm still having an issue with the User-Tracking correctly viewing the activity within the user shopping cart, (always just "Session Expired" or "No Cart Recorded") all other areas are working without error codes. I thought that your SQL issue might be due to how you are entering it. I had a similar problem but was able to by-pass it. Instead of browsing for the folder and uploading it, I copied the user_tracking_FULL_20060805.sql file and pasted it into the SQL Query Executor (Admin/Tools/Install SQL Patches) where it says "Enter the query to be executed:" and hit the send button.

I hope this helps to at least get you past this error and into the next

Tim

Thanks Tim! It worked, telling me there were 9 statements processed. I had thought about doing that last night but I wasn't sure since I know nothing about sql stuff. Now hopefully I can get it to track users!

-April
:)

[MeltDown]

but I wasn't sure since I know nothing about sql stuff.

-April
:)

Yeah, you and me both!
Believe me, I had visions of the end of the world before pressing the "Send" button... The shopping cart collapsing, database erased etc.

Glad I was able to pass on a bit of experience-acquired knowledge instead of always just asking for help in this forum.

Tim

[Brent]

..... Now hopefully I can get it to track users!

-April
:)

Have you set "User Tracking Visitors" to "True" in Tools >> User Tracking Config?

[rebekah]

Thanks Tim! It worked, telling me there were 9 statements processed. I had thought about doing that last night but I wasn't sure since I know nothing about sql stuff. Now hopefully I can get it to track users!

-April
:)

Thank you both! This worked for me too. Congratulations on your first sale!

[MeltDown]

I'm still having an issue with the section under the heading "User Shopping Cart". which views the activity within the cart. It always reads just "Session Expired" or "No Cart Recorded" even whan there are sales.

Does anyone know off-hand which php files directly affects this part of the mod?

Thanks

Tim