Forum

Thread tagged as: Question, Problem, Configuration

Assets not loading...

Hi, just updated to 2.7.1. Image Assets are not loading and all my previous Images have: "Notice: Undefined index: mime in /var/www/vhosts/clubalpha60.de/subdomains/test/perch/core/lib/PerchFieldTypes.class.php on line 747" in the backend.

Matthew Owen

Matthew Owen 0 points

  • 7 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you show us your diagnostics?

Which version did you update from?

Perch: 2.7.1 Production mode: Development (10) Installed apps: content (2.7.1), assets (2.7.1), categories (2.7.1), perch_blog (4.5.2), perch_events (1.9), perch_forms (1,5), perch_gallery (2.6), perch_members (1.0.3) DB driver: PDO DB tables: perch2_blog_authors, perch2_blog_categories, perch2_blog_comments, perch2_blog_index, perch2_blog_posts, perch2_blog_posts_to_categories, perch2_blog_posts_to_tags, perch2_blog_sections, perch2_blog_tags, perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_events, perch2_events_categories, perch2_events_to_categories, perch2_forms, perch2_forms_responses, perch2_gallery_albums, perch2_gallery_image_versions, perch2_gallery_images, perch2_members, perch2_members_forms, perch2_members_member_tags, perch2_members_sessions, perch2_members_tags, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_log, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_settings, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users Users: 5 App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_forms', 'perch_blog', 'perch_events', 'perch_gallery', 'perch_members', ); ?> Scheduled tasks for perch_events: update_category_counts (60 mins) Scheduled tasks for perch_blog: delete_spam_comments (1440 mins) Editor plug-ins: ckeditor, markitup, redactor H1: bf7030dbc79d49001d9e0f69c839fa30 L1: d70d007cb6c6c1d5f2dafe74da518cb0 headerColour: #E02735 content_singlePageEdit: 1 helpURL: siteURL: https://www.clubalpha60.de hideBranding: 1 content_collapseList: 1 lang: de latest_version: 2.5.3 perch_blog_post_url: /blog/post.php?s={postSlug} headerScheme: dark perch_blog_slug_format: %Y-%m-%d-{postTitle} perch_blog_akismet_key: perch_events_detail_url: /events/event.php?event={eventSlug} dashboard: 0 content_hideNonEditableRegions: 0 perch_blog_comment_notify: 0 perch_gallery_basicUpload: 0 logoPath: /perch/resources/clubAlphaLogo.png on_sale_version: 2.7.1 update_2.7.1: done perch_blog_update: 5.0 perch_events_update: 1.8 perch_blog_max_spam_days: 0 hide_pwd_reset: 0 content_frontend_edit: 0 PERCH_DEVELOPMENT: 10 PERCH_STAGING: 50 PERCH_PRODUCTION: 100 PERCH_DB_USERNAME: alpha60DB_user PERCH_DB_SERVER: localhost PERCH_DB_DATABASE: neuDB_alpha60 PERCH_DB_PREFIX: perch2_ PERCH_EMAIL_FROM: iphone@sdb-grafik.de PERCH_EMAIL_FROM_NAME: Matthew Owen PERCH_LOGINPATH: /perch PERCH_PATH: /var/www/vhosts/clubalpha60.de/subdomains/test/perch PERCH_CORE: /var/www/vhosts/clubalpha60.de/subdomains/test/perch/core PERCH_RESFILEPATH: /var/www/vhosts/clubalpha60.de/subdomains/test/perch/resources PERCH_RESPATH: /perch/resources PERCH_HTML5: 1 PERCH_DEBUG: PERCH_EDITORIMAGE_MAXWIDTH: 580 PERCH_EDITORIMAGE_MAXHEIGHT: 600 PERCH_EDITORIMAGE_CROP: PERCH_PRODUCTION_MODE: 10 PERCH_RUNWAY: 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_PREVIEW_ARG: preview PERCH_TEMPLATE_PATH: /var/www/vhosts/clubalpha60.de/subdomains/test/perch/templates PERCH_DEFAULT_DOC: index.php PERCH_DEFAULT_EXT: .php PERCH_RWD: PERCH_HTML_ENTITIES: PERCH_SSL: PERCH_AUTH_PLUGIN: PERCH_DB_CHARSET: utf8 PERCH_DB_PORT: PERCH_DB_SOCKET: HOSTING SETTINGS

