Null primary key not allowed.

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #364443

-- HikaShop version -- : 5.1.1
-- Joomla version -- : 5
-- PHP version -- : 8.2
-- Error-message(debug-mod must be tuned on) -- : Null primary key not allowed.

Hi,
I want to make an order. click on product add to cart and click to cart... i want to create new account but i have this error: Null primary key not allowed.

When i create new account from Joomla component is ok.

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
1 month 1 week ago #364446

Hi,

I've never seen this error and it's not an error message from HikaShop.
I've found this page which proposes two solutions for this error message with Joomla:
www.joomlashack.com/blog/tutorials/save-...ed-null-primary-key/
So I would recommend following their recommendation.

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

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #364452

Hi,
Thanks
Yes but is only in Hikashop registration. Joomla core is ok.

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

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #364456

The account is created, but I received an error message. The user hasn’t received the email for account confirmation or activation, and they aren’t able to proceed to the payment and complete the process.

Is not the same like in link sent because there is an issue from Joomla, Here the issue it comes from HikaShop registration step.
As i said earlier, Joomla core registration alone is ok.

Thanks

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
1 month 1 week ago #364455

Hi,

So, did you try both solutions on the link I gave ? Did it fix the problem ?

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

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #364458

Yes, i tried both.
As i said, All from Joomla is working, the only problem is when i try to register using HikaShop.
This was happening after the previous update.

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
1 month 1 week ago #364461

Hi,

Well, then i don't know. No one else reported the issue in the past 2 months with HikaShop 5.1.1.
So I doubt the problem is in HikaShop itself.
When a user account is created, Joomla calls user / authentication / system plugins. It's possible that a plugin was developed in a way which works fine with the Joomla registration form, but fails with that error when the registration is initiated from somewhere else.

Since the error message does sounds like a problem linked to the database, maybe you could try fixing the database ? Joomla has a button you can use for its database: www.joomlaplates.com/images/faq/discover-002.jpg
And HikaShop has the "check database" button on the HikaShop configuration page.
So you could try both. It wont hurt, and it might help.

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

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #364464

I did this and no issues are there



OK Table "hikashop_address" checked

OK Table "hikashop_badge" checked

OK Table "hikashop_banner" checked

OK Table "hikashop_cart" checked

OK Table "hikashop_cart_product" checked

OK Table "hikashop_category" checked

OK Table "hikashop_characteristic" checked

OK Table "hikashop_click" checked

OK Table "hikashop_config" checked

OK Table "hikashop_currency" checked

OK Table "hikashop_discount" checked

OK Table "hikashop_download" checked

OK Table "hikashop_entry" checked

OK Table "hikashop_field" checked

OK Table "hikashop_file" checked

OK Table "hikashop_filter" checked

OK Table "hikashop_geolocation" checked

OK Table "hikashop_history" checked

OK Table "hikashop_limit" checked

OK Table "hikashop_massaction" checked

OK Table "hikashop_order" checked

OK Table "hikashop_orderstatus" checked

OK Table "hikashop_order_product" checked

OK Table "hikashop_payment" checked

OK Table "hikashop_price" checked

OK Table "hikashop_product" checked

OK Table "hikashop_product_category" checked

OK Table "hikashop_product_related" checked

OK Table "hikashop_plugin" checked

OK Table "hikashop_shipping" checked

OK Table "hikashop_shipping_price" checked

OK Table "hikashop_tax" checked

OK Table "hikashop_taxation" checked

OK Table "hikashop_user" checked

OK Table "hikashop_variant" checked

OK Table "hikashop_vote" checked

OK Table "hikashop_vote_user" checked

OK Table "hikashop_waitlist" checked

OK Table "hikashop_widget" checked

OK Table "hikashop_zone" checked

OK Table "hikashop_zone_link" checked

OK Table "hikashop_warehouse" checked

OK Table "hikashop_email_log" checked

OK Product categories checked

OK Variants orphan links cleaned

OK Joomla users synchronized

OK User email addresses synchronized

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
1 month 1 week ago #364467

Hi,

While we can look into your issue, this will require a backend access and a FTP access ( which you can provide via our contact form: www.hikashop.com/support/contact-us.html ). Also, I'm pretty sure that the problem is not in HikaShop but in a third party. The fact that the HikaShop registration form doesn't work and you get that error message when using it is just a consequence of something else not working as it should during the registration process because it is not initiated by Joomla.
Also, this is likely to require several hours of investigation. As such we'll have to charge for the time spent if what I think is confirmed and it doesn't come from HikaShop's code.
We charge 60€ per hour.
Please confirm that you're ok with all of this before we proceed.

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

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #364468

Hi,
Now i can't pay because i'm not sure if is from something else than HikaShop. I understand but tell me your steps. What to check?
disable all plugins that are active?
I dont have many plugins, something else that Joomla and Hikashop.

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

  • Posts: 62
  • Thank you received: 1
  • Hikashop Business
1 month 6 days ago #364473

Hi
I think i solve it but i dont understand something:
Now:
- i choose the product , add to cart and click on cart
- here i choose to create my account, but i dont see the pass fields, i fill all the fileds and i got email, i click to activate my account and to complete the order, i need to login with user and pass, but in previous step i dont have where to add the password.

Can all auto? user to but without account or auto activate account, nothing from admin/administrator to do

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
3 weeks 6 days ago #364649

Hi,

Sorry for the late reply.

If you don't have a field to fill in the password, it's probably because how you configured the "registration" setting under the Checkout tab of the HikaShop configuration.
If you've configured it to "simplified registration", then the username and password field won't appear.
Instead, HikaShop will use the email address of the user as username, and automatically generate the password.
The password will then be included in the activation email so the user will be able to know it and use it.

If you want no activation, you can configure this in the settings of the Joomla user manager:
docs.joomla.org/Allowing_user_registration

The following user(s) said Thank You: agrobiobrichet

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

Time to create page: 0.074 seconds
Powered by Kunena Forum