Support Forum

Support for my OSS Projects

1. 

   Binny V A
   Key Master

   I justed installed an activated the pollin plugin. I can edit a new poll, but after I save it, I do not see it.
   
   When I say save, the manage polls pages says "Question added."
   
   But there are no polls appearing in the list, it just says "No questions found."
   
   Any idea how to fix this?
   
   thanks

   Posted 2 years ago #
2. 

   Binny V A
   Key Master

   Yep, having this exact issue

   Posted 2 years ago #
3. 

   Anonymous
   Unregistered

   Sorry about this guys. I'll look into this as soon as I get some time. I should get some time ass soon as my [url=http://www.bin-co.com/blog/2009/07/plugin-week-2-wordpress-plugin-weather-man/:2cabnymg]Plugin Week 2[/url:2cabnymg] is completed.

   Posted 2 years ago #
4. 

   Binny V A
   Key Master

   I am having the exact problem!
   
   Please fix this!

   Posted 2 years ago #
5. 

   Anonymous
   Unregistered

   Hello I have the same issue and I really want to try your plugin, also the survey plugin has problems, when I try to save a survey redirect me to a 404 error and no surveys!
   
   Hope you have time to fix it and thank you for your effort!
   
   Diana from Mexico City

   Posted 2 years ago #
6. 

   Anonymous
   Unregistered

   Sorry about the delay. I can't seem to reproduce that error. Can you give me the following details...
   
   Server OS
   Web Server
   Wordpress Version
   Browser / version
   The exact URL you are being redirected to.

   Posted 2 years ago #
7. 

   Binny V A
   Key Master

   Linux
   Wordpress 2.8
   ie 8
   
   Not sure about the web server question or the rediredt url?
   It's within the wordpress admin pages when we make a new poll and hit save. It redirects us back to the polls page where it should show all of the polls we have created. No polls exist there even thought we just created them.

   Posted 2 years ago #
8. 

   Anonymous
   Unregistered

   Can you download the attached file, extract it and then upload it to your server - into the pollin folder? After that try to create a new poll. This will not fix the problem - but it will show the error message that I need to fix the issue.

   Posted 2 years ago #
9. 

   Binny V A
   Key Master

   I am having the same problem as well. I uploaded the file you suggested. Here is my info:
   Windows Vista
   Internet Explorer 8
   Wordpress 2.8.2

   Posted 2 years ago #
