| Author |
 Topic  |
|
|
gswetsky
Starting Member
12 Posts |
 Posted - 29 June 2007 : 10:49:49
|
Running XP home and MySql/ODBC 3.51. I originally had server problems and switched to Quick 'n Easy Web Server. This time running setup gives me the following four errors:
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'F_DESCRIPTION' can't have a default value
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'snitz.forum_members' doesn't exist
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'snitz.forum_forum' doesn't exist
My connection string:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=xxxxxx;password=xxxxxxxxx;DATABASE=snitz;" '##MySQL w/ MyODBC v3.51
Help please! Thanks.
Gerry |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 29 June 2007 : 10:52:13
|
| have you tried searching ? these mySQL errors have been discussed on numerous occasions |
 |
|
|
gswetsky
Starting Member
12 Posts |
Posted - 29 June 2007 : 12:01:08
|
I'll try that, but I wonder if:
"driver={MySQL ODBC 3.51 Driver}"
has to be edited to point to the driver and if so what that would be.
Gerry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
gswetsky
Starting Member
12 Posts |
Posted - 29 June 2007 : 14:05:44
|
I did all that plus several others it was complaining about. I was curious about whether I did this one right, though:
I replaced: strSql = strSql & "M_HOBBIES " & strN & "text NULL DEFAULT '' , "
With: strSql = strSql & "M_HOBBIES " & strN & "text NULL , "
Anyhow, I got to the admin login screen and after logging in, I was greeted with this:
Script error detected at line 2716.
Source line: function edit_hrefs(sURL, iType) {
Script details:
2706 my_Conn.Close
2707 set my_Conn = nothing
2708
2709 Response.Write "" & vbCrLf
2710 Response.Write "" & vbCrLf
2711 end sub
2712
2713 Response.Write "" & vbCrLf
2714 Response.Write "" & vbCrLf
2715 Response.Write "" & vbCrLf
2716
2717 function edit_hrefs(sURL, iType) {
2718 sOutput = new String(sURL);
2719
2720 if (iType == 1) {
2721 sOutput = sOutput.replace(/\b(http\:\/\/[\w+\.]+[\w+\.\:\/\@\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
2722 "$1<\/a>");
2723 } else if (iType == 2) {
2724 sOutput = sOutput.replace(/\b(https\:\/\/[\w+\.]+[\w+\.\:\/\@\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
2725 "$1<\/a>");
2726 } else if (iType == 3) {
Description: Invalid character
Gerry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
gswetsky
Starting Member
12 Posts |
Posted - 29 June 2007 : 17:32:11
|
Same thing - I think.....
Script error detected at line 2716.
Source line: function edit_hrefs(sURL, iType) {
Script details:
2706 my_Conn.Close
2707 set my_Conn = nothing
2708
2709 Response.Write "" & vbCrLf
2710 Response.Write "" & vbCrLf
2711 end sub
2712
2713 Response.Write "" & vbCrLf
2714 Response.Write "" & vbCrLf
2715 Response.Write "" & vbCrLf
2716
2717 function edit_hrefs(sURL, iType) {
2718 sOutput = new String(sURL);
2719
2720 if (iType == 1) {
2721 sOutput = sOutput.replace(/\b(http\:\/\/[\w+\.]+[\w+\.\:\/\@\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
2722 "$1<\/a>");
2723 } else if (iType == 2) {
2724 sOutput = sOutput.replace(/\b(https\:\/\/[\w+\.]+[\w+\.\:\/\@\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
2725 "$1<\/a>");
2726 } else if (iType == 3) {
Description: Invalid character
Gerry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
gswetsky
Starting Member
12 Posts |
Posted - 29 June 2007 : 18:10:44
|
I'm going to start with a fresh copy of inc_create_forum_mysql.asp and start with a fresh database.
Gerry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2007 : 18:18:39
|
| This does not depend on the database. I never saw the last error and I'm guessing it may be related to Javascript support in your server... You can try and upload a fresh copy of inc_func_common.asp. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
gswetsky
Starting Member
12 Posts |
Posted - 29 June 2007 : 18:39:47
|
Well, anyhow I did all that. Paid more attention to what I was doing. Instead of going right to the admin login this time it went to a screen that I clicked on to check the database. Then I clicked to go to the forum and the error line was different:
Script error detected at line 3236.
Source line: function edit_hrefs(sURL, iType) {
Script details:
3226 my_Conn.Close
3227 set my_Conn = nothing
3228
3229 Response.Write "" & vbCrLf
3230 Response.Write "" & vbCrLf
3231 end sub
3232
3233 Response.Write "" & vbCrLf
3234 Response.Write "" & vbCrLf
3235 Response.Write "" & vbCrLf
3236
3237 function edit_hrefs(sURL, iType) {
3238 sOutput = new String(sURL);
3239
3240 if (iType == 1) {
3241 sOutput = sOutput.replace(/\b(http\:\/\/[\w+\.]+[\w+\.\:\/\@\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
3242 "$1<\/a>");
3243 } else if (iType == 2) {
3244 sOutput = sOutput.replace(/\b(https\:\/\/[\w+\.]+[\w+\.\:\/\@\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
3245 "$1<\/a>");
3246 } else if (iType == 3) {
Description: Invalid character
I would be willing to believe it was in the server, but I'd like to be sure before I scrub all this work.
Thanks,
Gerry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2007 : 18:55:06
|
| Line 3236 is blank there, and in the file it corresponds to the line I posted. I do think it's a server issue and it's very uncommon. I cannot remember any other time where it occurred in the past. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2007 : 18:58:09
|
You can try and replace the statement I posted at the end of inc_func_common.asp.
Replace
<script language="javascript1.2" runat="server">
by
<script language="javascript" runat="server">
Not sure that it will help, though. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
gswetsky
Starting Member
12 Posts |
Posted - 30 June 2007 : 02:16:02
|
I think the server is at fault. From the author:
JScript is not supported as server-sided script language.
You can only use VBScript as ASP language.
He reports later:
The next version will also support JSCRIPT.
It should be finished in a few weeks, maybe sooner.
Guess my project is temporarily on hold. Thanks.....
Gerry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
