New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table wp_mu_global_podlove_template doesn’t exist #1021

Open
rahra opened this Issue Dec 13, 2018 · 0 comments

Comments

Projects
None yet
1 participant
@rahra
Copy link

rahra commented Dec 13, 2018

I run Podlove Podcast Publisher and the Subscribe Button in a WP multi-site installation. It works perfect (at least it seems to) but the Apache regularly complains in its error log that the table ‘wp_mu_global_podlove_template’ does not exist. And I check it, there is no such table.

The complete error message is as follows:
[Wed Dec 12 14:16:14.459794 2018] [php7:notice] [pid 72931] [client X.X.X.X] WordPress-Datenbank-Fehler Table 'wpm.wp_mu_global_podlove_template' doesn't exist f\xc3\xbcr Abfrage SELECT * FROM wp_mu_global_podlove_template WHERE title = '1' LIMIT 0,1 von require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/twentyfourteen/index.php'), get_template_part, locate_template, load_template, require('/themes/twentyfourteen/content.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, podlove_autoinsert_templates_into_content, Podlove\\Model\\Template::find_one_by_title_with_fallback, Podlove\\Model\\Template::with_network_scope, Podlove\\Model\\Template::Podlove\\Model\\{closure}, Podlove\\Model\\Base::__callStatic, Podlove\\Model\\Base::find_one_by_property, Podlove\\Model\\Base::find_one_by_sql

As a workaround I manually created the table in question which eliminated the error message. The Podlove Podcast Publisher still works. But I didn’t publish a new episode yet.
Probably the PPP does not perfectly work in a WPMU environment, yet.

Just for clarification about the table naming convention in the WPMU env:
Blog-specific tables are named as <blog_id><table_name>. Global (network) tables seem to use the word “global” instead of the blog ID. In my case the podlove_template table is named “wp_mu_9_podlove_template”. I created an exact copy of this table (which contains just a single record) with the name “wp_mu_global_podlove_template”.

Expected behavior

There shouldn't be any error message in the server's error log while in normal operation.

Actual behavior

Error message in the server's error log (message above).

System information (see Podlove > Support menu)

It is an Apache 2.4, PHP 7.2, MariaDB 10.2, latest WP 5.0, based on FreeBSD 11.2.

Website                    https://www.freeskippers.at
PHP Version                7.2.13
WordPress Version          5.0
WordPress Theme            Twenty Fourteen v2.3
Active Plugins             
 [removed for security reasons]
WordPress Database Charset utf8
WordPress Database Collate 
Publisher Version          2.7.19
Web Player Version         player_v4
Twig Version               1.35.4
open_basedir               ok
curl Version               7.62.0
iconv                      available
simplexml                  ok
max_execution_time         30
upload_max_filesize        10M
memory_limit               512M
disable_classes            
disable_functions          
permalinks                 ok (/%year%/%monthnum%/%postname%/)
podlove_permalinks         ok
podcast_settings           ok
web_player                 ok
podlove_cache              on
assets                     
  - mp3    audio/mpeg       https://www.freeskippers.at/feed/mp3/
cron                       ok

0 errors
0 notices
Nice, Everything looks fine!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment