I just joined an organization that helps inner city folk learn to grow gardens, to end hunger. Their cause is right down my ally, but they have a MySQL error and want to help them out. They are a 501c3 Not-for-profit so I thought I'd come to the place that's helped me so much personally Drupal!). Thought maybe someone here could just tell me what the error means so I can let them know if it's a big deal
thanks for any help you can give, the error is at the bottom of this code here, lata
Alex Ihlo
"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"

Hi. I changing our company site with Drupal. What i want to know that is how to control permission to access specified folder?
Uploaded files are contained one folder.
I want to check user's status which member or visitor when user download files.
But I only can check download action through attachment box, i can't check through just link.(For example, http://www.google.com/sites/files/ThisIsJustExample.zip)
Same file, just diffrent way to access.
Our site can check file click hit that 2 ways. How can I improve for this action?

Does have anybody experience in moving from OpenCMS to Drupal?

Warning: array_diff_key(): Argument #1 is not an array in drupal_lookup_path() (line 101 of C:\wamp\www\drupal-7.x-dev\includes\path.inc).
Warning: array_flip(): The argument should be an array in drupal_lookup_path() (line 101 of C:\wamp\www\drupal-7.x-dev\includes\path.inc).
I got these 2 warning please any one can give me the solution.

Hey folks - just want to introduce myself. I am working on the conversion of Examiner.com (a ColdFusion/SQL Server based site) to Drupal 7.0.
I am the architect of the current Examiner.com site - a top 100 US website! We rely a great deal on cacheing, obviously, which tends to take the form of MemcacheD and MongoDB plus some of the built in application cacheing of ColdFusion (like compiled classes, cached queries, in-memory classes etc.).
We run about 100 transactions a second (tends to run about 600 transactions a second at the DB level) so we have a bit of a challenge ahead of us. We support 215 Editions with dynamic page generation behind them which creates a potential of about 1 billion pages. From a block level we would probably support about 200,000 different blocks at any point in time.

Hey everyone. New Drupal convert here. I'm currently doing the exercise of trying to convert my GURPS dedicated site (http://free.7host07.com/spdesign/) to Drupal ! One thing that my site uses a lot for game aids is data tables. For my current site, I built them custom with .asp coding but I would like to know if there would be useful modules that would mimic the .NET datatables (tables where you can click on the header to re-sort them). Here's an example of a data table I create (http://free.7host07.com/spdesign/article.asp?id=5). Any Drupal Module would enable me to do this or something similar ? Also, if I would want to store my data in the same mySQL database as my Drupal site, would there be any risk for me to lose them whenever I would upgrade Drupal to a new version ? Thanking you all in advance...

Hi all,
I have a fairly basic website that consists mainly of a few static pages that are updated from time to time. The only thing that's somewhat complex is that I have one page that has a form, which when submitted redirects to a second page that has a second form. The second form has a number of hidden attributes based on the first form and lets the user verify some information. When the second form is submitted it goes off to a third party site.
I've got Drupal 6 installed in a test environment and have been playing around with writing my own module. I've got a basic module that creates a form and displays the results when its submitted, and I'm playing around with a multi-form module from the Pro Drupal Development book. But one thing that confuses me is how do you place a form in the middle of static content? I want more than just the form displayed when the user visits the appropriate page, and I want different static content depending on whether the user is on the first page or the second confirmation page. None of the examples I've seen so far demonstrate anything more than displaying a standalone form. What am I missing?

Hell all,I am new to Drupal from Joomla and I wish to start a realty listings site where sellers pay to gain access to issue ads and the general public only get to see the ads but no adding or editing ads unless they're paying members.I had started this support enquiry here http://drupal.org/node/697960 thanks in advance for taking the time to read my post.

Hi mates, this is my first post and it seems that I'll be here por a long time. My company is switching from a bespoke CMS developed in asp.net to Drupal. This CMS has 1000+ posts or articles that I have to import to Drupal because it's impossible to do it manually. So I'm thinking of writing some function that takes all the content from SqlServer and writes the Querys in a file (script) to run it in the MySql Browser or Administrator... Or I could do the inserts in my function as well.
The thing is that I must understand the DB schema of Drupal. This are the most relevant fields in the asp.net CMS (* means mandatory field):

Hi all,I am laughably new to Drupal and seek some enlightenment about the possibilities one has with Drupal.You see I have this idea of a paid membership site for realtors where they can enlist offers and have discussions with one another,basically I would want the site to be a marketing tool and a communication tool for realtors and property dealers,is there a collection of modules that could work together to pull this off?.I have heard that ubercart has the ability to manage subscriptions but I have not heard of a cataloging module that can integrate with it to formulate a paid listings system,integration with some SN modules also would be essential but not important,thank you!