Problems with upgrade from 2.08 to 2.09

Started by garygocmc, November 26, 2014, 04:53:36 AM

Previous topic - Next topic

garygocmc

Everything is ok until I get to the test phase then I get:

*   1.   Execute Modification   ./index.php   Test successful
*   2.   Execute Modification   ./Sources/PackageGet.php   Test successful
*   3.   Execute Modification   ./Sources/Subs-Package.php   Test successful
*   4.   Execute Modification   ./Sources/Packages.php   Test successful
*   5.   Execute Modification   ./Sources/Load.php   Test successful
*   6.   Execute Modification   ./Sources/ManageServer.php   Test successful
*   7.   Execute Modification   ./Sources/Subs-Auth.php   Test successful
*   8.   Execute Modification   ./Sources/Subs-Db-mysql.php   Test failed
   1.   Replace   ./Sources/Subs-Db-mysql.php   Test failed
   2.   Replace   ./Sources/Subs-Db-mysql.php   Test successful
*   9.   Execute Modification   ./Sources/Display.php   Test successful
*   10.   Execute Modification   ./Sources/QueryString.php   Test successful


But the files are writeable and they exist so I'm a bit lost as to what the error might be and I certainly don't want to go ahead with it without taking advice.

I have a few mods in place:

1.   Add Domaintools to TrackIP   1.1
2.   Tapatalk SMF 2.0 Plugin   4.0.1
3.   Redirect Banned Users   2.0

And here's the version status:

SMF File   Your Version   Current Version
SMF Package   SMF 2.0.8   SMF 2.0.9
Sources   2.0.8   2.0.9
Default Templates   2.0   2.0.9
Language Files   2.0.7   2.0.8
Current Templates   2.0   2.0

Can anyone advise please?

TIA,
Gary

kat

According to this:

http://custom.simplemachines.org/upgrades/index.php?action=upgrade;file=smf_patch_1.1.20_2.0.9.zip;smf_version=2.0.8

The modifications to that file are:

Replace this:

* @version 2.0.8

with this:

* @version 2.0.9

Not too critical, really. :)

Then, replace this line:


if (strpos($db_string, 'GROUP BY') !== false && strpos($db_string, 'ORDER BY') === false && strpos($db_string, 'INSERT INTO') === false)


with this:


if (strpos($db_string, 'GROUP BY') !== false && strpos($db_string, 'ORDER BY') === false && preg_match('~^\s+SELECT~i', $db_string))


It seems that it's the second edit that's failing. Does that line exist, in your file? If so, you can do that one, manually.

Before you attempt this update, you WILL read my sig, woncha? ;) Click it for the "How".

Westwegoman

I had the same problem when I upgraded. The problem was, for some reason, my Subs-Db-mysql.php file had:
* @version 2.0.4

Got around it by changing to 2.0.8 and then installing the update.

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: