configuration not saving phpmyfaq 2.9 beta2

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
nallan
Posts: 7
Joined: Sat Feb 13, 2016 8:52 am

configuration not saving phpmyfaq 2.9 beta2

Post by nallan »

Hi
I've just installed phpmyfaq 2.9 beta2 to test. the install went fine, but my changes don't seem to be saving in the web interface. e.g I tried to change the phpmyfaq title, but when I click save, it just reverts to the default one of "phpMyFAQ Codename Proteus"
Is this a bug or have I don't set something up correctly?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: configuration not saving phpmyfaq 2.9 beta2

Post by Thorsten »

Hi,

please enable the DEBUG mode in inc/Bootstrap.php and try it again and check if any errors occur.

Thanks!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
nallan
Posts: 7
Joined: Sat Feb 13, 2016 8:52 am

Re: configuration not saving phpmyfaq 2.9 beta2

Post by nallan »

Hi Thorsten
It doesn't look like it produces an error, see debug log below. This is from when I enter a title into the edit box and click save.

Code: Select all

DEBUG INFORMATION:
/home/adaptiv/public_html/kb/inc/Bootstrap.php:
PMF_Configuration->getAll() in line 149:             SELECT
                config_name, config_value
            FROM
                faqconfig
/home/adaptiv/public_html/kb/inc/PMF/User/CurrentUser.php:
PMF_User->getUserByCookie() in line 522:             SELECT
                user_id,
                login,
                account_status
            FROM
                faquser
            WHERE
                remember_me = 'd35f3d6f74575469bbff824409ac2edbe7f98f86' AND account_status != 'blocked'
/home/adaptiv/public_html/kb/inc/PMF/User.php:
PMF_User_UserData->load() in line 408:             SELECT
                last_modified, 
                display_name, 
                email
            FROM
                faquserdata
            WHERE
                user_id = 1
/home/adaptiv/public_html/kb/inc/PMF/User/CurrentUser.php:
PMF_User_CurrentUser->updateSessionId() in line 529:             UPDATE
                faquser
            SET
                session_id = '0f277fb7b9d43bdf24c8ab517a69648f',
                session_timestamp = 1455367502,
                last_login = '20160213134502',
                ip = '123.456.213.21'
            WHERE
                user_id = 1
/home/adaptiv/public_html/kb/admin/index.php:
PMF_Perm_Medium->getUserGroups() in line 183:             SELECT
                fg.group_id AS group_id
            FROM
                faquser fu,
                faquser_group fug,
                faqgroup fg
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id
/home/adaptiv/public_html/kb/inc/PMF/Helper/Administration.php:
PMF_Perm_Basic->getAllRightsData() in line 142:             SELECT
                right_id,
                name,
                description,
                for_users,
                for_groups
            FROM
                faqright
            ORDER BY
                right_id ASC
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id
/home/adaptiv/public_html/kb/inc/PMF/User.php:
PMF_User_UserData->get() in line 912:             SELECT
                display_name
            FROM
                faquserdata
            WHERE
                user_id = 1
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getRightId() in line 162:             SELECT
                right_id
            FROM
                faqright
            WHERE
                name = 'editconfig'
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->checkUserGroupRight() in line 166:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fr.right_id = 17 AND
                fr.right_id = fgr.right_id AND
                fg.group_id = fgr.group_id AND
                fg.group_id = fug.group_id AND
                fu.user_id  = fug.user_id AND
                fu.user_id  = 1
/home/adaptiv/public_html/kb/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->checkUserRight() in line 166:             SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = 17 AND
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id

nallan
Posts: 7
Joined: Sat Feb 13, 2016 8:52 am

Re: configuration not saving phpmyfaq 2.9 beta2

Post by nallan »

Hi Thorsten
Further investigation indicates that it is actually saving. When you click save, it does update the database, its just the form shows the original values. If I click on the dashboard, it uses the new values and if I then go back to the config area, the new values are there.

Nick
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: configuration not saving phpmyfaq 2.9 beta2

Post by Thorsten »

Hi,

I checked it on the current pre release candidate and it looks like I already fixed it. So please wait for phpMyFAQ 2.9.0-RC which will be released the next days.

Thanks for testing!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Sh4d0wL3x
Posts: 25
Joined: Sat Jul 09, 2016 10:41 am

Re: configuration not saving phpmyfaq 2.9 beta2

Post by Sh4d0wL3x »

Hi Guys,

Sorry for picking up this thread, but i have exact the same issue ,but not only by the config-site.

VersionInfo:
System Information

phpMyFAQ Version 2.9.2
phpMyFAQ API Version 1.1
Server Software Apache
Server Document Root /var/www/vhosts/pokefans.online/httpdocs
phpMyFAQ Installation Path /var/www/vhosts/pokefans.online/httpdocs
PHP Version 5.5.9-1ubuntu4.14
Webserver Interface FPM-FCGI
PHP Extensions Core, date, ereg, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, dba, dom, hash, fileinfo, filter, ftp, gettext, SPL, iconv, mbstring, session, posix, Reflection, standard, shmop, SimpleXML, soap, sockets, Phar, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, cgi-fcgi, PDO, curl, gd, json, mysql, mysqli, pdo_mysql, pdo_sqlite, readline, sqlite3, xsl, mhash, Zend OPcache
PHP Session path /var/lib/php5
Database Server mysqli
Database Server Version 5.5.47-0ubuntu0.14.04.1
Database Client Version 5.5.47
Elasticsearch n/a
The values arre not saving, i must change everything in the datebase direct.
The same when i try to enable a user manualy. The button moves out but nothing changes. If i reload the page the same user looks like not activated.

