Install error... please help

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

Post Reply
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

I have installed this mod on my forum http://www.dinkydrinks.co.uk/forum.

As you can see the mod appears in the forum and i can see it in the admin panel... but i get this error when i click the link:-

error from clicking QUIZ in admin panel

Could not get category data

DEBUG MODE

SQL Error : S0002 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'phpbb_quiz_categories'.

SELECT * FROM phpbb_quiz_categories

Line : 338
File : admin_quiz.php

end of error

I get the following error when clicking the link to the QUIZZES from my forum home page:-

An Error Occurred

DEBUG MODE

SQL Error : S0002 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'phpbb_quiz_categories'.

Line : 984
File : quiz.php

Please help !!!
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

sorry... Bump, need some help urgent.
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

I don't know much about MSSQL (which I assume is what you are using) but I would think that suggests you haven't run the database changes yet (quiz_install.php).
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)
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

Hi Battye,

Cheers for the reply...

I have run the quiz_install.php - but for some reason the tables are not beeing inserted correctly using the install script u have provided.

Is there any chance you might now the changes needed to make it create them correctly.

Please advise as i think this is a great mod and wood dearly like to get it working for my members :)

kind regards

Jamie 2k
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

If you look at the database using phpMyAdmin (if phpMyAdmin works with MSSQL... it might only work with MySQL in which case you will need to look using something similar) can you see the quiz_categories table. Or any of the quiz tables?
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)
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

I have checked the tables and none are there...
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

Did you get errors when running quiz_install.php?
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)
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

battye wrote:Did you get errors when running quiz_install.php?
No Errors... just no tables...

can i manually add them by running a ms sql insert ?

I don't have phpmyadmin on this server, as its not mine

I am however able to run sql inserts using MS Sql Enterprise manager... does same as phpmyadmin to all intents and purposes.

Please can you tell me if this is possible and if so which tables are needed for the install to function properly.

kind regards

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

No Errors... just no tables...
What do you mean?

When you ran the file what appeared on the screen? A lot of green text, red text??? :?

If you wish to do it manually, you can. But it might take some time. Have a look inside quiz_install.php (open it in Notepad) for a list of the queries.
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)
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

This was in the top of the page in black:-

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '`'., SQL state 37000 in SQLExecDirect in w:\vh\d\dinkydrinks.co.uk\forum\db\mssql-odbc.php on line 171

This was then in a part of the page which looked like it had been created by the install script.

Ultimate Quiz MOD Installation
Ultimate Quiz MOD v1.2 Series
The script is now going to alter your forum database so the Ultimate Quiz MOD can function!
Any queries which are shown in green were executed successfully, those in red however, encountered a problem. It is absolutely vital that you have made all code changes already, and uploaded all quiz files to their respective locations.

CREATE TABLE phpbb_quiz ( `quiz_id` int(10) NOT NULL default '0', `quiz_name` varchar(200) NOT NULL default '', `quiz_author` int(10) NOT NULL default '0', `quiz_enabled` int(1) NOT NULL default '0', `quiz_category` int(5) NOT NULL default '0', `quiz_type` varchar(20) NOT NULL default '0', `quiz_plays` int(5) NOT NULL default '0');
CREATE TABLE phpbb_quiz_categories ( `category_id` int(5) NOT NULL default '0', `category_password` VARCHAR( 100 ) NOT NULL default '', `category_name` varchar(140) NOT NULL default '', `category_permissions` int(1) NOT NULL default '0', `category_description` varchar(255) NOT NULL default '');
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');
CREATE TABLE phpbb_quiz_multiple_choice_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_alternates` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_true_false_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_input_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL)
ALTER TABLE phpbb_sessions ADD `session_quiz_categories` VARCHAR( 255 ) NOT NULL;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_show_answers', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Register_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Count_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Requirement', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Play_Once', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Min_Max_Questions', '5,10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Mod', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Banned', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Moderators', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Stats_Display', '10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Mod_Submit', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Currency', 'user_points')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Incorrect', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Correct', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Tax', '2')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_CashMOD_On', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_packs_category', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_packs_bot', 'Quartz')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_timeout', '10')

Installation is complete, however, some errors were encountered. It is suggested that you rectify these problems before attempting to use the Ultimate Quiz MOD!
Jamie 2k
Greenhorn
Greenhorn
Posts: 7
Joined: Sat Feb 24, 2007 11:21 pm

i created the tables using a sql stripped from the quiz_install.php

this code created the tables with some strange looking names, which i changed... the structure and content in the tables looked ok

i edited the table names

but i now get the error from my insert about a stored procedure relating to 'user_id'

error
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'user_id'.

please help... i am slowly loosing the desire to run a comp mod :(
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

I have to be honest with you, I've never used MSSQL, so my knowledge is very limited.

As for that error, I have no idea what it means. I can only assume that maybe one of the settings for that column is not correct (maybe a default value needs to be set for instance)
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)
Post Reply