| Author |
 Topic  |
|
Adjunkten
Starting Member
30 Posts |
 Posted - 20 September 2006 : 10:54:47
|
I have installed latest version with mysql database but there seems to be some code flaws. Check my forum here:
http://www.adjunkten.dk/forum2/ (Pick the thread 'Testing forums' - )
I have deleted and uploadet several times in case files were corrupted in the upload process - a few months ago vers. 3.4.05 was up and running.
Any ideas? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 20 September 2006 : 12:01:13
|
and which searchword would you recommend for this problem !?
thanx anyway 
Edit: Can't find any 'options=4' in config.asp ? JiveMiguel is writing about version 3.4.05. |
Edited by - Adjunkten on 20 September 2006 12:19:19 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 20 September 2006 : 12:03:22
|
| have you read the sticky topic regarding "type mismatch" errors at all. |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 20 September 2006 : 12:24:54
|
No. I would'nt post my thread then, would I?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 September 2006 : 12:32:19
|
Using 'Default.asp, line 923' as the keywords would have got you to the solution.
Update the connection string so that the use of OPTION looks like this:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;"
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 20 September 2006 : 12:39:37
|
Thanx ruirib.
I tried your connectstring (inc. in new version). I get this errormessage:
Code : 80004005
Error Description :
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Is data source name = db name?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 20 September 2006 : 12:40:33
|
quote:
Originally posted by Adjunkten
No. I would'nt post my thread then, would I?
well perhaps you should start by reading them. they are made in to sticky topics for YOUR benefit not ours. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 September 2006 : 14:20:21
|
Guys, the fix posted by Jive, was implemented in the 3.4.06 version. So the default option for MySQL is no longer OPTION=4 but is now OPTION=16387.
If you were still getting the type mismatch errors with the latest version of the forums, then something is definitely up.
Unless you were using the old connection string.
Make sure you are using the MySQL w/ MyODBC v3.51 connection string.
Not the MySQL w/ MyODBC v2.50. That's for older version. |
Support Snitz Forums
|
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 21 September 2006 : 03:34:36
|
I am using the new connect string with option=16387. Error message mentioned above.
In the weekend I will try my luck with web wiz.
btw I have searched for download of 3.4.05 version, which worked fine on same server (will backup next time I try to upgrade!), but I can only find mirrors with newest version. Can anyone help here? |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 03:56:46
|
As far as I am aware the only change that affected MySQL was the change to the connection string, so have you tried using the old connection string if that worked for you ? however the errors you describe are all consistent with the reason the fix was implemented in the first place
and the error that is currently displaying from your link would indicate that you do not infact have your connectionstring set correctly at all. We do test this stuff on MySQL you know so are pretty confident that it works |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 September 2006 : 04:15:33
|
The error is pretty basic. Your connection strong is not properly set. The forum is unable to read your strDBType value, or the strConnString value.
Make sure you remove the single quote ' from in front of the connection string and the strDBType, that you are using.
If you are sure that is correct, copy and paste the code from your config.asp file, that contains your strDBType and your strConnString. Make sure to replace your username, password and database name with asteriks ***, when you make your post. |
Support Snitz Forums
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 04:17:20
|
| their initial problem was the type mismatch error, the current error is a new one they recieved after changing their connection string. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 September 2006 : 04:20:49
|
| Yeah, you're right. But I am thinking they used the old connection string to get the first problem. Just a guess. He hasn't told us what mysql server version he using. Haven't tested the new option with older mysql database server. Would think at least hosting companies are at least mysql version 4. Any good hosting company that is. |
Support Snitz Forums
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 05:21:41
|
quote:
Would think at least hosting companies are at least mysql version 4. Any good hosting company that is.
yes, I think I have 5 installed on my server |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 21 September 2006 : 10:40:09
|
Hello, here's my entire config.asp. I'm using Mysql v4.1.21 - standard. I have only changed language ID and unquoted the right (?)lines.
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
'strDBType = "access"
strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=mysql1.unoeuro.com;user=(user);password=(passw);DATABASE=adjunkten_dk_db;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
|
|
|
|
Topic |
|
Topic Locked
