[docvader]

Originally Posted by Justdave

Anyone write anymore quiz packs?

These are great, thanks in advance!!!

:squareeyed: Dave

I'm not exactly sure, from the instructions, how to upgrade the Inferno Quiz that I had running (successfully) on vb 3.07, to this current version.

I have upgraded by vb 3.07 to vb 3.52 without problems.

Now, to upgrade the quiz....

I tried the 2.1 to 2.2 instructions. No good.

I tried the "full install", and got this:

Database error in vBulletin 3.5.2:

Invalid SQL:
CREATE TABLE `quiz` (
`qid` INT( 15 ) NOT NULL AUTO_INCREMENT ,
`q_name` VARCHAR( 255 ) NOT NULL default '0',
`q_state` TINYINT( 2 ) NOT NULL default '0',
`q_perms` text not null,
`q_start` int(15) not null default '0',
`q_end` int(15) not null default '0',
`q_autoend` tinyint(2) not null default '0',
`q_timelimit` int(8) not null default '0',
`q_viewanswer` tinyint(2) not null default '0',
PRIMARY KEY ( `qid` )
) TYPE = MYISAM;;

MySQL Error : Table 'quiz' already exists
Error Number : 1050
Date : Sunday, December 18th 2005 @ 02:43:55 PM
Script : http://x.russbo.com/vbtest/admincp/install_quiz.php

I guess I'm just not sure how to upgrade the quiz, now that I've upgraded my vb that has an older version of the quiz on it.

The link to the quiz page now gives me this:
Database error in vBulletin 3.5.2:

Invalid SQL:
select * from quiz where q_state=1 order by qid desc limit 0,1;

MySQL Error : Unknown column 'q_state' in 'where clause'
Error Number : 1054
Date : Sunday, December 18th 2005 @ 02:53:24 PM
Script : http://x.russbo.com/vbtest/quiz.php?
Referrer : http://x.russbo.com/vbtest/index.php
IP Address : 67.77.47.30
Username : doc
Classname : vb_database

Any suggestions?

Thanks
rich