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');
I have this error.
Erorr! In Quiz Install
Moderator: CricketMX Forum Moderators
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:
#1067 - Invalid default value for 'stats_id'
While i try manual
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:
#1067 - Invalid default value for 'stats_id'
While i try manual
Second Erorr.
Query 17 did not execute correctly
DEBUG MODE
SQL Error : 1054 Unknown column 'user_points' in 'field list'
UPDATE phpbb_config SET config_value = user_points WHERE config_name = 'Quiz_Cash_Currency'
Line : 84
File : admin_quiz.php
2 Erorrs
Query 17 did not execute correctly
DEBUG MODE
SQL Error : 1054 Unknown column 'user_points' in 'field list'
UPDATE phpbb_config SET config_value = user_points WHERE config_name = 'Quiz_Cash_Currency'
Line : 84
File : admin_quiz.php
2 Erorrs
Coding is not my forte but...Google is my friend
I searched for...
Query 17 did not execute correctly
http://www.google.com/search?hl=en&q=Qu ... arch&meta=
The first result would appear to be what you are looking for...
I searched for...
Query 17 did not execute correctly
http://www.google.com/search?hl=en&q=Qu ... arch&meta=
The first result would appear to be what you are looking for...
That's not the man in the moon...that's me
Yep, that's right.
I have just updated the sticky to have a link as well, because a few people have asked this.
I have just updated the sticky to have a link as well, because a few people have asked this.
I get the error "Query 17 did not execute correctly". Help.
This is very easy to fix. It is just a small bug in admin_quiz.php. Replace the current admin_quiz.php file with the file found at http://forums.cricketmx.com/viewtopic.php?p=57367#57367 and you will not get error.
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
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');
You didn't answer this one.
that's in database erorr
You didn't answer this one.
that's in database erorr
DEBUG MODE
SQL Error : 1146 Table 'ecmekoh_portal.phpbb_quiz_statistics' doesn't exist
SELECT stats_id FROM phpbb_quiz_statistics ORDER BY stats_id DESC LIMIT 1
Line : 31
File : functions_quiz.php
Comes with error.
I know why comes see post 1
SQL Error : 1146 Table 'ecmekoh_portal.phpbb_quiz_statistics' doesn't exist
SELECT stats_id FROM phpbb_quiz_statistics ORDER BY stats_id DESC LIMIT 1
Line : 31
File : functions_quiz.php
Comes with error.
I know why comes see post 1
Do you use MySQL?
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
I vaguely remember fixing this a few years ago.
Try:
Does that work?
Try:
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');
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
No worries!
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)