CricketMX.com

Posted: **Fri Feb 18, 2011 4:43 pm**

thank you very much.

Posted: **Fri Feb 18, 2011 5:12 pm**

I think I messed mine up. This came up:

Creating table phpbb_quiz...

Creating table phpbb_quiz_questions...

Creating table phpbb_quiz_statistics...

Installation is finished with no errors.

Then this:

General Error
SQL ERROR [ mysqli ]

Table 'zz_mk1.quiz_categories_table' doesn't exist [1146]

SQL

SELECT * FROM QUIZ_CATEGORIES_TABLE ORDER BY quiz_category_name ASC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_quiz.php
LINE: 172
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_quiz->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Posted: **Fri Feb 18, 2011 5:16 pm**

Abera, which page were you on when that error occurred? From the error, I assume the ACP?

Did you definitely update the files (in particular /includes/quiz/quiz.php - which is where QUIZ_CATEGORIES_TABLE is defined)?

Also, did you accidentally run quiz_installer.php from v2.1.0 instead of the one included in v2.1.1? Because in your message above it doesn't say "Creating table phpbb_quiz_categories..."

Posted: **Fri Feb 18, 2011 5:25 pm**

battye wrote:Abera, which page were you on when that error occurred? From the error, I assume the ACP?

Did you definitely update the files (in particular /includes/quiz/quiz.php - which is where QUIZ_CATEGORIES_TABLE is defined)?

Also, did you accidentally run quiz_installer.php from v2.1.0 instead of the one included in v2.1.1? Because in your message above it doesn't say "Creating table phpbb_quiz_categories..."

I updated all of the files and ran the v2.1.1 installer. Some how I tend to think it was my fault as always. Looks like I'll have to start all over again.
Thanks and will get back.

Posted: **Fri Feb 18, 2011 5:37 pm**

Make sure that

Code: Select all

define('QUIZ_CATEGORIES_TABLE', $table_prefix . 'quiz_categories');

Is on the second last line of includes/quiz/quiz.php - if it is, then that file is okay and the problem lies elsewhere.

Edit: Something I just thought of... did you run quiz_installer.php before you uploaded the modified files?

Posted: **Fri Feb 18, 2011 6:02 pm**

battye wrote:Make sure that
Code: Select all
define('QUIZ_CATEGORIES_TABLE', $table_prefix . 'quiz_categories');
Is on the second last line of includes/quiz/quiz.php - if it is, then that file is okay and the problem lies elsewhere.

Edit: Something I just thought of... did you run quiz_installer.php before you uploaded the modified files?

The includes/quiz/quiz.php is fine and I completely started over. All of the edits for the MOD and uploaded all of the new files. Then ran the install. Now it shows:
General Error
SQL ERROR [ mysqli ]

Table 'phpbb_quiz' already exists [1050]

SQL

CREATE TABLE phpbb_quiz ( quiz_id INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY, quiz_name VARCHAR(255) NOT NULL, quiz_time INT(20) NOT NULL, quiz_category INT(5) NOT NULL, user_id INT(8) NOT NULL, username VARCHAR(255) NOT NULL, user_colour VARCHAR(10) NOT NULL )

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: quiz_installer.php
LINE: 74
CALL: dbal_mysqli->sql_query()

Sorry for all of the hassle.

Thanks

PS
I did the MOD file edits over.

Posted: **Fri Feb 18, 2011 7:28 pm**

Here is all that I'm seeing:

My quiz.php

db tables

Cats page

After sub
Thanks

Posted: **Fri Feb 18, 2011 7:34 pm**

Post contents removed to avoid confusion with my new post below.

Posted: **Fri Feb 18, 2011 9:54 pm**

There is a missing comma in the quiz_installer.php (211 Alpha 2) file which will cause a syntax error during installation. Before running this file, you must edit quiz_installer.php and add a comma at end of following line:

Incorrect:

Code: Select all

('qc_cash_column', 'user_points', 1)

Correct:

Code: Select all

('qc_cash_column', 'user_points', 1),

