Project:Area
Version:6.x-4.1
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

after installing area and clicking on the settings link I get the following page:

Query failed:

whats wrong?

thanks

james

Comments

#1

GHi James,
mm, can you tell me a nit more about the error you get_
- Give me the whole error text
- Which drupal version do you have?
- Where are you installing area in /sites/all/modules or /.modules?

Let's see if we can find why you get this error
jaume

#2

I have installed it to /sites/all/modules and have 6.9 installed.

Does the module use Drupal's DB prefix configuration setting? I'm getting this error message and have a db_prefix of "news_" is it not being added to the query?

Table 'xxx.node' doesn't exist query: SELECT DISTINCT type FROM node WHERE type != '' ORDER BY type; in /xxx/sites/xxx/modules/area/lib/functions.php on line 54.

hope this helps

thanks

james

#3

have u had a chance to look at this? would really help me if you could. :)

thanks

james

#4

Hi james
I did install Area in the 6.9 to check if there was a problem with the drupal version
For me works with no problem instaling area in sites/all/modules

I see in your error the path
/xxx/sites/xxx/modules/area/lib/functions.php
i this the real path you have?
Why you don't have somethinglie /xxx/sites/all/modules/area/lib/functions.php ?

James, you can find me in the chat> irc.freenode,net #drupal

jaume

#5

Hi, tried to install the area module and got a similar error with Drupal 6.16:

Message Table '28244_gdpmmaster.node' doesn't exist query: SELECT DISTINCT type FROM node WHERE type != '' ORDER BY type; in /Users/rolf/htdocs/cv2010.gdpmmaster/sites/all/modules/area/lib/functions.php on line 54.

Any ideas?

Cheers, Rolf

#6

Hi Rolf,
mm, I tried fresh installs of Area for drupal 6.17 and all looks ok to me.
Can you give me more feedback?
Can I see your site? It is online?

sorry for the delay
jaume

#7

Hi Jaume

No it's a locally installed site. nothing special; clean URL, status report ok.

I tried to install it on a fresh site and same outcome:

php
Date Monday, July 26, 2010 - 00:06

User admin

Location http://localhost:8888/demo.gdpmmaster/admin/settings/area

Referrer http://localhost:8888/demo.gdpmmaster/admin/build/modules

Message Table 'demomaster.node' doesn't exist query: SELECT DISTINCT type FROM node WHERE type != '' ORDER BY type; in /Users/rolf/htdocs/demo.gdpmmaster/sites/all/modules/area/lib/functions.php on line 54.
Severity error

Cheers, Rolf

nobody click here