Order products

-- HikaShop version -- : 5.1.1
-- Joomla version -- : 5
-- PHP version -- : 8.2
-- Error-message(debug-mod must be tuned on) -- : Products order

Hello,
I try without succes to reorder the products from administrator.
How can i do this?

Thank you

Hi,

You can use the arrows of the "order" column, or enter another number in the input field and then click on the save icon button at the top, next to the "order" title of the products listing.
Note that the order of the products is "per category", so, in order to see the arrows and the input fields, you need to access a leaf category ( a category without sub categories ) first with the category explorer on the left sidebar.

screenrec.com/share/DHqvQlZhwy

Hi,

How about if you drag & drop the rows with the anchor on the left side of the input field ?
Also, I would recommend increasing the number of elements on the page to have all the elements of that category on one page, and then make sure that the order starts at 1 and increments by 1 properly in all the order input fields before saving, that might help.

Worst case, you can run a MySQL query to reset the order to 0 for all the products via your PHPMyAdmin: Then, you can order the elements and it should work fine.

Hi,
I tried all solutions but i got this
prnt.sc/a1RUw1XqaNSy

Not working.
Previous version it was ok, this is after update.


You have the latest stable version of HikaShop Business: 5.1.1

Hi,

I don't see how running the MySQL to reset all the ordering would lead to the result on your screenshot.
Can you confirm that you run the MySQL query ?
Did you change the #__ with the table prefix of your database ?

If nothing works, we'll need a backend access, a FTP access and a database access in order to check the situation.

Hi,
I use your code and all were reset to 0 but after if i add my order is like in video sent in my last response.

Thank you

Also i can't purchase - cart is empty:
screenrec.com/share/EjVpD0godO

Do you need ftp and super user?

Hi,

Yes, you can go through our contact form to provide them:
www.hikashop.com/support/contact-us.html

I just sent,

Thank you

Also i see an error after the latest update .
you can create new user as example:
Save failed with the following error: Field 'id' doesn't have a default value

Hi,

What you said about the user creation gave me the idea that your issue might be linked to a major problem in your database.
So, after I checked I was able to somehow reproduce the issue on your products listing, I went to your orders listing. There, I clicked on the "new" button in order to create a new order. Normally, the new order should have the id "2" since there was only one order with the id "1". But the new order was created by MySQL with the id "0". This means that there is something seriously wrong with the database. The primary key and / or auto_increment must be missing in the hikashop_order table, and probably with all the tables, not only HikaShop.

I clicked on the "check database" button of the HikaShop configuration. The system found that all the auto_increment values and primary keys were missing in your HikaShop tables and fixed them:
i.imgur.com/DCsfVRP.png
After this, I'm not able to reproduce the issue with the ordering of the products. And the order creation process has been fixed too (and probably any other process of HikaShop which requires saving stuff to the database).

However, note that this only fixes the problem with the HikaShop tables. You likely have the same problem with other tables in your database, like the users table of Joomla, which would explain the error you have with the user creation.

I think this issue comes from a database migration issue. Something must have gone wrong along the way and the primary keys and auto_increments have been lost. That's a big issue. While the check database process can mitigate the problem for HikaShop, you likely want to go over the migration steps you took to avoid loose the primary keys and auto_increment of your tables in the first place.

Hi,

Thank you.

I noticed that our shop currently displays only one product. Could you let me know what changes were made or, if possible, roll back the products?

Is the ordering functionality working now?

If I provide the database or grant you database access, could you help fix the issue?

This site was built from scratch without any migration. I’m not sure why, but after installing the latest update of HikaShop, issues started occurring. I understand it’s likely not a fault with HikaShop; it might be due to another extension during the update or installation process.

Thank you for your assistance.

I saw that were in different category, i put them back.
But i notice that i dont have my menu after the change and console errors

prnt.sc/7m7nu8vk-SNV

Hi,

The changes I made for HikaShop are easy. I only pressed the "check database" button. And what it did is to try and repair what was lost in HikaShop as best as it could. That's why the products were moved because it couldn't restore them in the correct category.
While HikaShop's processes should all be working fine now thanks to the database check, processes linked to Joomla will still not work. So, for example, if you require registration or login during the checkout of HikaShop, people won't be able to register a new account if the Joomla users table is missing its primary key and / or auto_increment.

I dont see how updating an extension would remove the primary keys and auto_increment of all the tables. This issue is typical of a database export / import where the auto_increment flag is missing from the export.
It's likely that you saw the issue after the update as it made the problem apparent, but you already had it before.

And the issue with the menu is likely due to that same reason of the primary keys and auto_increment missing for the menu tables of Joomla in the database.

Also, the console errors are not really a problem. However, they seem to indicate that a migration of some sort has happened since the domain for the cookies has changed.

You'll likely find many other problems on your website if the primary keys and auto_increment are missing of all the tables.

The best would be to revert the database to a backup from before loosing all the primary keys and auto_increment.
If you can't, you'll have to go in the database to fix this manually. These are old posts of users of early versions of Joomla with the same issue (before HikaShop even existed). They contain more information about the issue and what to do to manually fix it :
forum.joomla.org/viewtopic.php?t=53592
forum.joomla.org/viewtopic.php?t=93219

Hi,
I fixed the problem with user error but main menu is not back.
Can you fix this ?

Or if i will roll back the database before your FIX, i will fix the issue with ID, maybe will work the Hikashop or will be the same issue with ordering ?

Done. I fixed in first the ID issue and then from hikashop check database.
I was thinking to Hikashop because after the latest update all were good... I dont know what happend.

Thank you