vb.org Archive
Page 45 of 87 « First 354344 45 464755 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   RPG Integration Hack - Old Support Thread (https://vborg.vbsupport.ru/showthread.php?t=73868)

rinkrat 09-19-2004 09:46 AM
AARGH!!! It was going beautifully just like last night then, all the sudden

Invalid SQL: select count(*) as new_posts from post where dateline > '1095576023'
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016

This is the same error as last night. Any idea what it is?

Revan 09-19-2004 10:52 AM
This has absolutely NOTHING to do with the RPG :)
It says so in the SQL, the error is with the New Posts query.

Vivi Ornitier 09-19-2004 04:27 PM
rinkrat: try runnin this query

repair table user

Hoffi 09-19-2004 04:28 PM
Quote:
Originally Posted by rinkrat
AARGH!!! It was going beautifully just like last night then, all the sudden


Invalid SQL: select count(*) as new_posts from post where dateline > '1095576023'
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016



This is the same error as last night. Any idea what it is?
You're Database is dead. The File where the Data fot the Table posts is stored has Problems.
That is really a mess.

Contakt your Server Admin.

Revan 09-19-2004 05:16 PM
Quote:
Originally Posted by Vivi Ornitier
rinkrat: try runnin this query

repair table user
It should be: REPAIR TABLE `post`; ;)
But if what Hoffi say is true, I doubt SQL can repair its file. Although I have no idea, so give it a shot ;)

rinkrat 09-19-2004 06:14 PM
Yeah that did it! thanks :) I'm back live and the users are loving this hack

GamerJunk.net 09-19-2004 10:37 PM
PHP Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
        SELECT
            user.userid,
            user.username,
            user.rpgclass,
            user.element,
            user.rpgrace,
            user.rpgtype AS rpgtype,
            user.alignment,
            user.rpggender,
            user.posts,
            user.maxhp,
            user.maxma,
            user.maxpp,
            user.inbattle,
            user.xp,
            user.ma AS uma,
            user.hp AS uhp,
            user.pp AS upp,
            user.ap AS uap,
            user.uttpoints AS money,
            rpg_battle_options.namefield AS namefield, 
            userfield.*,
            rpg_battle_options.exprate,
            rpg_battle_options.privacy AS battleprivacy,
            rpg_items_user.*,
            rpg_battle_stats.*,
            rpg_rpg_race.name AS rpgracename,
            rpg_rpg_race.alignment AS rpgalignmentname,
            rpg_rpg_classf.name AS fclassname,
            rpg_rpg_classf.folder AS fclassfolder,
            rpg_rpg_classm.name AS mclassname,
            rpg_rpg_classm.folder AS mclassfolder,
            rpg_rpg_element.name AS elename
        FROM rpg_battle_options
            LEFT JOIN user ON user.userid=1
            LEFT JOIN userfield ON userfield.userid=user.userid   
            LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
            LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
            LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
            LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
            LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
            LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment
    
mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054 
I get that error when viewing fpg.php and rpgcp.php

What is wrong?

Dyntheos 09-20-2004 12:40 AM
Quote:
Originally Posted by Revan
I assume you know what I said that about, so you do it in the SQL for the column of the user select rpg postbit
i cannot find this table, can you be more specific?

Warlord 09-20-2004 12:48 AM
What the hell does fpg.php do? I get:

Code:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, scott.alan.williams1@us.army.mil and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.27 Server at www.neropolis.com Port 80

Warlord 09-20-2004 12:54 AM
Quote:
Originally Posted by Dyntheos
i cannot find this table, can you be more specific?
In phpMyAdmin click on the table user, scroll down to rpgstats, follwing that row to the right and click on change. Once that screen pops up change the Default value from 1 to 0 and click on save.

All done. :)

This is of course assuming you have this modification hacked into your postbit. Either way, it'll still set it up so that the default is the drop down menu and not the vertical rpg stats. You may have to hack the dropdown menu into the postbit if you haven't done so already.


All times are GMT. The time now is 04:53 PM.
Page 45 of 87 « First 354344 45 464755 Last »
Show 40 post(s) from this thread on one page

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.01817 seconds
  • Memory Usage 1,766KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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