Please help - Challenges - MYSQL Error, Site nonfunctional!

Have you tried updating to 3.4.2?

Also it is telling you that tokiohot_new.fanfiction_challenges doesn't exist.  It looks like maybe you somehow tried to create a new challenges table in mySQL.  And i've never seen table prefixes with periods in them by the way.

Did you try and uninstall the challenges module? Did it work, or did you have errors? What were they?

My advice would be to go into your database using phpmyadmin, and delete the fanfiction_challenges table, and also the challenges row from the modules table.

I have the same problem.

A fatal MySQL error was encountered.
Query: SELECT count(chalid) FROM fanfiction_challenges
Error: (1146) Table 'quillsan_eFiction.fanfiction_challenges' doesn't exist

I did what Jan_AQ suggested and deleted both challenge rows from the module table, but I am still getting the same error. It looks like bug to me, but where!

Edit to add: I deleted the challenges folder from the server and I have the site up again. Is there anyway that I can get the challenges module installed again? And I have efiction 3.4.2 running.

You said you deleted both challenges rows, but did you delete the challenges TABLE?

So your site is working now? No errors, no problems, except you want challenges to be installed, and it currently isn't?

Please be more clear when asking for help! We also need each person to include the information, such as version number, mods, any edits to the script, and a link to your site. If we don't have that, we might not decide to help you.

You said you deleted both challenges rows, but did you delete the challenges TABLE?

There was no challenges Table created in my sql database, if there isn't a challenge table, then I can't delete it. I am not sure what happened with the previous module, challenges were hardly used by the admin who ran it, but we were planning to. I am really not kidding here.

So your site is working now? No errors, no problems, except you want challenges to be installed, and it currently isn't?

Yeps, I deleted the folder and those two rows from the module table and it was good to go.

Please be more clear when asking for help! We also need each person to include the information, such as version number, mods, any edits to the script, and a link to your site. If we don't have that, we might not decide to help you.

Oh, here we go then:

Site: http://www.quillsandink.com/fiction/
Version: 3.4.2 (direct upgrade from 3.3.1)
Modules:  Challenges (previously but I deleted the folder and rows now, the rows stated Challenges 1.1 and Challenges 1.3)
PHP: 5.2.2
MySQL: 4.1.21
Have you searched for your problem: Yes, with the sql error text and challenges & 3.4

Run these queries using phpmyadmin:

CREATE TABLE `fanfiction_challenges` (
  `chalid` int(11) NOT NULL auto_increment,
  `challenger` varchar(200) NOT NULL default '',
  `uid` int(11) NOT NULL default '0',
  `title` varchar(250) NOT NULL default '',
  `catid` varchar(200) NOT NULL default '',
  `characters` varchar(200) NOT NULL default '',
  `summary` text NOT NULL,
  `responses` int(11) NOT NULL default '0',
  PRIMARY KEY  (`chalid`),
  KEY `title` (`catid`),
  KEY `uid` (`uid`),
  KEY `title_2` (`title`),
  KEY `characters` (`characters`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=128 ;

INSERT INTO `fanfiction_modules` VALUES(1, 'Challenges', '1.1');

Upload the challenges folder back into your remote modules server and see if it works.

Initially phpadmin came back with this error:

MySQL said: Documentation
#1103 - Incorrect table name 'quillsan_eFiction.fanfiction_challenges'

I removed 'quillsan_efiction.' from the query, ran the two queries and copied the challenge folder back. It took me a while and some more sql errors later (I at first could only edit the option if I wanted the challenges to be for members only, which came back with an sql error, so I reasoned that I first had to figure out how to add a challenge), to get it working & displayed at the archive (two useful threads 1 & 2are here). *knocks on hard wood* Thank you for your help & assistance Jan_AQ! I can make our challenge moderator very happy with this!  🙂

Glad to hear it worked! 🙂