Upload von Demo-Content (.json) scheitert beständig

Hallo und guten Abend Community,

…habe ein Problem, welches wohl nicht unbedingt im engen Sinne mit dem konkreten Theme zu tun hat, sondern wohl ein grundsätzlicheres ist. (Mein Server ist ggf. nicht ganz ind er Lage jedes Protokoll und jeden Datentransfer so ohne weiteres zu vollziehen.

Also der Fehler bzw. was bisher geschah:

Rootserver:
Daten zum Server und zur Seite:
Site: ganz frisch – WP 5.9.1
MySQL version 5.5.33
PHP-Version: PHP Version 7.4.11
die Seite: https://www.job-starter.com –

also:
– Frische Seite: WP 5.9.1, WP Job-Manager, und diverse Zusatzplugins die empfohlen wurden.
– Beim Versuch einen Demo-Content eines Themes hochzuladen laufe ich immer wieder in Schwierigkeiten. will ein Template installieren wie hier auf diser page: https://2709.getwpt.tech/

bzw: https://jobify-demos.astoundify.com/classic/
oder: https://jobify-demos.astoundify.com/extended/

Theme: jobify: Habe praktisch alle Plugins installiert die noch empfohlen wurden:

gemäß der Dokumentationsseite verfahre ich wie folgt : https://kb.astoundify.com/article/jobify-skin-1/

bim Versuch eines der ausgewählten Dem-Templates zu laden – und hier sollten m.E. diverse .JSON- files installiert werden, laufe ich immer wieder in Probleme.

Hier kommen die Fragen auf: sind diese .JSON Files – im Themeordner drinne!? Ich gehe stark davon aus.

vgl. hier z.B.

bin noch vom System (den Log-files darauf aufmerksam gemacht worden, die ein Listin-Importer-Tool zu installieren. Dies ist offensichtlich obligatorisch beim Einsatz des WP-Job-Managers

Die Error aus den Serverlogs

WordPress database error Table 'jc.wp_pmxi_imports' doesn't exist for query SELECT options FROM wp_pmxi_imports WHERE id = 0 made by require_once('wp-load.php'), 
require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters,
 WPAI_WP_Job_Manager_Add_On->init, WPAI_WP_Job_Manager_Add_On_Helper->get_post_type, referer: https://www.my-site.com/wp-admin/admin.php?page=jobify-setup
When appeared the error exactly: what did i want to do: after i have installed the jobify theme – i wanted to add and upload the demo-content of the so called extended – page /(one of four demo-pages)

Aus der Fülle der möglichen Plugins habe ich mal was rausgesucht – hier
https://wordpress.org/plugins/search/WP+All+Import/`

ich hab mal beide hier genannten nun installiert:
https://de.wordpress.org/plugins/wp-job-manager-xml-csv-listings-import/
https://wordpress.org/plugins/wp-all-import/

Versuche ich nun die Demos zu laden – dann endet dies immer noch mit einem schlichten „FALSE im Display“ – also auf dem Dashboard.
Die Errorlogs, die ich nun bekomme – sie sind nun neue sie sind ziemlich konstant:

[Mon Feb 28 16:25:45.311493 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_files' for query ALTER TABLE wp_pmxi_files CHANGE COLUMN <code>registered_on</code> registered_on DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311558 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_images' for query ALTER TABLE wp_pmxi_images CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311623 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_images' for query ALTER TABLE wp_pmxi_images CHANGE COLUMN <code>attachment_id</code> attachment_id BIGINT(20) UNSIGNED NOT NULL made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311688 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_images' for query ALTER TABLE wp_pmxi_images CHANGE COLUMN <code>image_url</code> image_url VARCHAR(900) NOT NULL DEFAULT '' made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311748 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_images' for query ALTER TABLE wp_pmxi_images CHANGE COLUMN <code>image_filename</code> image_filename VARCHAR(900) NOT NULL DEFAULT '' made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311814 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_history' for query ALTER TABLE wp_pmxi_history CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311878 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_history' for query ALTER TABLE wp_pmxi_history CHANGE COLUMN <code>import_id</code> import_id BIGINT(20) UNSIGNED NOT NULL made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.311974 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_history' for query ALTER TABLE wp_pmxi_history CHANGE COLUMN <code>type</code> type ENUM('manual','processing','trigger','continue', 'cli', '') NOT NULL DEFAULT '' made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312050 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_history' for query ALTER TABLE wp_pmxi_history CHANGE COLUMN <code>time_run</code> time_run TEXT made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312116 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_history' for query ALTER TABLE wp_pmxi_history CHANGE COLUMN <code>date</code> date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312174 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_history' for query ALTER TABLE wp_pmxi_history CHANGE COLUMN <code>summary</code> summary TEXT made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312239 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_hash' for query ALTER TABLE wp_pmxi_hash CHANGE COLUMN <code>hash</code> hash BINARY(16) NOT NULL made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312302 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_hash' for query ALTER TABLE wp_pmxi_hash CHANGE COLUMN <code>post_id</code> post_id BIGINT(20) UNSIGNED NOT NULL made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312360 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_hash' for query ALTER TABLE wp_pmxi_hash CHANGE COLUMN <code>import_id</code> import_id SMALLINT(5) UNSIGNED NOT NULL made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, referer: https://www.my-site.com/wp-admin/plugins.php
[Mon Feb 28 16:25:45.312427 2022] [php7:notice] [pid 16791] [client 91.81.123.34:58432] WordPress database error ALTER command denied to user 'jc'@'localhost' for table 'wp_pmxi_hash' for query ALTER TABLE wp_pmxi_hash CHANGE COLUMN <code>post_type</code> post_type VARCHAR(32) NOT NULL DEFAULT '' made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, PMXI_Plugin->fix_options, PMXI_Plugin->fix_db_schema, dbDelta, 

Frage: fällt euch hier etwas besonderes auf? Ich habe die beiden o.g. Plugins noch installiert, aktiviert. Und die Demo-Files hab ich auch (schon auf dem SERVER) im Theme-Ordner drinne. Leider kommt es nicht zu einem Upload bzw. nur zu Rückmeldungen „wie etwa: FALSE“ – im Display.

Gut – ich hab auch noch folgende Probleme: die ja (vllt. hier nicht kpl. mit eine Rolle spielen -aber gelegentlich doch noch geklärt werden sollten). Habe nicht die Gelegenheit, die Uploads via SFTP hochzuladen – es wird imho lediglich ftp angeboten. Das sollte ich noch herausbekommen, ob es nicht noch weitere Optionen gibt!?

vgl. https://de.wordpress.org/support/topic/autom-updates-lediglich-via-ftp-oder-auch-ueber-sftp-moeglich/

• Dieses Thema wurde geändert vor 2 Jahren, 7 Monaten von stnabor.