vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   An error in the rpg_install.php (https://vborg.vbsupport.ru/showthread.php?t=77565)

Blootix 03-06-2005 12:06 AM

An error in the rpg_install.php
 
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 03-06-2005 12:53 AM

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

Ganon 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 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 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 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 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 :p
Everything will work great on yer live board ;)

TTG 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 03-06-2005 09:31 PM

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

hXc Radio 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
(
    `
useridint(10unsigned NOT NULL default '0',
    `
item0char(250NOT NULL default 'No Item',
    `
points0int(5NOT NULL default '0',
    `
description0char(250NOT NULL default 'No Description Available',
    `
icon0char(250NOT NULL default '',
    `
itid0int(11NOT NULL default '0',
    `
item1char(250NOT NULL default 'No Item',
    `
points1int(5NOT NULL default '0',
    `
description1char(250NOT NULL default 'No Description Available',
    `
icon1char(250NOT NULL default '',
    `
itid1int(11NOT NULL default '0',
    `
item2char(250NOT NULL default 'No Item',
    `
points2int(5NOT NULL default '0',
    `
description2char(250NOT NULL default 'No Description Available',
    `
icon2char(250NOT NULL default '',
    `
itid2int(11NOT NULL default '0',
    `
item3char(250NOT NULL default 'No Item',
    `
points3int(5NOT NULL default '0',
    `
description3char(250NOT NULL default 'No Description Available',
    `
icon3char(250NOT NULL default '',
    `
itid3int(11NOT NULL default '0'    
    
PRIMARY KEY (`userid`)
TYPE=MyISAM;

mysql errorYou 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 



All times are GMT. The time now is 01:42 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.01114 seconds
  • Memory Usage 1,776KB
  • 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
  • (7)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete