1. Guillermo Vargas
  2. Bug Report
  3. Friday, 15 August 2008
  4.  Subscribe via email
When the notification emails about new comments are sent, the urls are not SEF generated.

I have fixed this modifying the file josc_com_content.class.php, in the function setRowDatas after the line:


if (defined('_JOSC_J15')) {


add the following


if (!$row) {
$query = 'SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = "content" LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.id = '. JRequest::getInt('content_id');
$db = JFactory::getDBO();
$db->setQuery($query);
$row = $db->loadObject();
}


That is working for me, I'm not sure if it's the right one, but it could help to someone!
Responses (3)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Complete Uninstall to Work in J4??
We have recently updated a site from Joomlav3 to v4 (4.4.2). Now when we go to m...
7 Replies
Posted on Tuesday, 30 April 2024
Info about CMigrator for Joomla
Hi i need to import a few thousand articles from a site made in wordprres to a ...
0 Replies
Posted on Tuesday, 07 May 2024
  • New
    • #CMigator
    Error on android phone
    Why its working good on Computer and if i try it with smartphones the map dosent...
    0 Replies
    Posted on Tuesday, 07 May 2024
  • New
  • Bug with front-end submission and table not having
    Hi, i think i found a problem. When trying to edit a hotspot from front-end ...
    3 Replies
    Posted on Wednesday, 15 March 2023
    Question regarding custom fields
    How do I access custom fields after I have created them?...
    1 Replies
    Posted on Wednesday, 24 April 2024
    • #custom fields