URL to your eFiction: www.spntwisted.com
Version of eFiction: 3.2
Have you bridged eFiction, if so with what?: no
Version of PHP: PHP Version 5.1.4
Version of MySQL: 4.0
Have you searched for your problem: yes
If so, what terms did you try: categories, search, full text and a few others
State the nature of your problem: See below
Do you have a test account for us? Tammy has an account created.
Mods? I have the Recommendations module, Story End module, and Beta Reader search mods from Tammy's site installed. Also this mod by jrabbit is installed: https://efiction.org/forums/index.php?topic=4743.0
I don't know if these problems were there before I upgraded from 3.1.1 or not but I'm pretty sure they weren't.
1. Full Text Search does not work. Penname, title, and summary searches seem to work fine. If I try to search using full text search mode it says 0 results
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
If you are storing stories in files instead of the database, I don't think full text will work.
I'm using the database.
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
It doesn't even display the option to use full text search unless the stories are in the database.
I haven't tested this as I don't have access to a site where stories are in the database but it looks like the count query is corrupt in search.php. Line 52 should read:
$countquery = "SELECT count(stories.sid) FROM ".$tableprefix."fanfiction_stories as stories, ".$tableprefix."fanfiction_chapters as chapter WHERE chapter.storytext LIKE '%$searchterm%' AND chapter.sid = stories.sid GROUP BY stories.sid";
I tried that and got this. Of course there is always the chance I did something wrong. In fact it's probably likely I did something wrong. If you want access to my site just let me know jrabbit. I changed it back to the original search.php after the error.
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, DATE_FORMAT(stories.date, 'M d, Y') as date, DATE_FORMAT(stories.updated, 'M d, Y') as updated, , DATE_FORMAT(stories.updated, '%Y.%m.%d') as updatesort FROM fanfiction_authors as author, fanfiction_stories as stories, fanfiction_chapters as chapter WHERE chapter.storytext LIKE '%yet%' AND chapter.sid = stories.sid ORDER BY updated DESC LIMIT 0, 25
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 ' DATE_FORMAT(stories.updated, '%Y.%m.%d') as updatesort FROM fa
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
There's an extra comma after updated. I'm working on fixing it.
Thanks Tammy.
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
Are you good with this issue now Saturn?
Was this fixed in 3.2.1? I'll post again to let you know if it works after I upgrade.
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
Yes, this should be fixed with 3.2.1
http://www.spntwisted.com/search.php
I used the full text feature and it does indeed work but it still has a bug. I searched for a few different words to verify but here's what happens now.
I searched for the word Wishnik since I knew it would only be in one story.
1.The dates are wrong, but only on the search result page that I can tell. All the results showed: Published: Dec 31, 1969 Updated: Dec 31, 1969
2.It seems to return an entry for the story but shows it multiple times by every author on the site. (It might not be EVERY author but it looks like it)
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
Any update on this?
My site: www.spntwisted.com
eFiction: 3.5.1
Have you bridged eFiction?: no
PHP Version 4.3.11
MySQL: 5.0
Mods? Recommendations mod, Story End mod, Beta Reader mod, challenges mod
Change the query on line 51 to:
$query = "SELECT stories.*, "._PENNAMEFIELD." as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_stories as stories, ".TABLEPREFIX."fanfiction_chapters as chapter WHERE chapter.storytext LIKE '%$searchterm%' AND chapter.sid = stories.sid AND stories.uid = "._UIDFIELD;
Bump. Can someone confirm this is fixed now?
Bump again.
