BIG BUG with editing products!

19.07.2012 11:53
#1
mommek
Joomshopping forum user no avatar
Name: mommek
15.09.2011
Posts: 136
Quote
BIG BUG with editing products!

Hello there,

I have about 7000 products imported in my database.

So last product ID is 2610399544
When I see list products in administration, I see name, photo, price .. when I click on this product, I see empty fields in price, name etc.

I turn on debugging and see this in query DB:
SELECT *
FROM yepa6_jshopping_products
WHERE `product_id` = '2147483647'

So there is probably problem, why it select product_id 2147483647 ? I click on product, that have id 2610399544 (completly diferent id)

Why?

Thanks for advice.


Joomla: latest
JoomShopping: latest
PHP: latest
MySQL: latest
 
19.07.2012 14:04
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: BIG BUG with editing products!

Mysql Int - maximum

change type field product_id as BIGINT

or

clear database


Letzte Ă„nderung: 19.07.2012 14:07
 
19.07.2012 14:30
#3
mommek
Joomshopping forum user no avatar
Name: mommek
15.09.2011
Posts: 136
Quote
Aw: BIG BUG with editing products!

Yes, I think there was problem with int(11), but I think, INT 11 = 11 number places, or I'm wrong?

INT (11) == 111 222 333 44 or this is too much?

 
19.07.2012 20:48
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: BIG BUG with editing products!

See http://dev.mysql.com/doc/refman/5.0/en/integer-types.html

 
Copyrights MAXXmarketing GmbH. All Rights Reserved