Losing products on pages

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #6765

I am losing products. The page is only displaying 3 out of 11 products.
I just dropped the tables and reinstalled them but it is still not bringing them up.


Any help would be awesome! Is there a way to split up the items in the tables ie hika_prods1 and hika_prods2 etc to lighten the load on them or is the source of the error something else? PHPMy admin tweeks? SQL mods???? I have no clue where to even start at this point.
Thank you,

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #6778

If products are disappearing it must be because of the way you change them.
For example, if you put the products in another category, and remove them from their previous category, they won't appear in their previous category. Do you see your products on your back end products listing if you go in their categories ?
If you import your products via CSV, please make sure that you have a category specified in the categories column for your products. Otherwise, the product's link to its current categories will be removed.
Also, if you limit the number of items to 3 in your products listing module and that the random option is selected, only 3 products will be displayed and there won't be any pagination.

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

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

My apologies for the delayed response but i got sidetracked on aother project,and we were continuing to drop and reinstall tables almost daily.
I havechecked everythingeccept thelastnote regarding the limiting of 3 items in thelisting module. I'm not sure exactlywhat that is, and /or where tofind it. can you specify alittle more please?

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

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

Also is there any normal reason I should lose "no Image" graphicson certain items? example:http://aquatic-exotics.net/index.php?option=com_hikashop&view=product&layout=listing&Itemid=74
MYSQL issue? any advice on repairing it. I have optimized the tables and dropped/reinstalled,but to no avail.
Thank you!
(some of the pictures aren't even the right ones!)

Last edit: 13 years 7 months ago by JWeb5. Reason: added (.....)

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

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

First, I recommend you to update HikaShop. We fixed and improved a lot of fixes since 1.4.4 and now the thumbnails are generated on the fly if missing so you shouldn't get that image problem.

You need to go in the menu Display->Content menus/modules. There edit your menus and modules and make sure that the random option is turned off so that you get the pagination and check the option "number of items" as well.

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

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

i dont see"number of items"as an option in the hika menu.

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

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

Could you do a screenshot of what you see ?

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

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

i found it. random items is turned off, the pagination is stillnot displaying and the page itself is in the same state. it is set to allow 10 products and the category contains 12. so i am missing 2 products, a few images that are the default no image and some of the images are displaying on the wrong product?

I submitted a ticket to my host provider to have them run test on the db, but via phpmyadmin it looks fine to me.

cleaned and purged all cache and browser also, no change.

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

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

Could you do a screenshot of the options of your menus/modules ?

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

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

back end

Attachments:

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

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

front end

Attachments:

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

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

all ofthe module/menu options are the same in every item/option.

Attachments:

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

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

these are all of the menu items i have....problem?

Attachments:

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

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

i deletedall of the images in the media/com/thumb file and that repaired the loss of images/dropping of images. but now everything that was added as an imageviaabsolute path is gone, and how would i go about creating new thumbs for everything? disallow and reallow thumbs via config?

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

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

As I said previously, you should update hikashop. The thumbnails will be recreated on the fly in newer versions.

In your first screenshot, your settings are fine and you should indeed see the pagination... Not sure on what's going on.

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

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

i did,but i deleted the conficting images files after the fact. it may be that there is no pagination on that page because 2 of the items are not displaying. They show in the back end but not on the front. It's really baffleing

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

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

What if you increase the "number of items" option to something like 50 ?

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

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

NO luck. still no pagination and still only 10 of 12 in the front end.
here is a screen shot of the back end showing12 in that category.

Attachments:

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

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

Could you give us a back end access to your website so that we can check all that up ?

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

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

Thanks. We'll look at that later today.

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

Time to create page: 0.100 seconds
Powered by Kunena Forum