Support Forum

Support for my OSS Projects

1. 

   jmarciante
   Member

   Hello Binny and forum!
   We are having problems with the survey plugin. We are running version 2.8.4 of Wordpress and have your plugin from the 1/5/2010 updates. When creating a survey, it takes you all the way through to creating the questions. However, when you return to Manage Surveys, it tells you that there are no surveys created. The same thing happens with the questions. If you go to the Questions Page, there are no questions saved. The only place data is being stored is in the Results. If you go to see the results, you can see all of the answers you have created.
   Anyone have any ideas what is going on with the code?
   Many thanks,
   Jenn

   Posted 1 year ago #
2. 

   kaifanun
   Member

   Having same problem here. Running WP version 2.9

   Posted 1 year ago #
3. 

   pjllaneras
   Member

   I have the same problem. I have a wordpress web with survey plugin and I can't create surveys.

   This web is hosted on a Windows Server 2008, and all other plugins work pretty well.

   Is strange, because for develope I have the same web on my laptop running Ubuntu 10.04 and the surveys work well... I supose is something related to Windows Server.

   The function "$wpdb->get_results" doesn't work on Windows Server. This is the code of surveys_action.php that doesn't work:

   $wpdb->get_results("INSERT INTO {$wpdb->prefix}surveys_survey(name,description,status,added_on) VALUES('$_REQUEST[name]','$_REQUEST[description]','$_REQUEST[status]',NOW())");

   I have tried to change "get_results" function for "query" and "insert" but none works.

   Posted 1 year ago #
4. 

   pjllaneras
   Member

   I have found the problem... fist I've activated debuging in wp-config.php:

   @ini_set('display_errors',0);
   define('WP_DEBUG', true); // Turn debugging ON
   define('WP_DEBUG_DISPLAY', false); // Turn forced display OFF
   define('WP_DEBUG_LOG', true); // Turn logging to wp-content/debug.log ON

   Then I tried to create a new survey (and it hasn't created)... then I've looked into wp-content/debug.log and I've found this error:

   WordPress database error Field 'final_screen' doesn't have a default value for query INSERT INTO wp_surveys_survey(name,description,status,added_on) VALUES('test','survey test','1',NOW())

   Ok... first I've looked how the plugin creates the field 'final_screen" in surveys_survey table:

   final_screen mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

   Ok... it's defined as "NOT NULL"... well I don't know why in a Linux server this work but in Windows doesn't.

   SOLUTION: edit (with PHPMyAdmin) the 'final_screen' field of "surveys_survey" table and activate the "NULL" property.

   Perhaps it can be changed in future revision.

   That's all.

   Posted 1 year ago #
5. 

   pjllaneras
   Member

   The same problem hapens with fields "name" and "email" from "surveys_result" table... the same solution as the field "final_screen" from "surveys_survey" table works.

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.