Fatal error when activating current beta under clean install

Resolved deltafactory
(@deltafactory)

8 years, 7 months ago
Activating a new install of the beta plugin, I receive this error:
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘XXXXX.wp_mailpoet_subscribers’ doesn’t exist in /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/idiorm/idiorm.php:503
Stack trace:
#0 /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/idiorm/idiorm.php(503): PDOStatement->execute()
#1 /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/idiorm/idiorm.php(1906): ORM::_execute(‘SELECT * FROM `
…’, Array, ‘default’)
#2 /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/idiorm/idiorm.php(685): ORM->_run()
#3 /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/paris/paris.php(135): ORM->find_one(NULL)
#4 /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/idiorm/idiorm.php(2261): ORMWrapper->find_one()
#5 /home/wp/wordpress/wp-content/plugins/mailpoet/lib/Segments/WP.php(21): ORM->__call(‘findOne’, Array)
#6 /home/wp/wordpress/wp-content/plugins/mailpoet/lib/Segments/WP.php(93): MailPoet\Segments\WP::synchronizeUser(‘93603 in /home/wp/wordpress/wp-content/plugins/mailpoet/vendor/j4mie/idiorm/idiorm.php on line 503
</blockquote>

When attempting to create the subscribers table on my own, I see these lines in the definition:
```
first_name tinytext NOT NULL DEFAULT "",
last_name tinytext NOT NULL DEFAULT "",
```
which cause this error:

Error Code: 1101. BLOB, TEXT, GEOMETRY or JSON column 'first_name' can't have a default value

Please address this.
- This topic was modified 8 years, 7 months ago by deltafactory.
- This topic was modified 8 years, 7 months ago by deltafactory. Reason: Code formatting fixes

Viewing 11 replies - 1 through 11 (of 11 total)

Thread Starter deltafactory
(@deltafactory)

8 years, 7 months ago

@wysija, not sure if you saw this.

Also, is there a better venue through which to submit bug reports instead of general tech support?

Wysija
(@wysija)

8 years, 7 months ago

Re,

The best way is to use the ? icon on any of the plugin pages to contact us directly. Were you able to resolve this issue? If not, please get in touch with us via that option.

Thread Starter deltafactory
(@deltafactory)

8 years, 7 months ago

Fatal errors like this and the timeout issue reported here (https://wordpress.org/support/topic/better-handling-of-large-user-basees/) prevent the plugin from activating.

Therefore, I cannot use the support icon on the plugin pages.

In the meantime it looks like this is the best option, correct?
http://www.mailpoet.com/support/sales-pre-sales-questions/

Wysija
(@wysija)

8 years, 7 months ago

Hi,

The next week’s release will improve the activation process on sites with large user base. If you’d like to try it out in advance, please use http://www.mailpoet.com/support/wordpress-forums/ to contact us.

Thread Starter deltafactory
(@deltafactory)

8 years, 4 months ago

This was still not addressed.

Thread Starter deltafactory
(@deltafactory)

8 years, 4 months ago

Further reading as to the source of the problem with regard to DDL (CREATE/ALTER TABLE, etc.) statements:
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict

Thread Starter deltafactory
(@deltafactory)

8 years, 2 months ago

@wysija, can you please let me know if this is ever going to be addressed?

Wysija
(@wysija)

8 years, 2 months ago

@deltafactory no other user has reported that Fatal Error anymore. If you are still experiencing that same error:

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘XXXXX.wp_mailpoet_subscribers’ doesn’t exist in

Then that means some MailPoet tables are missing and you’ll need to reinstall your MailPoet from scratch (Settings page > Advanced tab > Reinstall).

Thread Starter deltafactory
(@deltafactory)

8 years, 2 months ago

This user is likely reporting the exact same issue. It’s in the subject and is 2 days old.

https://wordpress.org/support/topic/fatal-error-uncaught-pdoexception-sqlstatehy000/

I resolved the error using the steps I’ve documented for you. I’m trying to help you improve your plugin and save others from running into the same problem.

Wysija
(@wysija)

8 years, 2 months ago

Hello @deltafactory,

Thank you for reporting the issue and proposing a fix for it, we really appreciate it.

I checked your report and was able to confirm that subscriber table creation fails with MySQL Strict mode enabled.
We have logged the issue internally and will be looking at resolving it soon.

Thanks again for the detailed report, and apologies for the delays.

If you have any other questions or issues – please let us know. Thanks!

Best regards,
MailPoet Team.

Thread Starter deltafactory
(@deltafactory)

8 years, 2 months ago

I see this is resolved in yesterday’s release. Thank you very much!

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Fatal error when activating current beta under clean install’ is closed to new replies.