search

apigee / apigee-m10n-drupal

Add monetization features to a Drupal developer portal
https://www.drupal.org/project/apigee_m10n
GNU General Public License v2.0
13 stars 13 forks source link

Unable To Purchase a Rate Plan using Devportal #261

Closed shuhaibofficial closed 3 years ago

shuhaibofficial commented 3 years ago

Description

when I am Trying to Purchase a Rate plan From the Drupal Dev portal it is throwing Php Error. Also, Terms & Condition WIdget is not showing in the Purchase Form, BUT when I tried with Drupal Site Admin Its Showing the Widget[Only SomeTimes] But still got the Php Error.

PHP ERROR:

The website encountered an unexpected error. Please try again later.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "sub_g_bundle-comx_sub_g_plan" LINE 5: ...d_data.status = '1') AND (node_field_data.nid IN ('sub_g_bun... ^: SELECT base_table.vid AS vid, base_table.nid AS nid FROM {node} base_table INNER JOIN {node_field_data} node_field_data ON node_field_data.nid = base_table.nid WHERE (node_field_data.status = :db_condition_placeholder_0) AND (node_field_data.nid IN (:db_condition_placeholder_1)); Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => sub_g_bundle-comx_sub_g_plan ) in Drupal\Core\Entity\Plugin\EntityReferenceSelection\DefaultSelection->validateReferenceableEntities() (line 387 of core/lib/Drupal/Core/Entity/Plugin/EntityReferenceSelection/DefaultSelection.php).

Drupal\Core\Database\Statement->execute() (Line: 640)
Drupal\Core\Database\Connection->query() (Line: 202)
Drupal\Core\Database\Driver\pgsql\Connection->query() (Line: 510)
Drupal\Core\Database\Query\Select->execute() (Line: 145)
Drupal\Core\Database\Driver\pgsql\Select->execute() (Line: 267)
Drupal\Core\Entity\Query\Sql\Query->result() (Line: 83)
Drupal\Core\Entity\Query\Sql\Query->execute() (Line: 387)
Drupal\Core\Entity\Plugin\EntityReferenceSelection\DefaultSelection->validateReferenceableEntities() (Line: 133)
Drupal\Core\Entity\Plugin\Validation\Constraint\ValidReferenceConstraintValidator->validate() (Line: 196)
Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validateConstraints() (Line: 148)
Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validateNode() (Line: 158)
Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validateNode() (Line: 100)
Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validate() (Line: 90)
Drupal\Core\TypedData\Validation\RecursiveValidator->validate() (Line: 132)
Drupal\Core\TypedData\TypedData->validate() (Line: 364)
Drupal\apigee_edge\Entity\FieldableEdgeEntityBase->validate() (Line: 75)
Drupal\apigee_edge\Entity\Form\FieldableEdgeEntityForm->validateForm() (Line: 41)
Drupal\apigee_m10n\Entity\Form\FieldableMonetizationEntityForm->validateForm()
call_user_func_array() (Line: 82)
Drupal\Core\Form\FormValidator->executeValidateHandlers() (Line: 273)
Drupal\Core\Form\FormValidator->doValidateForm() (Line: 118)
Drupal\Core\Form\FormValidator->validateForm() (Line: 589)
Drupal\Core\Form\FormBuilder->processForm() (Line: 321)
Drupal\Core\Form\FormBuilder->buildForm() (Line: 61)
Drupal\Core\Entity\EntityFormBuilder->getForm() (Line: 86)
Drupal\apigee_m10n\Entity\Controller\PurchaseRatePlanController->purchaseForm()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 573)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 151)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 68)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 57)
Drupal\Core\StackMiddleware\Session->handle() (Line: 47)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass() (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 52)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 23)
Stack\StackedHttpKernel->handle() (Line: 708)
Drupal\Core\DrupalKernel->handle() (Line: 19)

Steps to Reproduce

Steps to reproduce the behavior:

  1. Log in as Developer in Portal
  2. Click Pricing&Plan
  3. Click Any Rate Plan [There Will be No button to Accept T&C, WHY???] [Initially, the T&C widget was Available ]
  4. and Click Purchase

Actual Behavior

