| purple |
First Post Posted on: 07-16-09 02:11 PM |
| MySQL error message during account activation |
|
| 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 |
Reply #: 1 Posted on: 07-17-09 03:02 AM |
| Re: MySQL error message during account activation |
|
| You may be enabled the forum plugin in admin ->configuration without installing the forum software, if so disable it. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|