Jump to content
Sign in to follow this  
bruno_caramiel

Bug with MySQL 4.1 ?

Recommended Posts

First I'd like to say that other topics I found about this problem didn't help me.

 

Problem, on /admin/orders.php :

 

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 'select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last' at line 1

select count(select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = \'1\' and s.orders_status_id = \'1\' and ot.class = \'ot_total\' order by o.orders_id DESC) as total

 

Notice that this bug is different from that one :

http://forums.oscommerce.com/index.php?showtopic=144095&st=0

 

Any idea ?

Share this post


Link to post
Share on other sites

More informations...

 

The problem seems to be that in /admin/orders.php, we got this :

 

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);

 

and $HTTP_GET_VARS['page'] is empty....

 

So, in /admin/includes/classes/split_page_results.php, we got this :

 

 function splitPageResults($query, $max_rows, $count_key = '*', $page_holder = 'page') {
     global $HTTP_GET_VARS, $HTTP_POST_VARS;

     $this->sql_query = $query;

 

But $query is empty !! That's why the next mysql query doesn't work.

 

Temporary solution if you really need your admin to work, such as me :

 

Search :

 

$count_query = tep_db_query("select count(" . $count_string . ") as total " . substr($this->sql_query, $pos_from, ($pos_to - $pos_from)));
$count = tep_db_fetch_array($count_query);
$this->number_of_rows = $count['total'];

 

Replace by :

 

//      $count_query = tep_db_query("select count(" . $count_string . ") as total " . substr($this->sql_query, $pos_from, ($pos_to - $pos_from)));
//      $count = tep_db_fetch_array($count_query);
//      $this->number_of_rows = $count['total'];

 

Here it is... ( but help :'( )

Edited by bruno_caramiel

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×