vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   Urgent! Error when installing! (https://vborg.vbsupport.ru/showthread.php?t=76612)

nirmah 02-19-2005 02:36 AM
Urgent! Error when installing!
 
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.

Code:
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 02-19-2005 06:15 AM
'rpg_clan' is not a standard vB or a uShop table. So your database is not a clean 3.0.6 database.

nirmah 02-19-2005 07:18 AM
How can that be when I installed vB on an empty database, then installed uCS, then now tried to install the RPG?

Revan 02-19-2005 10:42 AM
<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 02-19-2005 11:47 AM
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....03&postcount=7

Revan 02-19-2005 01:50 PM
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 02-19-2005 05:55 PM
Code:
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/ins...all.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 02-19-2005 11:53 PM
1 Attachment(s)
Try this file then...

nirmah 02-20-2005 05:52 AM
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 02-20-2005 10:49 AM
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.


All times are GMT. The time now is 01:21 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02270 seconds
  • Memory Usage 1,731KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete