Error when using Openbadges App | Opigno LMS | Learning Management System based on Drupal

schifazl

Tue, 09/01/2015 - 16:16

Forums

Hi. I'm having some problem with the Openbadges App. I've tried uninstalling it and reinstalling the module without success. When I click on a user to manage him/her, if the app is enabled I get this error: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'elearning.opigno_openbadges_backpack_connect' doesn't exist: SELECT * FROM opigno_openbadges_backpack_connect WHERE uid = 219; Array ( ) in BackpackConnectDb::getEntries() (line 125 of elearning/sites/all/modules/opigno_mozilla_openbadges_app/includes/backpack_connect/storage/backpackconnectdb.opigno_mozilla_openbadges_app.inc). This happens for every user. I've checked the three openbadges tables, and they are empty. It's OK to write this here or should I open an issue on the app's project page on drupal.org? Thanks, Borut

James Aparicio

Tue, 09/01/2015 - 16:49

Hi schifazl,

Can you check your database and check if there is a table called elearning.opigno_openbadges_backpack_connect?

Or one called opigno_openbadges_backpack_connect?

Best regards

schifazl

Fri, 10/30/2015 - 11:38

Hi!

Hi! Sorry for disappearing, I had two tough months. I have these tables:

opigno_opigno_openbadges_backpack_connect
opigno_opigno_openbadges_backpack_displayer
opigno_opigno_openbadges_backpack_displayer_collections

Maybe it's enough to remove the first "opigno_"?

James Aparicio

Fri, 10/30/2015 - 13:04

Hi Schifazl,

Yes, try renaming the tables and let me know if it worked.

Maybe there is a query not taking into account the prefix you set when installing opigno. We will take a look.

Best regards

cruzrincon

Mon, 01/11/2016 - 01:20

The very same error

The error: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sahumorg_drup363.opigno_openbadges_backpack_connect' doesn't exist: SELECT * FROM opigno_openbadges_backpack_connect The name of my databae: sahumorg_drup363 I can confirm that I have theese tables: opingo_lms_opigno_openbadges_backpack_connect opingo_lms_opigno_openbadges_backpack_displayer opingo_lms_opigno_openbadges_backpack_displayer_collections Renamed them to: opigno_openbadges_backpack_connect opigno_openbadges_backpack_displayer opigno_openbadges_backpack_displayer_collections With no success. Had to disable Openbadges App in order to restore funcionality of Profile

Amermod

Mon, 01/11/2016 - 12:23

Hi Cruzrincon and Schifazl,

This bug will be fixed in the next release of Opigno (will be released realy soon).

Stay tuned

Greetings,

Allan Mermod