Jump to content
xt:Commerce Community Forum

You Have An Error In Your Sql Syntax


DataDeko

Recommended Posts

Hallo,

Bei der V 2.0 rc1 tritt folgender Fehler auf:

Bei Eingabe einer nicht existierenden Artikelnummer in das Feld "Schnellsuche".

Fehlermeldung:

1064 - You have an error in your SQL syntax near '' ' at line 5

select products_fsk18, products_id from products where products_model LIKE '%123%' '

[XT SQL Error]

Der gleiche Fehler tritt auf, wenn in das Feld ?berhaupt nichts eingegeben wurde.

Gru?

J?rgen

Link to comment
Share on other sites

bugfix:

/includes/application_top.php

~ zeile 388

statt:


                $quickie_query = xtc_db_query("select

                         products_fsk18,

                         products_id from " . TABLE_PRODUCTS . "

                         where products_model LIKE '%" . $_POST['quickie'] . "%'

                         ".$group_check." ' 

                         ");


                $quickie_query = xtc_db_query("select

                         products_fsk18,

                         products_id from " . TABLE_PRODUCTS . "

                         where products_model LIKE '%" . $_POST['quickie'] . "%'

                         ".$group_check."

                         ");

Link to comment
Share on other sites

Archived

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

×
  • Create New...