Code: Select all
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
define('MULTIPLE_CHOICE', 'multiple_choice');
#
#-----[ AFTER, ADD ]------------------------------------------
#
define('MULTIPLE_CHECKBOX', 'multiple_checkbox');
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
battye wrote: Sorry for the delays, I'm glad most of the issues have been sorted though.
charades, regarding the bbcode error. Has the file been fully uploaded?
cwallace wrote: That seemed to work out that debug error, but THIS still plagues me...
SQL query:
CREATE TABLE phpbb_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'
);
MySQL said: Documentation
#1067 - Invalid default value for 'stats_id'
When I try to do the quiz_install.php file it gave me the code below in red saying it failed or had errors...then entering it manually I got the above return from phpmyadmin:
CREATE TABLE phpbb_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');
Anything on that? I will search their support site, but I have yet to get an admin approval for my account so I can only read and not post the problems there...I can search so I am at least doing that...
Thanks in advance...still snowed in..
Chris
Code: Select all
CREATE TABLE phpbb_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');
golgoth wrote: Put this in phpmyadmin:
in the meantime im upping my question: which lines should i change if i want cash to be removed when quiz is starting and not when i click on submit?Code: Select all
CREATE TABLE phpbb_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');