SOLVED! - Product Copy - error 167 Out of range value for column 'product_id'

Start
Prev
1
Next
End

shockoe
Topic Author
Away

Posts: 38
Thank you received: 5
Hikashop Business

6 years 8 months ago #296178

-- url of the page with the problem -- : www.ovrsupply.com
-- HikaShop version -- : 3.5.1
-- Joomla version -- : 3.8.11
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
167 Out of range value for column 'product_id' at row 1

When selecting a product and clicking the "copy" button... I get "An error has occurred.
167 Out of range value for column 'product_id' at row 1"

Thanks for helping me solve this...

Last edit: 6 years 8 months ago by shockoe.

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

nicolas
Away

Posts: 83603
Thank you received: 13533
MODERATOR

6 years 8 months ago #296181

Hi,

This problem is probably the same as the one here:
www.hikashop.com/forum/product-category-...-in-product-tab.html
You must have done something to the hikashop_product table via your phpmyadmin which broke the way HikaShop can add new entries to that table.
If you're not aware of any change made to that table, please look at the structure of that table via your phpmyadmin. If you can provide a screenshot of that page and the indexes there, that would be great.

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

shockoe
Topic Author
Away

Posts: 38
Thank you received: 5
Hikashop Business

6 years 8 months ago #296220

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.

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