Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Elliot Zimmerman
  1. Page Links = 5 Search Results = 20 $Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce
  2. Dear Farouk and Linda, Thanks so much for your reply. I am using oscommerce-2.2ms2, and Download Controller 5.3 MS2.2. I have MAX_DISPLAY_SEARCH_RESULTS in three places in orders.php: } $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows); $orders_query = tep_db_query($orders_query_raw); while ($orders = tep_db_fetch_array($orders_query)) { Further Down: <tr> <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td> <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td> </tr> Don't have ID of the orders.php ... JammerPro
  3. Dear Farrukh Saeed, Would you mind enlightening us as to the fix? Any suggestion would be helpful! JammerPro :roll:
  4. Ian and all others who have had the MySQL syntax problem... YourSQL is better than MySQL! :D However, I have not tried your fix (I had to mess with MySQL too many times this week). If you try it, or if anyone else tries it, please let me know how it turned out! JammerPro
  5. Ian ... See all previous and my previous comments in this thread (9/1/03) http://forums.oscommerce.com/viewtopic.php...p=223080#223080. In short, the problem is: EZ
  6. I have MS2 ... and there is no way that it worls! :evil:
  7. I had the same problem. Reloaded the program several times and I'm sure this is a bug! What's up with the author? :evil: JammerPro I had the same problem and the actual error lies in file /admin/orders.php around line 398: I made some modifications so i can't give you the exact line number sorry. There are 3 lines with the "$orders_query_raw" line of code. You will notice at the end it has "and ot.class = 'ot_total' order by $order" Well the "$order" has no appropiate value. A temporary fix is to remove the "order by $order" part from each of the 3 lines of code. But from what I have seen it looks like the author wanted to use the variable "$listing"... i.e. "order by $listing"... The links on the admin orders page support this theory although i have not tried it yet as i am still tweaking my code. I will also assume there is no default value for $listing so you will need to add that first.. I will give more info when i get there:-)