10. 

    Binny V A
    Key Master

    Here is the error message produced after uploading the file:
    WordPress database error: [Table 'michellemusic.wp_pollin_answer' doesn't exist]
    SELECT Q.ID,Q.question,Q.status,(SELECT COUNT(*) FROM wp_pollin_answer WHERE question_ID=Q.ID) AS answer_count FROM `wp_pollin_question` AS Q

    Posted 2 years ago #
11. 

    Anonymous
    Unregistered

    I think I understand now - you have to find the version of your Database server. This plugin only works with MySQL 5 - it fails with MySQL 4. I think your's is MySQL 4.

    Posted 2 years ago #
12. 

    Binny V A
    Key Master

    Thanks for solving the mystery! Too bad it doesn't work, but at least now I know why. I appreciate your response.

    Posted 2 years ago #
13. 

    Binny V A
    Key Master

    I use mysql 5 and experience EXACTLY the same problem. Any clue on how to fix it?
    
    Thanks.

    Posted 2 years ago #
14. 

    Binny V A
    Key Master

    Same problem here, i am using php5 and WP 2.8.3 on [url:yc7efyn2]http://www.infotech-de.com[/url:yc7efyn2]
    
    Best wishes from germany, Holger

    Posted 2 years ago #
15. 

    Anonymous
    Unregistered

    This is rather odd - it works fine for me. Anyway, I'll look into this issue a bit more. If I can reproduce the error, I'll fix it.

    Posted 2 years ago #
16. 

    Binny V A
    Key Master

    Your plug in seem to be so user-friendly and perfect. Unfortunately it does not work for any of us. Please let us know step by step what actions you took from when you install the plug in to editing. Maybe if we do that it will work. Also, do we need to tweak the php code? If so, please give detailed instructions as I only have basic html knowledge. Thanks much.

    Posted 2 years ago #
17. 

    Anonymous
    Unregistered

    I also ran into this exact problem. I got into the MySQL Wordpress database and found that the wp_pollin_answer table was missing. I checked the code in pollin.php that creates the tables and I did not see any obvious problems. I copied the code from plugin.php and pasted it into the MySQL CLI and the wp_pollin_answer table created successfully. After doing this, I can create polls.
    
    My platform and software information is:
    
    OS: FreeBSD 7.1-STABLE
    MySQL: 5.0.67
    PHP: 5.2.6
    Apache: 2.0.63
    Wordpress: 2.8.4

    Posted 2 years ago #
18. 

    Binny V A
    Key Master

    Yep, i've got the exact same problem. pollin_answer table wasn't created so created it as in the post above, and everything works now.
    
    Only thing... I can't see the poll ID anywhere in Manage Polls? It's obviously not the #, which changes if you delete polls.

    Posted 2 years ago #
19. 

    Binny V A
    Key Master

    The source of the problem seems to be that the two table creation commands are put into one SQL call (line 106 in pollin.php) which at least some versions don't like. Only the second CREATE TABLE is executed correctly. Maybe dbDelta() does not handle multiple SQL commands?

    Posted 2 years ago #
20. 

    Binny V A
    Key Master

    Same here. Created a poll, but it doesn't appear on my Manage Polls page. There is no wp_pollin_answer table in my pollin plugin folder. Should there be?

    Posted 2 years ago #
21. 

    Binny V A
    Key Master

    I ran into the same problem. Here is how I got things working:
    
    After looking at the tables in my wordpress database, the pollin tables were not created by the installation routine. I created them manually as follows:
    
    1) determine the table prefix used by your wordpress installation. Look at the tables in the wordpress database and find the comments table. (generally the first table when the tables are sorted alphabetically) The prefix normally consists of wp_{6 charaters}_ and will look something like this "wp_8gg0an_" including the underscores. You will need this exact string to ensure that the tables will work with your installation of wordpress. I cut & paste the table creation code from the pollin.php file. Please remember to use your prefix text and replace the {prefix} in the code below or the code you cut from the pollin.php file.
    
    

    CREATE TABLE IF NOT EXISTS {prefix}pollin_answer (
ID int(11) unsigned NOT NULL auto_increment,
question_ID int(11) unsigned NOT NULL,
answer varchar(255) default NULL,
sort_order int(3) NOT NULL,
votes int(5) NOT NULL default '0',
PRIMARY KEY (ID),
KEY question_ID (question_ID)
);
CREATE TABLE IF NOT EXISTS {prefix}pollin_question (
ID int(11) unsigned NOT NULL auto_increment,
question mediumtext NOT NULL,
added_on datetime NOT NULL,
status enum('1','0') NOT NULL default '1',
PRIMARY KEY (ID)
);

    
    
    I hope this helps.
    
    Gavin aka SparkPilot - http://sparkpilot.com/blog

    Posted 2 years ago #
22. 

    ZooMeister
    Member

    GREAT, Thats it. I had the same problem, after activating the plugin. In the database was only the table pollin_question, but not pollin_answers. After creating the table with your script manually, it works.
    Thanks

    Posted 2 years ago #
23. 

    g1_real
    Member

    Nice one @Binny V A. This just worked perfectly. But I have a question to the owner of this plugin: how come you didn't notice that your plugin doesn't install the answer table in the installation routine?

    Posted 1 year ago #
24. 

    Binny V A
    Key Master

    It should - no idea why it isn't working. It works for most people.

    Posted 1 year ago #
25. 

    Zhu Zhu
    Member

    Hi Guys I read all threads on this forums .Have some useful data for me .I have some problems but after read all threads i solve maximum problems of mine. You done great job.Thanks

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.