SOLVED! - Can NOT add (or save) Variant in product tab?

  • Posts: 38
  • Thank you received: 5
  • Hikashop Business
6 years 8 months ago #296177

-- url of the page with the problem -- : www.ovrsupply.com
-- HikaShop version -- : 3.5.1
-- Joomla version -- : 3.8.11
-- Browser(s) name and version -- : all

I believe I've fully followed the instruction on how to add a variant to a product. But, when I go to the "Variant" tab in the product and try to "add variant" after selecting the options... I click "Save"... and NOTHING??? The page just refreshes and nothing adds or shows on the product page.

Any help would be greatly appreciated. I can send login info via if it would be needed?

Attachments:
Last edit: 6 years 8 months ago by shockoe.

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
6 years 8 months ago #296179

Hi,

I got the access you sent via the contact form so I went on your website backend but I couldn't find the product of your screenshot for some reason. So I tried to create a new product and no matter what I did, I got an error when trying to save it. So I couldn't even create the product to test the issue with the variants.
To me this would indicate a problem with the database preventing HikaShop from adding new entries in the hikashop_product table. Did you change something via your phpmyadmin ?
Are you able to create new products on your end ?modify existing ones ?

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

  • Posts: 38
  • Thank you received: 5
  • Hikashop Business
6 years 8 months ago #296217

Hi Nicolas,

I didn't change anything in any database tables? I've attached the screen shot you requested and also sent you (via contact form) cPanel access so you can take a look at the database.

Thanks in advance for the great help.

Attachments:
Last edit: 6 years 8 months ago by shockoe.

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
6 years 8 months ago #296221

Hi,

So if I check your phpmyadmin, the highest value for the product_id in the hikashop_product table is 496:
monosnap.com/file/tLPKYKABpnS4PkOyuyW4vv2wXbzgO5
However, if I look at the information area of the table, I can see that the auto_increment value has been set to the value 4,294,967,296 which is invalid as it goes about the type (integer of 11 numbers) of the product_id column.
So I've updated your auto_increment value to 497. After that, everything worked again as it should:
monosnap.com/file/b8N3ytZ23f9klpDgkJANzbvqfpwr8W

So someone or something changed that value. If it's not you, it could some kind of database optimization extension or script gone awry.

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

  • Posts: 38
  • Thank you received: 5
  • Hikashop Business
6 years 8 months ago #296236

Hi Nicolas,

Again... Thanks so much for the great Hika help.

I did not change anything is the site's database... It is very interesting that you found this issue. In trying to solve this, I did read several forum post that referenced issues with the database table settings? I just didn't know what to exactly look for.

Your fix worked great... Thanks!

The following user(s) said Thank You: nicolas

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

Time to create page: 0.063 seconds
Powered by Kunena Forum