1064 -error TEP STOP

[mrdarcy]

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.

 

:'(

[red devil]

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

[mrdarcy]

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

[Guest]

http://www.oscommerce.com/forums/index.php?sho...44095&st=20

 

 

This maybe a good place to start.

[mrdarcy]

http://www.oscommerce.com/forums/index.php?sho...44095&st=20

This maybe a good place to start.

 

 

thanks for the info, it happened to be a great place to look for answers. I was able to fix this problem. :rolleyes: