[Resolved]Locale (en_US) not loaded during upgrade to 2.4.8

Software Support
,
29

Hi @asmecher,

I am very happy I have solved the DB error associated with Max_join_size which occurs when viewing the lists of manuscripts in the editor panel. Here is what I did: I added

mysql_query("SET SQL_BIG_SELECTS=1");

below line 175

	function &retrieveRange($sql, $params = false, $dbResultRange = null, $callHooks = true) {

in /lib/pkp/classes/db/DAO.inc.php. It should look like this after the modification:

function &retrieveRange($sql, $params = false, $dbResultRange = null, $callHooks = true) {
		mysql_query("SET SQL_BIG_SELECTS=1");
		if ($callHooks === true && checkPhpVersion('4.3.0')) {

I found out the problem by turning on show_stacktrace in config.inc.php.

So I have a working 2.4.8 and am still trying to upgrade it to 3.1.1 with your help.

Thanks a lot.

Paul

1 Like