Issue [DEVSOL-2418] is merged on the Developer Services portal for Private Cloud 4.17.01 ?

Not applicable

Hello,

We face several issues regarding the setup of monetization service inside the DevPortal on a private cloud deployement 4.17.01.


These issues have all in common a postgres database error.

I see that a very close match to our problem seems to have been fixed with the [DEVSOL-2418] issue on the 17.03.27.00 - Apigee Developer Services Portal Release. Is this fix embedded in the DevPortal on a private cloud deployement 4.17.01 ?

Details on our issues:

When doing a drush -v -d pm-enable 'devconnect_monetization'

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: "group_devconnect_monetization"  [error]LINE 2: WHERE  (id = 'group_devconnect_monetization')  ^ in /opt/apigee/apigee-drupal-7.53-0.0.12/includes/database/database.inc:2227

After that Drush goes crazy and is unusable:

PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "drupal_cache_mint" does not exist  [error]LINE 1: DELETE FROM drupal_cache_mint  ^: DELETE FROM {cache_mint}WHERE  (expire  :db_condition_placeholder_0) AND (expire < :db_condition_placeholder_1) ; Array(  [:db_condition_placeholder_0] => 0  [:db_condition_placeholder_1] => 1495122376)

And finally our DevPortal is broken and need a complete reinstalling.

Cheers,

JB Roux.

Solved Solved
2 2 153
1 ACCEPTED SOLUTION

Hi @Roux JB,

This is an on going issue in OPDK 4.17.01 with developer portal. You can resolve this by creating a copy of cache_mint table as drupal_cache_mint in postgres. If you earlier had dev portal installed on mysql then you can grab the schema of this table and create the same in postgres.

After creating table manually clear the drush cache and restart developer portal. This will resolve the issue with monetisation module.

Cheers!

View solution in original post

2 REPLIES 2

Hi @Roux JB,

This is an on going issue in OPDK 4.17.01 with developer portal. You can resolve this by creating a copy of cache_mint table as drupal_cache_mint in postgres. If you earlier had dev portal installed on mysql then you can grab the schema of this table and create the same in postgres.

After creating table manually clear the drush cache and restart developer portal. This will resolve the issue with monetisation module.

Cheers!

Thank you Mohammed, it has solved our issue. We were in the case of a fresh OPDK 4.17.01 install (no migration).

Cheers 🙂