osC MS2-MAX v1.7 with XAMPP 1.4.10a (lite) installation prob

[Philibuster]

I am trying to do a new install of osC MS2-MAX v1.7 on a Win2000 server under XAMPP 1.4.10a (light). I have removed IIS to make installation easier under the Apache environment in XAMPP.

First thing I downloaded and installed standard osCommerce 2.2-MS2 to see what problems there were in the pure vanilla version. Only one:

/catalog/admin/includes/classes/upload.php line 31

an apparent incompatibility with the latest revision XAMPP PHP. The line was commented out.

I removed the vanilla installation then downloaded and installed osC MS2-MAX v1.7. It experienced the same problem - which I quickly fixed.

Next I experienced a 'session_start' problem on line 67 of session.php. This appeared to be caused by an access error to the missing C:/tmp directory. Consequently, I changed the installation configuration to use the database for session control. The problem went away. Both the 'Catalog' and 'Administrator Tool' paths worked to the next stage of testing.

Next I attempted to log into the Login Panel using the default account. I was greeted with an error:

1267 - Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'

select admin_files_id from admin_files where FIND_IN_SET( '1', admin_groups_id) and admin_files_is_boxes = '1' and admin_files_name = 'configuration.php'

[TEP STOP]

The error appears to be generated in the following file:

\catalog\admin\includes\functions\general.php line 23:

$db_file_query = tep_db_query("select admin_files_name from " . TABLE_ADMIN_FILES . " where FIND_IN_SET( '" . $login_groups_id . "', admin_groups_id) and admin_files_name = '" . $filename . "'");

It would appear that there is a MySQL version compatibility issue. Does anyone have a solution for this and other yet to be discovered version issues? I was hoping to avoid these kinds of time consuming problems via my previous forum post regarding installation - no response. Now that I've gone ahead I'm in a quagmire. Any help would be appreciated.

Philibuster

[Philibuster]

Update:

After some investigation of my MySQL configuration (the my.cnf file), and viewing the database character set and collation under phpMyAdmin, I noticed that it was set for UTF8 - apparently for Win2000+ MySQL should be configured to support Latin1. I dropped the old database, changed the configuration file to Latin1, and created the database with Latin1 settings under phpMyAdmin. This cured my problem - I can see the admin splash. On to the next problem.

Philibuster

[Philibuster]

Update:

Next, I ran into several SQL errors similar to:

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 manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -10, 10

caused by a documented problem with an empty database and split_page_results.php running with later versions of MySQL. I added a test for negative values on the 'limit' clause prior to $sql_query:

\catalog\admin\includes\classes\split_page_results .php line 38:

if($offset < 0) $offset = 0; // added to prevent error in following sql_query
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

This revision cleared up several errors in Admin. The following 'Customers' errors were subsequently found:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in
\catalog\admin\customers.php on line 800

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in
\catalog\admin\customers.php on line 800

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in
\catalog\admin\customers.php on line 802

Warning: reset() [function.reset]: Passed variable is not an array or object in
\catalog\admin\includes\classes\object_info.php on line 17

Warning: Variable passed to each() is not an array or object in \catalog\admin\includes\classes\object_info.php on line 18

I am currently investigating these problems. Any ideas out there? Not much help so far.

Philibuster

[Philibuster]

Update:

The 'not an array' issue appears to be caused by a corrupt database. Using phpMyAdmin, I browsed the 'customers' table and found a single record for a 'Test' customer. This record had no supporting entries in it's associated tables (for example: customers_info table). I did an 'Empty' of the customers table using phpMyAdmin. The array warnings went away. BTW, I think a test for valid customer arrays such as:

if (is_array($country) && is_array($info) && is_array($reviews)){...

should be done before the 'array_merge' at line 800 of \catalog\admin\customers.php. A complete implementation would require the creation of a proper $cInfo object with an error indication so that the bogus customer record could be deleted via the Admin panel. For now, I'll be happy with clearing the customers table. Note: There may be a problem that I'm not aware of during installation that causes the database corruption. Any ideas about this out there in the silence?

I will now look into the setting up groups for the 'price per customer' feature.

[Philibuster]

Final Update:

I made a cursory test of the 'price per customer' feature and several of the other features - they don't have glaring errors. This release can now be considered to be installed and used as a baseline for further work.

Philibuster

[doumawis]

Originally Posted by Philibuster

I am trying to do a new install of osC MS2-MAX v1.7 on a Win2000 server under XAMPP 1.4.10a (light). I have removed IIS to make installation easier under the Apache environment in XAMPP.

First thing I downloaded and installed standard osCommerce 2.2-MS2 to see what problems there were in the pure vanilla version. Only one:

/catalog/admin/includes/classes/upload.php line 31

an apparent incompatibility with the latest revision XAMPP PHP. The line was commented out.

I removed the vanilla installation then downloaded and installed osC MS2-MAX v1.7. It experienced the same problem - which I quickly fixed.















Next I experienced a 'session_start' problem on line 67 of session.php. This appeared to be caused by an access error to the missing C:/tmp directory. Consequently, I changed the installation configuration to use the database for session control. The problem went away. Both the 'Catalog' and 'Administrator Tool' paths worked to the next stage of testing.

Next I attempted to log into the Login Panel using the default account. I was greeted with an error:

1267 - Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'

select admin_files_id from admin_files where FIND_IN_SET( '1', admin_groups_id) and admin_files_is_boxes = '1' and admin_files_name = 'configuration.php'

[TEP STOP]

The error appears to be generated in the following file:

\catalog\admin\includes\functions\general.php line 23:

$db_file_query = tep_db_query("select admin_files_name from " . TABLE_ADMIN_FILES . " where FIND_IN_SET( '" . $login_groups_id . "', admin_groups_id) and admin_files_name = '" . $filename . "'");

It would appear that there is a MySQL version compatibility issue. Does anyone have a solution for this and other yet to be discovered version issues? I was hoping to avoid these kinds of time consuming problems via my previous forum post regarding installation - no response. Now that I've gone ahead I'm in a quagmire. Any help would be appreciated.

Philibuster

i should not use th elightversion of Xampp, but the fullversion( read first there what is th edifference between ligt and a normal xampp)

doumawis

[bigboss]

Do you know how to fix the mysql error :
I am using Fedora Core 4, php5, mysql4.1 and create the database collated with unicode (utf-. Because I am using Chinese chars, so that I need to create it with utf-8.
Thanks!
============
1267 - Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'find_in_set'

select admin_files_id from admin_files where FIND_IN_SET( '1', admin_groups_id) and admin_files_is_boxes = '1' and admin_files_name = 'catalog.php'
============