access and permissions

[asphyxiia]

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?

[Joachim Müller]

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.

[asphyxiia]

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

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?action=search2;search=Unknown%20column%20user_location

[asphyxiia]

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

[Nibbler]

This thread didn't help ?

http://forum.coppermine-gallery.net/index.php?topic=23127.0

[asphyxiia]

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

[Joachim Müller]

Read the thread Nibbler has refered to.

[asphyxiia]

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

[asphyxiia]

I dont understand exactly what it is im supposed to do...

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