| Author |
 Topic  |
|
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 19 January 2013 : 03:16:24
|
I'm sure "Change Username" is not the actual name of the mod but that's what it allows members to do so I hope you guys know which mod I'm referring to here. Anyway, this is the error message:
Can't change username - error - Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[MySQL][ODBC 3.51 Driver][mysqld-5.1.56-community]Table 'tfpmembers.forum_common' doesn't exist
/tfp/ChangeMe.asp, line 172
Here are lines 162 - 179 below. I have a feeling this is not what you need though! Is this a database problem? 
If NOT (rs.BOF or rs.EOF) Then
If rs("M_CHANGEDNAME") > "" Then
Err_Msg = "<br><br><li>Error: You already changed your username, it cannot be changed again.</li>"
rs.Close
Set rs = Nothing
GoError(Err_Msg)
End If
Set rs = Nothing
End If
strSql = "SELECT WORDLIST FROM " & strTablePrefix & "COMMON WHERE WORDLIST='" & chkString(Request.Form("NewUserName"), "SQLString") & "'"
Set rs=my_Conn.Execute(strSql)
if not rs.EOF Then
Err_Msg = "<br><br><li>Requested username is too common, please select another.</li>"
rs.Close
Set rs = Nothing
GoError(Err_Msg)
End If
Set rs = Nothing
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 19 January 2013 : 03:41:52
|
No, I just inadvertently left it out. It was just a list of common words so that a user didn't choose a name like "the, a, an, of, etc....".
"dbs_common_words.asp"
Common Word Table 1.1
[DROP]
COMMON
[END]
[CREATE]
COMMON
WORDLIST#VARCHAR(255)##
REPLACE#VARCHAR(255)##
[END]
[INSERT]
COMMON
(WORDLIST,REPLACE)#('0','')
(WORDLIST,REPLACE)#('1','')
(WORDLIST,REPLACE)#('2','')
(WORDLIST,REPLACE)#('3','')
(WORDLIST,REPLACE)#('4','')
(WORDLIST,REPLACE)#('5','')
(WORDLIST,REPLACE)#('6','')
(WORDLIST,REPLACE)#('7','')
(WORDLIST,REPLACE)#('8','')
(WORDLIST,REPLACE)#('9','')
(WORDLIST,REPLACE)#('a','')
(WORDLIST,REPLACE)#('am','')
(WORDLIST,REPLACE)#('an','')
(WORDLIST,REPLACE)#('and','')
(WORDLIST,REPLACE)#('are','')
(WORDLIST,REPLACE)#('be','')
(WORDLIST,REPLACE)#('being','')
(WORDLIST,REPLACE)#('but','')
(WORDLIST,REPLACE)#('down','')
(WORDLIST,REPLACE)#('for','')
(WORDLIST,REPLACE)#('from','')
(WORDLIST,REPLACE)#('had','')
(WORDLIST,REPLACE)#('has','')
(WORDLIST,REPLACE)#('have','')
(WORDLIST,REPLACE)#('her','')
(WORDLIST,REPLACE)#('hers','')
(WORDLIST,REPLACE)#('him','')
(WORDLIST,REPLACE)#('his','')
(WORDLIST,REPLACE)#('how','')
(WORDLIST,REPLACE)#('I','')
(WORDLIST,REPLACE)#('if','')
(WORDLIST,REPLACE)#('in','')
(WORDLIST,REPLACE)#('is','')
(WORDLIST,REPLACE)#('it','')
(WORDLIST,REPLACE)#('left','')
(WORDLIST,REPLACE)#('my','')
(WORDLIST,REPLACE)#('no','')
(WORDLIST,REPLACE)#('nor','')
(WORDLIST,REPLACE)#('not','')
(WORDLIST,REPLACE)#('of','')
(WORDLIST,REPLACE)#('our','')
(WORDLIST,REPLACE)#('ours','')
(WORDLIST,REPLACE)#('out','')
(WORDLIST,REPLACE)#('right','')
(WORDLIST,REPLACE)#('than','')
(WORDLIST,REPLACE)#('that','')
(WORDLIST,REPLACE)#('the','')
(WORDLIST,REPLACE)#('their','')
(WORDLIST,REPLACE)#('theirs','')
(WORDLIST,REPLACE)#('them','')
(WORDLIST,REPLACE)#('then','')
(WORDLIST,REPLACE)#('they','')
(WORDLIST,REPLACE)#('this','')
(WORDLIST,REPLACE)#('to','')
(WORDLIST,REPLACE)#('too','')
(WORDLIST,REPLACE)#('up','')
(WORDLIST,REPLACE)#('was','')
(WORDLIST,REPLACE)#('were','')
(WORDLIST,REPLACE)#('what','')
(WORDLIST,REPLACE)#('when','')
(WORDLIST,REPLACE)#('where','')
(WORDLIST,REPLACE)#('who','')
(WORDLIST,REPLACE)#('why','')
(WORDLIST,REPLACE)#('you','')
(WORDLIST,REPLACE)#('your','')
[END]
|
Edited by - Carefree on 19 January 2013 03:42:45 |
 |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 19 January 2013 : 04:20:01
