Error after installing patch

[Mumszone]

Since upgrading when I click on manage listings I get the following error:-

Error: Unknown column 't1.' in 'order clause'
SELECT t1.*, `t1`.`comments_active` `comments`, t44.`id` id_category, t44.`title` category_title, t44.`path` path, t4.`crossed` crossed FROM `v21_links` t1 LEFT JOIN `v21_link_categories` t4 ON t1.`id` = t4.`id_link` AND t4.`crossed` = '0' LEFT JOIN `v21_categories` t44 ON t44.`id` = t4.`id_category` ORDER BY t1.`` DESC LIMIT 0, 20

This means I cant approve the new listings at all has anyone else had this?

[John Turner]

Hi Mumszone,

Please provide me with FTP and AdminPanel credentials, I'll help you, and I'll post results here.

[Mumszone]

Sorry but I have had to revert back to previous now as I couldnt get to approve any links

[Dave Baker]

Hello Mumszone,
Please check this thread:
http://www.esyndicat.com/forum/about9828.html

[Mumszone]

Thanks that seems to have fixed it. Its just my cron that doesnt seem to be working now

[Sergey Ten]

Hello Mumszone,

There is new cron jobs file in the patch 2.1.03 (includes/cron).

Also read this article:
http://www.esyndicat.com/support/desk/knowledgebase/view/7.html

[lumi]

I have no cron available. what can i do to run the script properly without cron jobs?

lumi

[Sergey Ten]

Hello lumi,

Please send me your FTP details and I will check that. Thanks.