Losing products on pages

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12758

Awesome thanks!

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12780

I went in your back end and I edited your asian fish menu: aquatic-exotics.net/administrator/index....=menus&task=edit&cid []=74
There, I turned off the random option which was still on and then I went in the menu Tools->clean cache in order to remove the cache from joomla. Then, I have the pagination displayed on aquatic-exotics.net/index.php?option=com...ut=listing&Itemid=74

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12861

Ok? I triplechecked the Menu's but ok, thank you.

I am still having problems with the product count.

Attachments:

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12862

In the image. The only one showing is the circled in the front or back end. I spokewithmy host provider and they have looked into the DB and all of the strings are correct. I have emptied and dropped tables, but no luck. I can't flush the tables because I don't have reload privleges on this server>?
I could really use some additional help or advice on where to look to findout how to correct the issue.

THANKS!

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12868

Could you try to just create a new CSV with some of the entries missing and just import it via the interface ? Does it work ?
Could you also send us that small CSV so that we can have a look at it ?

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12876

Here is the file I amimporting it right now

File Attachment:

File Name: butterflycsv.csv
File Size:1 KB

Attachments:

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12877

Now I am seeing Zero(0) on the front end

Last edit: 13 years 7 months ago by JWeb5.

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12879

the import said it was succesful but nothin is showing in the front or back end.

They are showing in Hika_Products but not in Product_category I guess in the MySQL????


I have a 1 gig size limit in MySQL but I amway under that I thought?

Thank you.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12890

You should really update hikashop.
There was a bug in the import prior to 1.4.7 which could result in the removing of products or otherwise unexpected results.

Could you make sure that the category with the id 20 exists ?
If the products are in the table hikashop_product but not in hikashop_product_category it means that there is a problem with the categories in the CSV.

I would first ask you to update. Is there a reason why you don't want to update ?

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12968

I thought I had updated,lol. Maybe i downloaded it and forgot to install it? Who knows?

It's current now. Attached is a "SS" that shows the existence of the category.

I am going to try to reupload the shortened CSV and see what appears, and then try the full CSV to double check results.

Attachments:

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12969

Everything loaded and was displayed with pagination as I uploaded the shortened CSV file. Iuploaded the full CSV again after that and lost a tonof products again and some pagination.
I guess I am going to try to make CSV file for each individual category and see if I lose products doing it that way. 1200 products may be taxing my data base????



The small Category specific CSV is uploading and displaying fine. Imay have an issue with excess data in the large "master" CSV?

Last edit: 13 years 7 months ago by JWeb5.

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

  • Posts: 79
  • Thank you received: 0
13 years 7 months ago #12982

OK so.......

I have multiple menus eg. (2) menu #1 and (2) Menu #2, duplicates. As random items was turned on to try to write a string that would fill all pages woth random products, ie. a page with 14 having 6 random items, when they were turned off, it was the wrong ones. Hika is perfect, I'm just dumb, lol. So, everything is fine I guess, images are still a bit off and not displaying, but that is due to some deletion on my part.

I wish I weren't dumb sometimes,haha.

Attachments:
Last edit: 13 years 7 months ago by JWeb5. Reason: adding image.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12990

Great !

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

Time to create page: 0.078 seconds
Powered by Kunena Forum