SMF Support > phpBB

'ORDER BY null' at line 203

<< < (4/4)

emanuele:

--- Quote from: rollntider on August 21, 2012, 05:41:17 PM ---MySQL returned an empty result set (i.e. zero rows). (Query took 0.0009 sec)

hope i did it right

--- End quote ---
And before that one?
I would expect an error message with a query.

Chelien Orlenard:
The same trouble.

phpBB version 3.0.10
SMF version 2.0.4
Using the latest converter.

Do you still have not solved this problem?

Chelien Orlenard:
I solved the problem myself.
I modified the following parts of the source.

Sources/Sub-Db-mysql.php

find:

--- Code: ---$db_string = substr($db_string, 0, $pos) . "\t\t\tORDER BY null\n" . substr($db_string, $pos, strlen($db_string));

--- End code ---
replace with:

--- Code: ---$db_string = substr($db_string, 0, $pos) . "\n" . substr($db_string, $pos, strlen($db_string));
--- End code ---

find:

--- Code: ---$db_string .= "\n\t\t\tORDER BY null";
--- End code ---
replace with:

--- Code: ---$db_string .= "";
--- End code ---

This fix is only temporary, I undo the conversion is finished.
Thank you.

Navigation

[0] Message Index

[*] Previous page