- support - lists.drupal.org

Unable to connect to Postgres via UNIX domain socket
by Bill Moran 11 May '07

11 May '07

I don't know if MySQL had the equivalent to this, but with PostgreSQL, you can connect to a unix domain socket instead of TCP/localhost. This has the advantage of being faster because it doesn't have the overhead of TCP. It doesn't seem as if Drupal's connection scheme is capable of supporting this. Using raw pg_connect() in php, the connection would be established thusly: pg_connect('user=drupal dbname=drupal host=/tmp'); Optionally, the host= could be omitted entirely, and the PG drivers will default to connecting to the local socket in /tmp. if I tweak the following: $db_url = 'pgsql://drupal@/tmp/drupal'; It doesn't work. I assume the url decoding is barfing on that. Leaving out the host name causes a similar error. Is this possible? I suppose it's not the end of the world if it's not, but I thought I'd ask. -- Bill Moran http://www.potentialtech.com

1 0

Possible to set default input format based on role?
by Jody Cleveland 10 May '07

10 May '07

Hello, In Drupal 5.1, is it possible to set the default input format for specific roles? Basically, I've got a role setup for content editors on the site. For them, I'd like to allow pretty much full html. For anonymous users, I don't want to allow any. All they'll be doing is posting comments anyway. Is this possible to do? I know I can have users select the input format for each one, but I'd like to set defaults for specific roles. - jody

2 4

What the *&^% is NABBLE.COM?
by blogdiva＠culturekitchen.com 10 May '07

10 May '07

And why are the Drupal Mailing lists on it? / liza

3 5

open popup from menu
by j0sh 10 May '07

10 May '07

hi all my first post here! is possible to add a menu voice that open a popup window? tnx to all

1 0

Forms in Nodes
by Mike Bishop 10 May '07

10 May '07

Hello Drupalers, I have searched high and low for a solution. I am looking for a module or simple programmatic way for "non-programmers" to be able to add forms to panels. One panel shows a view and the other would show a CCK node/add/*something* form associated with that view. The "non-programmers" in question have learned how to create new CCK types and Views as needed. Adding the form to the panel is the last step. Any help would be much appreciated. Thanks! Mike Bishop - St. Louis

2 1

Many menus - complex navigation
by jp.stacey＠torchbox.com 10 May '07

10 May '07

Hi, I've got much of the functionality together that I need from Drupal, except the client would now like quite structured menu navigation and I was wondering how I would accomplish this in the least hacky way. The site is divided up into sections with the category module, although final "pages" are often views rather than nodes, so (I think) they can't be categorised and hence put in a section directly. There's four to five layers of sections, and the end pages don't have to appear in the navigation themselves (except when they're what you'd call "index" pages). My problems are specifically at the view layer - putting the overarching menu together in admin isn't too hard. Any suggestions on the following requirements gratefully received: 1. Across the top, two layers deep into the section hierarchy: A B C D (Hidden dropdowns:) a1 b1 ... a2... b2... ... 2. Down the left-hand side, the second and subsequent layers of the *current* section's hierarchy. So if you're in top-level section B: b1 b2 b2-1 b2-2... b3... This would need to adapt depending on what section the user is navigating in (so in section A you'd just see a1...aN). 3. Current top-level-section (A, B, C or D) highlighted, and current sub-sub-...-section expanded on the left-hand side, all the way down. I can force sections for non-sectioned pages in template.tpl.php - I'm already doing it, sort of, for one of the views - but it'd be good to know how to do the above with the least PHP. Specifically: * how to highlight A, B, C or D (with HTML classes?) and make a menu only 2 levels deep * how to choose a submenu, and how to expand just the leaves (leafs?) that lead you down the tree to e.g. b2-3-1, given that sub-sub-sub...section (so generating a menu 2-to-X levels deep) Many thanks in advance! Cheers, J-P

4 3

Devel module - how to turn off page execution time?
by Jody Cleveland 08 May '07

08 May '07

Hello, I've got a Drupal 5.1 site running with the latest version of the Devel module. Just for grins, I decided to check the box to show page execution time. Now, every page I go to only displays the execution time, nothing else. Since I can't get to the module settings through the site, how do I manually turn that feature off? - jody

2 1

creating menus with "system" destination URLs
by Neil: esl-lounge.com 08 May '07

08 May '07

I have a new theme and am now trying to create the menus. I have run into a lot of trouble with destination URLs such as user/me ( I am using me module) profile/me user/1 These are either not being put in or are put in but without the possibility of adding sub-menus to them. Has anyone else struggled with this issue? I just created a menu item going to user/1 and it showed up in FF but not in IE. I realised it was because, only for admins, I still have the "Navigation" menu showing up and it has the "locked" item MyAccount. In FF, this disappeared when the new menu item going to user/1 was created, whereas in IE, it stayed in the Navigation menu and didn't show in the new menu. My head's about to explode. :-(

4 11

Newbie with a dead site
by erase 08 May '07

08 May '07

Perhaps I should start by saying that I'm obviuosly very daft for not having backed up the last few days work! Where I now am after power loss is with a site reporting: Warning: Table '.\drupal\sessions' is marked as crashed and should be repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '207a004ebaa486e50fc0560a9dc892a8' in C:\xampp\htdocs\includes\database.mysql.inc on line 172 But when I try running the command in mysql it just reports: mysql> select drupal -> SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '207a004ebaa486e50fc0560a9dc892a8'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELEC T u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid ' at line 2 mysql> Any ideas where I go from here? Thanks Phil

3 6

optional user profile fields
by Jean Gazis 08 May '07

08 May '07

I would like to make some user profile fields dependent on other user profile fields, for example, right now I have parent 1, a whole bunch of contact info fields, parent 2, a whole bunch of the same fields, child 1 - many fields, child 2 - many fields, child 3 - many fields. I'd like to make it so the user could check a box if all the info is the same for each person, or if there is only one person, and not have to put "N/A" in over and over. Would this require some other module, or custom field types, or php codiig? -- Jean Gazis www.jeangazis.com www.boxofrain.us

3 2