BIG BUG with editing products!

19.07.2012 11:53
#1
pcsupport
Joomshopping forum user no avatar
Name: pcsupport
15.09.2011
Сообщения: 166
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25934
Quote
Aw: BIG BUG with editing products!

Mysql Int - maximum

change type field product_id as BIGINT

or

clear database


Последнее изменение: 19.07.2012 14:07
 
19.07.2012 14:30
#3
pcsupport
Joomshopping forum user no avatar
Name: pcsupport
15.09.2011
Сообщения: 166
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25934
Quote
Aw: BIG BUG with editing products!

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

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.