|
aarif ahmed
|
Thursday 24 June 2004 10:08:31 am
Can someone please help me I have screwed up my site. I am getting above error when I access the user site and when I try admin site using admin/publish i get loop back to login page. I have verified my database settings are correct I can login to database from mysql command line, I dont have (_)underscore in my host name. I did try to upload data from my test site to this site and mysql upload didnt throw any errors but problem started afterwards, is there any place in db I can verify the user/name passwd are correct. Please help . I will appreciate any docs advice.
Thanks
|
|
Björn Dieding@xrow.de
|
Thursday 24 June 2004 10:57:19 am
frist turn on debugging, see what happens if the pass is messed up do this go to the ezuser table in db and find admin row
set flag for plain password
enter a plain password in the password field
Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/
|
|
aarif ahmed
|
Thursday 24 June 2004 11:42:28 pm
Hi thanks for your help, here is the output of debug, i see many db errors but have no idea how to fix them. i 'd really appreciate any help. thanks a lot
Query error: Unknown column 'user_id' in 'field list'. Query: SELECT data, user_id FROM ezsession WHERE session_key='23a39752ec38257d70a5c9907f8e0fe2'
Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Jun 25 2004 01:38:00
SELECT data, user_id FROM ezsession WHERE session_key='23a39752ec38257d70a5c9907f8e0fe2'
Warning: PHP Jun 25 2004 01:38:00
Undefined index: user_id in /hsphere/local/home/gbock/politicsofhealth.org/lib/ezutils/classes/ezsession.php on line 63
Timing: Jun 25 2004 01:38:00
Module start 'content'
Error: eZMySQLDB Jun 25 2004 01:38:00
Query error: Unknown column 'ezuser_role.limit_identifier' in 'field list'. Query: SELECT DISTINCT ezrole.id,
ezrole.name,
ezuser_role.limit_identifier,
ezuser_role.limit_value
FROM ezrole,
ezuser_role
WHERE ezuser_role.contentobject_id IN ( 42,4,10 ) AND
ezuser_role.role_id = ezrole.id
Notice: eZMySQLDB::query(0.000 ms) query number per page:1 Jun 25 2004 01:38:00
SELECT DISTINCT ezrole.id,
ezrole.name,
ezuser_role.limit_identifier,
ezuser_role.limit_value
FROM ezrole,
ezuser_role
WHERE ezuser_role.contentobject_id IN ( 42,4,10 ) AND
ezuser_role.role_id = ezrole.id
Warning: PHP Jun 25 2004 01:38:00
Invalid argument supplied for foreach() in /hsphere/local/home/gbock/politicsofhealth.org/kernel/classes/ezrole.php on line 371
Warning: Insufficient permissions Jun 25 2004 01:38:00
Function required:
Module : user
Function : login
ClassID :
MainNodeID :
Policies that didn't match:
Timing: Jun 25 2004 01:38:00
Module end 'error'
Error: eZMySQLDB Jun 25 2004 01:38:00
Query error: Unknown column 'ezuser_role.limit_identifier' in 'field list'. Query: SELECT DISTINCT ezrole.id,
ezrole.name,
ezuser_role.limit_identifier,
ezuser_role.limit_value
FROM ezrole,
ezuser_role
WHERE ezuser_role.contentobject_id IN ( 42,4,10 ) AND
ezuser_role.role_id = ezrole.id
|