coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Permissions & Access Rights => Topic started by: asphyxiia on December 09, 2005, 12:36:58 AM

Title: access and permissions
Post by: asphyxiia on December 09, 2005, 12:36:58 AM
ALMOST got my gallery working perfectly :) yayaya

slowly getting each error solved thanks to you guys ;)

ok i get this error below when i log into my admin account but i can still access everything so this one is no biggie
Error
You don't have permission to access this page.



However when a new user tried to register this is the error they recieve
Critical error
There was an error while processing a database query 


any ideas?
Title: Re: access and permissions
Post by: Joachim Müller on December 09, 2005, 08:09:16 AM
enable debug_mode for everyone in coppermine's config, then reproduce the error and post the actual error message (not the debug output). A link might help as well.
Title: Re: access and permissions
Post by: asphyxiia on December 10, 2005, 03:55:49 AM
Thankyou

here is the link
http://asphyxiia.com/pics/

and enabled debug mode
here is error message :)

Critical error

There was an error while processing a database query.


While executing query "INSERT INTO cpg_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_location, user_interests, user_website, user_occupation) VALUES (NOW(), 'NO', '7b786b9d653a635fe27e4b00db1db372', 'Mystrice', 'lXXXXX', 'pyrogenetic@hotmail.com', '', '', '', '' )" on 0

mySQL error: Unknown column 'user_location' in 'field list'



File: /data/home/asphyxii/public_html/pics/include/functions.inc.php - Line: 105


Title: Re: access and permissions
Post by: Joachim Müller on December 10, 2005, 12:45:53 PM
http://forum.coppermine-gallery.net/index.php?action=search2;search=Unknown%20column%20user_location
Title: Re: access and permissions
Post by: asphyxiia on December 12, 2005, 07:53:03 AM
okies i read your thread link and nothing there has helped  :(

Anyone suggest any ideas on how i can get my users to be able to register ;) yayaya
Title: Re: access and permissions
Post by: Nibbler on December 12, 2005, 11:15:34 AM
This thread didn't help ?

http://forum.coppermine-gallery.net/index.php?topic=23127.0
Title: Re: access and permissions
Post by: asphyxiia on December 13, 2005, 02:06:03 AM
well i didnt downgrade, i upgraded.

i guess i can try it... where do i find that code i have to change?

they get the form to fill out, the location and website fields are there unlike the person in this thread. its just when they hit the final button at the bottom to register they get this message

Critical error

There was an error while processing a database query.


While executing query "INSERT INTO cpg_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_location, user_interests, user_website, user_occupation) VALUES (NOW(), 'NO', '7b786b9d653a635fe27e4b00db1db372', 'Mystrice', 'lXXXXX', 'pyrogenetic@hotmail.com', '', '', '', '' )" on 0

mySQL error: Unknown column 'user_location' in 'field list'



File: /data/home/asphyxii/public_html/pics/include/functions.inc.php - Line: 105


is it in the functions.inc.php??

ack im so confused.. i dont even think i know what im talking about /laugh
Title: Re: access and permissions
Post by: Joachim Müller on December 13, 2005, 08:28:09 AM
Read the thread Nibbler has refered to.
Title: Re: access and permissions
Post by: asphyxiia on December 17, 2005, 12:47:50 AM
that thread didnt make any sense to me :) i dont know where to find that file that im supposed to change or what its even called.

that thread also suggests that that person downgraded from on version to another.. i didnt do that am i still supposed to change some code in some file??

thanks

need to tell me in lamans terms i really have no clue and am learning through you guys' patience and guidance
Title: Re: access and permissions
Post by: asphyxiia on December 22, 2005, 12:48:49 AM
I dont understand exactly what it is im supposed to do...

and to what file or where it is.. can you please tell me?