PDA

View Full Version : Error after installing patch


Mumszone
04-03-2007, 08:45 AM
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
04-03-2007, 11:01 AM
Hi Mumszone,

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

Mumszone
04-04-2007, 10:45 PM
Sorry but I have had to revert back to previous now as I couldnt get to approve any links

Dave Baker
04-04-2007, 11:09 PM
Hello Mumszone,
Please check this thread:
http://www.esyndicat.com/forum/about9828.html

Mumszone
04-05-2007, 11:33 AM
Thanks that seems to have fixed it. Its just my cron that doesnt seem to be working now

Sergey Ten
04-06-2007, 04:54 AM
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
04-29-2007, 07:41 AM
I have no cron available. what can i do to run the script properly without cron jobs?

lumi

Sergey Ten
04-30-2007, 08:38 AM
Hello lumi,

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