June 2014 - support - lists.drupal.org

Re: [support] Clean URL fix if you are failing the test
by Chris McAndrew 28 Jun '14

28 Jun '14

I had the same issue and someone recommended going directly to the page with the checkbox at http://www.yoursite.com/admin/config/search/clean-urls. This bypasses the check page. Once you enable it from that link you should be all set. Chris *Chris McAndrew* Interactive designer & developer *e-mail*: chris(a)csmcreative.com *Web*: http://csmcreative.com On Fri, Jun 13, 2014 at 6:56 PM, <support-request(a)drupal.org> wrote: > Send support mailing list submissions to > support(a)drupal.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.drupal.org/mailman/listinfo/support > or, via email, send a message with subject or body 'help' to > support-request(a)drupal.org > > You can reach the person managing the list at > support-owner(a)drupal.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of support digest..." > > > Today's Topics: > > 1. Re: Druapal server fatal error: "MySQL server has gone away", > but DB server is still up & accessible. Help troubleshooting? > (grantksupport(a)operamail.com) > 2. Re: Druapal server fatal error: "MySQL server has gone away", > but DB server is still up & accessible. Help troubleshooting? (Maina) > 3. clean url's (techlists(a)phpcoderusa.com) > 4. Re: clean url's (Erik Alfkin) > 5. Re: clean url's (Don) > 6. Re: clean url's (Erik Alfkin) > 7. Re: clean url's (techlists(a)phpcoderusa.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 13 Jun 2014 05:35:27 -0700 > From: grantksupport(a)operamail.com > Subject: Re: [support] Druapal server fatal error: "MySQL server has > gone away", but DB server is still up & accessible. Help > troubleshooting? > To: support(a)drupal.org > Message-ID: > <1402662927.23063.128422697.1C55D3AB(a)webmail.messagingengine.com> > Content-Type: text/plain > > > > On Fri, Jun 13, 2014, at 01:28 AM, Liviu Nicolicioiu wrote: > > Check your mysql connect timeout. > > currently here > > connect_timeout = 120 > > > ------------------------------ > > Message: 2 > Date: Fri, 13 Jun 2014 15:59:03 +0300 > From: Maina <webmail.maina(a)gmail.com> > Subject: Re: [support] Druapal server fatal error: "MySQL server has > gone away", but DB server is still up & accessible. Help > troubleshooting? > To: support(a)drupal.org > Message-ID: > <CAGXYcw8gRhDLZZnWd_rbic+RszkNcYYdrDgi= > Dn46N6HKBn4bg(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hey Grant, > > Since you adjusted the 'max_allowed_packet' make sure that you restart > your Web Server. If you already did and still no effect, try running > the "update.php" file of Drupal and see if that helps. > > Maina > > On 6/13/14, grantksupport(a)operamail.com <grantksupport(a)operamail.com> > wrote: > > > > > > On Fri, Jun 13, 2014, at 01:28 AM, Liviu Nicolicioiu wrote: > >> Check your mysql connect timeout. > > > > currently here > > > > connect_timeout = 120 > > -- > > [ Drupal support list | http://lists.drupal.org/ ] > > > > > -- > http://www.mosesmaina.com > > > ------------------------------ > > Message: 3 > Date: Fri, 13 Jun 2014 14:36:22 -0500 > From: techlists(a)phpcoderusa.com > Subject: [support] clean url's > To: support(a)drupal.org > Message-ID: <9592b2ddf35e5666667dc7f96eb8a10f(a)phpcoderusa.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > Hi, > > I've uploaded Drupal Commerce Kickstart and it is working as I would > expect it to. The problem is clean URLs. > > This is on a new VPS and I have no other sites on this server that use > mod rewrite. As a result I do not know if this is an Apache config > issue or something to do with Drupal or Kickstart. I have KickStart > setup on a local dev box and clean URL's was not an issue so I assume > this might be an Apache config issue. > > I modified the Apache config changing AllowOverride to ALL. > > I've verified the .htaccess file that came with Kickstart is in the root > directory and have verified the permissions are 644. > > When I go into the Admin panel to check for clean URL's it fails. > > Any suggestions on how I can troubleshoot this issue? > > Thanks a bunch in advance!! > > Keith > > > ------------------------------ > > Message: 4 > Date: Fri, 13 Jun 2014 14:33:49 -0700 > From: Erik Alfkin <erik(a)alfkin.net> > Subject: Re: [support] clean url's > To: support(a)drupal.org > Message-ID: > <CAJkaSmZtcBbBaxv5aT= > Qo9kPQkUAw5EbdDEJXBHkjpQue-7y1Q(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Have you verified that mod_rewrite is enabled? > > > On Fri, Jun 13, 2014 at 12:36 PM, <techlists(a)phpcoderusa.com> wrote: > > > > > > > Hi, > > > > I've uploaded Drupal Commerce Kickstart and it is working as I would > > expect it to. The problem is clean URLs. > > > > This is on a new VPS and I have no other sites on this server that use > > mod rewrite. As a result I do not know if this is an Apache config > > issue or something to do with Drupal or Kickstart. I have KickStart > > setup on a local dev box and clean URL's was not an issue so I assume > > this might be an Apache config issue. > > > > I modified the Apache config changing AllowOverride to ALL. > > > > I've verified the .htaccess file that came with Kickstart is in the root > > directory and have verified the permissions are 644. > > > > When I go into the Admin panel to check for clean URL's it fails. > > > > Any suggestions on how I can troubleshoot this issue? > > > > Thanks a bunch in advance!! > > > > Keith > > -- > > [ Drupal support list | http://lists.drupal.org/ ] > > > > > > -- > > Erik Alfkin >

