Results 1 to 10 of 10
  1. #1
    Join Date
    May 2007
    Posts
    93
    Plugin Contributions
    0

    database error Poll Manager error (mysql)

    ok installed this mod and after having to fix some characters, looked as though it would work, yet when added to admin and checked on page I lose all the right sideboxes due to this error:

    Code:
    1146 Table 'zenbullstore.TABLE_POLL_DESC' doesn't exist
    in:
    [select * from TABLE_POLL_DESC pd,  TABLE_POLL_DATA p                     where pd.poll_id = p.poll_id and poll_status = '1'  and poll_type = '1'                      and p.language_id = '1']
    Just tried to do again but got duplicate error, anyone.

    Gerry

  2. #2
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Poll Manager error (mysql)

    You are missing some file(s), recheck the package and make sure you upload ALL required files to the correct places.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  3. #3
    Join Date
    May 2007
    Posts
    93
    Plugin Contributions
    0

    Default Re: Poll Manager error (mysql)

    Well what wa odd is that after downloading and unzipping I uploaded all required files, but when I logged into admin I got a parse error, so I rechecked the files and found that some characters were added:

    example:


    See that box? so after removing that box, I re-uploaded that file and was able to get into admin. I rechecked other files to find the same thing and re-uploaded.

    I'll try again and see what happens.

    thanks,

    Gerry

  4. #4
    Join Date
    May 2007
    Posts
    93
    Plugin Contributions
    0

    red flag Re: Poll Manager error (mysql)

    More issues: Rechecked all files, some had to correct, re upload all files. Tried to login and got fatal error:

    Fatal error: Cannot redeclare zen_set_poll_status() (previously declared in /cart/admin/includes/functions/extra_functions/poll_manager.php:22)

    Here is the poll_manager.php line 22:

    Code:
    // +----------------------------------------------------------------------+
    //  $Id: poll_manager.php 2005-04-27 [email protected]
    //
    function zen_set_poll_status($poll_id, $status) {
        global $db;
        if ($status == '1') {
          return $db->Execute("update " . TABLE_POLL_DESC . "
                               set poll_status = '1', poll_last_modified = now()
                               where poll_id = '" . (int)$poll_id . "'");
    
        } elseif ($status == '0') {
          return $db->Execute("update " . TABLE_POLL_DESC . "
                               set poll_status = '0', poll_last_modified = now()
                               where poll_id = '" . (int)$poll_id . "'");
    
        } else {
          return -1;
        }
      }
    so whats a miss?

    Gerry

  5. #5
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Poll Manager error (mysql)

    Do you know how to use the Developer tool kit in zen admin-tools?

    Search for:
    function zen_set_poll_status

    You should see it appear twice or more. Then you will know which file should be deleted.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  6. #6
    Join Date
    May 2007
    Posts
    93
    Plugin Contributions
    0

    Default Re: Poll Manager error (mysql)

    Searching 413 files ... for: function zen_set_poll_status

    /cart/admin/includes/functions/extra_functions/poll_manager.php

    Line #21 : function zen_set_poll_status($poll_id, $status) {

    ** looks like no duplicates were found. Also searched functions and same instance came up as above.

    ???

    Gerry

  7. #7
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Poll Manager error (mysql)

    Then maybe this file poll_manager.php which contains the function was called twice for some reason ^^
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  8. #8
    Join Date
    May 2007
    Posts
    93
    Plugin Contributions
    0

    Default Re: Poll Manager error (mysql)

    well yeah could be but what do I know....guess u lost too.

  9. #9
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Poll Manager error (mysql)

    Usually, I have to lok at that mod, see what files it contains, then look at your folder and see what's in there. But we cant do that so yeah im lost.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  10. #10
    Join Date
    May 2007
    Posts
    93
    Plugin Contributions
    0

    Default Re: Poll Manager error (mysql)

    well guess I will call it a night then and check back tomorrow see if anyone else figures something out.

    thanks for help though.

 

 

Similar Threads

  1. Poll Manager Sidebox Background
    By ALFO in forum Templates, Stylesheets, Page Layout
    Replies: 11
    Last Post: 14 Jul 2010, 12:30 PM
  2. Poll manager problem
    By Gwiazda in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 26 May 2008, 05:02 PM
  3. Poll Manager
    By londoner1988 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 10 Jan 2008, 06:28 PM
  4. Poll Manager
    By ALFO in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 19 Nov 2007, 09:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR