2 error messages

[cjcraven]

Hello,
Can anyone help me with the 2 following error messages?

I get the following error in my Admin screen for Discount Coupons;

*********
Warning: Division by zero in /catalog/admin/includes/classes/split_page_results.php on line 47

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS' at line 1
in:
[select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p roducts, restrict_to_categories, date_created,date_modified, coupon_active from coupons where coupon_active='Y' and coupon_type != 'G' limit -0, MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
*********

In my Admin screen for EZ-Pages Select a Page …. I get the following error message;

Warning: Division by zero in /catalog/admin/includes/classes/split_page_results.php on line 47

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_SEARCH_RESULTS_EZPAGE' at line 1
in:
[select * from ezpages order by toc_chapter, toc_sort_order, pages_title limit -0, MAX_DISPLAY_SEARCH_RESULTS_EZPAGE]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
**********

Server Information
Server OS: Linux 2.6.19.2-grsec
Database: MySQL 4.1.22-standard-log
PHP Version: 4.4.6 (Zend: 1.3.0)
HTTP Server: Apache
Zen Cart 1.3.0.2-l10n-jp-2 (Japanese Latest Version)
Database Patch Level: 1.3.0.2-l10n-jp-2

[DrByte]

http://www.zen-cart.com/forum/showth...357#post378357

[cjcraven]

Thank you but still getting the error message. I ran the following query with mySQLadmin;

# change cache tracking size
TRUNCATE TABLE db_cache;
ALTER TABLE db_cache CHANGE cache_data cache_data mediumblob;

I checked the DB and found the field cache_data as;
TYPE mediumblob
ATTRIBUTES: BINARY
NULL: Yes
DEFALUT: Null

[Ajeh]

What is the setting in the Configuration ... GV Coupons ...

Maximum Discount Coupons Per Page
Number of Discount Coupons to list per Page

[Ajeh]

And what are your settings in the Configuration ... Maximum Values ...

Maximum Display EZ-Pages
Maximum Display EZ-Pages
20 = Default

[cjcraven]

Hi, I don't see the settings in GV Coupons or Maximum Values. Could these DB fields have been missed in the upgrade?

[Ajeh]

Go to the Tools ... Developers Tool Kit and enter in the first input box:
MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS

select NONE and click Search ...

Then try a search on:
MAX_DISPLAY_SEARCH_RESULTS_EZPAGE

Do either of these show up?

[cjcraven]

Hi Linda,
No neither one shows up. I reported in another thread a simular problem with Discount Coupons.

[Ajeh]

I am sorry, I just realized you are running a very old and out dated version of Zen Cart and I do not believe these features even exist in it ...

Did you try an upgrade or something to the code that you might have mixed different versions of code and data in the database?

If you look in your admin Tools ... Server Info ... what do you have from below the menu bar up to and including the large PHP vX.XX ...

Is this a clean install of v1.3.0.2 or have you upgraded it at anytime?

How did you upgrade it?

I don't know if that version that you are running is original Zen Cart core code as what you have posted so far:
Zen Cart 1.3.0.2-l10n-jp-2 (Japanese Latest Version)
Database Patch Level: 1.3.0.2-l10n-jp-2

Is not a clean Zen Cart but an adapted version ...

[cjcraven]

It is the latest version from the Japan site - need Japanese language for customers.

I have a separate clean install (same version) and the features work fine.

For the upgrade, I copied the original to a local PC then uploaded in a new folder on the server. A new database received a copy of the original data. I made sure the newly installed copy worked. I uploaded the new files overwriting the originals, ran the database upgrades. Some database fields were missing and I installed them manually. The upgrade works except for the 3 areas; Discount Coupons, EZ-Pages, GV Coupons

The version info is below.

Server OS: Linux 2.6.19.2-grsec
Database: MySQL 4.1.22-standard-log
PHP Version: 4.4.6 (Zend: 1.3.0)
HTTP Server: Apache

Zen Cart 1.3.0.2-l10n-jp-2
Database Patch Level: 1.3.0.2-l10n-jp-2
v1.3.0.2-l10n-jp-2 [2007-09-05 21:57:23] (v1.3.0.2-l10n-jp-2)
v1.3.0.2-l10n-jp-1 [2007-09-05 21:54:49] (v1.3.0.2-l10n-jp-1)
v1.2.3 [2005-05-02 19:37:46] (Version Update 1.2.2->1.2.3)
v1.2.3 [2005-01-15 22:40:52] (Fresh Installation)

PHP Version 4.4.6