Helpful Information
 
 
Category: RPG Integration Hack
invalid?

First I want to say this hack looks sweet. Seen it a working version of it and now I got to have it on my board. Super job Revan and company…

Ok here is my dilemma. Added Ushop (no problems) and Downloaded the latest zip… Upload all the files and then tried running the installer. Everything is fine until I hit install. Then I get this…


Invalid SQL: CREATE TABLE `vbt_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 'vbt_rpg_clan' already exists

mysql error number: 1050

Date: Friday 21st of January 2005 01:41:49 AM
Script: http://www.mysite.com/testvb/installer/battleinstall.php?step=1
Referer: http://www.mysite.com/testvb/login.php


Uninstall works great by the way (lol)

If anyone can point me in the correct direction I am all ears… as I really want to install this. *Im still new to hacking so please describe in noob terms – I do great at following step by step directions. ;) *

Well. You should enter phpMyAdmin and manually delete the rpg_clan table.
Or you could run this: DROP TABLE IF EXISTS `vbt_rpg_clan`
You can run it from vB ACP provided that you set yourself the permissions in config.php :)

Whos the Man? You Are - thank you!

:banana: Ahh the little things that make us noobs happy :banana:

Im glad to be able to help, after all I didn't get this supportforum because I completely ignored the problems you guys have, now did I ;)

I am sorta puzzled on how the rpg_clan table could already exist in your database, since I assume you did a fresh install... :ermm:
Ah well, as long as it's sorted :)


//peace

I think there was something wrong beyond this hack on my test forum. What ever I tried to upload a file threw ftp, it would say it already existed and do I want to overright the file, even though I could plainly see the file was not their (even with refresh). As again this was my first time uploading and installing this.

Just for kicks. I deleted my test site and made another one from scratch. Behold no problems at all installing… Must have just been one of those weird anomalies that nobody can explain. Only real difference from the new test board and the old one is the old one was 3.0.3 and the new one is 3.0.6 (don't think that is the reason though.)

I’m going to do a few more test installs and then try it on my live board. Hopefully everything will go just as smooth. ;)










privacy (GDPR)