Erorr! In Quiz Install

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

Post Reply
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

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.
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

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
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

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 :(
User avatar
moongirl
Moderator
Moderator
Posts: 19016
Joined: Mon Jan 12, 2004 8:07 am

Coding is not my forte but...Google is my friend :wink:

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...
Image
That's not the man in the moon...that's me ;)
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

Yep, that's right.

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)
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

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
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

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 :)
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

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)
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

Yes i'm using MYSQL.

Something wrong with `stats_id` as i see
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

I vaguely remember fixing this a few years ago.

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'); 
Does that work?
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)
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

Your SQL query has been executed successfully (Query took 0.0111 sec)


Thank You :)
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

No worries! :mrgreen:
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)
bIgEr
Greenhorn
Greenhorn
Posts: 9
Joined: Fri Nov 02, 2007 3:54 am

Quiz Results

Correct Answers: 5 Incorrect Answers: 0

100%
You took 0 minutes, 5 seconds


Now works great .

Thanks again .. And thanks for this MOD
Post Reply