DB error instead 404 page

[qrczak]

Hi all

I have installation with Catalog 2.0.0 beta2 and when I have right url like:

domain.com/kolektory-sloneczne/product_category/active-energy

it's working fine.

where:
kolektory-sloneczne - page name
product_category - field in DB (it holding category name)
active-energy - name of category

But if I miss any letter in url like here:

domain.com/kolektory-sloneczne/product_category/active-en

it give me a DB error instead 404 page like in my others installations:

Fatal error: Uncaught exception Exception with message Query error: 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 ')) AND valueid IN ()) LIMIT 0,2' at line 1 (SELECT id,pid,sorting,tstamp,product_name,product_category,product_desc,product_photo,product_logo,product_schemat,product_cartproduct,product_certyfikat,product_models,feature,publish, (SELECT name FROM tl_catalog_types WHERE tl_catalog_types.id=kolektory.pid) AS catalog_name, (SELECT jumpTo FROM tl_catalog_types WHERE tl_catalog_types.id=kolektory.pid) AS parentJumpTo FROM kolektory WHERE pid='1' AND publish=1 AND feature=1 AND id IN (SELECT DISTINCT(itemid) FROM tl_catalog_tag_rel WHERE fieldid=8 AND itemid IN (SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=8 AND valueid=0 AND itemid IN(SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=8 AND valueid=)) AND valueid IN ()) LIMIT 0,2) thrown in /home/actenergy/domains/domain.com/public_html/system/libraries/Database.php on line 642
#0 /home/actenergy/domains/domain.com/public_html/system/libraries/Database.php(589): Database_Statement->query()
#1 /home/actenergy/domains/domain.com/public_html/system/modules/catalog/ModuleCatalogList.php(214): Database_Statement->execute(Array)
#2 /home/actenergy/domains/domain.com/public_html/system/modules/frontend/Module.php(140): ModuleCatalogList->compile()
#3 /home/actenergy/domains/domain.com/public_html/system/modules/catalog/ModuleCatalog.php(139): Module->generate()
#4 /home/actenergy/domains/domain.com/public_html/system/modules/catalog/ModuleCatalogList.php(79): ModuleCatalog->generate()
#5 /home/actenergy/domains/domain.com/public_html/system/libraries/Controller.php(271): ModuleCatalogList->generate()
#6 /home/actenergy/domains/domain.com/public_html/system/modules/frontend/PageRegular.php(71): Controller->getFrontendModule('35', 'main')
#7 /home/actenergy/domains/domain.com/public_html/index.php(198): PageRegular->generate(Object(DB_Mysqli_Result))
#8 /home/actenergy/domains/domain.com/public_html/index.php(333): Index->run()
#9 {main}

Any ideas? Maybe anyone know where I should looking for solution?

[ga.n]

Hi qrczak,

the problem is in the "valueid" ...

you have two errors:

valueid=) after the = should be a value

and valueid IN() into the parenthesis should be something

where do you use the valueid field?