I've just upgraded my 4.0.12 to 4.0.17 and applied the Mysql 5 patch. Several files had to be manually patched during the upgrade because of custom site modifications.

I have this on a test box and have discovered one problem, the anonymous check out button is no longer working as is the modify profile for login accounts. Other buttons appear to work but have only finished the upgrade this evening, so it isn't heavily tested yet.

I'm a newbie at this but managed to get this far. Any advice on where to look for the problems? It's not throwing out any SQL errors. It's as if the buttons are no longer connected.

hi,
could anyone please tell me if I can upgrade from 4.0.13 to 4.0.19 at once or do I have to upgrade first to 4.0.17, then to 4.0.18 and then to 4.0.19 ? I just need sql upgrade but in File Area there's only sql upgrade for 4.0.19-4.1.11

Somewhat frustrated here. Can't run the patch as it claims it's already patched (it isn't) and no one seems willing to explain manually patching the one file (or I've managed to miss it). I get that the "-" means remove and "+" means add, but there are lines that don't exist in the right place in the original file that it has neither "+" nor "-" next to.
Confusing.
The latter half of the patch has this:

if(defined("START_TIME")) is actually defined lower down in another function: "function db_query($query)", as are the two globals, not in the one given in the patch:

That explained it. I was assuming because it was showing this line "function db_select_db($sql_db)" that the lines needed to go there. The lines above and below that show the context of the section to edit exist in the query just below that for whatever reason. Added the lines to that function "function db_query($query)" and it's working now.