You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Ho-oh 112's mySQL Trade System
- Thread starter Ho-oh 112
- Start date
-
- Tags
- essentials
More options
Who Replied?Ho-oh 112
Advance Scripter
- 311
- Posts
- 13
- Years
- Age 28
- Seen Mar 8, 2014
Same error with your scripts.rxdata.
Tells when i use pbUploadList()
'Message: (eval)in `pbUploadList'wrong number of arguments(0 for 1)'
Help please?
YOU HAVN'T DEFINED THE POKEMON!
do this:
Code:
pokemondatahere=pbChoosePokemon(1,3)
pbUploadList(pokemondatahere)Allows you to choose 1 pokemon in your party
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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.
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.
Ho-oh 112
Advance Scripter
- 311
- Posts
- 13
- Years
- Age 28
- Seen Mar 8, 2014
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.
Nah, it's ok.
here's 2 websites:
http://xeround.com DATABASEONLY, minimum connections allowed for free (bad)
http://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.
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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.
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.
Ho-oh 112
Advance Scripter
- 311
- Posts
- 13
- Years
- Age 28
- Seen Mar 8, 2014
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.
I don't know why the scripts.rxdata didn't work though, but glad to see exporting the scripts seperatly works.
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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'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.
- 15
- Posts
- 12
- Years
- Seen May 17, 2012
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'
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'
Ho-oh 112
Advance Scripter
- 311
- Posts
- 13
- Years
- Age 28
- Seen Mar 8, 2014
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'
that's something in my script.
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.
yes.
Ho-oh 112
Advance Scripter
- 311
- Posts
- 13
- Years
- Age 28
- Seen Mar 8, 2014
Can you fix it/ tell me how to fix?
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.
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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.
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.
Ho-oh 112
Advance Scripter
- 311
- Posts
- 13
- Years
- Age 28
- Seen Mar 8, 2014
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.
Looks fine to me, also I'll be adding a .sql file that holds the correct table for the trades later.
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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.
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.
- 15
- Posts
- 12
- Years
- Seen May 17, 2012
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'
---------------------------
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'
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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'
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.
- 15
- Posts
- 12
- Years
- Seen May 17, 2012
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.
I feel the same.
Please don't contribute Scripts which are just not working.
.___________.''
pokemonmasteraaron
The blind Pokémon Master!
- 323
- Posts
- 13
- Years
- Age 27
- In the forest of an undiscovered region
- Seen Mar 11, 2022
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.
Hopefully Ho-oh112 will get back to us soon.