Author |
Message |
Secretperson Guest
Offline
|
|
Back to top |
|
|
D1st0rt Miss Directed Wannabe
Age:36 Gender: Joined: Aug 31 2003 Posts: 2247 Location: Blacksburg, VA Offline
|
Posted: Mon Apr 28, 2008 8:03 pm Post subject: |
|
|
|
|
That appears to be properly formed, what is your question/problem? _________________
|
|
Back to top |
|
|
Secretperson Guest
Offline
|
Posted: Mon Apr 28, 2008 8:08 pm Post subject: umm |
|
|
|
|
It freezes at sql initiation.. Wont load pas that. and no errors are spammed |
|
Back to top |
|
|
D1st0rt Miss Directed Wannabe
Age:36 Gender: Joined: Aug 31 2003 Posts: 2247 Location: Blacksburg, VA Offline
|
Posted: Mon Apr 28, 2008 8:31 pm Post subject: |
|
|
|
|
A couple of things you should double check:
- The firewall on your MySQL server allows port 3306 from whatever host your bot is running on.
- You're using a valid mysql-connector-whatever-bin.jar (the one in svn is 5.0.7)
Both of these can be checked if you download the database client from here and try to connect to your database. |
|
Back to top |
|
|
Secretperson Guest
Offline
|
Posted: Mon Apr 28, 2008 9:06 pm Post subject: K |
|
|
|
|
I ran it and put this in...
Unexpected Error
Check your URL
User Name: &&&&&&
URL: mysql.&&&&&.sshq.net
Driver: com.mysql.jdbc.Driver
JDBC Jar File(s): C:\Subspace\twcore\lib\mysql-connector-java-5.0.7-bin.jar |
|
Back to top |
|
|
Secretperson Guest
Offline
|
|
Back to top |
|
|
Maverick
Age:39 Gender: Joined: Feb 26 2005 Posts: 1521 Location: The Netherlands Offline
|
Posted: Tue Apr 29, 2008 2:57 am Post subject: |
|
|
|
|
Yes, if TWCore can't connect to the MySQL database then it freezes upon initial start.
I don't know Jetaware but I would recommend checking the connection to the database using SQLYog.
Oh, you are a SSHQ.net user (I wonder who you are ).
The URL to your database is always mysql.sshq.net .
Keep in mind there is also standard protection to disallow any outside IP to connect to the database aswell.
You can allow your own IP to connect to the database by adding it in the database properties in the Dreamhost Panel.
This is located under Goodies > Manage MySQL > (Click on your username under "Users with Access") _________________
|
|
Back to top |
|
|
D1st0rt Miss Directed Wannabe
Age:36 Gender: Joined: Aug 31 2003 Posts: 2247 Location: Blacksburg, VA Offline
|
Posted: Tue Apr 29, 2008 8:17 am Post subject: |
|
|
|
|
Whoops, didn't notice that in the url before, that will probably do it.
Mav, the purpose of using the AbeilleDB client was that it doesn't have its own connector built in so its a good way to test yours. |
|
Back to top |
|
|
Maverick
Age:39 Gender: Joined: Feb 26 2005 Posts: 1521 Location: The Netherlands Offline
|
Posted: Tue Apr 29, 2008 9:01 am Post subject: |
|
|
|
|
Ah ok, didn't know that. I should remember that, might come in handy some day |
|
Back to top |
|
|
Secretperson Guest
Offline
|
|
Back to top |
|
|
Maverick
Age:39 Gender: Joined: Feb 26 2005 Posts: 1521 Location: The Netherlands Offline
|
Posted: Wed Apr 30, 2008 10:21 am Post subject: |
|
|
|
|
Have you imported the required tables into your database for Robohelp? (Download here)
Note you can find other required tables for other bots on this wiki page. |
|
Back to top |
|
|
SSP Guest
Offline
|
Posted: Wed Apr 30, 2008 11:00 am Post subject: Yes |
|
|
|
|
All of the databases are installed...I double checked. |
|
Back to top |
|
|
Maverick
Age:39 Gender: Joined: Feb 26 2005 Posts: 1521 Location: The Netherlands Offline
|
Posted: Thu May 01, 2008 8:06 am Post subject: |
|
|
|
|
I already see what the problem is.
RoboHelp is trying to read out tblCall while the .sql scripts contains the table tblcall.
I've fixed it in the script. Redownload it and re-import it into your database (you might need to remove the old tblcall, tblwarnings and tbladvert). |
|
Back to top |
|
|
Aceflyer Newbie
Gender: Joined: Feb 13 2008 Posts: 22 Offline
|
Posted: Fri May 16, 2008 11:26 pm Post subject: |
|
|
|
|
Thanks MMaverick and D1st0rt!
No, the previous guest poster wasn't me, btw; it was one of SWE's devs at the time. _________________ SSCC Star Wars Empire Sysop
MERVBot.com Site Administrator
GetContinuum.com Site Administrator
SSC Forum Operator |
|
Back to top |
|
|
|