PHP Info: PHP Version 4.4.3
It's basically the same error as a bug here: https://efiction.org/forums/index.php?topic=3422.0
This was working last night, but when I woke up this morning I recieved emails about it.
It's happening on Most Recent, Categories, Series, and Titles. Authors and Challenges are fine.
http://www.trackbunnies.org/browse.php?type=recent
http://www.trackbunnies.org/browse.php?type=titles
http://www.trackbunnies.org/browse.php?type=categories
http://www.trackbunnies.org/browse.php?type=series
The error on the titles page says this:
Warning: implode() [function.implode]: Bad arguments. in /home/trackbun/public_html/includes/corefunctions.php on line 447
A fatal MySQL error was encountered.
Query: SELECT COUNT(seriesid) FROM fanfiction_series as series WHERE FIND_IN_SET(Yes, I do., series.classes) > 0 AND FIND_IN_SET(No, I don't., series.classes) > 0 AND FIND_IN_SET(I don't care., series.classes) > 0
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'do., series.classes) > 0 AND FIND_IN_SET(No, I don't., series.classes) > 0 AND F' at line 1
I also went in to repair the databases and that didn't work.
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
It's something in the latest browse.php file... because I just uploaded the browse.php file from one of the August test versions and it works.
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
From searching it...
This is in the latest browse.php...
if($classin) {
foreach($classin as $class) {
if(empty($class)) continue;
$query[] = "FIND_IN_SET($class, stories.classes) > 0";
$countquery[] = "FIND_IN_SET($class, stories.classes) > 0";
$scountquery[] = "FIND_IN_SET($class, series.classes) > 0";
$searchVars["classin"] = $classin
;
But this is in the older version...
if(!empty($classes)) {
foreach($classes as $cl) {
if(!isNumber($cl)) continue; // Just a bit of paranoia
$storyquery[] = "FIND_IN_SET('$cl', stories.classes) > 0";
$seriesquery[] = "FIND_IN_SET('$cl', series.classes) > 0";
$countquery[] = "FIND_IN_SET('$cl', classes) > 0";
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
This is an already known issue, but it has absolutely nothing to do with the error you cited. It's a conflict with the poll block. Turn the poll block off or set it to index only for now.
Thanks!
I did that and that worked but there's still an error at the top of the "titles" page:
http://trackbunnies.org/browse.php?type=titles
Warning: implode() [function.implode]: Bad arguments. in /home/trackbun/public_html/includes/corefunctions.php on line 447
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
I'm not getting that error when I click on that URL.
Really?
Maybe it has to do with membership?
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
I woke up this morning and had a ton of emails....
For some reason:
http://www.trackbunnies.org/browse.php?type=recent
It gets an error and it just popped up out of nowhere (I did no work on that page last night). I did try to install the Recommendation Module from Tammy's site and then uninstalled it.
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
Please DO NOT tack new bugs onto old threads. Start a new thread and turn debug on for your site.
Okay, I figured I'd just use the same thread b/c I thought I'd get in trouble if I started another one.
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
Then you probably need to go back and read the "Please Read Before Posting" thread again.
