[Plugin: Football Pool] Questions not saved after update 1.3.1

I’ll look into it. Can you tell me what your upgrade path was? First install untill v1.3.1.

Weird. I just followed the exact same path and everything works fine. The only thing I can think of is that there is a problem with the new pool_wp_bonusquestions_type table.

You can try the following SQL statements to correct this. If you allready have multiple choice or photo questions in your database, you have to manually correct them, because this script will reset them to text questions and delete the options and image.

DROP TABLE IF EXISTS pool_wp_bonusquestions_type;

CREATE TABLE IF NOT EXISTS pool_wp_bonusquestions_type (
  question_id int(10) unsigned NOT NULL,
  type int(10) unsigned NOT NULL,
  options text NOT NULL,
  image text NOT NULL,
  PRIMARY KEY (question_id)
) DEFAULT CHARSET=latin1;

INSERT INTO pool_wp_bonusquestions_type ( question_id, type, options, image )
SELECT q.id, 1, '', ''
FROM pool_wp_bonusquestions q
LEFT OUTER JOIN pool_wp_bonusquestions_type qt
	ON ( qt.question_id = q.id )
WHERE qt.type IS NULL

p.s. I did find a bug in the deactivation of the plugin. The new pool_wp_bonusquestion_type table was not removed from the database. I fixed this in v1.3.2.

I don’t understand why the questions are in the database, but are not shown in the back-end (or front-end).

The plugin uses the following query to get the questions for the back-end. It has an inner join with the ‘pool_wp_bonusquestions_type’ table so my first guess was that this table was the cause of the problem. If the questions are not also in that table, the query result will be empty.

SELECT
	q.id, q.question, q.answer, q.points, UNIX_TIMESTAMP(q.answerBeforeDate) AS questionDate,
	DATE_FORMAT(q.scoreDate,'%Y-%m-%d %H:%i') AS scoreDate,
	DATE_FORMAT(q.answerBeforeDate,'%Y-%m-%d %H:%i') AS answerBeforeDate, q.matchNr,
	qt.type, qt.options, qt.image
FROM pool_wp_bonusquestions q
INNER JOIN pool_wp_bonusquestions_type qt
	ON ( q.id = qt.question_id )
ORDER BY q.answerBeforeDate ASC

Can you provide a dump of your pool_wp_bonusquestions and pool_wp_bonusquestions_type tables?