1.5 moved non-public records?

[ardiederich]

It looks like in 1.5 non-public records are now always accessed through Approve Records, rather than in 1.4 where public and non-public records could be accessed through Edit Records. Is this right?

Also, in 1.5.1 I can't search for non-public records through the admin side. Is this design, or a bug?

Thanks for the help. I really like the new look for 1.5, by the way.

--
Andrew Diederich

[Thorsten]

Hi Andrew,

It looks like in 1.5 non-public records are now always accessed through Approve Records, rather than in 1.4 where public and non-public records could be accessed through Edit Records. Is this right?

correct.

Also, in 1.5.1 I can't search for non-public records through the admin side. Is this design, or a bug?

This works for me in version 1.5.2-dev on SQLite. Which database system did you use?

Thanks for the help. I really like the new look for 1.5, by the way.

Thanks a lot!

bye
Thorsten

[ardiederich]

I'm using 1.5.1, mysql. I double-checked, and using the search on either the Approve or Edit pages searches the public FAQs and not the non-public ones.

phpMyFAQ Version
phpMyFAQ 1.5.1
Server Software
Apache/1.3.27
PHP Version
PHP 4.3.4
PHP Memory Limit
Register Globals
off
Safe Mode
off
Database Client Version
3.23.49
Database Server Version
4.0.23a-log
Webserver Interface
APACHE

--
Andrew

[Thorsten]

Hi,

could you please enable the DEBUG mode in admin/index.php and post the queries here?

It works on my testsystem with Apache2, PHP 5.0.5 and MySQL 4.1, too.

bye
Thorsten

[ardiederich]

Absolutely. Here you go:

Administration of Records
n/a

DEBUG INFORMATION:

DELETE FROM supportfaqadminsessions WHERE time < 1127409908
SELECT usr, pass FROM supportfaqadminsessions WHERE uin = '27b5e48eaabc8701ce5a2b563f0072ab'
UPDATE supportfaqadminsessions SET time = 1127411708 WHERE uin = '27b5e48eaabc8701ce5a2b563f0072ab'
SELECT id, name, realname, email, pass, rights FROM supportfaquser WHERE name = 'andrew' AND pass = '1cb60fd54ebe03bbb2d9029f6192641b'
SELECT id, lang, parent_id, name, description FROM supportfaqcategories ORDER BY id
SELECT supportfaqdata.id, supportfaqdata.lang, supportfaqcategoryrelations.category_id, supportfaqdata.thema, supportfaqdata.content FROM supportfaqdata LEFT JOIN supportfaqcategoryrelations ON supportfaqdata.id = supportfaqcategoryrelations.record_id AND supportfaqdata.lang = supportfaqcategoryrelations.record_lang WHERE MATCH (supportfaqdata.thema,supportfaqdata.content,supportfaqdata.keywords) AGAINST ('confederation*' IN BOOLEAN MODE) AND (supportfaqdata.active = 'yes')
SELECT usr, pass FROM supportfaqadminsessions WHERE uin = '27b5e48eaabc8701ce5a2b563f0072ab'

--
Andrew

[Thorsten]

Hi,

SELECT supportfaqdata.id, supportfaqdata.lang, supportfaqcategoryrelations.category_id, supportfaqdata.thema, supportfaqdata.content FROM supportfaqdata LEFT JOIN supportfaqcategoryrelations ON supportfaqdata.id = supportfaqcategoryrelations.record_id AND supportfaqdata.lang = supportfaqcategoryrelations.record_lang WHERE MATCH (supportfaqdata.thema,supportfaqdata.content,supportfaqdata.keywords) AGAINST ('confederation*' IN BOOLEAN MODE) AND (supportfaqdata.active = 'yes')

what happens if you run this query in phpMyAdmin?

bye
Thorsten

[ardiederich]

I'm an evolutionary throwback and I still use mysql on the cli. Here's the query:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18594 to server version: 4.0.23a-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT supportfaqdata.id, supportfaqdata.lang, supportfaqcategoryrelations.category_id, supportfaqdata.thema, supportfaqdata.content FROM supportfaqdata LEFT JOIN supportfaqcategoryrelations ON supportfaqdata.id = supportfaqcategoryrelations.record_id AND supportfaqdata.lang = supportfaqcategoryrelations.record_lang WHERE MATCH (supportfaqdata.thema,supportfaqdata.content,supportfaqdata.keywords) AGAINST ('confederation*' IN BOOLEAN MODE) AND (supportfaqdata.active = 'yes');
Empty set (0.00 sec)

There are rows in supportfaqdata, of course, as well as supportfaqcategoryrelations. Hmm, at some point I should go back to using the standard table names.

--
Andrew

[Thorsten]

Hi,

this query works for me. Is it possible that there's no entry with the word 'confederation'? I didn't get any result on support.jabber.org/faq/ in the public frontend....

bye
Thorsten

[ardiederich]

Hi,

this query works for me. Is it possible that there's no entry with the word 'confederation'? I didn't get any result on support.jabber.org/faq/ in the public frontend....

Ah, there we go. The query is for (supportfaqdata.active = yes'), and This FAQ isn't active. Which explains why I couldn't find it on the back end with that query, since the query only looks for active records. I think searching on the admin side shouldn't force searching through only active/public records.

--
Andrew

[Thorsten]

Hi,

you're right. Fixed for 1.5.2.

bye
Thorsten