Install will then work.

IF ACP Quiz module doesn't show; go to ACP > System (tab) > Module management : Administration Control Panel. To right of Quiz module is "Enable". Click on this. You may also need to Purge the cache as well: ACP > General (tab) : Purge the cache.

As battye mentioned, immediately create a new Category within ACP > UQM before proceeding any further (i.e. create quiz).

------------------------------------------------------------

New issue:

ACP > UQM > Create category. Entered a name then on Submit. Received this error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Incorrect integer value: 'General' for column 'quiz_category_name' at row 1 [1366]

SQL

INSERT INTO phpbb_quiz_categories (quiz_category_name) VALUES ('General')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_quiz.php
LINE: 86
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_quiz->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Easily solved. I've altered (via phpMyAdmin):

Code: Select all

quiz_category_namae INT(5) NOT NULL

to:

Code: Select all

quiz_category_name VARCHAR(255) NOT NULL

---------------------------------------------------------

Couple of questions although it's common sense from the "controller" really:

Will ACP > UQM be foolproof? Examples:

The maximum number of questions field MUST be greater than the minimum number of questions field. ATM, anything can be entered. Although on testing (create a Quiz) it didn't cause any conflict.

Maximum multiple choices - d/b accepts zero. Think this needs to be at least a minimum of Two. (true/false for example).

--------------------------------------------------------------------------

I don't have any form of Cash/Points MOD so can't comment on this section.

Posted: **Fri Feb 18, 2011 10:05 pm**

good evening
when I want to start installing the update I get this error message.

Code: Select all

Erreur générale
SQL ERROR [ mysql4 ]

Table 'phpbb3_quiz_categories' already exists [1050]

SQL

CREATE TABLE phpbb3_quiz_categories ( quiz_category_id INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY , quiz_category_name INT(5) NOT NULL )

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: quiz_installer.php
LINE: 48
CALL: dbal_mysql->sql_query()

and

Code: Select all

Warning: Cannot modify header information - headers already sent by (output started at /home/forumsfa/public_html/personnel/gratuits/arcades-et-jeux-35/quiz_installer.php:1) in /home/forumsfa/public_html/personnel/gratuits/arcades-et-jeux-35/includes/functions.php on line 2678

can u help me please

Posted: **Sat Feb 19, 2011 12:52 am**

quahappy wrote:
New issue:

Easily solved. I've altered (via phpMyAdmin):
Code: Select all
quiz_category_namae INT(5) NOT NULL
to:
Code: Select all
quiz_category_name VARCHAR(255) NOT NULL

Worked great for me.
Thanks

Posted: **Sat Feb 19, 2011 12:56 am**

All is working fine for me, but I'd like to change a color.
Color change.
Thank you all for the help.

Posted: **Sat Feb 19, 2011 4:44 am**

Thanks for picking those things up quahappy

I have made and uploaded the changes, if anyone wants the updated package (only quiz_installer.php has changed).
And a good point about ACP validity checking - will add it to the list for 2.1.2

Clenzowen - do you have phpMyAdmin? As quahappy mentioned, there was a mistake in the categories table query which made the category name a number instead of a string (words).

Abera, the colour is the same used as in polls.

Posted: **Sat Feb 19, 2011 6:37 am**

Hello
how are you?
yes I have my php admin, what should I do to repair the error because of the sudden we can no longer play the quiz on the forum

Posted: **Sat Feb 19, 2011 7:05 am**

In phpMyAdmin find the phpbb_quiz_categories table, click "Structure", then find "quiz_category_name". Edit that row by clicking the small pencil button. Change "Type" to VARCHAR and "Length/values" to 255 and submit the changes

CricketMX.com

[ALPHA] Ultimate Quiz MOD v2.1.2 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 1] Ultimate Quiz MOD v2.1.0 Progress

Re: [ALPHA 2] Ultimate Quiz MOD v2.1.1 Progress

Re: [ALPHA 2] Ultimate Quiz MOD v2.1.1 Progress