Unhandled Exception (Debug)
ORA-00933: SQL command not properly ended
 (execute, -1)
SELECT vacancy.vacancy_id, vacancy.category_id, vacancy.vacancy_id as id, vacancy.is_published, vacancy_category_text.name as category_name, vacancy_text.post, vacancy_text.speciality, vacancy_text.functions, vacancy_text.requirement, vacancy_text.additional, vacancy.city_id, city_text.name as city_name FROM vacancy, vacancy_text, vacancy_category, vacancy_category_text, city_text WHERE vacancy_category.category_id=vacancy.category_id AND vacancy_category.category_id=vacancy_category_text.category_id AND vacancy_category.is_published=1 AND vacancy.is_published=1 AND vacancy_category_text.lang_id = 2 AND vacancy_text.vacancy_id = vacancy.vacancy_id AND vacancy_text.lang_id = 2 AND city_text.city_id = vacancy.city_id AND city_text.lang_id = 2 AND vacancy.vacancy_id = 26' ORDER BY vacancy.sort_order, city_text.name 

/var/www.kyivstar.net/www//../data/classes/sql.p(139)
exception.type=sql.execute 
--------------------------------------------------------------------------------
sql /var/www.kyivstar.net/www//../data/classes/sql.p(139)
jSql /var/www.kyivstar.net/www//../data/classes/sql.p(275)
jSql /var/www.kyivstar.net/www//../data/classes/sql.p(284)
if /var/www.kyivstar.net/www//../data/classes/sql.p(284)
_execute /var/www.kyivstar.net/www//../data/classes/sql.p(275)
if /var/www.kyivstar.net/www//../data/classes/sql.p(256)
_sql /var/www.kyivstar.net/www//../data/classes/sql.p(139)
jBody /var/www.kyivstar.net/www//../data/classes/sql.p(246)
code /var/www.kyivstar.net/www//../data/classes/common/lib.p(361)
if /var/www.kyivstar.net/www//../data/classes/common/lib.p(333)
run_time /var/www.kyivstar.net/www//../data/classes/sql.p(246)
_measure /var/www.kyivstar.net/www//../data/classes/sql.p(138)
table /var/www.kyivstar.net/www//../data/processes/vacancy.bp(11)
showVacancy /var/www.kyivstar.net/www//../data/processes/vacancy.bp(4)
if /var/www.kyivstar.net/www//../data/processes/vacancy.bp(3)
main /var/www.kyivstar.net/www//../data/classes/engine.p(2284)
trim /var/www.kyivstar.net/www//../data/classes/engine.p(2284)
rem /var/www.kyivstar.net/www//../data/classes/engine.p(2284)
if /var/www.kyivstar.net/www//../data/classes/engine.p(2282)
executeProcess /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(111)
parseBlockPostProcess /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(111)
parseBlock_data /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(111)
if /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(107)
if /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(99)
if /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(98)
menu /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(97)
processBlocks /var/www.kyivstar.net/www//../data/classes/engine.p(1513)
parseBlockPostProcess /var/www.kyivstar.net/www//../data/classes/engine.p(1513)
sort /var/www.kyivstar.net/www//../data/classes/engine.p(1513)
if /var/www.kyivstar.net/www//../data/classes/engine.p(1511)
if /var/www.kyivstar.net/www//../data/classes/engine.p(1504)
executeBlocks /var/www.kyivstar.net/www//../data/classes/engine.p(1821)
data /var/www.kyivstar.net/www//../data/classes/engine_kyivstar.p(53)
pagePreProcess /var/www.kyivstar.net/www//../data/classes/engine.p(1819)
defaultPage /var/www.kyivstar.net/www//../data/processes/common.pp(2)
main /var/www.kyivstar.net/www//../data/classes/engine.p(2284)
trim /var/www.kyivstar.net/www//../data/classes/engine.p(2284)
rem /var/www.kyivstar.net/www//../data/classes/engine.p(2284)
if /var/www.kyivstar.net/www//../data/classes/engine.p(2282)
executeProcess /var/www.kyivstar.net/www//../data/classes/engine.p(1454)
if /var/www.kyivstar.net/www//../data/classes/engine.p(1453)
generatePage /var/www.kyivstar.net/www//../data/classes/engine.p(1398)
_content /var/www.kyivstar.net/www//../data/classes/engine.p(1419)
if /var/www.kyivstar.net/www//../data/classes/engine.p(1410)
if /var/www.kyivstar.net/www//../data/classes/engine.p(1394)
if /var/www.kyivstar.net/www//../data/classes/engine.p(1393)
execute /var/www.kyivstar.net/www/_doc.html(106)
object /var/www.kyivstar.net/www/_doc.html(105)
jBody /var/www.kyivstar.net/www//../data/classes/oracle.p(40)
jBody /var/www.kyivstar.net/www//../data/classes/sql.p(76)
connect /var/www.kyivstar.net/www//../data/classes/sql.p(76)
inc /var/www.kyivstar.net/www//../data/classes/sql.p(76)
server /var/www.kyivstar.net/www//../data/classes/oracle.p(35)
server /var/www.kyivstar.net/www/_doc.html(96)
jBody /var/www.kyivstar.net/www//../data/classes/cachepage.p(53)
trim /var/www.kyivstar.net/www//../data/classes/cachepage.p(53)
cache /var/www.kyivstar.net/www//../data/classes/cachepage.p(51)
run /var/www.kyivstar.net/www/_doc.html(94)