Forum

Thread tagged as: Error, Addons, Podcasts

Not able to save an episode in the Perch Podcast App

I've just installed Runway locally and added the Perch Podcast App. I've not used the podcast app before so it's new to me.

On trying to create a new "show" and hitting save the page blanks out.

My php error log is showing the following:

thrown in /Users/jaygeorge/Sites/test.com/perch/addons/apps/perch_podcasts/modes/show.edit.pre.php on line 84
[29-Jan-2018 12:58:04 Europe/London] PHP Fatal error:  Uncaught Error: Call to a member function set_options() on null in /Users/jaygeorge/Sites/test.com/perch/addons/apps/perch_podcasts/modes/show.edit.pre.php:84

Am I missing something?
Jay George

Jay George 2 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Am I missing something?

Yup, diagnostic report, please.
Jay George

Jay George 2 points

3 years ago

<tips hat>

Perch Runway LTM: 3.0.13
Production mode: Production (100)
Installed apps: content (3.0.13), assets (3.0.13), categories (3.0.13), perch_podcasts (1.3)
DB driver: PDO
DB tables: perch3_backup_plans (0), perch3_backup_resources (0), perch3_backup_runs (0), perch3_categories (0), perch3_category_counts (0), perch3_category_sets (0), perch3_collection_index (0), perch3_collection_items (0), perch3_collection_revisions (0), perch3_collections (0), perch3_content_index (0), perch3_content_items (0), perch3_content_locks (0), perch3_content_regions (8), perch3_menu_items (10), perch3_navigation (0), perch3_navigation_pages (0), perch3_page_routes (0), perch3_page_templates (7), perch3_pages (5), perch3_podcasts (0), perch3_podcasts_downloads (0), perch3_podcasts_episodes (0), perch3_resource_log (0), perch3_resource_tags (0), perch3_resources (3), perch3_resources_to_tags (0), perch3_settings (23), perch3_user_passwords (0), perch3_user_privileges (32), perch3_user_role_buckets (0), perch3_user_role_privileges (2), perch3_user_roles (2), perch3_users (1)
Users: 1
App runtimes:
<?php
    $apps_list = [ 
    ];
Editor plug-ins:
H1: 5286aae1cfdfdb34ddd5dbf4253b1ae8
L1: 5cb5f4a285b31713c5e80962d1222643
F1: 3b606135b33e6a102526838f4152a807
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
installedAt: 3.0.13
update_3.0.13: done
headerColour: #000000
headerScheme: dark
update_runway_3.0.13: done
latest_version:
on_sale_version: 3.0.13
sidebar_back_link: 1
jaygeorge_perch_admin_style_external_font_stylesheet:
dashboard: 0
hide_pwd_reset: 0
keyboardShortcuts: 0
siteOffline: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
content_skip_region_list: 0
assets_restrict_buckets: 0
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_LOGINPATH: /perch
PERCH_PATH: /Users/jaygeorge/Sites/idonthavetimetogameanymore.com/perch
PERCH_DB_USERNAME: root
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: idonthavetimetogameanymorecomperch
PERCH_SITEPATH: /
PERCH_RESFILEPATH: /Users/jaygeorge/Sites/idonthavetimetogameanymore.com/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_DB_PREFIX: perch3_
PERCH_TZ: Europe/London
PERCH_TEMPLATE_FILTERS: 1
PERCH_EMAIL_FROM: contact@jaygeorge.co.uk
PERCH_EMAIL_FROM_NAME: Jay George
PERCH_CORE: /Users/jaygeorge/Sites/idonthavetimetogameanymore.com/perch/core
PERCH_HTML5: 1
PERCH_FEATHERS: 1
PERCH_IMAGE_LIB: imagick
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_ASSET_VERSION: f704e7442d11292c99b5
PERCH_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /Users/jaygeorge/Sites/idonthavetimetogameanymore.com/perch/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_XHTML_MARKUP:
PERCH_RWD: 1
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_DEFAULT_BUCKET: default
PERCH_TRANSLATION_ASSIST:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_PRIV_ASSIST:
PERCH_CUSTOM_EDITOR_CONFIGS:
PERCH_ENABLE_EXIF: 1
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
Hosting settings
PHP: 7.1.8
Zend: 3.1.0
OS: Darwin
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $
MySQL server: 5.6.35
Free disk space: 15.91 GB
Extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, SPL, iconv, intl, json, ldap, mbstring, session, standard, mysqlnd, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, mysqli, SimpleXML, soap, sockets, exif, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, apache2handler, imap, gettext, mcrypt, pgsql, pdo_pgsql, imagick, igbinary, memcached
GD: Yes
ImageMagick: Yes
PHP max upload size: 32M
PHP max form post size: 32M
PHP memory limit: 128M
Total max uploadable file size: 32M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
DEVELOPER_ENV: development
HTTP_HOST: idonthavetimetogameanymore.loc
HTTP_CONNECTION: keep-alive
HTTP_CACHE_CONTROL: max-age=0
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3334.0 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
HTTP_DNT: 1
HTTP_REFERER: https://idonthavetimetogameanymore.loc/perch/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.9,de;q=0.8
HTTP_COOKIE: cmsa=1; PHPSESSID=738ed78b097d47aeac1da20eed0f4d08
PATH: /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SOFTWARE: Apache
SERVER_NAME: idonthavetimetogameanymore.loc
SERVER_ADDR: ::1
SERVER_PORT: 80
REMOTE_ADDR: ::1
DOCUMENT_ROOT: /Users/jaygeorge/Sites/idonthavetimetogameanymore.com
SERVER_ADMIN: you@example.com
SCRIPT_FILENAME: /Users/jaygeorge/Sites/idonthavetimetogameanymore.com/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 52044
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1517234888.49
REQUEST_TIME: 1517234888
argc: 1
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Looks like your on MySQL 5.6, but it's working ok here on 5.7. Basically the insert is failing when it tries to add the show to the database. Do you have MySQL logs?
Jay George

Jay George 2 points

3 years ago

Unfortunately 5.7 doesn't seem to be available with MAMP Pro. Here is my error log

2018-01-31 18:22:52 70000b0e7000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2018-01-31 18:22:52 70000b0e7000 InnoDB: Error: Fetch of persistent statistics requested for table "idonthavetimetogameanymorecomperch"."perch3_podcasts" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so thatInnoDB: innodb_force_... is removed.
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Ok, I'll leave that one with you then.
Jay George

Jay George 2 points

3 years ago

I managed to fix this by re-installing my OS (a bit drastic maybe but it was due a cleanup anyway).

For anyone with a similar problem, I think this issue was caused my MySQL not shutting down properly once and then failing to regenerate the innodb tables when it was restarted. See the marked solution here https://dba.stackexchange.com/questions/48166/cannot-open-table-mysql-innodb-index-stats

I didn't read into this enough to find a solution, I figured it was quicker to re-install my OS.