Reviews plugin conflicts with autoalias2

foxhound	#1 2011-01-28 07:08
Donator Thanked: 5 times	Just so you know when you enable the reviews plugin on a website already running the autoalias2 plugin you will get an sql error trying to acces a page using the new url (with the alias): Armaholic 2011-01-27 23:06 Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY rw_id DESC LIMIT Also trying to acces the comments will result in an sql error. Enabling debug tells you its the review plugin. Tested on both an existing and filled 0.6.13 DB as well as a clean 0.6.13 DB. Disable the review plugin and the alias link will work again. <img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />

foxhound

#1 2011-01-28 07:08

Just so you know when you enable the reviews plugin on a website already running the autoalias2 plugin you will get an sql error trying to acces a page using the new url (with the alias):

Armaholic
2011-01-27 23:06
Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY rw_id DESC LIMIT

Also trying to acces the comments will result in an sql error.

Enabling debug tells you its the review plugin. Tested on both an existing and filled 0.6.13 DB as well as a clean 0.6.13 DB.
Disable the review plugin and the alias link will work again.

Dayver	#2 2011-01-28 14:23
Team Thanked: 178 times	If you tell about Reviews 1.1.0 then change in reviews.page.php 71 line WHERE rw_page = $id ORDER BY rw_id {$cfg['plugin']['reviews']['order']} LIMIT $d_rv,$perpage"); on WHERE rw_page = ".$pag['page_id']." ORDER BY rw_id {$cfg['plugin']['reviews']['order']} LIMIT $d_rv,$perpage"); Pavlo Tkachenko aka Dayver

Dayver

#2 2011-01-28 14:23

Team
Thanked: 178 times

If you tell about Reviews 1.1.0 then change in reviews.page.php 71 line

WHERE rw_page = $id ORDER BY rw_id {$cfg['plugin']['reviews']['order']} LIMIT $d_rv,$perpage");

WHERE rw_page = ".$pag['page_id']." ORDER BY rw_id {$cfg['plugin']['reviews']['order']} LIMIT $d_rv,$perpage");

Pavlo Tkachenko aka Dayver

Trustmaster	#3 2011-01-29 22:24
Administrators Thanked: 263 times	Please let me know if this fix worked. If it did, then I'll include it in next plugin release. May the Source be with you!