- support - lists.drupal.org

Drupal 6 --> 7 upgrade - rogue PHP code / delete page?
by Darrell Eifert 17 Jan '14

17 Jan '14

Hello all -- I recently completed a test Drupal 6 to 7 upgrade on our library site, and all seemed to be well except that our old cron job will not run -- it appears to die on a white screen with the words "Number of pages". I did some digging via drush cron, and discovered that a page I had built in Drupal 6 with PHP code listing the total number of website pages contained a PHP function referencing "db_result", which apparently is not supported in Drupal 7. My problem now is that I cannot delete the 'rogue' page from Drupal 7. I can find the page easily enough, but it displays only as white screen with text and none of the usual edit / delete tabs. Is there a way to delete a Drupal node without actually landing on that node? (Note also that I have the node alias from the Drupal 6 install, but do not know the node number of the page in D7.) Thanks in advance ... -- Best, Darrell Eifert Lane Memorial Library (603) 926-3368

4 4

Issues with pdo abstraction with 1:many data
by Jeff Greenberg 16 Jan '14

16 Jan '14

I have the following code: $query = db_query('SELECT * FROM table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.id'); $msg = $query->fetchAllAssoc('id'); Since it is 1:many data, I would expect id 1 another t1 field another t1 field t2 value 1 more t2 from that row t2 value 2 more t2 from that row id 2 But I only get 1 t2 row for each t1. If I do the same query (without the fetchAllAssoc) in mysql I get the expected results. -- --- drupal.org/user/367108 linkedin.com/in/jeffrgreenberg accidentalcoder.com / ayendesigns.com @accidentalcoder

2 1

how to show a view in a table format
by vibanu 16 Jan '14

16 Jan '14

Hi All, We would like to replicate the following page into DRUPAL http://www.cs.stonybrook.edu/students/undergrad/CSEcourses.html We have content type of courses. We are struggling to find a solution on how or the best way to show the 4 semesters. Any ideas are appreciated. Thanks in advance.

5 11

D6: Viers: only nodes with a webform attached to them?
by Shérab 15 Jan '14

15 Jan '14

Dear all, Is there a possibility in D6 to build a view of only those nodes of a given content type having a webform attached to them? Many thanks, Shérab.

1 0

Re: [support] support Digest, Vol 133, Issue 28: SA-CORE-2013-003 after updating from 7.23 to 7.25
by Chris McAndrew 15 Jan '14

15 Jan '14

The files directory error is just a permissions problem. You need to first make the private directory in ../private (outside of root). Then chmod that to 777. For your drupal directories, checkout this article: https://drupal.org/node/244924. This script rocks. Run it from your server root, not drupal and follow the directions carefully. This will correct everything within your drupal directory. I swear by this. Since the private directory is outside of that, it won't touch it which is why I do it manually - chmod 777 private. Refresh and that error will go away. Chris * Chr**is McAndrew* *Interactive Designer & Developer* *Mobile*: 1-603-498-3864 *email*: <chris(a)csmcreative.com>chris(a)csmcreative.com<chris(a)csmcreative.com?subject=Question+via+email+contact+link> *Web*: http://csmcreative.com *Twitter*: @chris_mcandrew <https://twitter.com/chris_mcandrew> *LinkedIn*: chrismcandrew <http://linkedin.com/in/chrismcandrew><http://linkedin.com/in/chrismcandrew> On Tue, Jan 14, 2014 at 1:52 AM, <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 > http://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. Explicitly using drupal CSS classes in 'external' content > (Tim Johnson) > 2. SA-CORE-2013-003 after updating from 7.23 to 7.25 (Afan) > 3. Date views (Roger) > 4. Re: SA-CORE-2013-003 after updating from 7.23 to 7.25 > (Wong Hoi Sing Edison) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 13 Jan 2014 16:41:49 -0900 > From: Tim Johnson <tim(a)akwebsoft.com> > Subject: [support] Explicitly using drupal CSS classes in 'external' > content > To: Drupal Support ML <support(a)drupal.org> > Message-ID: <20140114014149.GB2341(a)mail.akwebsoft.com> > Content-Type: text/plain; charset=us-ascii > > To define 'external' - I am working on a proof-of-concept for a > client. I have written a drupal module which renders legacy CGI > which uses my own python framework, which I have maintained for > years. The content is delivered into drupal via jQuery ajax. > > This is 'step 1' in migrating this very large legacy project into > drupal. > > The content of the legacy framework is created via a MVC strategy > using html templates which have hard-coded css classes. > > Is there a way to leverage drupal css classes rather than those > which were 'hand-rolled' for the original? > > This is an inquiry rather than a request for help. I would welcome > any comments [except for "are you crazy?" :) ] and pointers to > similar discussions and documentations. > > IOWS : Is there a "css naming protocol" that is observed accross > themes? > -- > Tim > tim at tee jay forty nine dot com or akwebsoft dot com > http://www.akwebsoft.com, http://www.tj49.com > > > ------------------------------ > > Message: 2 > Date: Mon, 13 Jan 2014 23:29:30 -0600 > From: Afan <drupal(a)afan.net> > Subject: [support] SA-CORE-2013-003 after updating from 7.23 to 7.25 > To: support(a)drupal.org > Message-ID: <52D4CB3A.9080502(a)afan.net> > Content-Type: text/plain; charset="iso-8859-1" > > Hi to all! > After I updated my Drupal website from 7.23 to 7.25 I'm getting this > > Public files directory Not fully protected > Seehttp://drupal.org/SA-CORE-2013-003for information about the > recommended .htaccess file which should be added to > the/sites/default/files/directory to help protect against arbitrary code > execution. > > > Temporary files directory Not fully protected > Seehttp://drupal.org/SA-CORE-2013-003for information about the > recommended .htaccess file which should be added to the//tmp/directory > to help protect against arbitrary code execution. > > > On the https://drupal.org/SA-CORE-2013-003 it said under Solution "... > upgrade to Drupal core 7.24." In may case it would be downgrade, right? > > What should I do? > > Thanks for any help, > Afan >

