SQL Error when filtering by favourites
Posted: Thu Jan 01, 2009 6:35 pm
Hi guys,
You have an invalid entry in your sql statement when filtering the webteases by "my favourites." I'm not sure if this problem is specific to me or if it's global, but I didn't see any posts up about it so far.
I'm pretty sure the invalid sql call is responsible for this php error as well, found on the same page:
Hope you can fix it... I tend to rely on the favourites section rather than bookmarking individual teases.
Patch
You have an invalid entry in your sql statement when filtering the webteases by "my favourites." I'm not sure if this problem is specific to me or if it's global, but I didn't see any posts up about it so far.
Code: Select all
Database Error: Invalid MySQL-Query!
Unknown column 'f.id' in 'where clause'
#0 jmDB::error(Invalid MySQL-Query!, Array ([query] => ,[db_error] => Unknown column 'f.id' in 'where clause',[db_errno] => 1054)) called at [/var/www/com.milovana/lib/jmDB/connector/mysqli.php:314]
#1 jmDBOperation_mysql->do_count_sql(SELECT COUNT(*) as count FROM webteases_teases as t WHERE (f.id IS NOT NULL) AND (t.visible = 1);) called at [/var/www/com.milovana/webteases/list.php:70]
Database Error: Invalid MySQL-Query!
Unknown column 'f.id' in 'where clause'
SELECT t.* FROM webteases_teases as t WHERE (f.id IS NOT NULL) AND
(t.visible = 1) ORDER BY t.published DESC LIMIT 0, 10;
#0 jmDB::error(Invalid MySQL-Query!, Array ([query] => SELECT t.* FROM webteases_teases as t WHERE (f.id IS NOT NULL) AND (t.visible = 1) ORDER BY t.published DESC LIMIT 0, 10;,[db_error] => Unknown column 'f.id' in 'where clause',[db_errno] => 1054)) called at [/var/www/com.milovana/lib/jmDB/connector/mysqli.php:241]
#1 jmDBOperation_mysql->do_get_sql(SELECT t.* FROM webteases_teases as t WHERE (f.id IS NOT NULL) AND (t.visible = 1) ORDER BY t.published DESC LIMIT 0, 10;) called at [/var/www/com.milovana/webteases/list.php:151]Code: Select all
Warning: Invalid argument supplied for foreach() in /var/www/com.milovana/webteases/list.php on line 170Patch
