URL to your eFiction: http://www.hpfandom.net/eff/
Version of eFiction: 3.1.1, upgraded from 1.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.3 something
Version of MySQL: 4.1.14
Have you searched for your problem: yes
If so, what terms did you try: advanced search fatal error
State the nature of your problem:
I've installed the challenges module, and people are able to issue them, but when a user clicks on to "respond to the challenge" link they receive the following error
A fatal MySQL error was encountered.
Query: SELECT title, seriesid FROM fanfiction_series WHERE uid = '1' AND FIND_IN_SET(1, challenges) < 1 ORDER BY title ASC
Error: (1054) Unknown column 'challenges' in 'where clause'
Thanks,
ataraxis
It didn't get installed correctly. Uninstall the module and try again.
I uninstalled the module and reinstalled after uploading brand new files for the module and it's still giving me MySQL errors when a person clicks on the Respond to Challenge link.
A fatal MySQL error was encountered.
Query: SELECT title, seriesid FROM fanfiction_series WHERE uid = '1' AND FIND_IN_SET(1, challenges) < 1 ORDER BY title ASC
Error: (1054) Unknown column 'challenges' in 'where clause'
It's not installing correctly on your site. You are missing a field in the fanfiction_series table. You can add it manually from phpMyAdmin.
ALTER TABLE `PREFIXfanfiction_series` ADD `challenges` varchar(200) NOT NULL default '0'
Replace PREFIX with your table prefix.
Thank you so much Tammy for your help, that did indeed work. 😀
