Friday, 21 February 2025
  3 Replies
  56 Visits
0
Votes
Undo
  Subscribe
This is an error with the stackideas toolbar. There is a fix that has been reported over at joomla.org...


Go to Site Modules and find (Stackideas Toolbar) Module. Click to open, Click the EasySocial tab, and scroll down to Display Search - Set this to NO and this will fix the 1242 error until Stackideas renders a fix.
2 weeks ago
·
#35
Accepted Answer
0
Votes
Undo
OK. worked through the issue and it seems to be a Joomla issue caused by either a Joomla bug (supposedly resolved in PR's 43151 / 42799) or as a result of a partially failed update which is then run again.

The solution is fairly straightforwards and simply requires reindexing the smart search index.

In the admin panel go to

Components > Smart Search > Index


Then select

Maintenance > Clear index


Followed by

Index


This forces the system to delete the smart search index (taxonomy table) and recreate it.

Please note: As with any fix / change. Please make sure you backup your site before performing this fix :thumb
DeeEmm set the type of the post as  Bug — 3 weeks ago
3 weeks ago
·
#33
0
Votes
Undo
Appears that this is an older issue that has now reoccurred as part of recent Joomla 4.4.11 update.

Within the post over on the Joomla.org forums linked to above it states that the issue is related to duplicate entries in the ' finder_taxonomy table'. The solution posted was to remove the duplicate entries and the error is resolved.

However looking at this table on one of my sites, there is only one entry, so this does not appear to be the issue in this case.

I will take a bit of a deeper dig into this later. However my initial thoughts are that if duplicate results are the issue, then the SQL is malformed and should implement 'LIMIT' or 'DISTINCT' clauses.
2 weeks ago
·
#35
Accepted Answer
0
Votes
Undo
OK. worked through the issue and it seems to be a Joomla issue caused by either a Joomla bug (supposedly resolved in PR's 43151 / 42799) or as a result of a partially failed update which is then run again.

The solution is fairly straightforwards and simply requires reindexing the smart search index.

In the admin panel go to

Components > Smart Search > Index


Then select

Maintenance > Clear index


Followed by

Index


This forces the system to delete the smart search index (taxonomy table) and recreate it.

Please note: As with any fix / change. Please make sure you backup your site before performing this fix :thumb
DeeEmm selected the reply #35 as the answer for this post — 2 weeks ago
2 weeks ago
·
#36
0
Votes
Undo
Some further information to help you...

You can run an SQL query directly on the table to test if you have duplicate values...


SELECT `title`, COUNT(`title`) FROM `jos_finder_taxonomy` GROUP BY `title` HAVING COUNT( `title`) >1;


You can also replace the column name with any other. I tested 'path' and 'title'. Substitute all instances before running the query. The results will be shown in a table.


To fix the issue, you can also use the Joomla CLI interface to reindex the table...

In a SSH terminal navigate to the /cli/ directory of your Joomla installation, then run the following command

php joomla.php finder:index
DeeEmm removed the type of  Bug from the post — 2 weeks ago
  • Page :
  • 1
There are no replies made for this post yet.
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below.
Supported: gif,jpg,png,jpeg,zip,rar,pdf
· Insert · Remove
  Upload Files (Maximum 2MB)