By Meenakshi-1 on

When I configure drupal on my local box and try accessing the base
folder at http://localhost/drupal-4.6.3/, I get the following message:

> user error: Unknown column 'n.nid' in 'on clause'
> query: SELECT DISTINCT(n.nid), e.event_start FROM event e INNER JOIN
> node_access na ON na.nid = n.nid INNER JOIN node n ON n.nid = e.nid
> WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN
> ('all0','og_uid0','og_group0')) AND n.status = 1 AND ((e.event_start
> > 1157086800 AND e.event_start < 1159678799) OR (e.event_end >
> 1157086800 AND e.event_end < 1159678799) OR (e.event_start <
> 1157086800 AND e.event_end > 1159678799)) ORDER BY event_start in
> D:\web\apache\htdocs\drupal-4.6.3\includes\database.mysql.inc on line 66.
>
> {head} {styles} {_BLOCK_.header.logo} {_BLOCK_.header.site_name}
> {_BLOCK_.header.site_slogan} {secondary_links} {primary_links}
> {_BLOCK_.header.blocks} {_BLOCK_.header.mission} {_BLOCK_.node.title}
> {submitted} {content} {_BLOCK_.node.title} {submitted} {content}
> {_BLOCK_.node.title} {submitted} {content} {_BLOCK_.node.links}
> {_BLOCK_.footer.blocks} {_BLOCK_.footer.message}

I have been trying to read the previous posts and debug this, but not
able to get a clue as to what this error is about.
I am installing drupla for the first time and am really caught with this.

Could somebody please help.

Thanks,
Meenakshi.

⋅ Categories: Drupal 4.6.x

Comments

PMunn’s picture

PMunn commented

I was going to ask if you were using PostgreSQL, but I can see from the error you're using MySQL. I saw and patched a similar kind of error in the core and in PostgreSQL for Organic Groups.
http://drupal.org/node/21220
http://drupal.org/node/67483
Maybe that might help. But probably not.

But I do see your path says 4.6.3. I hope that's a typo, because you want to install the latest version of 4.7.3 as of this writing.

Meenakshi-1’s picture

Meenakshi-1 commented

Hi,

The 4.6.3 is not a typo. I am working on the site that is at drupal 4.6. I have been given the maintenance of this site and am trying to install a developer's version of it, hence the need for 4.6.

The database is MYSQL.

I need to fix this one with drupla 4.6 itself. Any clues?

Thanks a lot !!!
Meenakshi.

PMunn’s picture

PMunn commented

All I can suggest is to copy and paste the query into whatever interactive tool MySql gives you for testing queries. Run it from there and modify the SQL until you nail down the problem. If you don't know SQL, well, then I think you probably are in over your head doing site maintenance.