mariovaldez.net

today I test (fresh installation)Zenchartv1.3.7.1-full-patched-07.05.2007 with oscpmwin 0.4.1.816 .And I have this massage : "Range check error"
Please help

FXTC:

> today I test (fresh installation)Zenchartv1.3.7.1-full-patched-07.05.2007
> with oscpmwin 0.4.1.816 .And I have this massage : "Range check error"

First, sorry for moving this post to this BugReports forum, but that ZenCart thread at the Wishlist forum is already too large.

That error usually means that some data list is too large. (At several places, the OSCPMWin application does not check properly the size of the language, currencies, products, manufacturers or categories lists).

Please enable in the configuration window the option "Log SQL queries" then try to connect. That option will create a file named OSCDEBUG.TXT in the directory where OSCPMWin is installed. Then send me that file by email to mario@mariovaldez.org. (That file is just a dump of the SQL queries done by the application, so I can check where the problem happened).

Anyway, I'll try to replicate the problem with a fresh install of that ZenCart version.


Regards,

Mario A. Valdez-Ramirez.

Hello Mario.
I send u oscdebug.txt

Zencart - crash with "Range chceck error" (Dont function)
2007-09-12 11:49:36:806
======================================

2007-09-12 11:49:49:584|BEGIN record loading (LoadTableNames)...
2007-09-12 11:49:49:734|END record loading.
2007-09-12 11:49:49:965|BEGIN record loading (LoadConfigList)...
2007-09-12 11:49:49:965|Executing query: select configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, set_function from configuration order by configuration_group_id, configuration_title
2007-09-12 11:49:49:975|Try 0 Ready... set...
2007-09-12 11:49:49:975|Go!
2007-09-12 11:49:50:375|Done!
2007-09-12 11:49:50:465|Decoded records: 624x7 Size: 121838 Original size: 168184

____________________________________________________________
Oscpwin and Oscommerce - Thats ok! (Function correctly)
2007-09-12 11:50:24:204
======================================

2007-09-12 11:51:07:656|BEGIN record loading (LoadTableNames)...
2007-09-12 11:51:07:907|END record loading.
2007-09-12 11:51:08:177|BEGIN record loading (LoadConfigList)...
2007-09-12 11:51:08:177|Executing query: select configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, set_function from configuration order by configuration_group_id, configuration_title
2007-09-12 11:51:08:177|Try 0 Ready... set...
2007-09-12 11:51:08:177|Go!
2007-09-12 11:51:08:487|Done!
2007-09-12 11:51:08:507|Decoded records: 156x7 Size: 23816 Original size: 33280
2007-09-12 11:51:08:507|END record loading.
2007-09-12 11:51:08:507|BEGIN record loading (LoadLangList)...
2007-09-12 11:51:08:507|Executing query: select languages_id, name from languages order by name
2007-09-12 11:51:08:507|Try 0 Ready... set...
2007-09-12 11:51:08:507|Go!
2007-09-12 11:51:08:688|Done!
2007-09-12 11:51:08:698|Decoded records: 4x2 Size: 32 Original size: 64
2007-09-12 11:51:08:698|END record loading.
2007-09-12 11:51:08:698|BEGIN record loading (LoadCatList)...
2007-09-12 11:51:08:698|Executing query: select categories.categories_id, categories.parent_id, categories_description.categories_name, categories.categories_image from categories, categories_description where categories_description.categories_id= categories.categories_id and language_id=1 ORDER BY categories.parent_id, categories_description.categories_name
2007-09-12 11:51:08:698|Try 0 Ready... set...
2007-09-12 11:51:08:698|Go!
2007-09-12 11:51:08:928|Done!
2007-09-12 11:51:08:928|Decoded records: 23x4 Size: 729 Original size: 1124
2007-09-12 11:51:08:928|END record loading.
2007-09-12 11:51:08:928|BEGIN record loading (LoadManList)...
2007-09-12 11:51:08:928|Executing query: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
2007-09-12 11:51:08:938|Try 0 Ready... set...
2007-09-12 11:51:08:938|Go!
2007-09-12 11:51:09:108|Done!
2007-09-12 11:51:09:118|Decoded records: 10x2 Size: 95 Original size: 156
2007-09-12 11:51:09:118|END record loading.
2007-09-12 11:51:09:118|BEGIN record loading (LoadTaxList)...
2007-09-12 11:51:09:118|Executing query: select tax_class.tax_class_id, tax_class_title, sum(tax_rate) from (tax_class) left join tax_rates on tax_class.tax_class_id=tax_rates.tax_class_id group by tax_class_id order by tax_class_title
2007-09-12 11:51:09:118|Try 0 Ready... set...
2007-09-12 11:51:09:118|Go!
2007-09-12 11:51:09:319|Done!
2007-09-12 11:51:09:319|Decoded records: 1x3 Size: 11 Original size: 20
2007-09-12 11:51:09:319|END record loading.
2007-09-12 11:51:09:319|BEGIN record loading (LoadDefCurrency)...
2007-09-12 11:51:09:319|Executing query: select currencies.currencies_id from currencies, configuration where configuration.configuration_key="DEFAULT_CURRENCY" and configuration.configuration_value=currencies.code
2007-09-12 11:51:09:319|Try 0 Ready... set...
2007-09-12 11:51:09:319|Go!
2007-09-12 11:51:09:519|Done!
2007-09-12 11:51:09:519|Decoded records: 1x1 Size: 1 Original size: 4
2007-09-12 11:51:09:519|END record loading.
2007-09-12 11:51:09:519|BEGIN record loading (LoadCurrencyList)...
2007-09-12 11:51:09:519|Executing query: select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies order by title, code
2007-09-12 11:51:09:529|Try 0 Ready... set...
2007-09-12 11:51:09:529|Go!
2007-09-12 11:51:12:103|Done!
2007-09-12 11:51:12:103|Decoded records: 3x9 Size: 76 Original size: 148
2007-09-12 11:51:12:103|END record loading.
2007-09-12 11:51:12:103|RenderLanguageDisplay BEGIN
2007-09-12 11:51:12:103|RenderLanguageDisplay END
2007-09-12 11:51:12:113|RenderCategoryDisplay BEGIN
2007-09-12 11:51:12:123|RenderCategoryDisplay END


Can u get me some tip for zen-cart. How can i interconnected zen-cart and ospwin.

Thank you.