- support - lists.drupal.org

[drupal-support] node_load functionality (lots of access_denied results)
by vrao 20 Oct '05

20 Oct '05

Hi, The node_load function is giving me some problems. I installed and then uninstalled node_privacy_byrole and that seems to have caused some issues. $node = db_fetch_object(db_query(db_rewrite_sql('SELECT n.*, u.uid, u.name, u.picture, u.data FROM {node} n INNER JOIN {users} u ON u.uid = n.uid WHERE '.\ implode(' AND ', $cond)))); does not return an object when a non admin user executes it. I did an echo db_rewrite_sql and sure enough for an admin user the query is : SELECT n.*, u.uid, u.name, u.picture, u.data FROM {node} n INNER JOIN {users} u ON u.uid = n.uid WHERE n.nid = '19' for a non admin user however, its still trying to do a join with node_users SELECT n.*, u.uid, u.name, u.picture, u.data FROM {node} n INNER JOIN {node_access} na ON na.nid = n.nid INNER JOIN {users} u ON u.uid = n.uid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0')) AND n.nid = '9' what gives? -v

1 0

[drupal-support] latest posts with username/pic
by Jad Madi 20 Oct '05

20 Oct '05

$result = db_query("SELECT n.uid, n.created, n.title, n.nid, n.changed FROM site_node n WHERE n.type = 'blog' ORDER BY n.changed DESC LIMIT 50"); any idea how to add one more query to get username/picture behind the post?

2 1

[drupal-support] i18n module
by Mohammed al-shar' 20 Oct '05

20 Oct '05

Blankdear listers, hello. I have been experimenting with the i18n module to creat a multi lingual site, and so far I have been able to translate nodes as expected. however, I need help with how to get the 'language dependent variables' to work. I know I should be modifying the config file, but where is that file? anybody who ever done this please help me out. I want in the end to have different site title, mission statement, footer, menu, etc. for each language. any help will be highly appreciated. regards, Mohammed Al-Shar' Adaptive technology specialist email: mohammed(a)mystop.net mobile: 00962(79)6632186 website: http://www.mystop.net

3 2

[drupal-support] Authorized Users Redirected
by Grand Junction 20 Oct '05

20 Oct '05

Hi, I'm having a problem on my Drupal installation where authorized users - immediately after logging in - are being redirected to /resources. That is a page on the site, but I can't figure out where the command is that is sending the users to that page. After looking around for a while, I went so far as to install the front page module, which works (it sends authorized users going to www.example.com to a different page from anonymous users) but when logging in I still get sent to /resources. Does anyone know how I can change that redirect? Thanks, Matthew O'Malley __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

2 1

[drupal-support] New to CVS, database connection issues
by Thatguywhowon'tgivehisname 19 Oct '05

19 Oct '05

I decided to try to use the CVS version of Drupal on a new site I am working on. I am using 4.3, 4.4 and 4.5 on other sites but this is my first foray into CVS and I am eager to learn. I wget'ted the cvs tarball and extracted it using my normal tar vxfz. I then tried two things: 1- I created a directory under the sites directory with the domain name and copied the settings.php from the sites/default directory there and modified the database connect string and the base url. I get the fancy, new "Unable to connect to database server" screen with this information- The MySQL error was: . Notice the dot after the colon. That is not a period at the end of my sentence. 2- I then changed the settings.php file in sites/default to my database information and base url. Same result. If I modify my Apache virtual host directives for this site to point to the directories for an existing 4.6.3 setup everything works fine. It is only when I use the cvs directories that it fails. I know that it is using the settings.php because the portion of the error screen that says "Currently, the username is root and the database server is localhost" changes when I change the username in the settings.php file. I must be doing something wrong. What am I missing? __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

2 2

[drupal-support] error 500 and menu module
by Larry 19 Oct '05

19 Oct '05

I keepting getting eror 500 in the menu module. Any pointer to wht mmight be wrong welcome . I have reproduced the error below, Server error! The server encountered an internal error and was unable to complete your request. Error message: Premature end of script headers: index.php If you think this is a server error, please contact the webmaster. Error 500 - Larry

1 0

[drupal-support] text size diminishing in bluemarine theme?
by Larry 18 Oct '05

18 Oct '05

I might be doing something wrong (can't think of what ) It looks like anytime I click on a node the text size on my site becomes smaller. Even with text size setting in the browser set to largest. i have tried this both in explorer and FireFox. Larry

2 2

[drupal-support] Who's online module
by Larry 18 Oct '05

18 Oct '05

How do I clear cache of guests online? Eg I have "There are currently 9 users and 504 guests online." I wish these 504 guests will join us online :) Larry Osei-Kwaku

4 3

[drupal-support] What happened to the mobile blog (moblog) module?
by Leo Burd 17 Oct '05

17 Oct '05

Hello everyone, I may have missed part of the discussion, but does anybody know what happened to the moblog / mobile blog module that was being developed for Drupal? That's such an interesting module... Best, Leo

1 0

Re: [drupal-support] Drupal 4.7 installation
by Kobus Myburgh 17 Oct '05

17 Oct '05

Thanks, Larry, I am going to try that tonight and will provide feedback. I will simply remove legacy.inc from my installation folder, and if that causes too much effort, I will turn on short tags, and if that doesn't solve the problem, I believe that the issue might be something else. Anyhoo, I will provide feedback for those interested. Regards, Kobus >>> larry(a)garfieldtech.com 10/17/2005 8:20:42 AM >>> Dollars to donuts it's this issue: http://drupal.org/node/34241 On Monday 17 October 2005 12:52 am, Kobus Myburgh wrote: > Hi, > > I tried to make screenshots with Drupal 4.7 and CivicSpace theme this > weekend (for the docs team), but I ended up making one screenshot only. > Drupal 4.6.3 works 100% on my local host, but 4.7 gives me gibberish (as > shown in the image). It might very well be a configuration issue, but I am > not sure whether I need to change something, and if so, what? Drupal 4.6.3 > works flawlessly. > > I am using Apache 1.3.x (I think 1.3.26?) > I am using MySQL 4.1 > I am using PHP 4.3.6 > > Any ideas, please? > > Regards, > > Kobus -- Larry Garfield AIM: LOLG42 larry(a)garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson -- [ Drupal support list | http://lists.drupal.org/ ]

1 0