Author |
Topic |
|
keithu
Starting Member
5 Posts |
Posted - 15 May 2002 : 09:10:05
|
Hi, hope you can help.
browsing to setup.asp crashes my virtual server account (chilisoft/mysql)
I since found that I should use setup.asp?RC=5 but I'm reluctant to try that until I've got some advice as I dont feel I should keep on crashing the server (isn't that nice of me).
this is from my ISP; **** Please return this program to the vendors and/or re-configure properly before tying to run this program again. Whenever you run this program it crashes the server for all users of ASP on your server. The error message is: java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: General error: Table 'keithu1.FORUM_CONFIG_NEW' doesn't exist ****
relevant bits from config.asp;
strDBType = "mysql" strConnString = "DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://194.216.113.252:3306/keithu1};uid=keithu1;pwd=mypaswd"
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 15 May 2002 : 09:13:06
|
RC=5... isn't that used for SQL instead of MySQL?
Crash's Site | Crash is from
|
|
|
nomad_2k
Junior Member
United Kingdom
173 Posts |
Posted - 15 May 2002 : 09:20:05
|
Keithu: Yes you need to run setup.asp?RC=5 to setup the database (it creates all the tables), if you don't do this snitz won't work.
Crash: RC=5 is for M$ SQL Server and mySQL.
Good things come to those who wait. http://www.freeasphost.co.uk/evolution/ |
|
|
keithu
Starting Member
5 Posts |
Posted - 15 May 2002 : 10:07:17
|
Thanks but it still crashes - any ideas? I think the support guy at my ISP would like to know why it crashes the whole server, but I'd settle for it just working :)
K
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 May 2002 : 13:16:16
|
May I ask why are you using a JDBC driver? Why not use an ODBC driver? I'm no specialist in MySQL (thank God for that ), but I think this is usually used with an ODBC driver. I would try an ODBC driver if I were you.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 15 May 2002 14:41:35 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 15 May 2002 : 13:35:45
|
Are you sure the asp emulator is ChiliSoft and not iAsp or something else? Snitz only works with ChiliSoft.
====== Doug G ====== |
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
keithu
Starting Member
5 Posts |
Posted - 16 May 2002 : 06:25:26
|
Cheers for the help so far...
Well its stopped crashing the server. I created the mySQL database online using myAccess and the access db supplied. Now I just get blank screens.
ruirib: I'm just using the recomended string from the ISP, what would you recomend I changed the string to exactly?
Doug G: you're spot on ( D'oh) chilisoft is another server for another client.
Nathan: So has no-one actually tried? Or does that mean that it doesn't work but no-one can show why? Am I really breaking new ground here?
|
|
|
keithu
Starting Member
5 Posts |
Posted - 16 May 2002 : 07:09:36
|
sorry "Now I just get blank screens" is a bit pants isn't it.
setup.asp gives me the setup has been completed screen. 'Click here to go to the forum.' gives me a blank page.
setup.asp?RC=5 asks for name and password so i put in the mysql username and pass as per the connection string. then I get to the admin login put in Admin admin and get another blank page.
Is this as good as it gets with iASP?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 May 2002 : 07:11:59
|
quote:
Cheers for the help so far...
Well its stopped crashing the server. I created the mySQL database online using myAccess and the access db supplied. Now I just get blank screens.
ruirib: I'm just using the recomended string from the ISP, what would you recomend I changed the string to exactly?
Doug G: you're spot on ( D'oh) chilisoft is another server for another client.
Nathan: So has no-one actually tried? Or does that mean that it doesn't work but no-one can show why? Am I really breaking new ground here?
Well I had never seen a JDBC driver being used with MySQL, and I thought that could be the reason. Doug, however seems to have found the cause. And sorry to disapoint you, but it's highly likely that you won't be able to get it running. I believe several members of the Dev team tried to make Snitz run in iASP, with the help of people from the tech support from iASP and they couldn't do it...
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
|
|
keithu
Starting Member
5 Posts |
Posted - 16 May 2002 : 07:23:28
|
Ho-hum,
can anyone recomend an alternative that does work on iASP?
Thanks again
Keith
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|