search

exstreme / Jcomments-4

Modified Jcomments 3.0.7 with Recaptcha 2 in comments. Adapted to Joomla 4. No compatibility with Joomla 1.5\2.5\3.x
16 stars 12 forks source link

Usage of #__jcomments_objects table #141

Open Giuse69 opened 1 year ago

Giuse69 commented 1 year ago

Hi, historically JComments uses the table #__jcomments_object_table to link the commented article in the backend, but:

  1. it stores the title and URL of the commented object/article, so if the title or the alias or the base root is changed => the title and URL becomes obsolete/wrong.
  2. it stores the absolute URL of the article, not the relative to the Joomla base folder, so when moving the site => URLs becomes wrong.

Would it be possible to overcome these limitations getting rid of this table and using #assets and specific table (#content) with joins? thanks

Giuse

Globulopolis commented 10 months ago

to link the commented article in the backend Not only in backend. In frontend too.

Partially, the problem can be solved by clearing the table cache in the admin panel in the comments list. The problem with links will be fixed in the new version.

Would it be possible to overcome these limitations getting rid of this table and using #assets and specific table (#content) with joins?

No. Not all objects stored in assets table. To get data about an object, the component uses plugins for each component.

Giuse69 commented 10 months ago

thanks

Giuse69 commented 5 months ago

Hi, has the new release addressed this issue? thanks

Giuse

Globulopolis commented 5 months ago

Hi, has the new release addressed this issue? thanks

Giuse

No. "New release"... I apologize for the inaccuracy, i meant 4.1 branch(still in development).

Giuse69 commented 5 months ago

ok