Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Xaman]

Done and sent.

[Harald Leithner]

good the needed query is not in it ;-)

please add after line 386 ("translate = fale;") the following line:

Code: [Select]

if ($_REQUEST['debug'] == '2') JLog::add('Query: ' . str_replace("\n", '\n', $this->sql), JLog::DEBUG, 'jdiction');


[Xaman]

Ok, done and sent the new logs file.

[Harald Leithner]

please send me a superuser account.

and do you have the latest jdiction version installed?

because it seams that it translates "UPDATE" and "SHOW" queries but that shouldn't be done.

[Harald Leithner]

And I did't a misstake.

could you change the code to:
line 429 or so to:

Code: [Select]

} else {
if ($_REQUEST['debug'] == '2') JLog::add('Query not translated: ' . str_replace("\n", '\n', $this->sql), JLog::DEBUG, 'jdiction');
//JLog::add('Backtrace: ' . @json_encode(debug_backtrace()), JLog::DEBUG, 'jdiction');
}
because atm all queries are translated in the log and thats not true ;-)

[Harald Leithner]

Oh I think I found it

could you search for the string

Code: [Select]

# Removed directory from order by because it makes the query SLOW

Code: [Select]

# Instead we run a much faster query below to re-order the output array
and remove both lines, it seams that they are both in the same query and the parse could not handle comments.

[Xaman]

Oh I think I found it

could you search for the string

Code: [Select]

# Removed directory from order by because it makes the query SLOW

Code: [Select]

# Instead we run a much faster query below to re-order the output array
and remove both lines, it seams that they are both in the same query and the parse could not handle comments.

Remove from where exactly?

[Harald Leithner]

Search for the Text in the joomla Installation. It must bin in component.

[Xaman]

I don't know how to do that, I can only search for files names.

[Harald Leithner]

Do you have a local copy of your site?

if so you can do it locally.

Anyway the should be in /components/com_jReviews/ and then maybe in models directory.

alternative install the attached version.
delete the logfile.
open the url with ?jDictionDebug=2
and send me the logfile.

then I should be able to find the file faster.

btw. the new version fixes a utf8 url translation problem.

[Xaman]

Ok, sent you the new logs file.

[Harald Leithner]

You have a good chance to find this in
/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php near line 613 or 679

[Xaman]

Finally, it worked! Thanks, seems they changed the location of these files, but now I know where is it.

Thanks again for all your help.

[Harald Leithner]

I will try to fix this problem in jdiction too but maybe not today ;-)