Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SEBLOD counts are wrong #787

Open
kimbare opened this issue Nov 28, 2023 · 14 comments
Open

SEBLOD counts are wrong #787

kimbare opened this issue Nov 28, 2023 · 14 comments
Assignees
@sebastienheraud

Comments

@kimbare
Copy link

kimbare commented Nov 28, 2023

Whatever is counting the number of results from a search in SEBLOD is giving the wrong answer. For example, when one enters a search, it says there are 5 items that match that search. Yet, the list only shows 3 items. It another case, it says there are 8 items that match the search criteria, yet only 7 items are displayed. It says there is a total of 1076 total number of items in our system (for which we have SEBLOD forms and it is being saved as it's own item), yet in the database (cck_store_form_nnnnn), yet there are 980 records. So how can there be 1076 total of that item?

This is just one of many issues with SEBLOD since moving to Joomla 4 and Seblod 4.XXX
@kimbare
Copy link
Author

kimbare commented Jan 17, 2024

This problem STILL EXISTS! Here is a screen shot showing SEBLOD says there are 1168 Index Entries
2024-01-17 number of Index Entries according to count in front end management
Yet, when one looks in the database, there are only 1082 Index Entry records. See the following screen shot:
2024-01-17 number of Index Entries in database
So where are the other 86 records?
Here is another example of the counts being wrong
Here is a screenshot showing SEBLOD stating there are 2 results when clearly there is only 1
2024-01-17 number says 2 but only 1 displays
We should not have to pay for help from SEBLOD to get the product to work as advertised. When will this be fixed?

@sebastienheraud
Copy link
Member

Hello,

Is there any join table on the query? A join table would indeed change the count... and a GROUP BY (manually applied) is required in that case (using the Search Query plug-in).
This may be the issue you're facing... and it was already the case in Joomla! 3 / SEBLOD 3.
Joining on users? (with multiple relations found)? In that case you cannot compare the query with the one found on PhpMyAdmin.

Without join table the count is expected to be right.
Feel free to confirm, but if this is the case it's a specific one.
Then yes we may see if there is a way to improve it, but adding it by default may not be the best.

Saba

@Giuse69
Copy link
Contributor

Giuse69 commented Jan 17, 2024

@kimbare pls have a look at this #644: I noticed an issue in Seblod COUNT when using group by and also proposed a possible solution (I am using it) but in 18 months no feedback on this by Octopoos

@kimbare
Copy link
Author

kimbare commented Jan 17, 2024 via email

@kimbare
Copy link
Author

kimbare commented Jan 17, 2024

There is no join table. I have a list and search type, and in the configuration I said show Items Number: Show.

The numbers for the item we call Index Entries is wrong everywhere. The total number is wrong and many, many queries show the wrong number. For example, we search for one that says school. It says there are 12 results but only 10 display in the list. (there is no limit on the number to display). Another query says the results are 5 but show only 4. Another says the results are 44 and only 40 display. The counts are wrong EVERYWHERE for this object. And the database shows 86 less that the total that shows in the list.

@kimbare
Copy link
Author

kimbare commented Jan 17, 2024

@kimbare pls have a look at this #644: I noticed an issue in Seblod COUNT when using group by and also proposed a possible solution (I am using it) but in 18 months no feedback on this by Octopoos

Thanks for responding - at least someone finally did! But I haven't used a group by. This is just a regular count as to how many items there are and it's off by up to 86.

@kimbare
Copy link
Author

kimbare commented Jan 18, 2024

There is no join table. There are a number of items called Index Entries. It has the wrong number of them listed. The total number does not match the number in the database. And many queries bring up the wrong count. The counts are wrong EVERYWHERE

There is no join table. There are a number of items called Index Entries. It has the wrong number of them listed. The total number does not match the number in the database. And many queries bring up the wrong count. The counts are wrong EVERYWHERE

Hello,

Is there any join table on the query? A join table would indeed change the count... and a GROUP BY (manually applied) is required in that case (using the Search Query plug-in). This may be the issue you're facing... and it was already the case in Joomla! 3 / SEBLOD 3. Joining on users? (with multiple relations found)? In that case you cannot compare the query with the one found on PhpMyAdmin.

Without join table the count is expected to be right. Feel free to confirm, but if this is the case it's a specific one. Then yes we may see if there is a way to improve it, but adding it by default may not be the best.

Saba

There is no join table. I have an item called Index Entry. I have a list and search type set up to display the Index Entries.
In the configuration for the list and search I set the "Show Items Number" to "Show". The total number does not match the number in the database. And many queries bring up the wrong count. Examples are the results say 5 but only 4 display, the results say 2 and only 1 displays, the results say 44 and only 40 display. The counts are wrong EVERYWHERE for the Index Entries. As shown above, the total number of them for all statuses (unpublished, published, archived, trashed) says 1168. Yet there are only 1082 entries in the database. The counts are wrong EVERYWHERE!!!!! and this is a simple count supplied by SEBLOD for all list and search types.

@sebastienheraud
Copy link
Member

Hi @kimbare,

We will let you know our findings by tomorrow, but we may send you an email to get some additional details or access.

Thanks,
Sebastien

@kimbare
Copy link
Author

kimbare commented Jan 22, 2024 via email

@sebastienheraud
Copy link
Member

I purchased an hour of consulting and we have a few issues. We don't feel like the count issue should count for that one hour because that should work out of the box

Hi @kimbare,

About the count, feel free to share the SQL query (from the debug).

And about the support hour, if you have any other issue in mind (your top priority), please let us know.

Sebastien

@kimbare
Copy link
Author

kimbare commented Jan 26, 2024 •
edited
Loading

When you say feel free to share the SQL query (from the debug) what do you mean?

When I go to the page the lists all of the Index Entries, it says there are 1176 of them.
2024-01-26 number of Index Entries according to count in front end management

Yet, in the database, there are only 1090 Index Entries.
2024-01-26 number of Index Entries in database

If I turn on debug system, and I go to the management page that lists all of them, it looks exactly the same as before (see photo 1 that was taken with debug on), so I don't know what to share.

If I turn on "inspect" it looks like this:
2024-01-26 Inspect on INCORRECT total for Index Entries

Is this what you wanted me to share?

In addition to all of the above, when I export all of the instances of the Index Entries, it says there are 1191 Index Entries, EXCEPT that there are MANY DUPLICATES in that list! Here is an example showing the MANY duplicates in the export
2024-01-26 spreadsheet duplicates - what a mess

When I remove all the duplicates, there are 1095 records. NONE OF THE COUNTS MATCH!!!!!

When will this mess be fixed? My client doesn't trust the website anymore .....

@kimbare
Copy link
Author

kimbare commented Jan 26, 2024 •
edited
Loading

I discovered that there is yet another place to say debug SEBLOD (I had previously said debug in the joomla settings, not the SEBLOD settings). Here is a screenshot of the page with the SEBLOD debug on
2024-01-26 Index Entries count query - debug on

I want to once again emphasize - this is OUT OF THE BOX!!!! It should work, but it does not. There are only 1090 database records for Index Entries, and once I remove the duplicates in the export (and there were a LOT of duplicates) there are 1095 exported items. NONE of the counts match or are correct!!!!

@sebastienlapoux
Copy link
Member

Thanks Kim. Please copy and paste here the query.

@sebastienheraud
Copy link
Member

sebastienheraud commented Feb 6, 2024 •
edited
Loading

Hi @kimbare,

And if you search for cck = kb_index_entry within #__cck_core, do you have 1176 entries?

Thanks,
Sebastien

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sebastienheraud sebastienheraud

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@sebastienheraud @sebastienlapoux @Giuse69 @kimbare