support January 2012

support@drupal.org

81 participants
134 discussions

Re: [support] Error updating database
by James Rome 19 Jan '12

19 Jan '12

It apparently DID timeout. I called GoDaddy, they tested the database and said it was working. Then I tried it again and it worked! So something got cleared. -- James A. Rome

4 3

main menu -> secondary menu
by Bert Van Kets 19 Jan '12

19 Jan '12

Hi all, here's a problem I have been struggling with for some time now: how do you keep the main menu item selected when a child item in the secondary menu is selected? Here's the setup: - Drupal 7.10 - menu_block 7.x-2.2 module I have selected the main menu for the main menu items below the header. I created a menu block using the 2d level items below the selected main menu item and put that menu in the left side bar. How can I keep the main item selected when any child element is clicked? Sample site: - main item clicked and main item selected: http://dream-models.com/test/node/2 - sub item selected, main item not selected: http://dream-models.com/test/content/radds-school-rotary-flight Do you know of any way to keep the main menu item selected? Thanks Bert

2 3

Drupal 7 Schema API / datetime => char?
by Tim Gustafson 18 Jan '12

18 Jan '12

So, in the Drupal 6 version of a lot of my modules, I made prodigious use of the datetime column type. Now, Drupal 7 says those pesky data-specific column types are off-limits. I created a hook_update_N function to convert datetime columns into char columns that looks like this: function hook_update_N() { db_change_field( "foo", "column_1", "column_1", array( "type" => "char", "length" => 20, "not null" => true, "default" => "0000-00-00 00:00:00", ) ); db_change_field( "foo", "column_2", "column_2", array( "type" => "char", "length" => 20, "not null" => true, "default" => "0000-00-00 00:00:00", ) ); } And when I run update.php, I now get: Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'column_2': ALTER TABLE {foo} CHANGE `created_on` `column_1` CHAR(20) NOT NULL DEFAULT '0000-00-00 00:00:00'; Array ( ) in db_change_field() (line 2984 of includes/database/database.inc). Please not that it's complaining about the default value on column_2 when it's trying to update column_1. How does one convert a table with two or more datetime columns to char(20) columns in Drupal 7? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tim Gustafson tjg(a)soe.ucsc.edu Baskin School of Engineering 831-459-5354 UC Santa Cruz Baskin Engineering 317B -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

2 3

Re: [support] Error updating database
by James Rome 18 Jan '12

18 Jan '12

On Wed, Jan 18, 2012 at 10:24 AM, James Rome <jamesrome(a)gmail.com> wrote: > When I run update.php, I get > PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone > away: SELECT filename, name, type, status, schema_version, weight FROM > {system} WHERE type = :type; Array ( [:type] => module ) > insystem_get_files_database()?(line?2188?of/home/content/72/8469872/html/drupal/modules/system/system.module). > > What does this mean? Are you upgrading from D6 or an earlier version of D7? I've seen this happen because of a poorly tuned DB. Something caused MySQL to not respond and close the DB connection. -- I did clear all caches, and this is just an update for Drupal 7 after updating Views. Caches cleared. Error message /PDOException/: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT filename, name, type, status, schema_version, weight FROM {system} WHERE type = :type; Array ( [:type] => module ) in/system_get_files_database()/ (line /2188/ of//home/content/72/8469872/html/drupal/modules/system/system.module/). The website encountered an unexpected error. Please try again later. Uncaught exception thrown in session handler. PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 206 of /home/content/72/8469872/html/drupal/includes/session.inc). -- James A. Rome URL: http://jamesrome.net

1 0

Need One-time On-site Technician (not Drupal)
by Fred Jones 18 Jan '12

18 Jan '12

This is a "job" but it's actually not Drupal-related so I can't post it on groups.drupal.org. But it's for a Drupal shop anyhow. :) We have a client in Boulder, Colorado who is in need of assistance adjusting their email clients to account for new POP3 and SMTP settings. They are unable to handle this alone. This is a simple, one-time job of about an hour or two, in Boulder. Anyhow who is available, or knows of a technician who does this type of work, please contact me. Sorry for the interruption--back to Drupal. Fred

1 0

views updates
by Anthony 18 Jan '12

18 Jan '12

I am constantly being told to download updates for Views from version 7.x-3.0-rc to 17.x-3.1 (Release notes)<http://drupal.org/node/1407192>. I have done it *several *times and yet it keeps coming back . The update seems to happen seamlessly. Thanks Tony -- *Anthony Stefan Maciejowski* *tony maciejowski** | analyst/programmer | websites | www.tony-mac.com<t_maciejowski(a)hotmail.com> * *Twitter: anntosh* | *Cell: 323.899.6206* | *Linked-In:* *Anthony Maciejowski*

1 0

Re: [support] Home Page Menu URL issue
by Keith Smith 18 Jan '12

18 Jan '12

1 0

Error updating database
by James Rome 18 Jan '12

18 Jan '12

When I run update.php, I get /PDOException/: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT filename, name, type, status, schema_version, weight FROM {system} WHERE type = :type; Array ( [:type] => module ) in/system_get_files_database()/ (line /2188/ of//home/content/72/8469872/html/drupal/modules/system/system.module/). What does this mean?

3 2

Member ship plan module
by Selvaraj Chnnasamy 18 Jan '12

18 Jan '12

Hi All Could you please tell membership plan module Regards Selvaraj.C

1 0

Campaign monitor doubts
by Selvaraj Chnnasamy 18 Jan '12

18 Jan '12

Hi Could you please explain campaign monitor Regards Selvaraj.C

3 4

← Newer
1
2
3
4
5
6
7
8
9
...
14
Older →

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support January 2012