GAAAAK! What is this error?

[Phil Soth]

Thank you for the links to #244 and #245. I haven't made the code changes yet, as I am uncertain as to what needs to be changed as indicated in #245. Can you be a bit more specific, as I am far less experienced than most of you.

By the way, I did go back and read through all the threads associated with this issue. What a fascinating tale this is....I just wish I could be at your level of experience and do the analytics and test and debug and discuss all the bells and whistles like you all! I really admire you people for what you have done with Zen Cart!

Anyway, please advise on #245...what do I do?

Thanks,
Phil

[RodG]

Thank you for the links to #244 and #245. I haven't made the code changes yet, as I am uncertain as to what needs to be changed as indicated in #245. Can you be a bit more specific, as I am far less experienced than most of you.

Load the file "includes/classes/cache.php" into a text editor (NOT MS NotePad)

Navigate to line#128, which should read:

$sql = "insert ignore into " . TABLE_DB_CACHE . " (cache_entry_name, cache_data, cache_entry_created) VALUES (:cachename, :cachedata, time() )";

Replace that line with:

$sql = "insert ignore into " . TABLE_DB_CACHE . " (cache_entry_name, cache_data, cache_entry_created) VALUES (:cachename, :cachedata, unix_timestamp() )";

Save the changes.

By the way, I did go back and read through all the threads associated with this issue. What a fascinating tale this is....

Yes, it has been a bit of along saga. That is the nature of intermittent type problems/bugs though.

I just wish I could be at your level of experience and do the analytics and test and debug and discuss all the bells and whistles like you all! I really admire you people for what you have done with Zen Cart!

None of us started with this experience. We've spent a lot of time, and made a lot of mistakes to get there, and we probably all started out by making 'small' changes by following step-by-step instructions.

Cheers
RodG