Php Error Thrown Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "sub_g_bundle-comx_sub_g_plan" LINE 5: ...d_data.status = '1') AND (node_field_data.nid IN ('sub_g_bun... ^: SELECT base_table.vid AS vid, base_table.nid AS nid FROM {node} base_table INNER JOIN {node_field_data} node_field_data ON node_field_data.nid = base_table.nid WHERE (node_field_data.status = :db_condition_placeholder_0) AND (node_field_data.nid IN (:db_condition_placeholder_1)); Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => sub_g_bundle-comx_sub_g_plan ) in Drupal\Core\Entity\Plugin\EntityReferenceSelection\DefaultSelection->validateReferenceableEntities() (line 387 of core/lib/Drupal/Core/Entity/Plugin/EntityReferenceSelection/DefaultSelection.php).

Expected Behavior

It should be Purchasing a Plan The T&C Widget Should be there.

Screenshots

Purchase_view form_mange T_and_C_Form_display

Notes

Add any other context about the problem here.

Version Info

PHP Warning: PHP Startup: Unable to load dynamic library 'zip.so' (tried: /usr/lib64/php/modules/zip.so (libzip.so.5: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/zip.so.so (/usr/lib64/p hp/modules/zip.so.so: cannot open shared object file: No such file or direc tory)) in Unknown on line 0 apigee/apigee-client-php 2.0.5 Client library for co ... apigee/apigee_devportal_kickstart 1.20.0 A fast demo and start ... asm89/stack-cors 1.3.0 Cross-origin resource ... behat/mink v1.8.1 Browser controller/em ... behat/mink-browserkit-driver v1.3.4 Symfony2 BrowserKit d ... behat/mink-goutte-driver v1.2.1 Goutte driver for Min ... behat/mink-selenium2-driver v1.4.0 Selenium2 (WebDriver) ... chi-teck/drupal-code-generator 1.32.1 Drupal code generator clue/stream-filter v1.4.1 A simple and modern a ... commerceguys/addressing v1.0.9 Addressing library po ... commerceguys/intl v1.0.6 Internationalization ... composer/ca-bundle 1.2.8 Lets you find a path ... composer/composer 1.10.13 Composer helps you de ... composer/installers v1.9.0 A multi-framework Com ... composer/semver 1.5.1 Semver library that o ... composer/spdx-licenses 1.5.4 SPDX licenses list an ... composer/xdebug-handler 1.4.3 Restarts a process wi ... consolidation/annotated-command 2.12.0 Initialize Symfony Co ... consolidation/config 1.2.1 Provide configuration ... consolidation/filter-via-dot-access-data 1.0.0 This project uses dfl ... consolidation/log 1.1.1 Improved Psr-3 / Psr\ ... consolidation/output-formatters 3.5.0 Format text by applyi ... consolidation/robo 1.4.12 Modern task runner consolidation/self-update 1.2.0 Provides a self:updat ... consolidation/site-alias 3.0.1 Manage alias records ... consolidation/site-process 2.1.0 A thin wrapper around ... container-interop/container-interop 1.2.0 Promoting the interop ... cweagans/composer-patches 1.6.7 Provides a way to pat ... dflydev/dot-access-data v1.1.0 Given a deep data str ... dnoegel/php-xdg-base-dir v0.1.1 implementation of xdg ... doctrine/annotations v1.4.0 Docblock Annotations ... doctrine/cache v1.6.2 Caching library offer ... doctrine/collections v1.4.0 Collections Abstracti ... doctrine/common v2.7.3 Common Library for Do ... doctrine/inflector v1.2.0 Common String Manipul ... doctrine/instantiator 1.3.1 A small, lightweight ... doctrine/lexer 1.0.2 PHP Doctrine Lexer pa ... drupal/address 1.8.0 Provides functionalit ... drupal/admin_toolbar 2.3.0 Provides a drop-down ... drupal/adminimal_admin_toolbar 1.11.0 Adminimal styling bro ... drupal/apigee_api_catalog 2.4.0 Apigee API Catalog fo ... drupal/apigee_edge 1.16.0 Apigee Edge for Drupa l. drupal/apigee_m10n 1.6.0 Apigee Edge Monetizat ... drupal/better_exposed_filters 5.0.0-beta1 Replaces the Views de ... drupal/coder 8.3.10 Coder is a library to ... drupal/commerce 2.21.0 Drupal Commerce is a ... drupal/components 2.0.0-beta3 Sets up folders of co ... drupal/core 8.9.6 Drupal is an open sou ... drupal/core-composer-scaffold 8.9.6 A flexible Composer p ... drupal/core-dev 8.9.6 require-dev dependenc ... drupal/core-project-message 8.9.6 Adds a message after ... drupal/core-recommended 8.9.6 Locked core dependenc ... drupal/ctools 3.4.0 Provides a number of ... drupal/default_content 1.0.0-alpha9 Imports default conte ... drupal/email_registration 1.1.0 Allows users to regis ... drupal/entity 1.1.0 Provides expanded ent ... drupal/entity_reference_revisions 1.8.0 Entity Reference Revi ... drupal/file_link 2.0.0 Extends the core Link ... drupal/fontawesome 2.17.0 The web's most popula ... drupal/inline_entity_form 1.0.0-rc7 Provides a widget for ... drupal/jquery_ui 1.4.0 Provides jQuery UI li ... drupal/jquery_ui_datepicker 1.0.0 Provides jQuery UI Da ... drupal/jquery_ui_slider 1.1.0 Provides jQuery UI Sl ... drupal/jquery_ui_touch_punch 1.0.0 Provides jQuery UI To ... drupal/key 1.14.0 Provides the ability ... drupal/openid_connect 1.0.0-rc1 A pluggable client im ... drupal/paragraphs 1.12.0 Enables the creation ... drupal/pathauto 1.8.0 Provides a mechanism ... drupal/profile 1.1.0 Provides configurable ... drupal/radix 4.10.0 Radix is a base theme ... drupal/requirement 1.1.0 A Drupal module to th ... drupal/smtp 1.0.0 Allow for site emails ... drupal/state_machine 1.0.0 Provides code-driven ... drupal/token 1.7.0 Provides a user inter ... drush/drush 9.7.2 Drush is a command li ... easyrdf/easyrdf 0.9.1 EasyRdf is a PHP libr ... egulias/email-validator 2.1.17 A library for validat ... fabpot/goutte v3.2.3 A simple PHP Web Scra per fightbulc/moment 1.32.1 Parse, validate, mani ... firebase/php-jwt v5.2.0 A simple library to e ... grasmash/expander 1.0.0 Expands internal prop ... grasmash/yaml-expander 1.4.0 Expands internal prop ... guzzlehttp/guzzle 6.5.4 Guzzle is a PHP HTTP ... guzzlehttp/promises v1.3.1 Guzzle promises libra ry guzzlehttp/psr7 1.6.1 PSR-7 message impleme ... instaclick/php-webdriver 1.4.7 PHP WebDriver for Sel ... jcalderonzumba/gastonjs v1.2.0 PhantomJS API based s ... jcalderonzumba/mink-phantomjs-driver v0.3.3 PhantomJS driver for ... justinrainbow/json-schema 5.2.10 A library to validate ... laminas/laminas-diactoros 1.8.7p2 PSR HTTP Message impl ... laminas/laminas-escaper 2.6.1 Securely and safely e ... laminas/laminas-feed 2.12.2 provides functionalit ... laminas/laminas-stdlib 3.2.1 SPL extensions, array ... laminas/laminas-zendframework-bridge 1.0.4 Alias legacy ZF class ... league/container 2.4.1 A fast and intuitive ... league/period 3.4.0 A time range immutabl ... masterminds/html5 2.3.0 An HTML5 parser and s ... mikey179/vfsstream v1.6.8 Virtual file system t ... myclabs/deep-copy 1.10.1 Create deep copies (c ... nikic/php-parser v4.10.2 A PHP parser written ... paragonie/random_compat v9.99.99 PHP 5.x polyfill for ... pear/archive_tar 1.4.9 Tar file management c ... pear/console_getopt v1.4.3 More info available o ... pear/pear-core-minimal v1.10.10 Minimal set of PEAR c ... pear/pear_exception v1.0.1 The PEAR Exception ba ... phar-io/manifest 1.0.3 Component for reading ... phar-io/version 2.0.1 Library for handling ... php-http/client-common 1.10.0 Common HTTP Client im ... php-http/discovery 1.12.0 Finds installed HTTPl ... php-http/guzzle6-adapter v1.1.1 Guzzle 6 HTTP Adapter php-http/httplug v1.1.0 HTTPlug, the HTTP cli ... php-http/message 1.9.0 HTTP Message related ... php-http/message-factory v1.0.2 Factory interfaces fo ... php-http/promise 1.1.0 Promise used for asyn ... phpdocumentor/reflection-common 2.2.0 Common reflection cla ... phpdocumentor/reflection-docblock 4.3.4 With this component, ... phpdocumentor/type-resolver 1.4.0 A PSR-5 based resolve ... phpmailer/phpmailer v6.1.8 PHPMailer is a full-f ... phpspec/prophecy v1.10.3 Highly opinionated mo ... phpunit/php-code-coverage 6.1.4 Library that provides ... phpunit/php-file-iterator 2.0.2 FilterIterator implem ... phpunit/php-text-template 1.2.1 Simple template engin e. phpunit/php-timer 2.1.2 Utility class for tim ing phpunit/php-token-stream 3.1.1 Wrapper around PHP's ... phpunit/phpunit 7.5.20 The PHP Unit Testing ... psr/container 1.0.0 Common Container Inte ... psr/http-message 1.0.1 Common interface for ... psr/log 1.1.3 Common interface for ... psy/psysh v0.10.4 An interactive shell ... ralouphie/getallheaders 3.0.3 A polyfill for getall ... sebastian/code-unit-reverse-lookup 1.0.1 Looks up which functi ... sebastian/comparator 3.0.2 Provides the function ... sebastian/diff 3.0.2 Diff implementation sebastian/environment 4.2.3 Provides functionalit ... sebastian/exporter 3.1.2 Provides the function ... sebastian/global-state 2.0.0 Snapshotting of globa ... sebastian/object-enumerator 3.0.3 Traverses array struc ... sebastian/object-reflector 1.1.1 Allows reflection of ... sebastian/recursion-context 3.0.0 Provides functionalit ... sebastian/resource-operations 2.0.1 Provides a list of PH ... sebastian/version 2.0.1 Library that helps wi ... seld/jsonlint 1.8.2 JSON Linter seld/phar-utils 1.1.1 PHAR file format util ... sirbrillig/phpcs-variable-analysis v2.8.3 A PHPCS sniff to dete ... squizlabs/php_codesniffer 3.5.6 PHP_CodeSniffer token ... stack/builder v1.0.5 Builder for stack mid ... symfony-cmf/routing 1.4.1 Extends the Symfony2 ... symfony/browser-kit v3.4.45 Symfony BrowserKit Co ... symfony/class-loader v3.4.41 Symfony ClassLoader C ... symfony/console v3.4.41 Symfony Console Compo ... symfony/css-selector v3.4.45 Symfony CssSelector C ... symfony/debug v3.4.41 Symfony Debug Compone nt symfony/dependency-injection v3.4.41 Symfony DependencyInj ... symfony/deprecation-contracts v2.2.0 A generic function an ... symfony/dom-crawler v3.4.45 Symfony DomCrawler Co ... symfony/event-dispatcher v3.4.41 Symfony EventDispatch ... symfony/filesystem v3.4.45 Symfony Filesystem Co ... symfony/finder v3.4.45 Symfony Finder Compon ent symfony/http-foundation v3.4.41 Symfony HttpFoundatio ... symfony/http-kernel v3.4.44 Symfony HttpKernel Co ... symfony/inflector v5.1.6 Symfony Inflector Com ... symfony/lock v3.4.45 Symfony Lock Componen t symfony/options-resolver v4.4.14 Symfony OptionsResolv ... symfony/phpunit-bridge v3.4.45 Symfony PHPUnit Bridg e symfony/polyfill-ctype v1.17.0 Symfony polyfill for ... symfony/polyfill-iconv v1.17.0 Symfony polyfill for ... symfony/polyfill-intl-grapheme v1.18.1 Symfony polyfill for ... symfony/polyfill-intl-idn v1.17.0 Symfony polyfill for ... symfony/polyfill-intl-normalizer v1.18.1 Symfony polyfill for ... symfony/polyfill-mbstring v1.17.0 Symfony polyfill for ... symfony/polyfill-php56 v1.17.0 Symfony polyfill back ... symfony/polyfill-php70 v1.17.0 Symfony polyfill back ... symfony/polyfill-php72 v1.17.0 Symfony polyfill back ... symfony/polyfill-php80 v1.18.1 Symfony polyfill back ... symfony/polyfill-util v1.17.0 Symfony utilities for ... symfony/process v3.4.41 Symfony Process Compo ... symfony/property-access v4.4.14 Symfony PropertyAcces ... symfony/property-info v4.4.14 Symfony Property Info ... symfony/psr-http-message-bridge v1.1.2 PSR HTTP message brid ge symfony/routing v3.4.41 Symfony Routing Compo ... symfony/serializer v3.4.41 Symfony Serializer Co ... symfony/string v5.1.6 Symfony String compon ent symfony/translation v3.4.41 Symfony Translation C ... symfony/validator v3.4.41 Symfony Validator Com ... symfony/var-dumper v4.4.14 Symfony mechanism for ... symfony/yaml v3.4.41 Symfony Yaml Componen t theseer/tokenizer 1.2.0 A small library for c ... twig/twig v1.42.5 Twig, the flexible, f ... typo3/phar-stream-wrapper v3.1.4 Interceptors for PHP' ... webflo/drupal-finder 1.2.0 Helper class to locat ... webmozart/assert 1.9.1 Assertions to validat ... webmozart/path-util 2.3.0 A robust cross-platfo

phdhiren commented 3 years ago

@shuhaibofficial ,

It seems this issue was raised earlier https://github.com/apigee/apigee-m10n-drupal/issues/253 and got resolved and it has been in latest release 8.x-1.8

Kindly update all the modules.

About Terms and Conditions widget:

The terms and conditions only shows up for a developer who have not accepted the latest terms and conditions, which is stored in Apigee. Could it be the developer already accepted the terms and conditions? You can verify through the Apigee API or through the Apigee Edge Interface.

shuhaibofficial commented 3 years ago

@phdhiren Thanks for your support, as you said T&C widget only appears if the user did not accepted the latest T&C,

253 is Raised by me, but the Issue was not when i installed freshly . anyways everything woks fine now, Thanks for your quick response