Print

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

[jasperli]

Hello,

I think a lot of jreviews users will love to get your component running on Jreviews. Although you said 3rd party components are not supported yet (after 1.0) i would like to tell you i have made a post in the Jreviews forum:
http://www.reviewsforjoomla.com/forum/index.php?topic=22609.0

I am testing Jreviews with 0.8.9.4 but that package is not working with Jreviews 2.3 yet.
When visiting a content page of Jreviews the frontend is giving the error:

"cannot calculate position of Review.created within BY `Review.created` DESC LIMIT 5"

The backend error.log says:

[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: jos_modules_menu in /var/www/clients/client2/web15/web/libraries/jdiction/database/database/mysqli.php on line 169, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: jos_modules in /var/www/clients/client2/web15/web/libraries/jdiction/database/database/mysqli.php on line 169, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: #__modules_menu in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Trying to get property of non-object in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: #__modules_menu in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Trying to get property of non-object in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: #__extensions in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Trying to get property of non-object in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: jos_template_styles in /var/www/clients/client2/web15/web/libraries/jdiction/database/database/mysqli.php on line 169, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: #__template_styles in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Trying to get property of non-object in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: #__template_styles in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Trying to get property of non-object in /var/www/clients/client2/web15/web/libraries/jdiction/jdiction.php on line 347, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/
[Wed Feb 13 15:17:41 2013] [error] [client 77.250.77.243] PHP Notice:  Undefined index: jos_associations in /var/www/clients/client2/web15/web/libraries/jdiction/database/database/mysqli.php on line 169, referer: http://test.skileraar.info/de/jobs/vacatures/nederland_c154/

Just to let you know!

Jasper

[Harald Leithner]

The problem is the mysql parser that tries to decompile the sql statement if it is not a JDatabaseQuery Object.

If the query is not well formated it fails sometimes... this could be fixed at 2 positions in the mysql parser of jdiction or by rewriting Jreviews sql query.