Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sharky92663

Archived
  • Posts

    14
  • Joined

  • Last visited

Profile Information

  • Real Name
    Jim Hwang

sharky92663's Achievements

  1. Hello, I have this installed and I get a blank screen when I hit the "update" button after the preview for a product. It adds the product attributes to the product and it shows up on the front end; although, the admin page doesn't return the product information - just a blank page. Any ideas or anyone else experience this?
  2. Hi, I have RMA 2.5h installed and some data does not appear on the catalog/admin/returns.php page. The Customer information does not display, except for the email address. Here is a snippet of code from the file: <td class="main"><b><?php echo ENTRY_CONTACT_NAME; ?></b></td> <td class="main"><?php echo $contact_user_name; ?></td> </tr> </table></td> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td> <td class="main"><?php echo tep_address_format(1, $order->customer, true, ' ', '<br>'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '20'); ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_TELEPHONE; ?></b></td> <td class="main"><?php echo $order->customer['telephone']; ?></td> </tr> </table></td> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td> <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, true, ' ', '<br>'); ?></td> </tr> </table></td> Any ideas or help would be great. Thanks. Jim
  3. Hello, Within the file, qbi_functions.php, there is a statement that doesn't like any single quotes in the data. $ship_match_query=tep_db_query("SELECT * FROM ".TABLE_QBI_SHIPOSC." AS so, ".TABLE_QBI_SHIPOSC_SHIPQB." AS soqb, ".TABLE_QBI_SHIPQB." AS sqb WHERE qbi_shiposc_car_text='$carrier' AND qbi_shiposc_serv_text='$service' AND so.qbi_shiposc_car_code=soqb.qbi_shiposc_car_code AND so.qbi_shiposc_serv_code=soqb.qbi_shiposc_serv_code AND sqb.qbi_shipqb_refnum=soqb.qbi_shipqb_refnum"); The portion in red is where I get an error. If my data includes a single quote (like "Customer's"), it breaks the SQL statement. I've tried some basic debugs but haven't found the right solution. Any ideas would be helpful, thanks in advance.
×
×
  • Create New...