error on advance search

[rahulbalakrishna]

i downloaded arfooo 2.01 lastest version available till now and installed without any error.
but after installation when i click on advance search i get this error

SELECT * FROM categories INNER JOIN categoryparents ON categoryParents.parentId = categories.categoryId WHERE searchEngineSettings != '' AND categoryparents.childId = '0' ORDER BY depth LIMIT 1/XD/extraField/getByCategoryId

(1024) B��d SQL Unknown column 'categoryParents.parentId' in 'on clause' (1054) Database.php line 235 7-4-10 0:29
FrontController->dispatch() # line 18, file: /home/amvtrade/public_html/XD/index.php
call_user_func_array(Array[2], Array[0]) # line 220, file: /home/amvtrade/public_html/XD/core/FrontController.php
ExtraFieldController->getByCategoryIdAction() # line 0, file: unknown
CategoryModel->findClosestParent("0", Object:Criteria) # line 40, file: /home/amvtrade/public_html/XD/controllers/ExtraFieldController.php
Model->find(Object:Criteria) # line 148, file: /home/amvtrade/public_html/XD/models/CategoryModel.php
Database->sqlGetRow("SELECT * FROM categories INNER JOIN categoryparents ON categoryP...") # line 92, file: /home/amvtrade/public_html/XD/core/Model.php
Database->sqlQuery("SELECT * FROM categories INNER JOIN categoryparents ON categoryP...") # line 330, file: /home/amvtrade/public_html/XD/core/Database.php
trigger_error("B��d SQL Unknown column 'categoryParents.parentId' in 'on clause...") # line 235, file: /home/amvtrade/public_html/XD/core/Database.php

i thought this error might be because my DB is not upto date so i ran install/update/update201.php
i get error "Duplicate key name 'urlName'"
please help me out its urgent

[twalbert]

I have the same problem. It seems at first glance that mysql cannot accept the term 'categoryparents.parentId' since the table has not been read. I have duplicated the call using only 'parentId' this produces a response.

I have performed a fresh test install, and it seems this is an inherent error.

I have changed line 143 of \models\CategoryModel.php from:

$c->addInnerJoin("categoryparents", "categoryParents.parentId", "categories.categoryId");
to
$c->addInnerJoin("categoryparents", "parentId", "categories.categoryId");

All seems fine?! keeping my fingers crossed. Anyone else?