Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problems installing Booth v2.0


kodomo

Recommended Posts

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

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
Share on other sites

  • 2 weeks later...

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.');

Link to comment
Share on other sites

  • 2 weeks later...

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]

Link to comment
Share on other sites

  • 2 months later...

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.

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

  • 4 weeks later...

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 :).

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...