itatih
Forum Replies Created
-
@mickdom
Thank you veri much for your information. It has been my solution.@danieliser
Please I need your help.
I have a problem with the database.
When Popup Maker tries to create wp_pum_subscribers table, I see an error in php-error.log
The Mysqls version is 8.0.20.
ThanksThe error you see in the log is:
[12-Aug-2020 20:05:16 UTC] Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘values longtext NOT NULL,
uuid varchar(255) NOT NULL,
consent varchar(25’ at line 10 de la base de datos de WordPress para la consulta CREATE TABLE wp_pum_subscribers (
ID bigint(20) NOT NULL AUTO_INCREMENT,
email_hash varchar(32) NOT NULL,
popup_id bigint(20) NOT NULL,
user_id bigint(20) NOT NULL,
email varchar(191) NOT NULL,
name varchar(255) NOT NULL,
fname varchar(255) NOT NULL,
lname varchar(255) NOT NULL,
values longtext NOT NULL,
uuid varchar(255) NOT NULL,
consent varchar(255) NOT NULL,
consent_args longtext NOT NULL,
created datetime NOT NULL,
PRIMARY KEY (ID),
KEY email (email),
KEY user_id (user_id),
KEY popup_id (popup_id),
KEY email_hash (email_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci realizada por require_once(‘wp-admin/admin.php’), do_action(‘popup_page_pum-subscribers’), WP_Hook->do_action, WP_Hook->apply_filters, PUM_Admin_Subscribers::page, PUM_Admin_Subscribers_Table->prepare_items, PUM_Abstract_Database::instance, PUM_Abstract_Database->__construct, PUM_DB_Subscribers->create_table, dbDelta@fpcorso Thanks for your information.
@mickdom Thanks for your information.
I have the same error!
pum_subscribers table does not exist.
At what point is the table created?
I use newsletter plugin, I dont use subscriber form of popup maker.
Regards!03-Aug-2020 12:47:01 UTC] Error Table ‘wp80.wp80_pum_subscribers’ doesn’t exist de la base de datos de WordPress para la consulta SELECT
ID
,uuid
,popup_id
,email_hash
,email
,name
,fname
,lname
,values
,user_id
,consent_args
,consent
,created
FROM wp80_pum_subscribers WHERE 1=1 LIMIT 20 realizada por require_once(‘wp-admin/admin.php’), do_action(‘popup_page_pum-subscribers’), WP_Hook->do_action, WP_Hook->apply_filters, PUM_Admin_Subscribers::page, PUM_Admin_Subscribers_Table->prepare_items, PUM_DB_Subscribers->query
[03-Aug-2020 12:47:01 UTC] Error Table ‘wp80.wp80_pum_subscribers’ doesn’t exist de la base de datos de WordPress para la consulta SELECTID
,uuid
,popup_id
,email_hash
,email
,name
,fname
,lname
,values
,user_id
,consent_args
,consent
,created
FROM wp80_pum_subscribers WHERE 1=1 realizada por require_once(‘wp-admin/admin.php’), do_action(‘popup_page_pum-subscribers’), WP_Hook->do_action, WP_Hook->apply_filters, PUM_Admin_Subscribers::page, PUM_Admin_Subscribers_Table->prepare_items, PUM_DB_Subscribers->total_rows, PUM_DB_Subscribers->query