Problems installing Booth v2.0

[kodomo]

Hi all

 

I tried to install the booth v2.0 and have the following problems

 

(1) At the admin console, I have this error when I click the Poll Manager

 

Poll Manager

 

Fatal error: Call to undefined function: tep_array_merge() in C:Program FilesApache GroupApache2htdocskodomo3adminpolls.php on line 185

 

(2) At the catalog side, I have this error after completing the booth

 

See what others think See what others think

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from phesis_comments where pollid = '2' and language

 

select count(select * from phesis_comments where pollid = '2' and language_id = '1') as total

 

[TEP STOP]

 

 

I have followed the instructions and still have the same results after doing re-installation.

 

Anyone knows how to resolve this ? Thanks a lot.

 

Cheers

kodomo

[Guest]

The version of osC you are using does not have the function 'tep_array_merge'..... ie. the contribution you are trying to install is not compatible.

 

Have to see the code that outputs your SQL query to fix it... but not much point there re. the above :shock: [/code]

[msheno01]

So what is the fix for the sql syntax. I would like to know because I am having the same problem and it would be nice if someone allready have found a fix instead of me researching it.

 

Thanks

[Guest]

You should post the relevant snippet of code - this is a contribution :shock:

[msheno01]

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from phesis_comments where pollid = '2' and language

 

select count(select * from phesis_comments where pollid = '2' and language_id = '1') as total

 

[TEP STOP]

 

 

This is exactly what I am recieving as an error.

I am using sql 4.1.

 

Thanks

[ricardo]

However i took the merge function from MS1 and got it to work.

 

Anyway i still have that same SQL statement error like you have.

 

if anyone has a clue ... Please let us know

[ricardo]

For anyone who want to see the code ..

 

http://www.intrance.nl/pollbooth.php.txt

[Guest]

Hey,

I've installed and really like the contrib. While testing I had set the "Allow multiple votes" option to YES in order to test and make a few slight html changes. I changed the "Allow multiple votes" option to NO after I felt the contrib was installed and setup how I wanted.

Now I wanted to test poll to make sure it would not allow multiple votes, figuring I'd get a nice error page. Instead I got the rather rude :shock: error found below. Any suggestions on what may be causing this error?

 

Thanks!

 

This is the error I'm getting:

1054 - Unknown column 'warn' in 'where clause'



select optionText from phesis_poll_data where pollid=2&warn=_ALREADY_VOTED and voteid='0' and language_id = '1'



[TEP STOP]

 

This is the snippit of code I believe is causing the problem from catalog/pollcollect.php:

tep_db_query($query);

if ($voteid) {

       $result=tep_db_query("select poll_type, poll_open from phesis_poll_desc where pollid=$pollid");

       $poll=tep_db_fetch_array($result);

       if ($poll['poll_open']=='1') {

               $votevalid=0;

               $warn="_POLLCLOSED";

               }

       if ($poll['poll_type']=='1' && !isset($customer_id)) {

               $votevalid=0;

               $warn="_POLLPRIVATE";

               }

       if ($votevalid==1 && POLL_SPAM==0) {

               $query="SELECT ip FROM phesis_poll_check WHERE ip='".$ip."' and pollid='".$pollid."'";

               $result=tep_db_query($query);

               $result1=tep_db_fetch_array($result);

               $ips=$result1['ip'];

               $ctime = time();

               if ($ip == $ips) {

                       $votevalid = 0;

                       $warn="_ALREADY_VOTED";

                       } else {

                     $query="INSERT INTO phesis_poll_check (ip, time, pollid) VALUES ('".$ip."', '".$ctime."' , '".$pollid."')";

                     tep_db_query($query);

                       $votevalid = 1;

               }

       }

}

 

I've also checked at found that _ALREADY_VOTED is defined in

catalog/includes/languages/english/pollbooth.php with the following: define('_ALREADY_VOTED', 'You've recently voted in this poll.');

[woekiewoekie]

For your second problem I posted a solution in the original pollbooth thread.

 

http://www.oscommerce.com/forums/viewtopic.php...p=214730#214730

 

I don't know but the best thing to do in my opinion is to state problems in the original contributions threads.

To be honest I didn't also do that in the past, but I think that is the nettiquette here (correct me if I am wrong)[/url]

[defender39]

I found out because of another error that this script is not setup well for search engine friendly URLS. If you change the setting to false it will work. I am looking into fixing it now but if anyone can help out that would be great. I am not a php programmer but I get by.

[defender39]

YEAH!!! I fixed this too...

 

only do this fix if you have search engine friendly URLS on as it may break again if you shut them off.

Change in pollcollect.php around line 49

 

$forwarder .= "&warn=" . $warn;

 

to

$forwarder .= "/warn/" . $warn;

[jwsfun]

I'm trying to install the PollBooth contribution and just got this error:

 

Fatal error: Cannot redeclare class pollinfo in /home/owners/public_html/shop/admin/includes/classes/poll_info.php on line 2

 

poll_info.php looks like:

 

<?php
 class pollInfo {
   var $id, $title, $votes, $timestamp;

// class constructor
   function pollInfo($poInfo_array) {
     $this->id = $poInfo_array['pollID'];
     $this->title = $poInfo_array['pollTitle'];
     $this->votes = $poInfo_array['voters'];
     $this->timestamp = $poInfo_array['timeStamp'];
   }
 }
?>

 

Can someone please help me fix this?

Thank you :).