Settings not visible/ accessible

[renickbuettner]

Hi there,

I have Shopware 6 (v6.4.10 Stable Version) and the plugin version 1.4.11.

I installed the plugin. Activated, and deactivated it. But I am not seeing any configuration options - either within the plugin store or the shopware settings.

Also I cleared the browsers cache, dumped the bundles. Do you have any idea, why the settings are not visible?

(The plugin settings where I can add the api token and these kind of stuff).

[renickbuettner]

I was about to recompile the admin panel (bc of that: shopware/shopware#2420), and got following exception by activating the plugin:

Shopware Plugin Lifecycle Service
=================================

 Activate 1 plugin(s):
 * Pay.nl payment (v1.4.11)


In AbstractMySQLDriver.php line 79:
                                                                                                                                                                                                                                                                            
  An exception occurred while executing 'SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `paym  
  ent_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as  
   `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.  
  appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_ur  
  l` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentM  
  ethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymen  
  tMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.translation  
  .name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableN  
  ame`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESC  
  E(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.t  
  ranslation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.  
  distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translat  
  ion.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translati  
  on.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id`  
   LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE (`payment_method`.`handler_identifier` LIKE ?)' with params ["\x2f\xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\  
  x7c\xe3\xe2\x0b", "%PaynlPayment%"]:                                                                                                                                                                                                                                      
                                                                                                                                                                                                                                                                            
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_method.appPaymentMethod.validate_url' in 'field list'                                                                                                                                                     
                                                                                                                                                                                                                                                                            

In Exception.php line 18:
                                                                                                                         
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_method.appPaymentMethod.validate_url' in 'field list'  
                                                                                                                         

In PDOStatement.php line 117:
                                                                                                                         
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_method.appPaymentMethod.validate_url' in 'field list'  
                                                                                                                         

[ahudyma]

Hello! Thanks for reporting. We are aware of this issue and will release a fix in the nearest few days.

[ahudyma]

We have fixed a way we build the plugin and it's configuration should be visible in 6.4.10. Will push new release soon.
As for this MySQL error, we believe that for some reason migration "Migration1643386819AddPreparedPaymentsToAppPaymentMethod" was not applied on your server.
Here we can see the commit where 'validate_url' column was added:
The change was introduced in 6.4.9

[renickbuettner]

Thank you for your quick answer