General ⇒ DVCS Info (Mercurial/CVS) :: Archives ⇒ Surveys issue - warning was issued about using it :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexDVCS Info (Mercurial/CVS)

Archived ⇒ Surveys issue - warning was issued about using it


I got another error while trying out CVS on my localhost installation.

On /radopod/index.php While executing query "SELECT poll_id, poll_title, voters, anonymous FROM cms_poll_desc WHERE artid=0 AND planguage='english' OR planguage='' ORDER BY poll_id DESC LIMIT 0,1" the following error occured: Unknown column 'anonymous' in 'field list' In: C:\Server\Apache2\htdocs\radopod\blocks\block-Survey.php on line: 27

I believe the errors arise from the recent changes brought into the CVS after Mammlouk's work on it. But some clarification on this will be welcome.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


@ Catch in your db select table cms_poll_desc drop the column named anonymous. it shouldnt be there

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups

Last edited by Dizfunkshunal on Tue Sep 04, 2007 3:32 pm; edited 1 time in total


Actually, it's quite the opposite. The query is looking for the "anonymous" column, but it was not created by the installer. You need to create that field in order for the query to succeed. Either that, or you can remove anonymous from the query in block-Survey.php on line 27.

I will be looking at the survey code to make required fixes today and tomorrow as I have time.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


thanks for the correction

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


Thanks for the help. Should look into it tommorow at the earliest.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


Dizfunkshunal wrote
thanks for the correction

No prob. Everyone says something backwards now and again Wink

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


sdrawkcab ffuts epyt I nehw ti ees dlouhs uoy

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


ecin

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


all fixed now

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Awesome.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are UTC