gnosis_wp
Forum Replies Created
-
I was able to get it to work by setting perms to 777 and giving apache write access, but seems too permissive.
Performed re-install several times.
Error message is:
Unable to open file!Do permissions need to be set a specific way?
770?
Apahce need write access?Thank you.
On my development server the plugin does not even appear in the dashboard.
On my production server I get cannot open file messages when I attempt to publish.Thank you.
Please post to this forum when complete, so I get an email notifying me.Thank you.
WordPress database error Unknown storage engine ‘MyISAM’ for query CREATE TABLE wp_alert_notice_boxes (\n\t\tid int(11) NOT NULL AUTO_INCREMENT,\n\t\tpost_ID int(11) NOT NULL,\n\t\ttitle TEXT NULL,\n\t\tdisplay_in TEXT NULL,\n\t\tlocation_id VARCHAR(100) NULL,\n\t\tdesign_id VARCHAR(100) NULL,\n\t\tanimation_id VARCHAR(100) NULL,\n\t\tanimation_out_id VARCHAR(100) NULL,\n\t\tdelay int(11) DEFAULT ‘2000’,\n\t\tshow_time int(11) DEFAULT ‘8000’,\n\t\tenabled VARCHAR(100) NULL,\n\t\tuser_types VARCHAR(100) NULL,\n\t\tdevice_class VARCHAR(100) NULL,\n\t\tPRIMARY KEY (id)\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, anb_update_db_check, alert_notice_boxes_install, dbDelta
IT jumped in and here is there response:
Based on the log, I think the plugin only allows creation of tables only using MyISAM storage engine but not InnoDB. MyISAM is an legacy storage engine that does not support MySQL galera clustering well. You may ask the developer to modify his code to support at least InnoDB storage engine.
IT does not have underlying virus software running.
I ran a few tests:
Deleted plugin and re-installed.
An entire new fresh install.
Neither worked.I then installed on my desktop using XAMP and worked.
Any other ideas?
yes, you are correct. I just installed on my local computer and the table was created. I wonder why it previously worked and not know.
Anyway, I will speak to IT and then get back to you if I continue to experience issues.
Thank you!
Interesting, but it previously worked, so not sure, but I will ask IT as well as test on XAMPP.
Here is the error log:
[Tue Oct 06 15:05:11 2020] [notice] [pid 13381] sapi_apache2.c(349): [client 146.96.33.199:56387] WordPress database error Table ‘library_wp.mrl365_alert_notice_boxes’ doesn’t exist for query SELECT * FROM mrl365_alert_notice_boxes ORDER BY delay DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/hestia/front-page.php’), get_footer, locate_template, load_template, require_once(‘/themes/hestia-child/footer.php’), wp_footer, do_action(‘wp_footer’), WP_Hook->do_action, WP_Hook->apply_filters, YCanb->register_alert_notice_boxes
[Tue Oct 06 15:05:57 2020] [notice] [pid 5213] sapi_apache2.c(349): [client 146.96.33.199:56395] WordPress database error Table ‘library_wp.mrl365_alert_notice_boxes’ doesn’t exist for query SELECT * FROM mrl365_alert_notice_boxes WHERE post_ID = 3565 made by require(‘wp-admin/edit-form-advanced.php’), do_meta_boxes, anb_item_meta_boxI gave Apache access to write to and execute the plugin, so not getting unabel to open file errors, but still not publishing. Here is a log entry when attempting to publish:
146.96.33.199 – – [06/Oct/2020:15:05:11 -0400] “POST /new4/wp-admin/admin-ajax.php HTTP/1.1” 200 1 “https://libdev.gc.cuny.edu/new4/wp-admin/post.php?post=3565&action=edit” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36” 21233 libdev.gc.cuny.edu
Was able to publish, but does not show and current alert remains even after disabling. I disabled the alert and click update, but <Enabled> checkbox returns after clicking on <Update>. Stranger is I moved all into the trash, but the the old one remains on the site.
Questions: does Apache need write access to the plugin?
When editing an alert:
https://library.gc.cuny.edu/new4/wp-admin/post-new.php?post_type=anb
then after clicking publish:
https://library.gc.cuny.edu/new4/wp-admin/post.phpI tried reinstalling.
Thank you!
Apache error logs reveal:
[Fri Oct 02 03:44:56 2020] [notice] [pid 103304] sapi_apache2.c(349): [client 146.96.33.242:54844] WordPress database error Table ‘library_wp.mrl365_alert_notice_boxes’ doesn’t exist for query SELECT * FROM mrl365_alert_notice_boxes ORDER BY delay DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/hestia/404.php’), get_footer, locate_template, load_template, require_once(‘/themes/hestia-child/footer.php’), wp_footer, do_action(‘wp_footer’), WP_Hook->do_action, WP_Hook->apply_filters, YCanb->register_alert_notice_boxes
Any ideas?
Forum: Fixing WordPress
In reply to: Update Questions