5 7

Weird Node Save Problem
by Nancy Wichmann 26 Jun '14

26 Jun '14

I have some code that is programmatically creating a node and turning over to the node form. So far it looks good and my code steps aside and lets Core do its stuff. So, the node_insert code gets called with a good node, complete with field data and a group. But then node_insert is invoked a second time with a node having the same ID, but missing group and most field data. This part makes no sense to me, and I can’t track down why it’s happening. Has anyone seen anything like this, and perhaps fixed it?

2 1

Druapal server fatal error: "MySQL server has gone away", but DB server is still up & accessible. Help troubleshooting?
by grantksupport＠operamail.com 17 Jun '14

17 Jun '14

I have a Drupal 7.28 server that's not working after a number of upgrades. It's suffering from "MySQL server has gone away" errors. This server used to work just fine. I've been unable to track down the cause of this problem, or find a fix or workaround. Appreciate any help! My env is php -v PHP 5.6.0-dev (cli) (built: Jun 12 2014 10:24:30) Copyright (c) 1997-2014 The PHP Group Zend Engine v2.6.0-dev, Copyright (c) 1998-2014 Zend Technologies with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by Zend Technologies mysqladmin version mysqladmin Ver 9.1 Distrib 10.0.11-MariaDB, for Linux on x86_64 Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others. Server version 10.0.11-MariaDB-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/cache/mariadb/mariadb.sock Uptime: 7 min 52 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 63 Queries per second avg: 0.004 the server's Apache/2.4.10-dev + php-fpm as an example of the error, from my siteroot drush st PDOStatement::execute(): MySQL server has gone away database.inc:2171 [warning] PDOStatement::execute(): Error reading result set's header database.inc:2171 [warning] Drush command terminated abnormally due to an unrecoverable error. [error] PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT filename FROM {registry} WHERE name = :name AND type = :type; Array ( [:name] => drush_drupal_environment [:type] => interface ) in _registry_check_code() (line 3150 of /srv/www/drupal7/dTEST/includes/bootstrap.inc). query and web logs ==> mariadb.log <== ... 140612 12:33:07 3 Connect gk_admin@localhost as anonymous on dTEST_db 3 Query select @@version_comment limit 1 3 Query SELECT 1 3 Quit 4 Connect gk_admin@localhost as anonymous on dTEST_db 4 Query SET NAMES utf8 4 Query SET sql_mode = 'ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER' 4 Query SELECT filename FROM registry WHERE name = 'DrupalDefaultEntityController' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'SelectQueryExtender' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'NodeController' AND type = 'class' 4 Query SELECT source FROM url_alias WHERE alias = 'node' AND language IN ('en', 'und') ORDER BY language ASC, pid DESC 4 Query SELECT alias FROM url_alias WHERE source = 'node' AND language IN ('en', 'und') ORDER BY language ASC, pid DESC 4 Query SELECT theme, pages FROM page_theme WHERE status = 1 ORDER BY weight, theme 4 Query SELECT rid, permission FROM role_permission WHERE rid IN ('1') 4 Query START TRANSACTION 4 Query SELECT filename FROM registry WHERE name = 'context_export_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'ctools_export_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'ctools_access_ruleset_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'ctools_custom_content_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'current_search_export_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'panels_layouts_ui' AND type = 'class' 140612 12:33:08 4 Query SELECT filename FROM system WHERE name = 'zen' AND type = 'theme' 4 Query SELECT 1 FROM panels_layout LIMIT 0, 1 4 Query SELECT t__0.* FROM panels_layout t__0 WHERE (plugin = 'flexible') 4 Query SELECT filename FROM registry WHERE name = 'panels_mini_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'services_ctools_export_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'stylizer_ui' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_ui' AND type = 'class' 4 Query SELECT nt.* FROM node_type nt WHERE (disabled = '0') ORDER BY nt.type ASC 4 Query SELECT 1 FROM apachesolr_search_page LIMIT 0, 1 4 Query SELECT t__0.* FROM apachesolr_search_page t__0 4 Query SELECT * FROM apachesolr_search_page 4 Query SELECT 1 FROM services_endpoint LIMIT 0, 1 4 Query SELECT t__0.* FROM services_endpoint t__0 4 Query SELECT 1 FROM page_manager_pages LIMIT 0, 1 4 Query SELECT t__0.* FROM page_manager_pages t__0 4 Query SELECT t__0.* FROM page_manager_pages t__0 WHERE (task = 'page') 4 Query SELECT * FROM apachesolr_search_page 4 Query SELECT 1 FROM views_view LIMIT 0, 1 4 Query SELECT t__0.* FROM views_view t__0 4 Query SELECT filename FROM registry WHERE name = 'view' AND type = 'class' 4 Query SELECT * FROM views_display WHERE vid IN ('2') ORDER BY vid, position 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_display_default' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_display' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_display_page' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_display_block' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_localization_none' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_localization' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_display_feed' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_display_attachment' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_handler_field_numeric' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_handler_field' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_access_none' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_plugin_access' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_handler_argument_string' AND type = 'class' 4 Query SELECT filename FROM registry WHERE name = 'views_handler_argument' AND type = 'class' 4 Query SELECT t__0.* FROM page_manager_pages t__0 WHERE (task = 'page') 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'contact' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'search' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'file/add' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'file/%' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'block/%' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'filedepot' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'tagclouds' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'comment/%comment/devel' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'taxonomy/term/%' AND module = 'system' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'system/files' AND module = 'system' 4 Query SELECT filename FROM system WHERE name = '' AND type = 'module' 4 Query SELECT menu_name FROM menu_links WHERE router_path = 'realname/autocomplete' AND module = 'system' 4 Query DELETE FROM menu_router ==> /var/log/drupal/drupal_dTEST.log <== Jun 12 12:33:08 deskEdgar dTEST: https://dTEST.loc|1402601588|menu|127.0.0.1|https://dTEST.loc/index.php||0|…: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {menu_router}; Array#012(#012)#012 in _menu_router_save() (line 3774 of /srv/www/drupal7/dTEST/includes/menu.inc). ==> mariadb.log <== /usr/local/mariadb/bin/mysqld, Version: 10.0.11-MariaDB-log (Source distribution). started with: Tcp port: 3306 Unix socket: /var/cache/mariadb/mariadb.sock Time Id Command Argument checking, despite the "MySQL server has gone away" error, the db server is still running ps ax | grep mysql 11715 ? Sl 0:00 /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/etc/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/data/db/mariadb --plugin-dir=/usr/local/mariadb/lib/plugin --log-error=/var/log/mariadb/mariadb-err.log --pid-file=/var/cache/mariadb/mariadb.pid --socket=/var/cache/mariadb/mariadb.sock --port=3306 23729 ? Ss 0:00 /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/usr/local/etc/mariadb/my.cnf mysqladmin status Uptime: 453 Threads: 1 Questions: 1 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 63 Queries per second avg: 0.002 Digging online, I find multiple suggestions for fixing the "MySQL server has gone away" that suggest increasing the value of `max_allowed_packet`. I've done that, mysqladmin variables | grep " max_allowed_packet" | max_allowed_packet | 67108864 unfortunately to no effect. I can't get a handle yet on what the problem is here. Any ideas or suggestions? Grant

