Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 server crashes on install
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

keithu
Starting Member

5 Posts

Posted - 15 May 2002 :  09:10:05  Show Profile
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  Show Profile  Visit crash's Homepage
RC=5... isn't that used for SQL instead of MySQL?



Crash's Site | Crash is from
Go to Top of Page

nomad_2k
Junior Member

United Kingdom
173 Posts

Posted - 15 May 2002 :  09:20:05  Show Profile
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/
Go to Top of Page

keithu
Starting Member

5 Posts

Posted - 15 May 2002 :  10:07:17  Show Profile
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

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 15 May 2002 :  13:16:16  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 15 May 2002 :  13:35:45  Show Profile
Are you sure the asp emulator is ChiliSoft and not iAsp or something else? Snitz only works with ChiliSoft.


======
Doug G
======
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 16 May 2002 :  01:24:18  Show Profile  Visit Nathan's Homepage
It has not been shown that Snitz doesn't work on iASP. . .

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

keithu
Starting Member

5 Posts

Posted - 16 May 2002 :  06:25:26  Show Profile
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?

Go to Top of Page

keithu
Starting Member

5 Posts

Posted - 16 May 2002 :  07:09:36  Show Profile
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?

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 May 2002 :  07:11:59  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

keithu
Starting Member

5 Posts

Posted - 16 May 2002 :  07:23:28  Show Profile
Ho-hum,

can anyone recomend an alternative that does work on iASP?

Thanks again

Keith

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 May 2002 :  07:27:21  Show Profile  Send ruirib a Yahoo! Message
With a Unix machine you have more options than ASP based forums. Have a look here: http://forum.snitz.com/competition.asp

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.62 seconds. Powered By: Snitz Forums 2000 Version 3.4.07