version 2.0.1 Admin error

samtheman · Post by **samtheman** » Mon Jun 04, 2007 11:31 am

I have just installed the new phpmyfaq 2.0.1 version and followed the instrutions to a tee, but when i log into the admin section (it lets me in fine) but if i click on any option within admin it takes me back to the login screen?

can anyone shed any light on this please?

thanks
Sam

calvin65 · Post by **calvin65** » Mon Jun 04, 2007 12:35 pm

At first it sounds like it is the same problem I described here:
viewtopic.php?t=4758
much longer and in german.

Post by **Thorsten** » Mon Jun 04, 2007 2:27 pm

Hi,

can you please enable the debug mode in inc/Init.php and post the queries here?

bye
Thorsten

samtheman · Post by **samtheman** » Mon Jun 04, 2007 4:41 pm

this is results from the inc/Init.php file

System Information
phpMyFAQ Version phpMyFAQ 2.0.1
Server Software Apache
PHP Version PHP 4.3.4
Register Globals on
Safe Mode off
Open Basedir off
Database Server Mysql
Database Client Version 4.0.18
Database Server Version 4.0.15-max-log
Webserver Interface APACHE2HANDLER
PHP Extensions xml, tokenizer, standard, posix, pcre, overload, openssl, apache2handler, odbc, snmp, qtdom, pgsql, mysql, mhash, mcrypt, mcal, gmp, gd, xslt, ctype, calendar, bz2, domxml, readline, mbstring, ldap, gettext, bcmath, wddx, zlib, exif, imap, session
NOTE: Art is resistance. Thank you very much for inspiration and everything else, L.
DEBUG INFORMATION:
pmf_currentuser->getuserbylogin() in line 146:
SELECT
user_id,
login,
account_status
FROM
sabfaquser
WHERE
login = 'admin'

pmf_userdata->load() in line 373:
SELECT
last_modified, display_name, email
FROM
sabfaquserdata
WHERE
user_id = 1
pmf_currentuser->updatesessionid() in line 150:
UPDATE
sabfaquser
SET
session_id = 'bdeeb73da47f13c294fa232d8bbc709a',
session_timestamp = 1180972723,
last_login = '20070604165843',
ip = '149.XXX.XXX.XX' (ive changed this!)
WHERE
user_id = 1
pmf_currentuser->login() in line 89:
UPDATE
sabfaquser
SET
auth_source = 'local'
WHERE
user_id = 1
pmf_permbasic->getallrightsdata() in line 122:
SELECT
right_id,
name,
description,
for_users,
for_groups
FROM
sabfaqright
ORDER BY
right_id ASC
pmf_permbasic->getuserrights() in line 309:
SELECT
sabfaqright.right_id AS right_id
FROM
sabfaqright,
sabfaquser_right,
sabfaquser
WHERE
sabfaqright.right_id = sabfaquser_right.right_id AND
sabfaquser.user_id = 1 AND
sabfaquser.user_id = sabfaquser_right.user_id

db_mysql->gettablestatus() in line 269:
SHOW TABLE STATUS

COOKIES:
pmf_auth_: 4e744fd74ac57881d9464a5aca46bed9
pmf_lang: en
pmf_sid: 3
__utma: 234317570.1809080732.1180518439.1180951685.1180956932.14
__utmz: 234317570.1180944946.11.2.utmccn=(organic)|utmcsr=search|utmctr=fraud courses|utmcmd=organic
__utmc: 234317570

Post by **Thorsten** » Mon Jun 04, 2007 7:38 pm

Hi,

hm, could you please send me your FAQ database by e-mail?

bye
Thorsten

samtheman · Post by **samtheman** » Tue Jun 05, 2007 4:51 pm

hi there thorsten

i have emailed you my faq databse, could ypu reply via mail or on this forum what I am doing wrong please.

Kind Regards
Sam

Post by **Thorsten** » Tue Jun 05, 2007 5:26 pm

Hi,

I received your mail.

bye
Thorsten

calvin65 · Post by **calvin65** » Thu Jun 07, 2007 4:27 pm

Please reply in the forum - I have the same problem.

Activity1 · Post by **Activity1** » Thu Jun 07, 2007 5:03 pm

I have the probleme too

GruÃŸ
Christof

Post by **Thorsten** » Thu Jun 07, 2007 5:06 pm

Hi,

please post your PHP version, your database type, the database version and the operating system here. If possible, post a phpinfo() output here.

bye
Thorsten

Activity1 · Post by **Activity1** » Thu Jun 07, 2007 5:27 pm

here is a link to my phpinfo

http://www.cs-technische-software.de/temp/test.php

GruÃŸ
Christof

Post by **Thorsten** » Thu Jun 07, 2007 5:48 pm

Hi,

can your PHP write session files into the temp directory? Please disable the STRICT MODE for running phpMyFAQ because we don't support STRICT MODE. Do you get any errors when you enabled the DEBUG MODE in inc/Init.php.

bye
Thorsten

samtheman · Post by **samtheman** » Fri Jun 08, 2007 4:11 pm

has anyone been able to get this admin error sorted? it would be great if someone can post clear instructions on how to do this please.

also is it possibe thorsten if you cold tell me how to disable strict mode? which file is it in and what do i cahnge please?

also do we have to create a temp directory too? where does this reside within the file structure please?

many thanks
Sam

Post by **Thorsten** » Fri Jun 08, 2007 4:21 pm

Hi Sam,

you have to disable the STRICT MODE in your php.ini file. I would recommend that you update PHP to the 4.4.7 or 5.2.3 because your PHP 4.3.4 is really old. The temporary directory is found on /tmp on Linux/Unix systems.

bye
Thorsten

calvin65 · Post by **calvin65** » Mon Jun 11, 2007 12:14 pm

Hello Thorsten,

You say that STRICT MODE stands in the php.ini file. I can't find it there.

Please can you tell how these function is correctly named or what I must add? I use PHP Version 5.2.2.

Thank you.
Calvin

phpMyFAQ