February 2006 - Development - lists.drupal.org

Upgrade system
by Gordon Heydon 15 Feb '06

15 Feb '06

Hi, Last night I converted E-Commerces old update system to the very cool new one. However I did run over 1 issue. When I am loading a fresh version of the schema, how do I tell the system which revisions have already been loaded. I know that the update system takes this from the system table, but I couldn't even find where Drupal does this. If anyone can enlighten me, I will be much appreciated. Thanks in advance. Gordon.

3 6

New maintainer: automember.module
by Kobus Myburgh 15 Feb '06

15 Feb '06

Hi, I've taken over maintainership of automember.module from njivy (http://drupal.org/user/6194) as from today. I am busy sorting some final bugs out in the code for the 4.7 release and will then need someone to upload it for me, as I can't use CVS. Anyone willing to help with that, please? Can someone with appropriate rights also please flag ownership of the project over to me (user/74) Thanks! Kobus

2 1

Re: [development] touchy mysql ordering
by randall＠thinkingoutloud.org 15 Feb '06

15 Feb '06

MySQL bug or module bug ? Sorry, to post about the same issue, but I am really trying to understand this. ---1--- This query (as seen in event.module): SELECT n.nid, e.event_start FROM event e INNER JOIN node n ON n.nid = e.nid When passed thru the db_rewrite_sql() function, the function returns this query: SELECT DISTINCT(n.nid), e.event_start FROM event e INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON n.nid = e.nid ------- ---2--- This query (the proposed fix): SELECT n.nid, e.event_start FROM node n INNER JOIN event e ON n.nid = e.nid When passed thru the db_rewrite_sql() function, the function returns this query: SELECT DISTINCT(n.nid), e.event_start FROM node n INNER JOIN node_access na ON na.nid = n.nid INNER JOIN event e ON n.nid = e.nid ------- Query 1 and 2 prior to being passed to the db_rewrite_sql() function are essentially the same. After being passed to the db_rewrite_sql() function... Query 1 produces an error in MySQL 5.0 and Query 2 does not. So, is this a MySQL bug or module bug ? Thanks Randall Original Message: ----------------- From: Chris Johnson chris(a)tinpixel.com Date: Mon, 13 Feb 2006 10:10:43 -0600 To: development(a)drupal.org Subject: Re: [development] touchy mysql ordering Tao Starbow wrote: > Stop me if you've heard this one before. > > I recently upgraded the server running my Drupal site, and the events > calendar stopped working for everyone except user=1. I tracked down the > problem to this (simplified) line of SQL: > SELECT n.nid, e.event_start FROM {event} e INNER JOIN {node} n ON n.nid > = e.nid > This returns all my events if the user=1, and zero if the user is anyone > else. > However, if I rewrite the SQL as: > SELECT n.nid, e.event_start FROM {node} n INNER JOIN {event} e ON n.nid > = e.nid > then it behaves as I would expect, returning all events regardless of > who the user is. > > I did not have this problem on my old server, which was running mysql > 4.0.20-max. The new server is running mysql 5.0.17. > > I suspect whatever is causing this is also at the root of my > node_access_by_role issue (http://drupal.org/node/40623) I guess my > next move is to install the devel module and see if I can find a > difference between the sql actually being generated when user=1 vs user!=1. If the actual generated SQL works/fails as you describe in the simplified SQL above, I think you have found a bug in MySQL. INNER JOIN should be commutative, that is, it should not matter which order the two joined tables are listed, the results should be the same. -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ .

3 6

Re: [development] Oracle buys SleepyCat
by karoly＠negyesi.net 15 Feb '06

15 Feb '06

6 6

DrupalCon Vancouver -- James Blackwell name tag?
by Karoly Negyesi 15 Feb '06

15 Feb '06

Hi! It seems that I somehow missed James' excellent name tags. If you happen to have a shoot of those (first it said, bzr crack dealer, next day it was bzr crack dealer, first commit is free :D) , please share. Regards NK

1 0

Bike Shed: Developing for Drupal
by Arnab Nandi 14 Feb '06

14 Feb '06

>From a discussion about NLD10 and xgl. I thought it was very relevant to the drupal devel crowd: http://mail.gnome.org/archives/desktop-devel-list/2006-February/msg00115.ht…

11 12

Translation speed
by Khalid B 14 Feb '06

14 Feb '06

Adding an index on the source column of the locales_source table seem to increase performance. See here http://drupal.org/node/48563 I think this is worth considering for 4.7.

3 4

Form field maxlengths vs. database field sizes
by Karthik 13 Feb '06

13 Feb '06

This issue stems from Killes' comment [ http://drupal.org/node/46306#comment-71971 ]. Should form field maxlengths be consistent with corresponding database field sizes or should unicode encoding be accounted for? This is especially in light of the fact that 4.7 now converts all existing databases to UTF-8, but also retains support for (MySQL) 3.23.58. Or should we just not use maxlengths at all? Thanks -K P.S Please reply on the issue page: http://drupal.org/node/48510

13 18

check_markup() and flexinode
by Fehér János 13 Feb '06

13 Feb '06

Hi, I'm using the 4.7 beta4 and the latest flexinode HEAD. When I try to apply the filters on the fields with this method $node->flexinode_97=check_markup($node->flexinode_97,$node->flexinode_97_format,FALSE); the filters aren't applied . In the body and teaser, everything is OK. What am I do wrong? -- Aries

1 1

Forum and the problem.....
by Mohsen Pahlevanzadeh 12 Feb '06

12 Feb '06

Dear all, When i created a container for Forum,I don't need to become link name of container itself.Unfortunetly name of container is become a link. Please guide me.....

2 1