Hoorah! I fixed it!. Here is how I fixed my issue..
As I mentioned, I had a red line while installing. I should not have ignored that line. The line that was red was this one:
Code: Select all
CREATE TABLE apdphpbb_quiz_statistics ( `stats_id` int(5) NOT NULL default '', `quiz_id` int(10) NOT NULL default '', `user_id` int(10) NOT NULL default '', `stats_correct` INT(5) NOT NULL default '0', `stats_incorrect` INT(5) NOT NULL default '0', `stats_percentage` INT(3) NOT NULL default '0');
So, I logged into my phpmyadmin for my domain and checked the tables. quiz_statistics was not there. hmmm. So, I tried to manually run the SQL commands. It shot back at me that the default for 'stats_id' was invalid. So, I changed '' to '0' and ran it again. This time, 'quiz_id' was invalid. Dur! so, I stuck in a 0 for the other ones that where only '' and ran it again. It looked like this:
Code: Select all
CREATE TABLE apdphpbb_quiz_statistics ( `stats_id` int(5) NOT NULL default '0', `quiz_id` int(10) NOT NULL default '0', `user_id` int(10) NOT NULL default '0', `stats_correct` INT(5) NOT NULL default '0', `stats_incorrect` INT(5) NOT NULL default '0', `stats_percentage` INT(3) NOT NULL default '0');
This time, eveything went through fine. I re-submitted my quiz and Tada! everything works great.
Again, thanks for the great mod, you have no idea how much this is going to help us.