4 8

Wiki tools and images
by Bert Van Kets 17 Jun '14

17 Jun '14

Hi all, I'm setting up a Wiki system in D7 using Freelinking, Flexifilter, WikiTools, and Tagcloud. I need to add the ability to upload images and files. I tried using WYSIWYG module, ckeditor and IMCE, but CKEditor escapes the Wiki tags and that screws up most wiki editing. If possible I'd like to add versioning to the images and files too. Anybody got any suggestions on how to add image support to WikiTools and Flexifilter? Thanks Bert

1 0

clean url tutoria
by Don 16 Jun '14

16 Jun '14

I ran across this easy to follow tutorial which might help you pinpoint the problem. http://www.wallpaperama.com/forums/how-to-test-check-if-mod-rewrite-is-enab… -Don-

2 1

Editing user fields in PHP locks user out
by Jesse Osiecki 16 Jun '14

16 Jun '14

I have recently written a custom module that among other things edits a user field (2 actually) during execution. If any user field is changed, after logging out, the user can no longer log in and has to reset his/her password. It this usual behaviour (am I missing something key to drupal permissions?) I can send code, but it is all using user_load ---- modify array -- and then user_set(array) to save the changes

1 0

Tutorials for Learning Drupal
by Gregory Evans Callaway 15 Jun '14

