Elxis CMS Forum

Support => Database => Topic started by: amirsardari on July 18, 2011, 15:41:41

Title: problem in insert comment
Post by: amirsardari on July 18, 2011, 15:41:41

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

Title: Re: problem in insert comment
Post by: datahell on July 18, 2011, 18:46:38

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>

Title: Re: problem in insert comment
Post by: amirsardari on July 19, 2011, 09:59:34

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?

Title: Re: problem in insert comment
Post by: amirsardari on July 19, 2011, 10:27:38

I was able to solve it.
Thanks