Error in mysql

[deemurphy]

I am getting an error when I try to view orders, anything in reports. I just installed osCommerce on my local server to test, before we decided to use it. I am currently running xampp 5.01 php 5.05, apache 2.0.55, mysql 5.0.15.

 

I read information here and tried the change in the split_page_reults.php and in doing so nothing workings, so I just replaced it with the original.

 

I think this happening because I have no orders in there, but this is not good for showing my boss right after setting this up.

 

Can someone please help.

Darlene :o

[Guest]

have you implemented the osc upgrade?

http://www.oscommerce.com/solutions/downloads

 

and have you configured the mysql 5.x after you installed it? I've no idea if xampp does that automatically as I always install separately the mysql.

[skeeweeaka]

I am receiving these same errors. The 20-20 bugfix at the bottom fixed 1064... However, 1054 is still not fixed, and now my product listiings page is not showing up. Add a product and see if yours is showing up at all or if you get this same message.

 

I'm getting,

"Fatal error: Cannot pass parameter 3 by reference in /hsphere/local/home/skeeweea/absolutelybeautifulhairillusions.com/catalog/includes/modules/product_listing.php on line 13"

 

Here was the fix I used for 1064...

 

 

In .../catalog/includes/classes/split_page_results.php, change

 

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

to

$this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page;

 

 

In .../admin/includes/classes/split_page_results.php, change

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

to

$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;

[skeeweeaka]

By the way for anyone nice enough to help us...

 

This is line 13...

 

$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

 

:blush: