| Author |
 Topic  |
|
|
Qasem
Starting Member
18 Posts |
 Posted - 18 April 2005 : 20:36:46
|
i have tried everything i could to install the latest snitz forum on my website, but it just not work! i have also tried the auto install from http://www.forumco.com/articles/snitzinstall/snitzinstall.aspx but it still not work. i have convertet my access database to mysql, because my host dont support access, it still not work. i (think) i have tryed many things now, but thats not my cop of coffe..
i have snitz on my computer, i its work very fine. and iam very happy about it, but cant get it on the net. Could someone PLZZ help me to JUST SET the basic things up on my website? i will be very thankfull..
my email adr. is ATIFALT@hotmail.com, if some one could add me on the MSN, and help me there.. It could be very very very nice.
many thanks.. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Qasem
Starting Member
18 Posts |
Posted - 19 April 2005 : 08:14:44
|
quote:
Originally posted by ruirib
It will be easier to help if you tell us what is going wrong.
"The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
SQLState: S Native Error Code: 1102 [TCX][MyODBC]Incorrect database name '632493655423621250.sql'"
I have tryed wich access and 632493655423621250.mdb, and mysql and 632493655423621250.sql.
my strConnString points to the database. but i still get the problem?
I think the problem is in the database, it cant open the database or something. my host dont support access, therefor i convertet the access database to mysql, and upload it to my website. do i miss something?
Iam new in this, so if its some stupid question then sorry me and just help  |
 |
|
|
Qasem
Starting Member
18 Posts |
Posted - 19 April 2005 : 08:17:03
|
quote:
Originally posted by Podge
If you have Snitz working on your computer, just upload those files to your webspace via ftp.
Change config.asp to reflect the correct database type (MySql) and change the connection string accordingly.
Then run setup.asp
If you get errors, post the url to your forum here along with a copy of the error.
The ForumCo automated installer only supports Access DB's.
Okay so i cant convert the database to mysql? .. it will not work, right?
|
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 19 April 2005 : 09:01:06
|
'632493655423621250.sql' is not a valid MySql database name. Its a text file.
Edit these lines in config.asp
Change 'strDBType = "mysql"
to
strDBType = "mysql"
and
strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
to look something like this (insert the data your host gave you for connecting to MySql)
'strConnString = "driver=MySQL;server=127.0.0.1;uid=MyUsername;pwd=MyPassword;database=Snitz" '## MySQL
Then run setup.asp
Do you need to import data from another database or do you want to start from the beginning ? |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
Edited by - Podge on 19 April 2005 09:01:53 |
|
|
|
Qasem
Starting Member
18 Posts |
Posted - 19 April 2005 : 19:54:54
|
quote:
Originally posted by Podge
'632493655423621250.sql' is not a valid MySql database name. Its a text file.
Edit these lines in config.asp
Change 'strDBType = "mysql"
to
strDBType = "mysql"
and
strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
to look something like this (insert the data your host gave you for connecting to MySql)
'strConnString = "driver=MySQL;server=127.0.0.1;uid=MyUsername;pwd=MyPassword;database=Snitz" '## MySQL
Then run setup.asp
Do you need to import data from another database or do you want to start from the beginning ?
thanks for the help. iam over the problem, but get some new problems now..
when i rum setup.asp it says:
The database needs to be upgraded !!
The database you are using needs to be upgraded !!
Code : 800A0E78
When i click at Click here to upgrade the database., i get this:
You need to logon first.
To upgrade the database you need to be logged on as a forum administrator.
Admin Login
UserName:
Password:
As i said before its auto installation, and when i type the "admin" code i typed when it auto installed the forum i get this message:
The page cannot be displayed
Technical Information (for support personnel)
Error Type:
Sun ONE ASP VBScript runtime (0x80004005)
/forum/setup_login.asp, line 56
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
POST 73 bytes to /forum/setup_login.asp
POST Data:
setup=Y&ReturnTo=RC%3D3%26VER%3D&Name=(adminname)&Password=(adminpassword)&Submit1=Login
Time:
Wednesday, April 20, 2005, 1:53:46 AM
More information:
Sun ONE Active Server Pages Support
Do u know that where the problem could be? my host is b-one.net
And Podge iam starting from beginning.. with a fresh copy .. |
Edited by - Qasem on 19 April 2005 19:56:09 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Qasem
Starting Member
18 Posts |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 20 April 2005 : 08:30:56
|
quote:
As i said before its auto installation, and when i type the "admin" code i typed when it auto installed the forum i get this message:
You cannot use the auto installer for Sun One for two reasons;
1. Your host does not support Access
2. The fixes that ruirib posted are not present in that version.
If the auto installer copied the files to your server you will need to download the 4 files in ruiribs two links and apply the changes. Then re-upload them to your server.
The four files are
inc_iconfiles.asp
inc_func_common.asp
admin_config_email.asp
config.asp |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
Edited by - Podge on 20 April 2005 08:31:23 |
|
|
|
Qasem
Starting Member
18 Posts |
Posted - 20 April 2005 : 08:53:41
|
quote:
Originally posted by Podge
quote:
As i said before its auto installation, and when i type the "admin" code i typed when it auto installed the forum i get this message:
You cannot use the auto installer for Sun One for two reasons;
1. Your host does not support Access
2. The fixes that ruirib posted are not present in that version.
If the auto installer copied the files to your server you will need to download the 4 files in ruiribs two links and apply the changes. Then re-upload them to your server.
The four files are
inc_iconfiles.asp
inc_func_common.asp
admin_config_email.asp
config.asp
Hmmm... i have made a faul, my strconnsting was:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=(myuser);password=(mypassword);632493655423621250.mdb;" '##MySQL w/ MyODBC v3.51
Witout DATABASE.
When i use this strconnstring:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=(myuser);password=(mypassword);database=632493655423621250.mdb;" '##MySQL w/ MyODBC v3.51
i get this faul:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
SQLState: S Native Error Code: 1045 [TCX][MyODBC]Access denied for user: 'root@localhost' (Using password: YES)
My password is right and everything..
& Yes, i have edited ALL the 4 files ruirib and u told me before.. |
Edited by - Qasem on 20 April 2005 08:54:35 |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 April 2005 : 09:53:47
|
quote:
Originally posted by Podge
I think you should ask your host what the name of your MySql database is and include that instead of the .mdb file name.
Indeed. Access will never work in a Linux / Unix server! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Qasem
Starting Member
18 Posts |
Posted - 22 April 2005 : 19:30:24
|
**** b-one have bad support.. they dont want to help me witch anything, but okay. thats right.
u told me before that i couldt not use .sql file as the database, and u also say that i cant use .mdb file at a mysql server..
could someone help me witch one thing?.. just convert my access database file to mysql, so i can run my sql database on my server, do anyone know how i do that? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