15 Jun '14

Can you tell me where I can obtain the best tutorials for learning Drupal? Sincerely, Gregory Callaway

7 6

Customizing Drupal Commerce
by techlists＠phpcoderusa.com 14 Jun '14

14 Jun '14

Hi, I am looking at customizing Drupal Commerce. I've been a LAMP dev for a while however I am very new to Drupal. I have a ton of questions. First let me say thank you for all your help and guidance. I am wondering the best way to proceed? Hack the existing commerce modules or create other modules that interact with the existing commerce modules? Thanks again for all your help!! Keith

3 2

clean url's
by techlists＠phpcoderusa.com 14 Jun '14

14 Jun '14

Hi, I've uploaded Drupal Commerce Kickstart and it is working as I would expect it to. The problem is clean URLs. This is on a new VPS and I have no other sites on this server that use mod rewrite. As a result I do not know if this is an Apache config issue or something to do with Drupal or Kickstart. I have KickStart setup on a local dev box and clean URL's was not an issue so I assume this might be an Apache config issue. I modified the Apache config changing AllowOverride to ALL. I've verified the .htaccess file that came with Kickstart is in the root directory and have verified the permissions are 644. When I go into the Admin panel to check for clean URL's it fails. Any suggestions on how I can troubleshoot this issue? Thanks a bunch in advance!! Keith

3 8

Updating live from dev
by techlists＠phpcoderusa.com 11 Jun '14

11 Jun '14

Hi, I seem to recall hearing there was a way to push changes from a dev site to a live / production website. I know some use GIT and that seems good, however I'm wondering about content as well. Say someone writes an article on the test site and when ready pushes it to the live site. Or should I only be doing Drupal config / building on the dev site and do all my articles on the live site with a backup. What is the "Drupal way" protocol and what will make my life the easiest? Thank you for your continued guidance!! Keith

2 1