Hi! Got the following message while installation:

Update failed
"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'content' at row 1 (SQL: insert into `ibsellnet_leadspopupconvertor_popups` (`name`, `popuptype_id`, `content`, `type1_seconds`) values (Demo Popup will be visible in 3 seconds, 1, <p><strong>Convert More Visitors into Subscribers &amp; Customers with Exit Intent</strong></p> <p><strong>Use Privy on-site displays like this one to grow your email list, reduce abandonment, and drive online sales</strong></p> <p class="oc-text-bordered"><strong><a href="https://ibsell.net">SIGN UP FREE</a></strong></p> , 3))" on line 664 of /var/www/rest/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Great idea for the plugin, by the way!

Also I got

 General error: 1364 Field 'type2_selector' doesn't have a default value (SQL: insert into `ibsellnet_leadspopupconvertor_popups` (`name`, `popuptype_id`, `content`, `type1_sec  
  onds`) values (Demo Popup will be visible in 3 seconds, 1, , 3))       

so you better make type2_selector field with default value in migration

            $table->string('type2_selector')->default(0);

That's not critical error, but for some database configs, such as mine, it will give this error

Hi! Thank you for let us know about those errors. We will make the fixes and also tests for the new Octobercms version. We will include them in the next plugin update. Raluca

vdomah said:

Hi! Got the following message while installation:

Update failed
"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'content' at row 1 (SQL: insert into `ibsellnet_leadspopupconvertor_popups` (`name`, `popuptype_id`, `content`, `type1_seconds`) values (Demo Popup will be visible in 3 seconds, 1, <p><strong>Convert More Visitors into Subscribers &amp; Customers with Exit Intent</strong></p> <p><strong>Use Privy on-site displays like this one to grow your email list, reduce abandonment, and drive online sales</strong></p> <p class="oc-text-bordered"><strong><a href="https://ibsell.net">SIGN UP FREE</a></strong></p> , 3))" on line 664 of /var/www/rest/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Great idea for the plugin, by the way!

Tell me, please! How did you solve this issue?

Hi all, I will make a push tonight with the fixes. I'll let you know here when the update is ready. Thank you!

dhuunghia6211 said:

vdomah said:

Hi! Got the following message while installation:

Update failed
"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'content' at row 1 (SQL: insert into `ibsellnet_leadspopupconvertor_popups` (`name`, `popuptype_id`, `content`, `type1_seconds`) values (Demo Popup will be visible in 3 seconds, 1, <p><strong>Convert More Visitors into Subscribers &amp; Customers with Exit Intent</strong></p> <p><strong>Use Privy on-site displays like this one to grow your email list, reduce abandonment, and drive online sales</strong></p> <p class="oc-text-bordered"><strong><a href="https://ibsell.net">SIGN UP FREE</a></strong></p> , 3))" on line 664 of /var/www/rest/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Great idea for the plugin, by the way!

Tell me, please! How did you solve this issue?

after unsuccessful installation plugin's dir are already in your project. Then I've removed this part of code in plugin's seeder file in updates dir. Then run php artisan october:up

@vdomah thank you for your help. A new update is ready, now this bug is fixed in version 1.0.10

And another update os here. Thanks for using this plugin and enjoy it! 2019-10-31 on edit a popup you can copy paste directly the code into your page for popup type "after some seconds" the user may change the page but when he came back, of the time is there and he is on that page he will see the popup. This is helpful for big time like: show a popup after one hour (as example) after 2 hours, if the user will come back again on the web he will see again the popups that are set up, otherwise he will see them only once. Example 1: set up an exit popup, when the user wants first to go out he will see the popup, if the user open it again and want again to go out he will not see it anymore, only after another 2 hours. Example 2: if you set up a "after some seconds" popup type and you set up 10 seconds. After the user will get the popup after 10 seconds, he refresh the page and he will not see it again after those 10 seconds, only if he enter again after 2 hours.

I also got that error:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'content' at row 1 (SQL: insert into ibsellnet_leadspopupconvertor_popups (name, popuptype_id, content, type1_seconds) values (Demo Popup will be visible in 3 seconds, 1, <p><strong>Convert More Visitors into Subscribers & Customers with Exit Intent</strong></p> <p><strong>Use Privy on-site displays like this one to grow your email list, reduce abandonment, and drive online sales</strong></p> <p class="oc-text-bordered"><strong><a href="https://ibsell.net">SIGN UP FREE</a></strong></p> , 3))" on line 664 of /Users/klas/web/october/vendor/laravel/framework/src/Illuminate/Database/Connection.php

EDIT: After upgrading October (and some other plugins), uninstalling this plugin, and reinstall it, it install, but I can not ugrade the plugin (same error) and there is no popup types !

Last updated 4 years ago

I figured it out. I just removed the last content in seeder109.php in update directory for the plugin. I did that in end of the update process, when it complained, then runed the "try again", and then it installed with success.

What I understand, it was just a file for example data, am I right?

Edit did not function, had to remove whole last declaration:

//fill in a popup example after 10 seconds $popupDemo01 = Popups::insert([

What I understand plugin have the wrong datatype for that, it should bee TEXT not VARCHAR (255). ..

Last updated 4 years ago