1 0

update on: how to use start/end dates from calendars in views? was: Date views
by M. Fioretti 14 Jan '14

14 Jan '14

UPDATE: right after posting the request below, I found something online AND realized I had maybe missed to provide some information. Namely, I found this discussion: https://drupal.org/node/326061 but I don't think is applicable to my case, because I cannot create new content types etc. I have to create a view that is decently printable of upcoming events, with start and end dates, that are ALREADY inserted by others in the standard drupal 6.x calendar. Thanks, Marco Greetings, I have a question related (I think) to the one that Roger just asked: On Tue, Jan 14, 2014 17:47:07 PM +1100, Roger wrote: ... Sorted on Date - start date(asc) I am trying to add to a Drupal 6 website a view that produces a single page, with an HTML table or list containing all and only the events **already** inserted in the standard calendar (which is working perfectly btw): a) with a start date in the future b) ordered by ascending start date. the only problem is... finding the start date. I have already added as filter node=event. After that, I've clicked everywhere in /admin/build/views/edit/my_custom_calendar, but cannot find there anything looking like the "start date" field to work on. How do I tell Drupal that I want the start and end date of calendar events available when I build the view? Should I install/reconfigure some other module (but which one?) or what? Thanks in advance for any feedback!! Marco

1 0

Date views
by Roger 14 Jan '14

14 Jan '14

I hope someone can help me with Drupal 7 views. We have a scenario where events have a lot of repeating dates. For instance, one lot of events may occur every Wednesday for a year in various venues or another every third Monday for the year in similar venues. There are 100+ events held across a 30+ venues in 5 states every week. We have many similarly named events and the calendar format is very cluttered. I am having trouble creating a view which displays each event with it's appropriate title, venue and locality as a heading but shows only start time and limited from now +up to 7 days. Effectively categorising events to a venue/state. Event name, Venue Locality and State are taxonomy terms. States have many venues. Event name has many venues. No matter what I do the view shows redundant data - previous dates for past weeks and future dates for a month or so. And will not categorise event names to a venue or locality. It filters on term from field_event_venue: Field state title, field_event_date = now, Published, Venue. Sorted on Date - start date(asc) Taxonomy Locality is grouped to State Venue is grouped to Locality and to State Most perplexed Help is greatly appreciated Roger

2 1

more on views
by Roger 14 Jan '14

14 Jan '14

I am experimenting with views and taxonomy based on my last post about taxonomy. In a test setup, I have Vocabularies, state, locality, venue, event, each has populated terms. Event content type has: Title, Event type, Venue - term reference to the locality vocabulary with auto complete widget Locality - term reference to the State vocabulary with auto complete widget State - term reference Contact - term reference Event dates Body I entered data into event and auto completed Event type, Venue and Contact. Created events tab which displays the data from a core view. I do not know how to alter the default core view. Each field is a link supposed to go to a page or block with explanatory information for example: click on the name of the venue it should display a block of info about how to find the venue and display a small map. Click on the contact name and it should display further contact info. Needless to say it does not do this, instead display the event again under the venue heading. Click on Locality it shows the locality heading and the State field contents. I am really stuck on how to change the default view and get the links working. Help is much appreciated. Thanks in advance Roger

2 2

SA-CORE-2013-003 after updating from 7.23 to 7.25
by Afan 14 Jan '14

14 Jan '14

Hi to all! After I updated my Drupal website from 7.23 to 7.25 I'm getting this Public files directory Not fully protected Seehttp://drupal.org/SA-CORE-2013-003for information about the recommended .htaccess file which should be added to the/sites/default/files/directory to help protect against arbitrary code execution. Temporary files directory Not fully protected Seehttp://drupal.org/SA-CORE-2013-003for information about the recommended .htaccess file which should be added to the//tmp/directory to help protect against arbitrary code execution. On the https://drupal.org/SA-CORE-2013-003 it said under Solution "... upgrade to Drupal core 7.24." In may case it would be downgrade, right? What should I do? Thanks for any help, Afan

2 1

Explicitly using drupal CSS classes in 'external' content
by Tim Johnson 14 Jan '14

14 Jan '14

To define 'external' - I am working on a proof-of-concept for a client. I have written a drupal module which renders legacy CGI which uses my own python framework, which I have maintained for years. The content is delivered into drupal via jQuery ajax. This is 'step 1' in migrating this very large legacy project into drupal. The content of the legacy framework is created via a MVC strategy using html templates which have hard-coded css classes. Is there a way to leverage drupal css classes rather than those which were 'hand-rolled' for the original? This is an inquiry rather than a request for help. I would welcome any comments [except for "are you crazy?" :) ] and pointers to similar discussions and documentations. IOWS : Is there a "css naming protocol" that is observed accross themes? -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com, http://www.tj49.com

1 0