cotonti.com : Reviews plugin conflicts with autoalias2

Trustmaster

Sa, 29 Jan 2011 22:24:17 -0000

Please let me know if this fix worked. If it did, then I'll include it in next plugin release.

Dayver

Fr, 28 Jan 2011 14:23:00 -0000

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");

foxhound

Fr, 28 Jan 2011 07:08:41 -0000

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.