| Author |
 Topic  |
|
kycable
New Member
USA
82 Posts |
 Posted - 09 January 2001 : 19:18:16
|
quote:
Glad to hear it!
(felt quite embarrassed)
I guess I will back up my DB before running the set-up? :)
Wedont
snitz ver3.1 sr2
Well I agree that should be done anyways, but this only update/changes the PM_MOD table. and adds/updates the fields M_NAME, M_CODE, M_VALUE.
Other than that, good luck if there is still a problem please let me know.
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
 |
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 09 January 2001 : 19:41:30
|
2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_MODS' already exists.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_MODS' already exists.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_MODS' already exists.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Database set-up finished..
You bet !!!!!!!!
Wedont
snitz ver3.1 sr2 |
|
|
|
Metric
Starting Member
7 Posts |
Posted - 09 January 2001 : 19:47:06
|
lol, got a similar, first three worked then syntax. In addition, i tried to reg a new user, it goes to the filling in screen...i was just about to type in username and it refreshed itself out of there
help ;)
mike
|
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 19:58:49
|
So I'm glad it worked.... (sorry for the scarsium)
Actually after running the setup try the using the mod now
Jeff Brown
Web Zone Complete
<Snitz with many addons>
Edited by - KYCable on 09 January 2001 20:01:37 |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 20:03:15
|
quote:
lol, got a similar, first three worked then syntax. In addition, i tried to reg a new user, it goes to the filling in screen...i was just about to type in username and it refreshed itself out of there
help ;)
mike
I do not know why it would have refreshed at all. There is nothing that I had done to make a refresh statement.
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
Metric
Starting Member
7 Posts |
Posted - 09 January 2001 : 20:07:47
|
dunno...so should i download the zip again? or is it the same?
whats the take on getting a modified script of one of you guys who know what theyre doing?
Mike
|
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 09 January 2001 : 20:15:38
|
quote:
So I'm glad it worked.... (sorry for the scarsium)
Actually after running the setup try the using the mod now
Jeff Brown
Web Zone Complete
<Snitz with many addons>
Jeff Have you noticed the thingnies: "syntax error" ? :)
At least it now registers the message's text but still cant exceed a few lines!
Wedont
snitz ver3.1 sr2 |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 20:23:34
|
quote:
quote:
So I'm glad it worked.... (sorry for the scarsium)
Actually after running the setup try the using the mod now
Jeff Brown
Web Zone Complete
<Snitz with many addons>
Jeff Have you noticed the thingnies: "syntax error" ? :)
At least it now registers the message's text but still cant exceed a few lines!
Wedont
snitz ver3.1 sr2
I know wedont, I was being scarcastic, everything I say has some punch line to it. I don't ever try to make it look like I am smarter then others. I would just like to let you know that I am working on it. I setup a new forum (SR4 and SR3) on my computer and everything setup just fine locally, I was able to put in 7,483 charicaters in the message including the center, bold, color, smiles, and all the other tags that I have. I will post a message here tonight for everyone as soon as I find out what is going on. I thought I have tested it throughly enough for others to migrate easily but I musted have missed something. Let me look around.
Metric, can you send me your register.asp file so I can see it. kycable99@msn.com would be the best address.
Thanks
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 20:28:28
|
quote:
Hi Jeff,
The problem seems to be with the lenght of the text. Eventhough I did change "M_VALUE" to MEMO. I checked twice and it still wont accept more then a couple lines!
Wedont
snitz ver3.1 sr2
Jeff the link you just posted, not sure it's the right one. LOL
Edited by - wedont on 09 January 2001 18:35:47
wedont,
If you have access 2000, can you check to see if that line is still a memo?
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 09 January 2001 : 20:28:39
|
quote:
quote:
So I'm glad it worked.... (sorry for the scarsium)
Actually after running the setup try the using the mod now
Jeff Brown
Web Zone Complete
<Snitz with many addons>
Jeff Have you noticed the thingnies: "syntax error" ? :)
At least it now registers the message's text but still cant exceed a few lines!
Wedont
snitz ver3.1 sr2
Cant register new user any more!! get error message : eof bof true....
Wedont
snitz ver3.1 sr2 |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 09 January 2001 : 20:44:32
|
Cant register new user any more!! get error message :ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
.../inc_functions.asp, line 642
line 633-644:
function getMemberID(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
rsGetMemberID = my_Conn.Execute(strSql)
getMemberID = rsGetMemberID("MEMBER_ID")
end function
and did check db: M_VALUE is MEMO
Hope it will help!
Wedont
snitz ver3.1 sr2
access2k
Edited by - wedont on 09 January 2001 20:48:46
register_asp sent.
Edited by - wedont on 09 January 2001 21:07:29 |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 20:52:04
|
wedont,
can you send me your register.asp file... kycable99@msn.com I would apperciate it.
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 21:56:02
|
I believe that HuwR, I have fixed the issues in this mod (at least hopfully) I have updated the zips above with a new setup file...
Remember to run the setup file
If the mod commander is installed then you will see errors in the setup file. All it is saying that it basically some fields and tables already exist. It will delete any issuses with the NewMemPM fields and then re-add them.
If you have any other issues with this please let me know. Again an example can be seen at my site.
Last but least there are three or four places in the register.asp file you need to add the NewMemPM lines to get the information from the database. All of them are marked with a '################# New MEM PM Mod ###############
Thanks
Jeff Brown
Web Zone Complete
<Snitz with many addons>
Edited by - KYCable on 09 January 2001 22:00:23 |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 09 January 2001 : 22:23:39
|
Sorry Jeff
Did apply the new setup file:
same errors!
-text limited to a couple lines
-unable to register new user (same error message)
Hope it has nothing to do with v3.1 sr2!
Best of luck.
Wedont
snitz ver3.1 sr2
access 2k. |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 09 January 2001 : 22:27:30
|
quote:
Sorry Jeff
Did apply the new setup file:
same errors!
-text limited to a couple lines
-unable to register new user (same error message)
Hope it has nothing to do with v3.1 sr2!
Best of luck.
Wedont
snitz ver3.1 sr2
access 2k.
Well it shouldn't I have 3.1 SR3b2 online, and on my test site I have 3.1 final (gosh isn't that old) I think I need to update that one.
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
Topic |
|
Topic Locked
