vb.org Archive - Invalid Monster Battle

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)

- - Invalid Monster Battle (https://vborg.vbsupport.ru/showthread.php?t=116825)

DragoZERO

05-23-2006 12:32 AM

Invalid Monster Battle

Great, thanks.

I have another problem: Many users are getting an "Invalid Battle" error, as in they are still in an active battle which they already clicked submit at the end of a battle.

Revan

05-23-2006 07:44 PM

I have a small number of people reporting this but I have been unable to reproduce.
Lets start easy; is this regular battle or monster battle?

DragoZERO

05-23-2006 08:30 PM

Monster battle.

Revan

05-27-2006 01:04 PM

Sorry about the delay.

Ok what I need you to do is this: Find an user that is experiencing this problem, and note down his userid.
Then run these queries, only replacing the userid with the userid you found:
[sql]SELECT monsterbattleid FROM rpg_user WHERE userid = '1'[/sql]
[sql]SELECT userid FROM rpg_ibot_templates WHERE userid = '1'[/sql]
And tell me what the results of each of these queries are.

DragoZERO

05-27-2006 11:24 PM

First query:

Code:

An error occurred while attempting to execute your query. The following information was returned.

error number: 1146

error desc: Table 'nt_vb.rpg_user' doesn't exist

2nd:

Code:

An error occurred while attempting to execute your query. The following information was returned.

error number: 1146

error desc: Table 'nt_vb.rpg_ibot_templates' doesn't exist

This is odd.. I don't recieve this errors when changing user info and editing the ibots.

Revan

05-27-2006 11:55 PM

You use a table prefix then. Append that before the name of the table (so if your prefix is vb_ the table name becomes vb_rpg_user) and try it again.
You can find your table prefix in the config.php file.

DragoZERO

05-28-2006 06:47 AM

My bad.

First query: 0
2nd query did not come up with any results.

Revan

05-28-2006 09:31 AM

I see.
And you are sure that the userid you used to query is infact stuck with that error? If you are, then run the following query:
[sql]UPDATE user SET rpg = '' WHERE userid = '1'[/sql]
Adding the table prefix and replacing the userid as needed, and tell the user to refresh any RPG page, then see if he is still stuck with that error.

DragoZERO

05-30-2006 03:28 PM

That did it. Thanks a lot man. I'll be talking to you later, I'm sure I'll need more help later on. lol.

Revan

05-30-2006 06:31 PM

Okay, well then we have nailed what the problem is: The cache didn't update itself.
That should make it fixable. Thanks for the aid :)

PS: When next your users recieve this error, just run the Rebuild RPG Users maintenance function.

DragoZERO

06-02-2006 04:13 AM

Some of my members are getting the same error still. I ran the SQL query, along with the rebuild function. Suggestions?

Revan

06-02-2006 05:27 AM

They must be completing a new monster battle right after you running the queries thus making the problem reappear.
Ill see about bringing out a patch for this soon, got a final exam in 30 mins tho...

DragoZERO

06-04-2006 09:33 AM

A patch would be great. Good luck on the exam, hah.

Revan

06-08-2006 10:46 AM

Okay I know what to do now, I will see about updating the hack for 3.5.4 and 3.6.0 Beta 1 with a fix to this.
Thanks for the help :)

All times are GMT. The time now is 07:15 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01211 seconds Memory Usage 1,733KB 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 (14)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
Messages: