By sebey on

help I Have no my sql experience please: help here is what it is saying

user warning: 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 'LIMIT 0, 1' at line 1 query: SELECT count(node.nid) AS num_nodes FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (term_node.tid IN ('1')) GROUP BY LIMIT 0, 1 in /Applications/MAMP/htdocs/drupal/includes/database.mysql.inc on line 172.

please help!

⋅ Categories: Drupal 5.x

Comments

Jerimee’s picture

Jerimee commented

You may not have the proper permissions on your database that will allow this sql script to do it's job. Did you set permissions? Did you flush permissions after you set them?

Look at the instructions to create a database in the INSTALL.mysql.txt file:

You will be asked for the 'username' database password. At the MySQL
prompt, enter following command:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

where

'databasename' is the name of your database
'username@localhost' is the username of your MySQL account
'password' is the password required for that username

Note: Unless your database user has all of the privileges listed above, you will
not be able to run Drupal.

pobster’s picture

pobster commented

I'm going to assume by that error message that this isn't an installation error rather that you're trying to pull something out of the database yourself and you're making a bit of a pigs ear out of it...? Why don't you post your code and I'll (or someone will) fix it for you.

Pobster

--------------------------------------------
http://www.justgiving.com/paulmaddern
--------------------------------------------

sebey’s picture

sebey commented

how do I do that? or what do you mean

pobster’s picture

pobster commented

O----kay... Erm, well are you trying to do write your own code or not? If you are, then copy and paste it here (between tags) so I can take a look at it. If you're not, then say so and give more information about what's going on - I can't guess what's going on with your installation, I can't see it for myself...

Pobster

--------------------------------------------
http://www.justgiving.com/paulmaddern
--------------------------------------------

sebey’s picture

sebey commented

I was trying to build a mouth to mouth achive in views and after that that error appeared so I am not writing my own code

pobster’s picture

pobster commented

This is like getting blood out of a stone... Sebastian put the Guinness down (it's not even midday yet...) and tell me some useful information, such as;

Are you using the latest version of views?
Does views work for other views you have?
Detail *exactly* how you've built your views query which doesn't work.

Thanks,

Pobster

--------------------------------------------
http://www.justgiving.com/paulmaddern
--------------------------------------------

sebey’s picture

sebey commented

but anyway here is what I have

here is the version I have: 5.x-1.6-beta5
other views: yes one called about this show

    its a block, 1 node per block,full node
    one field called audio:tag title,
    one argument:itunes RSS Feed Selector and no argument code
    a filter with taxomeny term and a taxomeny term with exposed filter with nothing in it

and lastly the view that does not work:

    its a block, 2 nodes per block,list view
    one field; link to node with no values
    2 arguments;Node: Posted Year with default being return page not found and Node: Posted Month and with default display all values and no code
    and thats it no filters
pobster’s picture

pobster commented

Okay, well... Two things immediately spring to mind;

1. Link to node won't work with no values - you need to fill out the hyperlink in the Options box as it says in the instructions; "This will create a link to the node; fill the option field with the text for the link."
2. Arguments are passed in through a url - is this really what you're after (as you're defining a block and not a page you can easily pass arguments to in the form of http://www.example.com/a_page_view/2007/06), I'm thinking probably not?

Pobster

--------------------------------------------
http://www.justgiving.com/paulmaddern
--------------------------------------------

sebey’s picture

sebey commented

How did you know I was irish?