• Just a reminder that providing specifics on, sharing links to, or naming websites where ROMs can be accessed is against the rules. If your post has any of this information it will be removed.
  • Ever thought it'd be cool to have your art, writing, or challenge runs featured on PokéCommunity? Click here for info - we'd love to spotlight your work!
  • PokéCommunity's Easter Egg Hunt is now on! If you're interested in looking for some eggs and earning badges, click here!
  • Our weekly protagonist poll is now up! Vote for your favorite Conquest protagonist in the poll by clicking here.
  • Welcome to PokéCommunity! Register now and join one of the best fan communities on the 'net to talk Pokémon and more! We are not affiliated with The Pokémon Company or Nintendo.
    Register

Ho-oh 112's mySQL Trade System

Same error with your scripts.rxdata.
Tells when i use pbUploadList()
'Message: (eval)in `pbUploadList'wrong number of arguments(0 for 1)'

Help please?
 
overstood said:
Same error with your scripts.rxdata.
Tells when i use pbUploadList()
'Message: (eval)in `pbUploadList'wrong number of arguments(0 for 1)'

Help please?
Click to expand...


YOU HAVN'T DEFINED THE POKEMON!
do this:
Code: 
pokemondatahere=pbChoosePokemon(1,3)
pbUploadList(pokemondatahere)

Allows you to choose 1 pokemon in your party
 
I'm still confused about how to work my sql.
What would you say a good sql host for free is,
If any?
BTW, I don't think I'll need those text files now that I downloaded that scripts.zip file from your earlier post.
Thanks, all though I am still nervous about editting them, I think I can make it work.
What seems more important at the moment is getting a my sql up and running.
Also, when I do find a mysql host, how would I upload my database?
Lastly, how do I edit the mysql scripts on the mysql server or whatever?
Here's what I've done so far with mysql.
Downloaded mysql installer from Mysql.com.
Installed the .msi.
It includes (server and workbench).
I'm sorry for seeming to be an idiet.
I've just never worked with mysql before.
 
pokemonmasteraaron said:
I'm still confused about how to work my sql.
What would you say a good sql host for free is,
If any?
BTW, I don't think I'll need those text files now that I downloaded that scripts.zip file from your earlier post.
Thanks, all though I am still nervous about editting them, I think I can make it work.
What seems more important at the moment is getting a my sql up and running.
Also, when I do find a mysql host, how would I upload my database?
Lastly, how do I edit the mysql scripts on the mysql server or whatever?
Here's what I've done so far with mysql.
Downloaded mysql installer from Mysql.com.
Installed the .msi.
It includes (server and workbench).
I'm sorry for seeming to be an idiet.
I've just never worked with mysql before.
Click to expand...


Nah, it's ok.

here's 2 websites:
https://xeround.com DATABASEONLY, minimum connections allowed for free (bad)
https://astahost.com actual website host (with mySQL) I haven't used this yet

and you don't need to upload your database, although you can export your database to a .sql file and upload them again to your database host.
 
You mean I never had to install mysql?!
hahaha.
Anyway, I'll get to work on that.
Things are looking pretty good.
I've got the scripts in my game now, but haven't editted them yet.
I'm going to wait until I get my mysql database setup.
I don't know why, but your scripts.rxdata didn't work in my backup.
I exported the ones I needed in to my main project, though, and it works fine.
 
pokemonmasteraaron said:
You mean I never had to install mysql?!
hahaha.
Anyway, I'll get to work on that.
Things are looking pretty good.
I've got the scripts in my game now, but haven't editted them yet.
I'm going to wait until I get my mysql database setup.
I don't know why, but your scripts.rxdata didn't work in my backup.
I exported the ones I needed in to my main project, though, and it works fine.
Click to expand...


I don't know why the scripts.rxdata didn't work though, but glad to see exporting the scripts seperatly works.
 
will freemysql.net work?
I'm having trouble creating a database with xeround.

It's really only my blindness that's getting in the way though, it isn't the website's falt.
 
i get this error now :/



Exception: RuntimeError

Message: Script error within event 13, map 38 (Route 1):

Exception: NoMethodError

Message: Section142:363:in `pbUploadPokemonGTS'undefined method `pbConnectSql' for #<Interpreter:0x9726c78>

***Full script:

PokeData=pbChoosePokemon(1,3)
pbUploadList(PokeData)


Interpreter:243:in `pbExecuteScript'

mySQL Trade:355:in `pbUploadList'

mySQL Trade:299:in `loop'

mySQL Trade:359:in `pbUploadList'

(eval):2:in `pbExecuteScript'

Interpreter:1593:in `eval'

Interpreter:243:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'



Interpreter:276:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Scene_Map:101:in `loop'

Scene_Map:114:in `update'

Scene_Map:68:in `main'
 
overstood said:
i get this error now :/



Exception: RuntimeError

Message: Script error within event 13, map 38 (Route 1):

Exception: NoMethodError

Message: Section142:363:in `pbUploadPokemonGTS'undefined method `pbConnectSql' for #<Interpreter:0x9726c78>

***Full script:

PokeData=pbChoosePokemon(1,3)
pbUploadList(PokeData)


Interpreter:243:in `pbExecuteScript'

mySQL Trade:355:in `pbUploadList'

mySQL Trade:299:in `loop'

mySQL Trade:359:in `pbUploadList'

(eval):2:in `pbExecuteScript'

Interpreter:1593:in `eval'

Interpreter:243:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'



Interpreter:276:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Scene_Map:101:in `loop'

Scene_Map:114:in `update'