I enabled the Debug output:
phpMyFAQ warning [2]: file_exists(): open_basedir restriction in effect. File(/var/lib/php5/sess_qtr5kgn1jrpgphd10dhlo4hig4) is not within the allowed path(s): (/var/www/vhosts/pokefans.online/:/tmp/) in /var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User/CurrentUser.php on line 348

DEBUG INFORMATION:
/var/www/vhosts/pokefans.online/httpdocs/inc/Bootstrap.php:
PMF_Configuration->getAll() in line 149:
SELECT
config_name, config_value
FROM
faqconfig

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User/CurrentUser.php:
PMF_User->getUserByCookie() in line 522:
SELECT
user_id,
login,
account_status
FROM
faquser
WHERE
remember_me = '45426fc078ba3c81e1a6b811efb18b2b17344d75' AND account_status != 'blocked'

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User.php:
PMF_User_UserData->load() in line 408:
SELECT
last_modified,
display_name,
email
FROM
faquserdata
WHERE
user_id = 1

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User/CurrentUser.php:
PMF_User_CurrentUser->updateSessionId() in line 529:
UPDATE
faquser
SET
session_id = '36c5m60r9aj9gt7hhrs5ic3g21',
session_timestamp = 1468057856,
last_login = '20160709115056',
ip = '80.108.135.120'
WHERE
user_id = 1

/var/www/vhosts/pokefans.online/httpdocs/admin/index.php:
PMF_Perm_Medium->getUserGroups() in line 183:
SELECT
fg.group_id AS group_id
FROM
faquser fu,
faquser_group fug,
faqgroup fg
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id AND
fg.group_id = fgr.group_id AND
fr.right_id = fgr.right_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Helper/Administration.php:
PMF_Perm_Basic->getAllRightsData() in line 142:
SELECT
right_id,
name,
description,
for_users,
for_groups
FROM
faqright
ORDER BY
right_id ASC

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id AND
fg.group_id = fgr.group_id AND
fr.right_id = fgr.right_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id AND
fg.group_id = fgr.group_id AND
fr.right_id = fgr.right_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id AND
fg.group_id = fgr.group_id AND
fr.right_id = fgr.right_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User.php:
PMF_User_UserData->get() in line 912:
SELECT
email
FROM
faquserdata
WHERE
user_id = 1

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User.php:
PMF_User_UserData->get() in line 912:
SELECT
display_name
FROM
faquserdata
WHERE
user_id = 1

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id AND
fg.group_id = fgr.group_id AND
fr.right_id = fgr.right_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getUserRights() in line 790:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->getUserGroupRights() in line 791:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fu.user_id = 1 AND
fu.user_id = fug.user_id AND
fg.group_id = fug.group_id AND
fg.group_id = fgr.group_id AND
fr.right_id = fgr.right_id

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->getRightId() in line 162:
SELECT
right_id
FROM
faqright
WHERE
name = 'editconfig'

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Medium->checkUserGroupRight() in line 166:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faqgroup_right fgr,
faqgroup fg,
faquser_group fug,
faquser fu
WHERE
fr.right_id = 17 AND
fr.right_id = fgr.right_id AND
fg.group_id = fgr.group_id AND
fg.group_id = fug.group_id AND
fu.user_id = fug.user_id AND
fu.user_id = 1

/var/www/vhosts/pokefans.online/httpdocs/inc/PMF/Perm/Medium.php:
PMF_Perm_Basic->checkUserRight() in line 166:
SELECT
fr.right_id AS right_id
FROM
faqright fr,
faquser_right fur,
faquser fu
WHERE
fr.right_id = 17 AND
fr.right_id = fur.right_id AND
fu.user_id = 1 AND
fu.user_id = fur.user_id
My Problem is, im live with over 200 viewers in the first day, so i cant work only with the database ^^

Br Lex
Sh4d0wL3x
Posts: 25
Joined: Sat Jul 09, 2016 10:41 am

Re: configuration not saving phpmyfaq 2.9 beta2

Post by Sh4d0wL3x »

Tested on a 2nd Server with oder Config.

Same problems.
System Information

phpMyFAQ Version 2.9.2
phpMyFAQ API Version 1.1
Server Software nginx/1.2.1
Server Document Root /home/vhosts/pokefans.online/httpdocs
phpMyFAQ Installation Path /home/vhosts/pokefans.online/httpdocs
PHP Version 5.6.16-1~dotdeb+7.1
Webserver Interface FPM-FCGI
PHP Extensions Core, date, ereg, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, dba, dom, hash, fileinfo, filter, ftp, gettext, SPL, iconv, json, mbstring, session, posix, Reflection, standard, shmop, SimpleXML, soap, sockets, Phar, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, cgi-fcgi, PDO, curl, gd, imagick, imap, intl, mcrypt, memcache, mysql, mysqli, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, pspell, recode, snmp, sqlite3, tidy, xmlrpc, xsl, mhash, Zend OPcache
PHP Session path /var/lib/php5/sessions
Database Server mysqli
Database Server Version 5.5.37-0+wheezy1-log
Database Client Version 5.5.46
Elasticsearch n/a
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: configuration not saving phpmyfaq 2.9 beta2

Post by Thorsten »

Hi,

your session configuration is broken due to wrong open_basedir restrictions:
phpMyFAQ warning [2]: file_exists(): open_basedir restriction in effect. File(/var/lib/php5/sess_qtr5kgn1jrpgphd10dhlo4hig4) is not within the allowed path(s): (/var/www/vhosts/pokefans.online/:/tmp/) in /var/www/vhosts/pokefans.online/httpdocs/inc/PMF/User/CurrentUser.php on line 348
Fix it and it will work.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply