Query removal

[Rose]

I need to remove a few queries in the database. The reason - two hacks conflicting. I had the vB quiz hack installed, but removed it. So I thought. I didn't remove the queries.

Now, I want to install the "Post Prefix" hack. Unfortunately, there's a conflict with duplicate id's.

Now, I don't know if I can simply change the id number in the post prefix hack and make that work, or if the quiz queries need to be removed.

I believe there's three of them.

If you have suggestions, I'd love to hear!

[g-force2k2]

Rose can you show me the queries you ran for the vbQuiz hack... and then i'll just show you how to remove them :P regards..

g-force2k2

[Rose]

Hrm...Well, I ran the install script that did it all automatically. I'll attach the file (this file is written by TWTCommish and is all his. I own nothing).

[Chris M]

Ah yes...Personally, I would not alter the Quiz Table...

Instead change the setting ids of the "Post Prefix" hack...Strange...The Post Prefix Hack I used had no complications, and I have the Quiz & Post Prefixes installed:)

Satan

[Rose]

Hrm. I don't need the quiz hack....

And yeah, I don't know where the conflicts came from. But three of the queries came back with duplicate errors.

And in the admin cp, under the "post prefix" section in "vbulletin options" - it has the right header "Post Prefix" but all the options are the quiz options.

[Chris M]

Hmm...

Weird...

Would you mind posting up the Queries you used?

Satan

[g-force2k2]

DELETE FROM settinggroup WHERE display=99
DELETE FROM setting WHERE settinggroupid=99
DELETE TABLE quiz
DELETE TABLE quiz_answers
DELETE TABLE quiz_categories
DELETE TABLE quiz_questions
DELETE TABLE quiz_results
DELETE TABLE quiz_temp

Run all of those queries should uninstall all the queries...

g-force2k2

[Rose]

Error
SQL-query :

DELETE TABLE quiz_temp


MySQL said:


You have an error in your SQL syntax near 'TABLE quiz_temp' at line 1

Hrm, I'm getting the above error message with each query. An error in SQL syntax near "query" at line 1 (or 2).

:s

HellSatan - pay attention! I posted the file that has the queries above. ;) :p *hehe*

[NTLDR]

Try:

DELETE FROM settinggroup WHERE displayorder=99;
DELETE FROM setting WHERE settinggroupid=99;
DROP TABLE quiz_answers;
DROP TABLE quiz_categories;
DROP TABLE quiz_questions;
DROP TABLE quiz_results;
DROP TABLE quiz_temp;

Making sure you run each one individually

[g-force2k2]

whoops :p i meant DROP not DELETE but thanks as always for NTLDR for being there when i needed it :) regards...

g-force2k2

[Rose]

Thanks to both of you for being there when I needed you. :)

The queries are removed. NTLDR has the patience of Jobe (if that's right...:s) and he walked me through it in im. Thanks!

Of course, now that that's fixed, I'm told that there's a better prefix hack than what I"m using and.....:(

* Rose mopes off to worry with it tomorrow

[Chris M]

Lol...

I would have helped, but was away with cousins, so...Anyway - Glad you found some:)

Satan