SQL Error when filtering by favourites

[patchwolf]

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.

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]

I'm pretty sure the invalid sql call is responsible for this php error as well, found on the same page:

Code: Select all

Warning: Invalid argument supplied for foreach() in /var/www/com.milovana/webteases/list.php on line 170

Hope you can fix it... I tend to rely on the favourites section rather than bookmarking individual teases.

Patch

[str0be]

I get the same problem, so it is not just you patchwolf.

str0be

[King Sidrick]

Same problem here too. Any idea when it'll be fixed?

[seraph0x]

Fixed!