problem in insert comment

[amirsardari]

when I want to insert a comment in site,I can insert it,but can not record and see this error:

URI: index2.php
Message: Unknown column 'notify' in 'where clause'
SELECT author, email FROM elx_comments WHERE origin=1 AND articleid=5614 AND published=1 AND notify=1 AND email<>'rekalantari@yahoo.com' GROUP BY ema

[datahell]

I guess you have updated from an older Elxis version but you forgotten to update the database. Column "notify" should exist in table elx_comments.

XML schema for table elx_comments on Elxis 2009.3:

Code: [Select]

<table name="comments">
<field name="cid" type="I">
<KEY />
<AUTOINCREMENT />
</field>
<field name="origin" type="I1">
<NOTNULL />
<DEFAULT value="0" />
</field>
<field name="articleid" type="I">
<NOTNULL />
<DEFAULT value="0" />
</field>
<field name="cmessage" type="X2"></field>
<field name="ctimestamp" type="C" size="20"></field>
<field name="ipaddress" type="C" size="64"></field>
<field name="userid" type="I">
<NOTNULL />
<DEFAULT value="0" />
</field>
<field name="author" type="C" size="80"></field>
<field name="email" type="C" size="120"></field>
<field name="published" type="I1">
<NOTNULL />
<DEFAULT value="1" />
</field>
<field name="notify" type="I4">
<NOTNULL />
<DEFAULT value="0" />
</field>
</table>

[amirsardari]

I add column "notify" in table elx-comments,but there are 2 problems:

1.I dont know what does it means: "type:I4"

2.what can I write in column "notify" for insert comment?

[amirsardari]

I was able to solve it.
Thanks