Issue trying to create content.

Hi,

I had an issue with drupal so I initated a fresh install and after installing and setting up h5p I am getting the following error trying to add content. 

It looks like a database table is missing but I'm not sure why.

Any help would be greatly aprecaited. 

Cheers. Tomm.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'h5pdrupal.h5p_content_user_data' doesn't exist: UPDATE {h5p_content_user_data} SET timestamp=:db_update_placeholder_0, data=:db_update_placeholder_1 WHERE (content_main_id = :db_condition_placeholder_0) AND (delete_on_content_change = :db_condition_placeholder_1) ; Array ( [:db_update_placeholder_0] => 1448532382 [:db_update_placeholder_1] => RESET [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 ) in H5PDrupal->resetContentUserData() (line 425 of/Users/tomwarham/Sites/h5p/drupal/sites/all/modules/h5p/h5p.classes.inc).

falcon's picture

I'm unable to reproduce this problem. Witch version of the module are you using?

Hi,

I'm using drupal 7.41, h5p module 7.x - 1.11.

Its a fresh install of drupal, my mySql version has been updated from 5.6.21 to 5.7.9

I'm going to see if I can get the previosu version of MySql and see if this resolves the issue. 

 

falcon's picture

Hi again, ok, were there any error messages when you installed the module? Could you check manually if the table "h5p_content_user_data" or "h5pdrupal.h5p_content_user_data" is in your database?

Hi,

Checking in sequel there was no table 'h5p_content_user_data' present.

I've just removed the newer version of MySql (5.7) and reinstalled the latest version of 5.6.x (5.6.27)

It has installed fine on this version of MySql, I appear to be having issues locally now connecting on localhost, but this is an issue with crossed over config files I presume. 

falcon's picture

Ok, maybe Drupal has an issue with mySQL 5.7 then. We use Drupal's script to create the table so I don't think the problem is in H5P.