| Author |
 Topic  |
|
big9erfan
Average Member
540 Posts |
 Posted - 13 June 2001 : 01:45:08
|
Shep,
What's the error it gives you when you enter too many characters? Does it say you are trying to add too much info or what?
It seems like the setup of the New Member PM only allows for 255 characters. If you can download your database and open it, change the field from a text field to a memo, other wise you can write up a small little script that will first DROP the table and then re-add the table changing the one field to a memo field.
Look in new_mem_pm_setup.asp to see how to add and drop tables in code.
http://www.ugfl.net/forums |
 |
|
|
Shep
New Member
74 Posts |
Posted - 13 June 2001 : 01:55:55
|
quote:
Shep,
What's the error it gives you when you enter too many characters? Does it say you are trying to add too much info or what?
http://www.ugfl.net/forums
Here is what I get :
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''I wanted to take the time to personally thank you for registering for the CalvaryWorship.org forums. If you need any help - check the FAQ - it that doesn't answer your questions - drop me a not. John' WHERE M_NAME = 'NewMemPM' AND M_CODE = 'Message'.
/calvaryworship/admin_new_mem_pm.asp, line 46
Also I downloaded and installed Table Editor - but don't know how to get it to access the right database.
Thanks for your help,
Shep
|
|
|
|
Shep
New Member
74 Posts |
Posted - 13 June 2001 : 02:05:41
|
9er
Also - I ran the new_mem_pm_setup.asp and got this:
-2147217900 | Table 'FORUM_USERFILES' already exists.
-2147217900 | Table 'FORUM_MODS' already exists.
-2147217887 | Field 'M_ALLOWDOWNLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217887 | Field 'M_ALLOWUPLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
Database set-up finished..
Shep
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 13 June 2001 : 03:29:38
|
Shep,
First about running the new_mem_pm_setup.asp, I had said look at it for examples on how to drop tables and add tables if you wanted to go about it that way.
Secondly, dealing with the error you receive.
on line 45 of admin_new_mem_pm.asp could you remove the ' in front of response.write strSQL
so it will look like this
strSql = "UPDATE " & strTablePrefix & "MODS "
strSql = strSql & " SET M_VALUE ='" & b(i) & "'"
strSQL = strSql & " WHERE M_NAME = 'NewMemPM' AND M_CODE = '" & a(i) & "' "
response.write strSQL
my_Conn.Execute (strSql)
Next
then run that page again and see what it says up at top of the page, you should see something like this
UPDATE FORUM_MOD Set M_VALUE ='someValue" WHERE M_NAME = 'NewMemPM' AND M_CODe = 'someOtherValue'
http://www.ugfl.net/forums |
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 13 June 2001 : 10:05:20
|
quote:
Rib,
There is something wrong with the preview message ( cookie related I belive, it's either not set or not read properly ).
As per the New Member PM, did you make sure and turn that function ON, also, try setting it to off, hitting submit, then setting to on and then submit.
Thanks '9'r, that worked last night but this morning it's giving me a Jet error when I try to change the message (only 123 characters). I appreciate all your help but I think this Mod's just to buggy with too many unresolved problems so I'm going to remove it and restore my database.
Good luck Shep and thanks again Big9 
|
|
|
|
Shep
New Member
74 Posts |
Posted - 13 June 2001 : 10:42:34
|
quote:
Shep,
First about running the new_mem_pm_setup.asp, I had said look at it for examples on how to drop tables and add tables if you wanted to go about it that way.
Secondly, dealing with the error you receive.
on line 45 of admin_new_mem_pm.asp could you remove the ' in front of response.write strSQL
so it will look like this
strSql = "UPDATE " & strTablePrefix & "MODS "
strSql = strSql & " SET M_VALUE ='" & b(i) & "'"
strSQL = strSql & " WHERE M_NAME = 'NewMemPM' AND M_CODE = '" & a(i) & "' "
response.write strSQL
my_Conn.Execute (strSql)
Next
then run that page again and see what it says up at top of the page, you should see something like this
UPDATE FORUM_MOD Set M_VALUE ='someValue" WHERE M_NAME = 'NewMemPM' AND M_CODe = 'someOtherValue'
http://www.ugfl.net/forums
Found it - removed it - reran it - no difference.
Shep
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 13 June 2001 : 11:46:46
|
Shep,
Now when you run it, at the top of your page that you go to that either shows the error or the successful change to the message, you should see a big line of text.
It will start with UPDATE FORUM_MOD
I want to read this so I know what's going on when it throws the error.
http://www.ugfl.net/forums |
|
|
|
Shep
New Member
74 Posts |
Posted - 13 June 2001 : 13:57:21
|
quote:
Shep,
Now when you run it, at the top of your page that you go to that either shows the error or the successful change to the message, you should see a big line of text.
It will start with UPDATE FORUM_MOD
I want to read this so I know what's going on when it throws the error.
http://www.ugfl.net/forums
This is what I get:
UPDATE FORUM_MODS SET M_VALUE ='John Brown' WHERE M_NAME = 'NewMemPM' AND M_CODE = 'Admin' UPDATE FORUM_MODS SET M_VALUE ='Welcome!' WHERE M_NAME = 'NewMemPM' AND M_CODE = 'Subject' UPDATE FORUM_MODS SET M_VALUE ='I wanted to take the time to personally welcome you to the CalvaryWorship.org forums. Thanks for registering. If you have any questions, please consult the FAQ. If that doesn't resolve your question, please drop me a note. In Christ, John Brown' WHERE M_NAME = 'NewMemPM' AND M_CODE = 'Message' UPDATE FORUM_MODS SET M_VALUE ='1' WHERE M_NAME = 'NewMemPM' AND M_CODE = 'OnOff'
Configuration Posted!
Congratulations!
Back to Admin
Thanks, Shep
|
|
|
|
Shep
New Member
74 Posts |
Posted - 13 June 2001 : 17:09:57
|
Well - here I am again.
Although the my former message says that the revised letter was completed it was not. I signed into the forum as a test user and got an "enter your message here" from the forum as my welcome message. Meaning that the revised letter didn't take.
Shep
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 13 June 2001 : 17:25:10
|
Shep,
I can't fix it now from work, but when I get home tonight I will undertake the job of fixing this.
http://www.ugfl.net/forums |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 13 June 2001 : 20:28:43
|
Anyone Fix this error yet? This was one of the biggest errors with this mod 
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.
Test Site
www.eastpasco.com
HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 13 June 2001 : 23:39:25
|
got the same error,
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/testarea/31sr4test_m/inc_functions.asp, line 659
http://hibj.51.net/register.txt
http://hibj.51.net/inc_functions.txt
Edited by - bjlt on 13 June 2001 23:48:13 |
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 13 June 2001 : 23:53:39
|
bjlt,
Ricks problem was caused by an improper entry in his FORUM_MODS table
This table has 3 attributes
M_NAME
M_CODE
M_VALE
Please list all the entries in your database where M_NAME = NewMemPM
example
NewMemPM Admin Big9erFan
NewMemPM Subject This is your subject
NewMemPM Message This is your big ole Message
NewMemPM OnOff 1
For the others having the problem with Adding too much information change the M_VALE from a text 255 to memo field, and the M_CODE field to hold 255 characters instead of 50 and you'll be fine ( at least I was )
http://www.ugfl.net/forums
Edited by - big9erfan on 14 June 2001 00:10:47 |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 14 June 2001 : 02:12:32
|
quote:
bjlt,
Ricks problem was caused by an improper entry in his FORUM_MODS table
This table has 3 attributes
M_NAME
M_CODE
M_VALE
I'm sorry I don't quite understand it. You mean I need to check if the table is created like that?
well,
It worked on my local access db now., I've changed the length of the field.However, when try to changed the message, got the same error on line 46.
haven't settle it on remote sql as I don't have any table editor on hand now.
|
|
|
|
big9erfan
Average Member
540 Posts |
|
|
Topic |
|
Topic Locked