Scene_Map:68:in `main'
Click to expand...


that's something in my script.

pokemonmasteraaron said:
will freemysql.net work?
I'm having trouble creating a database with xeround.

It's really only my blindness that's getting in the way though, it isn't the website's falt.
Click to expand...


yes.
 
overstood said:
Can you fix it/ tell me how to fix?
Click to expand...


check first post, I uploaded a .zip file with the fix.

if it still doesn't work:

rename everything in the script that says:

pbconnectSql()
to:
pbSqlConnect()


I mixed up the names of them.
 
So, does this look right?
I won't know if it works until somebody who can see gets home and reads me the event I've setup.

Host = "SQL09.FREEMYSQL.NET" # mysql server(local : 127.0.0.1)
User = "aaronbaker" # mysql user
Pass = "freemysql password (note that isn't my password!)" # mysql password
Base = "pokemontourney" # base name
Port = 3306 # server port (default: 3306)
I wasn't sure what port to put, as I didn't see one listed in my database
As I said, I won't know if it worked until somebody get's home, but I do know I don't get any
exeption run time errors
or any other errors that cut off the game.
 
pokemonmasteraaron said:
So, does this look right?
I won't know if it works until somebody who can see gets home and reads me the event I've setup.

Host = "SQL09.FREEMYSQL.NET" # mysql server(local : 127.0.0.1)
User = "aaronbaker" # mysql user
Pass = "freemysql password (note that isn't my password!)" # mysql password
Base = "pokemontourney" # base name
Port = 3306 # server port (default: 3306)
I wasn't sure what port to put, as I didn't see one listed in my database
As I said, I won't know if it worked until somebody get's home, but I do know I don't get any
exeption run time errors
or any other errors that cut off the game.
Click to expand...


Looks fine to me, also I'll be adding a .sql file that holds the correct table for the trades later.
 
Well, it isn't right.
I have some ideas on fixing it, but I'm still going to tell you the simptums incase it isn't a server problem.
One.
When uploading my ivysaur to the database, I get an acception run time error.


---------------------------
Pokémon Tourney, The corrupted soul
---------------------------
Script 'Interpreter' line 275: RuntimeError occurred.

Script error within event 12, map 1 (Pokemon Center):Exception: NoMethodErrorMessage: Section144:363:in `pbUploadPokemonGTS'undefined method `pbConnectSql' for #<Interpreter:0x87bfe78>***Full script:pokemondatahere=pbChoosePokemon(1,3)
pbUploadList(pokemondatahere)
Interpreter:243:in `pbExecuteScript'mySQL Trade:355:in `pbUploadList'mySQL Trade:299:in `loop'mySQL Trade:359:in `pbUploadList'(eval):2:in `pbExecuteScript'Interpreter:1592:in `eval'Interpreter:243:in `pbExecuteScript'Interpreter:1592:in `command_355'Interpreter:493:in `execute_command'Interpreter:193:in `update'
---------------------------
OK
---------------------------

When searching.
Game freezes, and than
Rgss player has stoped responding.
Windows is looking for a solution to the problem.
Or something like that.
 
After the ''fix''



---------------------------
Exception: RuntimeError

Message: Script error within event 13, map 38 (Route 1):

Exception: NoMethodError

Message: Section142:363:in `pbUploadPokemonGTS'undefined method `pbpbSqlConnect' for #<Interpreter:0x99908a0>

***Full script:

PokeData=pbChoosePokemon(1,3)
pbUploadList(PokeData)


Interpreter:243:in `pbExecuteScript'

mySQL Trade:355:in `pbUploadList'

mySQL Trade:299:in `loop'

mySQL Trade:359:in `pbUploadList'

(eval):2:in `pbExecuteScript'

Interpreter:1593:in `eval'

Interpreter:243:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'



Interpreter:276:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Scene_Map:101:in `loop'

Scene_Map:114:in `update'

Scene_Map:68:in `main'
 
overstood said:
After the ''fix''



---------------------------
Exception: RuntimeError

Message: Script error within event 13, map 38 (Route 1):

Exception: NoMethodError

Message: Section142:363:in `pbUploadPokemonGTS'undefined method `pbpbSqlConnect' for #<Interpreter:0x99908a0>

***Full script:

PokeData=pbChoosePokemon(1,3)
pbUploadList(PokeData)


Interpreter:243:in `pbExecuteScript'

mySQL Trade:355:in `pbUploadList'

mySQL Trade:299:in `loop'

mySQL Trade:359:in `pbUploadList'

(eval):2:in `pbExecuteScript'

Interpreter:1593:in `eval'

Interpreter:243:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'



Interpreter:276:in `pbExecuteScript'

Interpreter:1593:in `command_355'

Interpreter:494:in `execute_command'

Interpreter:193:in `update'

Interpreter:106:in `loop'

Interpreter:198:in `update'

Scene_Map:103:in `update'

Scene_Map:101:in `loop'

Scene_Map:114:in `update'

Scene_Map:68:in `main'
Click to expand...


I got a similar error see above post.
I thought it was because of mysql database, but maybe not if you get an almost identical error.
 
I dont know what is it with that but first i got "script is hanging. the game will restart." then unable to connect to database. I have set up everything but nothing works.
 
venom12 said:
I dont know what is it with that but first i got "script is hanging. the game will restart." then unable to connect to database. I have set up everything but nothing works.
Click to expand...

I feel the same.

Please don't contribute Scripts which are just not working.
.___________.''
 
there's probably just some simple explanation, the script is setup well, there's just something we're missing.
Hopefully Ho-oh112 will get back to us soon.
 
You must log in or register to reply here.
Back
Top