Error : Division by zero.....

[artisticleaf]

Very interesting thing happened with my Zen cart install. My first install was without any problem except that I had not opted for Demo Data(sample stores), and could not find a way to re-install just the demo data. Therefore, I wiped out all my dabase for Zen and started with clean install again. At the end of install, Zen cart congratulated me for successful install but when I went to admin area I had following errors on the top of the admin page.

Error: There is currently no default currency set. Please set one at: Administration Tools->Localization->Currencies
Error ERROR_NO_DEFAULT_LANGUAGE_DEFINED

So under localisation, I went to set for currencies, languages and orde status and I get following erro. I am new at this so I would appreciate if anyone can help me resolve this.

Currencies

Warning: Division by zero in /home/artistic/public_html/mystor_name/admin/includes/classes/split_page_results.php on line 48
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 'MAX_DISPLAY_SEARCH_RESULTS' at line 1
in:
[select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, last_updated, value from artleaf_currencies order by title limit -0, MAX_DISPLAY_SEARCH_RESULTS]
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.

Languages

Warning: Division by zero in /home/artistic/public_html/mystor_name/admin/includes/classes/split_page_results.php on line 48
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 'MAX_DISPLAY_SEARCH_RESULTS' at line 1
in:
[select languages_id, name, code, image, directory, sort_order from artleaf_languages order by sort_order limit -0, MAX_DISPLAY_SEARCH_RESULTS]
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.

My server Data:

Server OS: FreeBSD 4.11-STABLE
Database: MySQL 4.0.16
PHP Version: 4.4.1 (Zend: 1.3.0)

Thanks,

Artistic Leaf

[DrByte]

Under Admin->Configuration->Maximum values, what do you have for Search results ?

[Chuckl]

Sounds to me like you are not finding a lot of files with defaults in them, which to me points to some file path problems in your config files, or missing files.

[artisticleaf]

DR Byte and Chuck,
Thank you for your reply.
Under Admin->Configuration->Maximum values, wI have for Search results 20 pages.

If I had any missing files or problem with default config file. nothing showed in flight check before install started. According to Zen software my install was successful.

Something interesting I noted today. if I run sql query on most of the table in my database on my sever, I get the same mysql error 1064. Version on my server for mysql has not changed. In my admin, most of pull downs gives me the same error # 1064 as I have noted in the beginning of my post.

Artistic Leaf

[DrByte]

# 1064 simply means a syntax error in the SQL query you're running.

[DrByte]

I think this might be the solution you need:
http://www.zen-cart.com/forum/showpo...57&postcount=3