articles not displayed

  • Posts: 18
  • Thank you received: 0
8 years 3 months ago #263178

-- url of the page with the problem -- : sizaspeelotheek.nl/index.php/bestellen-reserveren
-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6
-- Browser(s) name and version -- : firefox 50.0.2

In one category no articles are displayed.
There is no different setting compared to the other categories which are correct.
It's the category Tijdschriften (TS), subcategories Luistertijdschriften and Tijdschriften
There are articles in these subcategories, but not visible at the frontend.
Of course they are published.
What can cause the problem?

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
8 years 3 months ago #263184

Hello,
That's weird because the displaying of the product listings from your categories is done by the same category listing content menu and its product listing content module,

So the only thing that I can advise you to do, will actually be to check again products which are part of the "Luistertijdschriften" and "Tijdschriften" categories

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
8 years 3 months ago #263543

I wanted to delete these categories and create new ones, but they appeared to be "Standard" categories and cannot be deleted...
So I renamed and unpublished them.
Newly created categories Tijdschriften behave correctly.
I must have created the previous categories accidentally as Standard.
How can I get rid of these standards or why can't I delete them?

Please Log in or Create an account to join the conversation.

  • Posts: 83989
  • Thank you received: 13604
  • MODERATOR
8 years 3 months ago #263544

Hi,

Note their id, and go in the menu System>Mass actions. There, create a new mass action on the category data with a filter on the categor_id being equal to the id of the category to delete and an action delete the elements. When you click on the "process" button, that will delete it.
Then, click on the "rebuild" button of the categories listing to fix the structure of the categories in the database and you should be good to go.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
8 years 3 months ago #263755

Thank you Nicolas.
I followed your instruction, but after I clicked the process button I got this error message:

1064 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 ') AND file_type='category'' at line 1 SQL=SELECT * FROM #__hikashop_file WHERE file_ref_id IN () AND file_type='category'

Terug naar controlepaneel

I don 't understand this.
The category still remains.
What can I do?

Please Log in or Create an account to join the conversation.

  • Posts: 83989
  • Thank you received: 13604
  • MODERATOR
8 years 3 months ago #263767

Hi,

Change the line:

if(!is_array($pkeys)) $pkeys = array($pkeys);
to:
		if(!is_array($pkeys))
			$pkeys = array($pkeys);
		if(!count($pkeys))
			return;
		JArrayHelper::toInteger($pkeys);
in the file administrator/components/com_hikashop/classes/file.php and try again. That should fix that error and it should then work fine.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
8 years 3 months ago #263906

After I updated the file as described, the error message disappeared, but the Standard categories are still there.
I tried several options at Mass actions. 1 category has been selected there by the filter and after the Process button it seems successful.
After "rebuild" the category is still there.....
Any other suggestion?

Please Log in or Create an account to join the conversation.

  • Posts: 83989
  • Thank you received: 13604
  • MODERATOR
8 years 3 months ago #263910

Hi,

I've done a test on my end and the mass action correctly deleted the category.
But well, you can also do it directly in the table hikashop_category in your PHPMyAdmin.
Delete the categories you don't want in there and then click on the "rebuild" button and that should be ok.

The following user(s) said Thank You: Jes01

Please Log in or Create an account to join the conversation.

Time to create page: 0.051 seconds
Powered by Kunena Forum