| Welcome Visitor, Please Login or Register Now |
|
Friday, April 19, 2024 07:47 AM |
 |
purple  |
| Registered Member |
Posts: 6  |
| Joined: 12-31-05 07:43 AM |
|
|
|
 |
   |
|
| |
 |
|
| MySQL error message during account activation |
Edit Delete   Quote |
| First Post Posted on: 07-16-09 02:11 PM |
  |
|
|
| I'm getting the following error message when clicking on the email link to activate an account.\
\
SQL Error: Unknown column 'Reads' in 'field list'\
Query:\
INSERT INTO Forum_Users_Info SET AttachSign='1',YIM='',Occupation='',Custom7='',\
LastVist='1136785547',View='1',Custom5='',DateFormat=NULL,\
AIM='',Attach='1',NotifyPM='1',WebURL='',ViewEmail='1',\
AllowPM='1',Custom6='',ViewIP='1',Edit='1',Post='1',\
Custom10='',Custom9='',Sticky='1',Avatar='',ViewOnline='1',\
Custom4='',ICQ='',Timezone='10',Interests='',Poll='1',\
Custom1='',Reply='1',Custom2='',Location='',Custom3='',\
Deletes='1',MSNM='',Announce='1',WebTitle='',EmailTime='0',\
Browse='1',Language='English',Vote='1',Posts='0',Reads='1',\
Rank='0',Level='0',User_ID='userx',Custom8='',Sig=''\
Line 645, File /home/html/auctions/cgi-bin/auction/SQLlib.pm.\
\
\
Despite the error message, the account is being activated and the user can login after the link is clicked on. I'm using a combined registration database for auctionawy/classifiedawy/boardawy (registration for all 3 products is being done through the auctionawy registration form).\
\
edited to add: in the forums_user_info table there is a readx field but not the read field the query is looking for. |
|
|
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 04-19-24 07:47 AM |
| Location: knxoville, TN, USA |
 |
|
|
    |
|
| |
|
|
|
|
| |
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.0670 Seconds |
|