PHP: 5.5.10 Zend: 2.5.0 OS: Linux SAPI: cgi-fcgi Safe mode: not detected MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ MySQL server: 5.1.73-0ubuntu0.10.04.1 Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gettext, SPL, iconv, json, mbstring, mcrypt, session, standard, mysqlnd, pcntl, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, readline, Reflection, mysql, shmop, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, cgi-fcgi, gd, imagick, mhash GD: Yes (image sharpening disabled, #66714) 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: No PATH: /usr/local/bin:/usr/bin:/bin PP_CUSTOM_PHP_INI: /var/www/vhosts/system/clubalpha60.de/etc/php.ini PP_CUSTOM_PHP_CGI_INDEX: 5.5.10 SCRIPT_NAME: /perch/core/settings/diagnostics/index.php REQUEST_URI: /perch/core/settings/diagnostics/?extended QUERY_STRING: extended REQUEST_METHOD: GET SERVER_PROTOCOL: HTTP/1.1 GATEWAY_INTERFACE: CGI/1.1 REMOTE_PORT: 52827 SCRIPT_FILENAME: /var/www/vhosts/clubalpha60.de/subdomains/test/perch/core/settings/diagnostics/index.php SERVER_ADMIN: julianruppel@googlemail.com DOCUMENT_ROOT: /var/www/vhosts/clubalpha60.de/subdomains/test REMOTE_ADDR: 188.99.173.188 SERVER_PORT: 80 SERVER_ADDR: 88.80.210.144 SERVER_NAME: clubalpha60.de SERVER_SOFTWARE: Apache SERVER_SIGNATURE: <address>Apache Server at clubalpha60.de Port 80</address> HTTP_ACCEPT_ENCODING: gzip, deflate HTTP_REFERER: https://clubalpha60.de/perch/core/settings/diagnostics/ HTTP_ACCEPT_LANGUAGE: en-us HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10) AppleWebKit/600.1.25 (KHTML, like Gecko) Version/8.0 Safari/600.1.25 HTTP_COOKIE: cmsa=1; PHPSESSID=k1lghf79dj3qctbdjmu3vcdo72 HTTP_CONNECTION: close HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 HTTP_HOST: clubalpha60.de FCGI_ROLE: RESPONDER PHP_SELF: /perch/core/settings/diagnostics/index.php REQUEST_TIME_FLOAT: 1414504811,8252 REQUEST_TIME: 1414504811

Updated from an early Perch 2 release.

Drew McLellan

Drew McLellan 2638 points
Perch Support

In what sort of circumstance are you getting this error?

It appears in Events and Blog when I edit existing posts.

Could it be that I jumped to far from 2.3.4 to 2.7.1 and missed something along the way?

Drew McLellan

Drew McLellan 2638 points
Perch Support

I don't think so. You could try reindexing your assets by going to this URL in your browser

/perch/core/apps/assets/reindex/
0,0139  0   SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled='1' AND u.userID=1 AND u.userHash='816a8b077a113be0ea6f2856274989ba' LIMIT 1
0,0157  0,0018  UPDATE perch2_users SET userHash='30c276e732060c572f00082eff0a9304' WHERE userID=1
0,0159  0,0002  SELECT p.privKey FROM perch2_user_privileges p
0,019   0,0031  SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
0,0286  0,0096  adding: Reindex Assets
0,0305  0,002   SELECT * FROM perch2_resources ORDER BY resourceUpdated ASC
0,0309  0,0004  Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'resourceUpdated' in 'order clause'
0,0352  0,0043  Queries: 5
Drew McLellan

Drew McLellan 2638 points
Perch Support

Where are you getting that?

that came up after I went to the URL you gave me.

Drew McLellan

Drew McLellan 2638 points
Perch Support

I've just realised you're the same person as the other thread. Might be best to tackle one issue at a time. There's something not right with your install.