Urgent! Error when installing!

[nirmah]

Hey Revan! I'm trying to install the RPG Integration hack on a vB 3.0.6 that has only the latest uCS installed. But when I try to run the installer.php, I get the following error when I click install.


Database error in vBulletin 3.0.6:

Invalid SQL: CREATE TABLE `rpg_clan` (
`clanid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`leader` varchar(50) NOT NULL default '',
`clanpoints` varchar(5) NOT NULL default '',
`logo` varchar(100) NOT NULL default '',
`ally` varchar(10) NOT NULL default '0',
`enemy` varchar(10) NOT NULL default '0',
`maxmem` int(3) NOT NULL default '5',
`col1` varchar(5) NOT NULL default '0',
`col2` varchar(5) NOT NULL default '0',
`col3` varchar(5) NOT NULL default '0',
`col4` varchar(5) NOT NULL default '0',
`cm_col_access` varchar(5) NOT NULL default '0',
`ci_col_access` varchar(5) NOT NULL default '0',
`rm_col_access` varchar(5) NOT NULL default '0',
`clanmidiurl` varchar(100) NOT NULL default '',
PRIMARY KEY (`clanid`)
) TYPE=MyISAM;
mysql error: Table 'rpg_clan' already exists

mysql error number: 1050

Date: Friday 18th of February 2005 10:32:50 PM
Script: http://www.xxxxxxxxxx.net/forums/installer/battleinstall.php?step=1
Referer: http://www.xxxxxxxxxx.net/forums/installer/battleinstall.php?step=1
Username: Static
IP Address: 210.21.235.18

[Marco van Herwaarden]

'rpg_clan' is not a standard vB or a uShop table. So your database is not a clean 3.0.6 database.

[nirmah]

How can that be when I installed vB on an empty database, then installed uCS, then now tried to install the RPG?

[Revan]

<a href="https://vborg.vbsupport.ru/showthread.php?t=75841" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=75841</a>
This thread has every piece of info you need.

I am hoping to get v3 Beta 1 out by the end of March at the latest (as per my zig), at which point all these errors will be history.

[nirmah]

I'm a n00b when it comes to MySQL. Revan, could you explain to me more indepth starting from when I first got the error? For example, I have no clue about the post here.

https://vborg.vbsupport.ru/showpost.php?p=608403&postcount=7

[Revan]

Just edit the installer file instead, you dont have to piss about with MySQL.
Since you have managed to edit vB files with RPG coding, I assume you can edit the installer file too ;)

As it says, before the first instance of $DB_site->query add the code in the first box, and after the last instance of $DB_site->query add the code in the second box.
Then run the installer again.

[nirmah]

Database error in vBulletin 3.0.6:

Invalid SQL: CREATE TABLE `rpg_lottery` (
`lotteryid` int(5) NOT NULL auto_increment,
`lotteryname` varchar(20) NOT NULL default '',
`lotterym` varchar(50) NOT NULL default '',
`prize` int(10) NOT NULL default '0',
`dateset` varchar(35) NOT NULL default '',
`dateend` varchar(35) NOT NULL default '',
`cost` int(6) NOT NULL default '0',
`sold` int(5) NOT NULL default '0',
`active` int(2) NOT NULL default '0',
`editing` int(5) NOT NULL default '',
PRIMARY KEY (`lotteryid`,`lotteryid`)
) TYPE=MyISAM;
mysql error: Duplicate column name 'lotteryid'

mysql error number: 1060

Date: Saturday 19th of February 2005 01:54:46 PM
Script: http://www.camphyrule.net/forums/installer/battleinstall.php?step=1
Referer: http://www.camphyrule.net/forums/installer/menue.htm
Username: Static
IP Address: 210.21.235.18


Still showing up. Could you instead send me a battleinstall.php with the code part fixed? I've added it before the first and after the last, but still doesn't seem to work. That'd be great Reven. Sorry for being such a problem, but I really hope to get this mod working! :)

[Revan]

Try this file then...

[nirmah]

Thanks Revan! The installation was smooth! But it seems that the text file RPG SYSTEM INSTALL should be fixed because some of the codes are different on vB 3.0.7. Thanks.

Never mind. I found out about those [....] things.

Now I'm done with the installation and tried to access pages such as the rpg.php, rpgcp.php, etc. But when I go there, I see a blank white page with nothing. Any idea what the problem could be?

Thanks

Fixed it myself. Thanks.

By the way, is the Automerged Doublepost a mod?

[Revan]

Yes that is a mod, to avoid n00bs who don't know what the "Edit" button does having spamming up the board with 15 posts in a row :p

And the instructions will of course be revamped for v3...
Currently working on the installer.