Error after osCMax fresh installation. Can't open admin

[juanlopez4691]

I have just installed osCMax locallyy (appServ under Windows XP Pro). I get the screen with the two buttons. "Catalog" works ok, and the sample shop opens. But when I click on the "Administration tool" button I get this error:

Warning: main(includes/languages/espanol/login.php): failed to open stream: No such file or directory in k:\appserv\www\oscmax\catalog\admin\login.php on line 58

Warning: main(includes/languages/espanol/login.php): failed to open stream: No such file or directory in k:\appserv\www\oscmax\catalog\admin\login.php on line 58

Fatal error: main(): Failed opening required 'includes/languages/espanol/login.php' (include_path='.;c:\php4\pear') in k:\appserv\www\oscmax\catalog\admin\login.php on line 58

I have tried to jump to the admin section using:

http://localhost/oscmax/catalog?language=en

and it works ok (opens admin in english)

Any clues?

[michael_s]

Spanish is not correctly installed in the admin. You need login.php in the espanol diretory.

[juanlopez4691]

I solved the problem copying login.php and logout.php from the /english directory into the /espanol directory and now it works. The files login.php and logout.php for "espano" do not exist in the original oscmax_v1.7.zip file.

Now I am getting SQL syntax errors in many areas of the admin panel. For example, if I click on "Customers" i get:

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 '-10, 10' at line 1

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit -10, 10

The same happens when I click on "Tax zones", "Tax rates", "Banners", and many other options

Excuse me if I sound rude but, is this a complete, tested and stable release or did I overlook something in the installation process?

[michael_s]

Yes it is a complete tested stable release. The only supported language is english, the others are included as a courtesy, but are not tested. This is going to be fixed in the next full release, when we have the 3 included packs fully tested.

The sql errors are most likely related to some install problem or mysql version you are running. Double check that all your files were properly uploaded. Also, it would help if you posted your platform info and server software versions for mysql, php and your os...

[juanlopez4691]

Thanks a lot for your help.

I am using Windows XP Pro SP2, and I installed appServ v2.4.3 as page server. I includes:
# Apache Web Server Version 1.3.33
# PHP Script Language Version 4.3.10
# MySQL Database Version 4.1.8
# Zend Optimizer Version 2.5.7
# phpMyAdmin Database Manager Version 2.6.1-rc2

I also installed osCommerce v2.2 MS2 (last stable release) and it works ok, with no SQL syntas error missages

When do you plan to deliver next full release?

[michael_s]

The issue is your mysql version. osCommerce and osCMax are not yet compatible with Mysql 4.1x .

See this:

http://oscdox.com/phpWiki-index-pagename-SQLError.html

[juanlopez4691]

I see! I will try a previous version of mySql then. Thans a lot for your help.