jDiction Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

jDiction 2.2.0 released. http://jdiction.org/downloads

Author Topic: Jreviews and jDiction  (Read 18811 times)

jasperli

  • Newbie
  • *
  • Posts: 2
    • View Profile
Jreviews and jDiction
« on: February 13, 2013, 03:35:54 pm »

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:
Quote
"cannot calculate position of Review.created within BY `Review.created` DESC LIMIT 5"
The backend error.log says:
Quote
[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

Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: Jreviews and jDiction
« Reply #1 on: February 13, 2013, 03:48:50 pm »

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.
Logged
Joomla! 5.0 Release Manager
Vote at JED