Access Denied error in Drupal 6.19 immediately after Gallery 3 RC2 installation

dreadpirate15

Joined: 2010-08-25
Posts: 2

Posted: Wed, 2010-08-25 14:00

Hello, I installed Gallery 3 RC2 on my website yesterday. Immediately, I recieved an error and now it seems that all of my content has been locked down. I'll quote the specific error I'm getting:
Access Denied

Quote:

user warning: Unknown column 'u.picture' in 'field list' query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2 in /usr/local/pem/vhosts/234368/webspace/httpdocs/isaiahjroberts/pig/modules/node/node.module on line 755.

You are not authorized to access this page

Normally when I get Access Denied errors, it's as simple as a few mixed up permissions... But all my permissions seem to be in order. I really don't know quite where to begin in order to fix this. Also, I'm getting that precise error on EVERY page.

Here's a shortlink to a screenshot of my front page: http://cl.ly/27Pr

Here's a bit of info about my setup:
Domain.com Linux Deluxe webhosting
php5 (I tested with php4 enabled, didn't affect the situation at all)
CGI enabled
SSI enabled...
That's about all the info I have. Does anyone have any idea how I can repair this problem, or if uninstalling will help, and if so, how to uninstall?

Isaiah J Roberts
http://isaiahjroberts.com

bharat

Joined: 2002-05-21
Posts: 7994

Posted: Sun, 2010-08-29 05:13

Um, is it possible that you installed Gallery 3 in the same database as Drupal? If you did, and you didn't specify a table prefix then you may have replaced the Drupal users table with the Gallery table. If that's the case, then I hope you have a backup of your Drupal setup. You can verify this by going to your Drupal database in MySQL and try "show create table users".

Since that's most likely the problem here I suggest that you restore your Drupal database from your backups, then install Gallery either into a different database or specify a table prefix when you do the install.
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git

dreadpirate15

Joined: 2010-08-25
Posts: 2

Posted: Mon, 2010-08-30 05:26

That's kinda exactly what happened... I decided to start back over since I hadn't done too much on the site yet. I learned my lesson... First time actually working *with* databases, glad I learned this early on... I'm using prefixes and backing up slightly more often. Thanks for your help!

Isaiah J Roberts
http://isaiahjroberts.com

dreadpirate15 Joined: 2010-08-25 Posts: 2	Posted: Wed, 2010-08-25 14:00
	Hello, I installed Gallery 3 RC2 on my website yesterday. Immediately, I recieved an error and now it seems that all of my content has been locked down. I'll quote the specific error I'm getting: Access Denied Quote: user warning: Unknown column 'u.picture' in 'field list' query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2 in /usr/local/pem/vhosts/234368/webspace/httpdocs/isaiahjroberts/pig/modules/node/node.module on line 755. You are not authorized to access this page Normally when I get Access Denied errors, it's as simple as a few mixed up permissions... But all my permissions seem to be in order. I really don't know quite where to begin in order to fix this. Also, I'm getting that precise error on EVERY page. Here's a shortlink to a screenshot of my front page: http://cl.ly/27Pr Here's a bit of info about my setup: Domain.com Linux Deluxe webhosting php5 (I tested with php4 enabled, didn't affect the situation at all) CGI enabled SSI enabled... That's about all the info I have. Does anyone have any idea how I can repair this problem, or if uninstalling will help, and if so, how to uninstall? Isaiah J Roberts http://isaiahjroberts.com
	XUser login Username: * Password: * Create new account Request new password
bharat Joined: 2002-05-21 Posts: 7994	Posted: Sun, 2010-08-29 05:13
	Um, is it possible that you installed Gallery 3 in the same database as Drupal? If you did, and you didn't specify a table prefix then you may have replaced the Drupal users table with the Gallery table. If that's the case, then I hope you have a backup of your Drupal setup. You can verify this by going to your Drupal database in MySQL and try "show create table users". Since that's most likely the problem here I suggest that you restore your Drupal database from your backups, then install Gallery either into a different database or specify a table prefix when you do the install. --- Problems? Check gallery3/var/logs bugs/feature req's \| upgrade to the latest code \| use git

dreadpirate15 Joined: 2010-08-25 Posts: 2	Posted: Mon, 2010-08-30 05:26
	That's kinda exactly what happened... I decided to start back over since I hadn't done too much on the site yet. I learned my lesson... First time actually working with databases, glad I learned this early on... I'm using prefixes and backing up slightly more often. Thanks for your help! Isaiah J Roberts http://isaiahjroberts.com

Access Denied error in Drupal 6.19 immediately after Gallery 3 RC2 installation

XUser login