Quote Originally Posted by mc12345678 View Post
To prevent the early demise of the previous edit, see below. As I said it is unlikely for an internal link to be greater than 254 characters; however, the original code went a step further and considered 128 as the maximum (see the declaration for the table and the current table length for the last url field). This is one of the downfalls of hard coding something that is dependent on something else. I'd like to implement a define that will the first time pull from the database, and thenon the next run through don't load it again as it would be defined. That would then be used to truncate the strings to the length of the table's field(s).

Towards the end of YOURSTORE/includes/functions/extra_functions/user_tracking.php

have the code look something like this:

Code:
    /* Start - User tracking v1.4.3b modification*/
    while (strpos(substr($page_desc, -1), '\\') !== false) {
        $page_desc = substr($page_desc, 0, -1);    
    }
    /* End - User tracking v1.4.3b modification*/

    $wo_last_page_url = substr($wo_last_page_url, 0, 127);
    /* Start - User tracking v1.4.3b modification*/
    while (strpos(substr($wo_last_page_url, -1), '\\') !== false) {
        $wo_last_page_url = substr($wo_last_page_url, 0, -1);    
    }

    $referer_url = substr($referer_url, 0, 253);

    while (strpos(substr($referer_url, -1), '\\') !== false) {
        $referer_url = substr($referer_url, 0, -1);    
    }
    /* End - User tracking v1.4.3b modification*/
I applied the above and will report back if I experienced any issues. Thanks!