November 2005 - support - lists.drupal.org

Odd 'fatal error' but no problems in database and no changes to drupal files
by Nick Holden 29 Nov '05

29 Nov '05

About 5pm yesterday, our drupal site at http://www.workersliberty.org just died: - Fatal error: 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 '' at line 1 query: SELECT title FROM node WHERE nid= in /home/newawl/www/includes/database.mysql.inc on line 97 - I stopped MySQL and checked all the tables. Nothing wrong, even on extended check. The error appears on every possible URL within the site, and seems to suggest that drupal is sending a malformed query to the database. Drupal is 4.4.1 (yeah, I know, we've been meaning to upgrade for a while), php is 4.3.10-15 and MySQL is Ver 12.22 Distrib 4.0.24 - nothing has changed in recent days, yet suddenly this lot won't talk to each other. Any thoughts? Many thanks, Nick

2 2

Re: [support] Odd 'fatal error' but no problems in database and no changes to drupal files
by Chris Johnson 29 Nov '05

29 Nov '05

Nick Holden wrote: > On Monday 28 November 2005 22:09, Chris Johnson wrote: > >>I think you are right that Drupal is sending a malformed query. It appears >>to be specifically the book.module that is generating it (or possibly a >>contributed module). > > > Why do you think it's the book module? I'm not even sure that we're using it! It's just a guess based on the limited information available. I searched all of the source code for core for SQL queries that match your error. Only the book module has one like it. That does not mean something else is not creating one bit by bit dynamically or that some contributed module is not doing it. It was just my best guess. > None of those URLs work - I get the same error message as on the home page > with all of them, which makes me think it's not a module that's messing up, > but something more core. But in that case why would it suddenly stop working? Sorry they didn't work. There was a chance that the bad SQl would not be run on admin pages and they would work if your session had not timed out. No such luck. I can only guess it stopped working because new content was added or something else in the database changed resulting in a bug getting exercised -- one that was avoided previously. But again, I'm just guessing based upon the limited information and general experience with the software. ..chrisxj

1 0

i18n question : $i18n_variables = array in settings.php
by vrao 29 Nov '05

29 Nov '05

Hi, Most of my site is translated, but I want to be able to translate more fields (like profiles, footer message etc) However, Whenever I uncomment $i18n_variables = array('site_name'); (the actual list is very long) I lose my primary links, secondary links etc from the site display. I am trying to add to the list of translated variables (I want to translate my footer), but it seems Im doing it completely wrong. As of now, I have to leave it commented /*$i18n_variables = array( */ and have to settle for whats already allowed. How do I load all existing variables and add new ones? Whats the syntax? Thanks. V

1 0

Ldap AD authentication
by Andy Morris 28 Nov '05

28 Nov '05

Okay, I am trying to get drupal to authenticate to win2k3 domain. I have installed the ldap module, just don't know what to do next. Can someone walk me through this. I just want users to authenticate to domain via ldap and then have certain rights on the drupal site. I don't want them to change their passwords. Thanks, andy

1 0

PayPal Pro module dudes
by Joan Martínez Serres 28 Nov '05

28 Nov '05

Hi all. I'm new in this list I just try the module PayPalPro for offer the payPal and Credit Card payment in a Drupal Website. All function fine but this option "PayPal Digital Certificate" is a mistery for me. I search for a Digital certificates in PayPal.com without a response. In the instructions say: "The absolute path to your PayPal SSL certificate. Use the "cert_key_pem.txt" file provided by PayPal, do not convert it to P12 format. " I need contact with PayPal for obtain this ssl certificate? I can't find this srvice on it. Or I need make or create am SLL certificate in my Server? how? tanks and regards -- ********************************************************* Joan Martínez Serres mailto:joan_a_linuxbcn:com

3 4

Re: [support] Support?????
by Kobus Myburgh 28 Nov '05

28 Nov '05

> just the other day a person named kubas helped me restore my site which was > mostly going to be lost and imagine the panic when every single data in the I try to help whenever I can. I am glad I could help you, Mohammed! Anna, just a quick note. Sometimes, when a person doesn't answer your question it doesn't necessarily means that they are ignoring you. Sometimes they simply just don't know the answer and prefer not to clutter the list with useless posts, hoping someone that DOES know the answer can get it solved for the requester. I was aware of your question, but couldn't answer properly, so I just hushed. If you wish, I could attempt to help privately, but no guarantees, and with unsure answers I won't flood the list :-) Regards, Kobus

1 0

the read more link
by Mohammed al-shar' 28 Nov '05

28 Nov '05

hello. I am not sure I can find this on the drupal site, so I am asking here. can I get read of the read more link and the add new comment link too on the trimped version of the stories on my main page? another thing is can I just list links to other content on my main page without a trimped version of that story? thank you.

3 2

turning off theme selection
by vrao 26 Nov '05

26 Nov '05

Is it possible to disable the 'theme select' option for users? (without hacking) Thanks, V

3 4

mysql collation and i18n
by Ryan Grace 26 Nov '05

26 Nov '05

Hello there, Moving to a new dedicated host today. My old one had mysl 4.0.20 New host has mysql 4.1.13 I get "unsupported database type" when i check the results of my whm/cpanel migration... odd thing is this is for my civicspace .8.3 rc6 install only. but my standard drupal 4.6.3 sites come up clean and working... I was also recieving the elusive collation errors before in my civicspace sites if i enabled civicrm.. it is disabled still as a result. My question is this... Is civicspace compatible with mysql 4.1.13? And for the future.. will i be able to get i18n working with civicspace/civicrm? What is the current status of the i18n bug? It is making me nervous that the only solution to the collation bug at this point is a hack which fundamentally disables i18n ability.... eager to see a multilingual civicspace, ryan grace.

1 1

user1 account
by Larry 25 Nov '05

25 Nov '05

is there anyway to restore a user1 account which has been deleted? Regards Larry

7 10