The Arcive of Official vBulletin Modifications Site.

An error in the rpg_install.php · **Released**: 03-06-2005

There's an error in rpg_install.php.

Code:

Parse error: parse error, unexpected ')', expecting ']' in /home/phalanx/public_html/testvb/admincp/rpg_install.php on line 1516

Fresh install on a test board in vB 3.0.7.

Revan · #2 03-06-2005, 12:53 AM

Fixed.
Add the ] it wants after the 'part' to fix it.

Ganon · #3 03-06-2005, 01:00 AM

Is the updated file in the ZIP? If not, exactly where do you add the ] -- my editing program doesn't give me line numbers unfortunately.

Blootix · #4 03-06-2005, 06:05 AM

Quote:

Originally Posted by Ganon

Is the updated file in the ZIP? If not, exactly where do you add the ] -- my editing program doesn't give me line numbers unfortunately.

Go download Notepad +. It's a free software that works great.

The zip is updated. I checked

.

Ok, now I got an SQL problem while I was running the installer and it came to the db part. I refreshed once, and got this:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
ALTER TABLE `vb3_user` 
	ADD `rpgclass` int(3) NOT NULL, 
	ADD `rpgrace` int(3) NOT NULL, 
	ADD `alignment` int(3) NOT NULL, 
	ADD `rpgtype` int(3) NOT NULL, 
	ADD `rpggender` int(3) NOT NULL,
	ADD `hp` int(6)  NOT NULL default '0', 
	ADD `maxhp` int(6)  NOT NULL default '0', 
	ADD `ma` int(6)  NOT NULL  default '0',    
	ADD `maxma` int(6)  NOT NULL  default '0',    
	ADD `pp` int(6)  NOT NULL  default '0',   
	ADD `maxpp` int(6)  NOT NULL  default '0',   
	ADD `ap` int(6)  NOT NULL  default '0',    
	ADD `element` int(3)  NOT NULL  default '0',    
	ADD `inbattle` int(3) NOT NULL default '0',
	ADD `xp` int(11)  NOT NULL  default '0',
	ADD `clan` smallint(5) NOT NULL default '0',
	ADD `chalable` tinyint(1) NOT NULL default '1'

mysql error: Duplicate column name 'rpgclass'

mysql error number: 1060

Help! Even though this is just a test board I want to have it running at the real board soon!

Revan · #5 03-06-2005, 10:01 AM

The parse error can safely be ignored, the entire hack was installed successfully.
What was NOT done though, is:
* Rebuild of datastore
* Rebuild of phrases
* Rebuild of styles

To remedy this:
Enter your ACP;
* open any random setting page, save the settings.
* Under Styles and templates, open any random template that you have modified before (important!), and save it instantly
* Under Languages and Phrases, click Language Manager, then Rebuild all languages.

Blootix · #6 03-06-2005, 02:57 PM

Quote:

Originally Posted by Revan

The parse error can safely be ignored, the entire hack was installed successfully.
What was NOT done though, is:
* Rebuild of datastore
* Rebuild of phrases
* Rebuild of styles

To remedy this:
Enter your ACP;
* open any random setting page, save the settings.
* Under Styles and templates, open any random template that you have modified before (important!), and save it instantly
* Under Languages and Phrases, click Language Manager, then Rebuild all languages.

Ok, did that.

However, on View Battles, Add Battle Scenes, Edit Battle Scenes, Add Battle Midis, Edit Battle Midis, and Prune Battles pages doesn't have words (In the ACP)

Edit Class Returns with:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT MAX(id) AS id_types FROM vb3_rpg_type ORDER BY name
mysql error: Table 'phalanx_testboard.vb3_rpg_type' doesn't exist

mysql error number: 1146

Add Classes returns with:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM vb3_rpg_type ORDER BY name
mysql error: Table 'phalanx_testboard.vb3_rpg_type' doesn't exist

mysql error number: 1146

Edit Lottery and Pick Winner returns with:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM vb3_rpg_lottery ORDER BY dateset asc
mysql error: Table 'phalanx_testboard.vb3_rpg_lottery' doesn't exist

mysql error number: 1146

Trying to do a DB fix comes with:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT 
				vb3_user.userid 
			FROM vb3_user 
				LEFT JOIN vb3_rpg_items_user ON vb3_user.userid=vb3_rpg_items_user.userid 
			WHERE vb3_rpg_items_user.userid IS NULL
		
mysql error: Table 'phalanx_testboard.vb3_rpg_items_user' doesn't exist

mysql error number: 1146

Also, when I go to any RPG pages such as "forums/battle.php" it comes with a blank page.

What should be done to fix these?

Revan · #7 03-06-2005, 04:19 PM

Weird... I saw the parse error right before the "done" step of the installer.
All I can say is that you have to manually drop the tables/fields created and Uninstall everything not query-related using the installer, then reinstall.
Since its a test board then it doesnt matter much, phew

Everything will work great on yer live board

TTG · #8 03-06-2005, 08:33 PM

Quote:

Originally Posted by Revan

Everything will work great on yer live board

Except asking headquaters.php produces

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT level1_wins, level2_wins FROM rpg_limit_settings
mysql error: Table 'thetechg_retreat.rpg_limit_settings' doesn't exist

Chief Corn · #9 03-06-2005, 09:31 PM

i remember that headquarters.php error being a beta 1 problem...are you using beta 2?

hXc Radio · #10 03-07-2005, 01:16 AM

I am receiving on admincp/rpg_install.php?step=install&part=queries&all=yes

Created Table: rpg_items
Created Table: rpg_items_cats

There seems to have been a slight problem with the HxC Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

PHP Code:


			
Database error in vBulletin 3.0.7:



Invalid SQL: 

CREATE TABLE `rpg_items_user` 

(

    `userid` int(10) unsigned NOT NULL default '0',

    `item0` char(250) NOT NULL default 'No Item',

    `points0` int(5) NOT NULL default '0',

    `description0` char(250) NOT NULL default 'No Description Available',

    `icon0` char(250) NOT NULL default '',

    `itid0` int(11) NOT NULL default '0',

    `item1` char(250) NOT NULL default 'No Item',

    `points1` int(5) NOT NULL default '0',

    `description1` char(250) NOT NULL default 'No Description Available',

    `icon1` char(250) NOT NULL default '',

    `itid1` int(11) NOT NULL default '0',

    `item2` char(250) NOT NULL default 'No Item',

    `points2` int(5) NOT NULL default '0',

    `description2` char(250) NOT NULL default 'No Description Available',

    `icon2` char(250) NOT NULL default '',

    `itid2` int(11) NOT NULL default '0',

    `item3` char(250) NOT NULL default 'No Item',

    `points3` int(5) NOT NULL default '0',

    `description3` char(250) NOT NULL default 'No Description Available',

    `icon3` char(250) NOT NULL default '',

    `itid3` int(11) NOT NULL default '0'    

    PRIMARY KEY (`userid`)

) TYPE=MyISAM;



mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(`userid`)

) TYPE=MyISAM' at line 24



mysql error number: 1064

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05778 seconds Memory Usage 2,325KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (7)bbcode_code (1)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!