Print

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

[opms.org]

Hi everyone,

 I have installed the jdiction 0.9 on my joomla 2.5.9 and everything works perfect.Thanks for the amazing job!

Now i want to translate certain 3rd party component. It says that "The integration into 3rd party components is simple, it only needs a XML File with some metadata, this file could be created easily." but i don't know exactly what or where (or how ) to do it and I cannot found any documentation for that.
Can someone please give me some pointers?

To be specific my problem is on the registration, login and profile pages of community builder. When I try to access them with "greek" language it shows up an error message

ERROR 5
cannot calculate position of ordering within BY `ordering`.

Thanks.

[Harald Leithner]

the sql parser has a problem with the sql query... atm I can't really help you with this.

If you know how to get the sql query I can look at it.

[opms.org]

I have attached the mysql.log where i have kept only the query's that happens when the problem occurs.
Unfortunately I have no idea witch of those is the false one since it doesn't logs the answers.
But i believe its after line 33 where "lang_id" appears.

Can you look into the matter?

Again thanks a LOT for your help.

[Harald Leithner]

this log comes from the mysql query log file correct?

the query will never be executed so you need to modify the jdiction core and print the queries manualy, I haven't a good debug method for this atm.

[nkt]

Hi all,

I have the same problem and I found the SQL query:

Code: [Select]

SELECT DISTINCT ue.*, u.*, '' AS 'NA' FROM #__users u JOIN #__user_usergroup_map g ON g.`user_id` = u.`id` JOIN #__comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND ue.banned = 0 AND g.group_id IN ( 6, 2, 3, 4, 5) ORDER BY `name` ASC
The code is executed at line 346 of cb.lists.php in SITE_URL/administrator/components/com_comprofiler/library/cb.

I'll try to fix the problem, but if you know how to solve it immediately please let me know!

Official error: UnableToCalculatePositionException: cannot calculate position of name within BY `name` ASC

Further more if I remove

Code: [Select]

ORDER BY `name` ASC the problem is solved

[Harald Leithner]

remove the quote for

Code: [Select]

name

[nkt]

Thank you Harald! I just figured that out, because I traced the problem till deep in the parser.

Explanation for others: you're not allowed to have ` around non-operators. Want to know more, check line 121 and 122 of position-calculator.php in SITE_ROOT/libraries/jdiction/database/parser/classes

I let you know where to edit in Community Builder

[nkt]

Found it, you need to comment in Community builder admin.comprofiler.html.php located in SITE_ROOT/administrator/components/com_comprofiler
Start: line 868

Code: [Select]

//if ( substr( $sortfield->name, -1, 1 ) != ')' ) {
// $sortfieldName = '`' . $sortfield->name . '`';
//} else {
$sortfieldName = $sortfield->name;
//}Start: line 828

Code: [Select]

//if ( substr( $sortpart['field'], -1, 1 ) != ')' ) {
// $sortfiNam = '`' . $sortpart['field'] . '`';
//} else {
$sortfiNam = $sortpart['field'];
//}

[Harald Leithner]

Would you please test version 1.1.9.2, I replaced the sql parser with a new version.

I think that would solve the problem.

[nkt]

Hi Harald,

It get the following message: 

Code: [Select]

Fatal error: Class 'MySqlParser' not found in SITE_ROOT\libraries\jdiction\database\database\mysqli.php on line 122

[Harald Leithner]

The something went wrong while you updated, because the mysqli.php should try to load \PHPSQLParser\PHPSQLParser() and not longer the MySqlParser class.