Line	Code /usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php
123	`{`
124	`<?php $t = esynDebug::m();`
125	`}`
126	`<?php`
127	`<?php $rs = mysql_query($aSql, $this->mLink);` #0 mysql_query(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5, Resource id #9) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:127] #1 esynDatabase.query(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198] #2 esynDatabase.getAll(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340] #3 esynListing.getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13] #4 eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399] #5 esynConfig.startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275] #6 require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41] WARNING mysql_query() [function.mysql-query]: Unable to save result set
128	`if (ESYN_DEBUG===2)`
129	`{`
130	`<?php $t = round(esynDebug::m() - $t,4);`
131	`<?php $t = "DB Query: \|".$t." ".$aSql;`
132	`<?php trigger_error($t, E_USER_NOTICE);`

Line

Code /usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php

123

124


<?php             $t = esynDebug::m();

125

126


<?php

127


<?php         $rs = mysql_query($aSql, $this->mLink);

#0  mysql_query(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5, Resource id #9) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:127]
#1  esynDatabase.query(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198]
#2  esynDatabase.getAll(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340]
#3  esynListing.getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13]
#4  eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399]
#5  esynConfig.startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275]
#6  require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41]

WARNING mysql_query() [function.mysql-query]: Unable to save result set

128


if (ESYN_DEBUG===2)

129

130


<?php             $t = round(esynDebug::m() - $t,4);

131


<?php             $t = "DB Query: |".$t." ".$aSql;

132


<?php             trigger_error($t, E_USER_NOTICE);

Error:

SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5

Debug backtrace:

#0 esynDatabase->query(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198] #1 esynDatabase->getAll(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340] #2 esynListing->getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13] #3 eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399] #4 esynConfig::startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275] #5 require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41]

Line	Code /usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php
156	`else`
157	`{`
158	`echo "<PRE>".mysql_errno().": ".$error."</PRE>";`
159	`}`
160	`<?php trigger_error("Database query error: ".strip_tags($data), E_USER_ERROR);` #0 trigger_error(Database query error: Error: SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5 Debug backtrace: #0 esynDatabase->query(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198] #1 esynDatabase->getAll(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340] #2 esynListing->getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13] #3 eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399] #4 esynConfig::startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275] #5 require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41] , 256) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:160] #1 esynDatabase.query(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198] #2 esynDatabase.getAll(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340] #3 esynListing.getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13] #4 eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399] #5 esynConfig.startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275] #6 require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41] Fatal ERROR Database query error: Error: SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, \'0\' `favorite` , \'0\' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = \'active\' AND t9.`status` = \'active\' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5\n\nDebug backtrace:\n#0 esynDatabase->query(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, \'0\' `favorite` , \'0\' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = \'active\' AND t9.`status` = \'active\' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198]\n#1 esynDatabase->getAll(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, \'0\' `favorite` , \'0\' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = \'active\' AND t9.`status` = \'active\' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340]\n#2 esynListing->getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()\'d code:13]\n#3 eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399]\n#4 esynConfig::startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275]\n#5 require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41]\n
161	`<?php`
162	`die("Fatal database error");`
163	`}`
164	`<?php`
165	`return $rs;`

Line

Code /usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php

156


else

157

158


echo "<PRE>".mysql_errno().": ".$error."</PRE>";

159

160


<?php             trigger_error("Database query error: ".strip_tags($data), E_USER_ERROR);

#0  trigger_error(Database query error: Error: SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5

Debug backtrace:
#0  esynDatabase->query(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198]
#1  esynDatabase->getAll(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340]
#2  esynListing->getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13]
#3  eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399]
#4  esynConfig::startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275]
#5  require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41]
, 256) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:160]
#1  esynDatabase.query(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198]
#2  esynDatabase.getAll(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, '0' `favorite` , '0' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340]
#3  esynListing.getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()'d code:13]
#4  eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399]
#5  esynConfig.startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275]
#6  require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41]

Fatal ERROR Database query error: Error: SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, \'0\' `favorite` , \'0\' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = \'active\' AND t9.`status` = \'active\' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5\n\nDebug backtrace:\n#0 esynDatabase->query(SELECT t1., `t1`.`comments_active` `comments`, t9.`path`, \'0\' `favorite` , \'0\' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = \'active\' AND t9.`status` = \'active\' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynDb.php:198]\n#1 esynDatabase->getAll(SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path`, \'0\' `favorite` , \'0\' `account_id_edit` FROM `v2203_listings` t1 LEFT JOIN `v2203_categories` t9 ON t1.`category_id` = t9.`id` WHERE t1.`status` = \'active\' AND t9.`status` = \'active\' ORDER BY t1.`date` DESC, `t1`.`sponsored` DESC, `t1`.`featured` DESC, `t1`.`partner` DESC LIMIT 0, 5) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/classes/esynListing.php:340]\n#2 esynListing->getLatest(0, 5, ) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php(399) : eval()\'d code:13]\n#3 eval() called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/config.inc.php:399]\n#4 esynConfig::startHook(bootstrap) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php:275]\n#5 require_once(/usr/www/users/maps97e8/eu-limodirectory.co.uk/includes/view.inc.php) called at [/usr/www/users/maps97e8/eu-limodirectory.co.uk/view-listing.php:41]\n

161


<?php

162


die("Fatal database error");

163

164


<?php

165


return $rs;