|
This is what I got when I ran the database, Carefree.
Afterwards, I still received the same error as above.
Dropping Table..
Table does not exist
--------------------------------------
Creating table(s)...
CREATE TABLE FORUM_COMMON( WORDLIST varchar(255) NOT NULL , REPLACE varchar(255) NOT NULL )
Table already exists
--------------------------------------
Adding new records..
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('0','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('1','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('2','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('3','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('4','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('5','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('6','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('7','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('8','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('9','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('a','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('am','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('an','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('and','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('are','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('be','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('being','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('but','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('down','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('for','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('from','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('had','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('has','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('have','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('her','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('hers','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('him','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('his','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('how','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('I','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('if','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('in','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('is','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('it','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('left','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('my','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('no','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('nor','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('not','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('of','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('our','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('ours','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('out','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('right','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('than','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('that','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('the','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('their','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('theirs','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('them','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('then','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('they','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('this','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('to','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('too','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('up','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('was','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('were','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('what','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('when','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('where','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('who','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('why','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('you','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('your','')
INSERT INTO FORUM_COMMON (WORDLIST,REPLACE) VALUES ('your','')
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.1.56-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLACE) VALUES ('your','')' at line 1
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 19 January 2013 : 07:01:34
|
quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLACE) VALUES ('your','')' at line 1[/red]
Duhhhh - the word "replace" is restricted in mysql. I'll have to change it for you.
Common Word Table 1.1
[DROP]
COMMON
[END]
[CREATE]
COMMON
WORDLIST#VARCHAR(255)##
W_REPLACE#VARCHAR(255)##
[END]
[INSERT]
COMMON
(WORDLIST,W_REPLACE)#('0','')
(WORDLIST,W_REPLACE)#('1','')
(WORDLIST,W_REPLACE)#('2','')
(WORDLIST,W_REPLACE)#('3','')
(WORDLIST,W_REPLACE)#('4','')
(WORDLIST,W_REPLACE)#('5','')
(WORDLIST,W_REPLACE)#('6','')
(WORDLIST,W_REPLACE)#('7','')
(WORDLIST,W_REPLACE)#('8','')
(WORDLIST,W_REPLACE)#('9','')
(WORDLIST,W_REPLACE)#('a','')
(WORDLIST,W_REPLACE)#('am','')
(WORDLIST,W_REPLACE)#('an','')
(WORDLIST,W_REPLACE)#('and','')
(WORDLIST,W_REPLACE)#('are','')
(WORDLIST,W_REPLACE)#('be','')
(WORDLIST,W_REPLACE)#('being','')
(WORDLIST,W_REPLACE)#('but','')
(WORDLIST,W_REPLACE)#('down','')
(WORDLIST,W_REPLACE)#('for','')
(WORDLIST,W_REPLACE)#('from','')
(WORDLIST,W_REPLACE)#('had','')
(WORDLIST,W_REPLACE)#('has','')
(WORDLIST,W_REPLACE)#('have','')
(WORDLIST,W_REPLACE)#('her','')
(WORDLIST,W_REPLACE)#('hers','')
(WORDLIST,W_REPLACE)#('him','')
(WORDLIST,W_REPLACE)#('his','')
(WORDLIST,W_REPLACE)#('how','')
(WORDLIST,W_REPLACE)#('I','')
(WORDLIST,W_REPLACE)#('if','')
(WORDLIST,W_REPLACE)#('in','')
(WORDLIST,W_REPLACE)#('is','')
(WORDLIST,W_REPLACE)#('it','')
(WORDLIST,W_REPLACE)#('left','')
(WORDLIST,W_REPLACE)#('my','')
(WORDLIST,W_REPLACE)#('no','')
(WORDLIST,W_REPLACE)#('nor','')
(WORDLIST,W_REPLACE)#('not','')
(WORDLIST,W_REPLACE)#('of','')
(WORDLIST,W_REPLACE)#('our','')
(WORDLIST,W_REPLACE)#('ours','')
(WORDLIST,W_REPLACE)#('out','')
(WORDLIST,W_REPLACE)#('right','')
(WORDLIST,W_REPLACE)#('than','')
(WORDLIST,W_REPLACE)#('that','')
(WORDLIST,W_REPLACE)#('the','')
(WORDLIST,W_REPLACE)#('their','')
(WORDLIST,W_REPLACE)#('theirs','')
(WORDLIST,W_REPLACE)#('them','')
(WORDLIST,W_REPLACE)#('then','')
(WORDLIST,W_REPLACE)#('they','')
(WORDLIST,W_REPLACE)#('this','')
(WORDLIST,W_REPLACE)#('to','')
(WORDLIST,W_REPLACE)#('too','')
(WORDLIST,W_REPLACE)#('up','')
(WORDLIST,W_REPLACE)#('was','')
(WORDLIST,W_REPLACE)#('were','')
(WORDLIST,W_REPLACE)#('what','')
(WORDLIST,W_REPLACE)#('when','')
(WORDLIST,W_REPLACE)#('where','')
(WORDLIST,W_REPLACE)#('who','')
(WORDLIST,W_REPLACE)#('why','')
(WORDLIST,W_REPLACE)#('you','')
(WORDLIST,W_REPLACE)#('your','')
[END]
|
Edited by - Carefree on 19 January 2013 07:04:14 |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 19 January 2013 : 15:11:35
|
PERFECT! It works PERFECT now!
Thank you Soooo much, Carefree!!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
| |
Topic |
|
|
|
