| Author |
 Topic  |
|
|
mb
Starting Member
9 Posts |
 Posted - 02 May 2001 : 07:14:59
|
After install File Attachment mod
there are some problems to register new members
What is wrong by the sql statement
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_SIG, M_YAHOO, M_ICQ, M_AIM, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE) VALUES ('1', '1', '12112.ssdasd@wef.de', '20010502131542', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20010502131542', 1, '1', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '')
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Field 'FORUM_MEMBERS.M_OCCUPATION' can't be a zero-length string.
/d_ee/test/forumsr4/register.asp, line 284
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 May 2001 : 07:59:39
|
The error message is telling you what's wrong.
If you can edit yoour DB, you need to set the field to allowzerolength, alternatively you can edit the INSERT query so that it inserts a space instead of an empty string.
|
 |
|
|
mb
Starting Member
9 Posts |
Posted - 02 May 2001 : 08:13:38
|
But why these error message occur, only after update file attachment mod.??
The strSql in register.asp ist the same
before update and in the db always zero-length string not allowed for all text-fields.
|
|
|
| |
Topic |
|
|
|
Topic Locked
