User tracking mod

[PeterBKK]

Sorry it was recorded but as the person had been active for 5 hours, i missed it as the record was out of page.....

[DrByte]

There were no code changes related to "who" gets tracked.

[bettysue]

One of the sites I have the v1.27d compatible version in is suddenly after working without error since installation is getting this error message:

1016 Can't open file: 'user_tracking.MYI' (errno: 145)

I can't find such a file.

Any ideas as to how to fix this?

thank You,

betty

[Brent]

....J
- added forum-suggested index keys to UT table definition for new installs and upgrades


Still compatible with v1.3.x and v1.2.x

DrByte,

sql_update_to_20060805.sql creates duplicate index keys for time_entry.

Brent

PS. I should have added the index keys months ago as they have made a fantastic difference. Thanks for the update.

[DrByte]

1016 Can't open file: 'user_tracking.MYI' (errno: 145)

This is database-corruption.
Run a database-repair either on that table or the entire database using your cPanel or phpMyAdmin.

[DrByte]

sql_update_to_20060805.sql creates duplicate index keys for time_entry.

Oops ... thanks for the update. The zip is fixed for the sake of future downloads.

[inksale]

Installed on 1.3.0.2 and it works well.
I do have one little "QuerK".
I choose user tracking from the tools and can view the users however, when I click on View session I and brought to the admin login screen and need to log in again. Once I have logged in for the 2nd time I can navigate the sessions just fine.

Any idea what is causing this?
Its happening on 3 different computers 2 PCs in different locations IE and FF as well as on my Mac.

[heavenlynights]

I do have one little "QuerK".
I choose user tracking from the tools and can view the users however, when I click on View session I and brought to the admin login screen and need to log in again. Once I have logged in for the 2nd time I can navigate the sessions just fine.

Any idea what is causing this?
Its happening on 3 different computers 2 PCs in different locations IE and FF as well as on my Mac.

I have had this same problem right from the start except that for some reason it does not do this on my laptop and I am not sure as to why. I have had this issue for a long time, but didn't worry too much about it. I decided to post to let users know that this issue isn't isolated to a single person!!

[PeterBKK]

I got something strange today.. And i have NOT done anything with the DB last 24 hour. No updates, have not even looked at it.... The user tracking have worked perfect all the time untill 00:00 last night.... I still can see all tracking till 00:00 last night but only an error for to day.

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 '915fde48348c08a5e3d9ed11a4100' order by time_last_click desc' at line 1
in:
[SELECT customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, session_id, referer_url FROM zen_user_tracking WHERE session_id = '00d"'915fde48348c08a5e3d9ed11a4100' order by time_last_click desc]
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.

[PeterBKK]

Installed on 1.3.0.2 and it works well.
I do have one little "QuerK".
I choose user tracking from the tools and can view the users however, when I click on View session I and brought to the admin login screen and need to log in again. Once I have logged in for the 2nd time I can navigate the sessions just fine.

Any idea what is causing this?
Its happening on 3 different computers 2 PCs in different locations IE and FF as well as on my Mac.

I did never had this problem