@sigridmariec Sorry for the late answer. Can you provide more info about which block has installation issue or all of them, which WordPress version are you using and send a screenshot of browser console log?
Thread Starter
sigrid
(@sigridmariec)
Hi @foadyousefi !
The problem occurs with all the blocks. We are running WP version 5.1.1-nb
Screenshot of console:
View post on imgur.com
@sigridmariec
Tested on our sites and everything works. Can you please do one of the followings or both:
1- Deactivate all other plugins and test
2- Update everything (plugins and WordPress core) then test
And after that, let me know if the issue still exists.
Thread Starter
sigrid
(@sigridmariec)
Hi! Everything is updated and deactivating the other plugins does not help.
It makes no sense. Can you check your database if cloudblocks table exists?
Also, what is your servers PHP version? Can you share a screenshot of your phpinfo?
Hi @foadyousefi ! The pluging doesnt seem to work as it should. PHP server version is 7.0.
Thread Starter
sigrid
(@sigridmariec)
I can not find cloudblocks table in the database. Also deactivated the plug in and installed it again.
Hm, something is wrong then. Can you please check server error logs, so we can find what is the problem?
There is no relevant info in debug.log if that’s what you are looking for. No bugs coming from the Gutenberg Cloud plugin
@swiftarts
I mean servers error log where PHP errors being stored, not WordPress.
Thread Starter
sigrid
(@sigridmariec)
Hi @foadyousefi
Here are the error log:
[Thu May 09 07:08:32.244886 2019] [proxy_fcgi:error] [pid 4849] [client 127.0.0.1:50709] AH01071: Got error ‘PHP message: WordPress database error Table ‘scrbgketcx.wp_cloud_blocks’ doesn’t exist for query SELECT * FROM wp_cloud_blocks made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/generatepress/page.php’), get_header, locate_template, load_template, require_once(‘/themes/generatepress/header.php’), wp_head, do_action(‘wp_head’), WP_Hook->do_action, WP_Hook->apply_filters, wp_enqueue_scripts, do_action(‘wp_enqueue_scripts’), WP_Hook->do_action, WP_Hook->apply_filters, CloudBlocks\\Blocks\\Blocks->blocks_register_styles, CloudBlocks\\Blocks\\Options::get_all\n’
/Sigrid
-
This reply was modified 7 years ago by
sigrid.
@sigridmariec
Thanks. But this error fired when plugin tries to get the list of installed blocks. We need to debug why plugins can’t create the table.
The method which is responsible for creating the database table, being called within plugins activation hook.
We need to find errors fired while activating the plugin.
Can you please deactivate and then activate the plugin again and check for any errors in the error log and post then here?
Thanks again for cooperating.
I am also experiencing this issue and I found a log message that could be useful:
WordPress database error Invalid default value for 'block_installed' for query CREATE TABLE gny8_cloud_blocks (
id mediumint(9) NOT NULL AUTO_INCREMENT,
block_name varchar(150) NOT NULL,
package_name varchar(150) NOT NULL UNIQUE,
js_url varchar(255) DEFAULT '' NOT NULL,
css_url varchar(255) DEFAULT '' NOT NULL,
editor_css varchar(255) DEFAULT '',
info_url varchar(255) DEFAULT '' NOT NULL,
thumbnail varchar(255) DEFAULT '' NOT NULL,
block_version varchar(10) DEFAULT '' NOT NULL,
block_manifest text DEFAULT '' NOT NULL,
block_installed datetime DEFAULT CURRENT_TIMESTAMP,
block_updated datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
available_version varchar(10) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by activate_plugin, do_action('activate_cloud-blocks/cloud-blocks.php'), WP_Hook->do_action, WP_Hook->apply_filters, CloudBlocks\Activator::init, CloudBlocks\Activator::create_db, dbDelta
In MySQL datetime fields do not accept timestamp values
@cmcamara Thanks to posting your error log. Fixed the issue in version 1.1.7.
@sigridmariec If you update to 1.1.7, it should work without problems.
