Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 -error TEP STOP


mrdarcy

Recommended Posts

Hi,

I would like to find out how I can fix this error. I didn't want to show some of the modules and after turning something off this error occurred.

 

please see: https://luzon.globat.com/~recherchejewelry....17e72aaeccbf342

 

Any help would be appreciated.

 

I'm a super novice at this so please speak slowly.

 

:'(

Link to comment
Share on other sites

Can't help with the error - sorry - but if you "view source" on that page, this is what you get at the bottom of the page (if you haven't already seen this). Does this help pin point the problem?

 

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 '' at line 1<br><br>select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name lim

Link to comment
Share on other sites

Can't help with the error - sorry - but if you "view source" on that page, this is what you get at the bottom of the page (if you haven't already seen this). Does this help pin point the problem?

 

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 '' at line 1<br><br>select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name lim

 

 

Thanks for trying,

This is the snippet of code that is at the bottom of every page below the ending html tag:

 

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

And here is the application_bottom.php code:

 

<?php

/*

$Id: application_bottom.php,v 1.14 2003/02/10 22:30:41 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// close session (store variables)

tep_session_close();

 

if (STORE_PAGE_PARSE_TIME == 'true') {

$time_start = explode(' ', PAGE_PARSE_START_TIME);

$time_end = explode(' ', microtime());

$parse_time = number_format(($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0])), 3);

error_log(strftime(STORE_PARSE_DATE_TIME_FORMAT) . ' - ' . getenv('REQUEST_URI') . ' (' . $parse_time . 's)' . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);

 

if (DISPLAY_PAGE_PARSE_TIME == 'true') {

echo '<span class="smallText">Parse Time: ' . $parse_time . 's</span>';

}

}

 

if ( (GZIP_COMPRESSION == 'true') && ($ext_zlib_loaded == true) && ($ini_zlib_output_compression < 1) ) {

if ( (PHP_VERSION < '4.0.4') && (PHP_VERSION >= '4') ) {

tep_gzip_output(GZIP_LEVEL);

}

}

?>

 

 

I have no idea what I am looking at but I am 51% sure this has to do with it.

 

thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...