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