Suche im Adminbereich

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
Andy
Posts: 87
Joined: Fri Mar 07, 2003 10:58 am

Suche im Adminbereich

Post by Andy »

Im Adminbereich beim editieren vorhandener Einträge funktioniert bei mit (phpMyFAQ 2.01.) die Suchfunktion nicht

Wenn ich nach den gleichen Begriffen in der normalen Oberfläche für die Anwender suche, klappt es.
Thorsten
Posts: 15724
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

was passiert denn? Fehlermeldungen?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Andy
Posts: 87
Joined: Fri Mar 07, 2003 10:58 am

Post by Andy »

Keine Fehlermeldung. Lediglich kein Ergebnis.

Hier die ausgabe mit Debug modus
Es wurde kein Eintrag gefunden.
DEBUG INFORMATION:
PMF_Configuration->getAll() in line 87:

SELECT
config_name, config_value
FROM
faqconfig


PMF_User->getUserById() in line 416:

SELECT
user_id,
login,
account_status
FROM
faquser
WHERE
user_id = 1


PMF_User->getUserById() in line 416:

SELECT
pass
FROM
faquserlogin
WHERE
login = 'admin'


PMF_UserData->load() in line 331:

SELECT
last_modified, display_name, email
FROM
faquserdata
WHERE
user_id = 1


PMF_CurrentUser->getSessionInfo() in line 423:

SELECT
session_id,
session_timestamp,
ip
FROM
faquser
WHERE
user_id = 1


PMF_PermBasic->getAllRightsData() in line 122:

SELECT
right_id,
name,
description,
for_users,
for_groups
FROM
faqright
ORDER BY
right_id ASC


PMF_PermBasic->getUserRights() in line 746:

SELECT
faqright.right_id AS right_id
FROM
faqright,
faquser_right,
faquser
WHERE
faqright.right_id = faquser_right.right_id AND
faquser.user_id = 1 AND
faquser.user_id = faquser_right.user_id



PMF_PermMedium->getUserGroupRights() in line 747:

SELECT
faqright.right_id AS right_id
FROM
faqright,
faqgroup_right,
faqgroup,
faquser_group,
faquser
WHERE
faquser.user_id = 1 AND
faquser.user_id = faquser_group.user_id AND
faqgroup.group_id = faquser_group.group_id AND
faqgroup.group_id = faqgroup_right.group_id AND
faqright.right_id = faqgroup_right.right_id



PMF_PermMedium->getUserGroups() in line 149:

SELECT
faqgroup.group_id AS group_id
FROM
faquser,
faquser_group,
faqgroup
WHERE
faquser.user_id = 1 AND
faquser.user_id = faquser_group.user_id AND
faqgroup.group_id = faquser_group.group_id



PMF_Category->getOrderedCategories() in line 150:

SELECT
fc.id AS id,
fc.lang AS lang,
fc.parent_id AS parent_id,
fc.name AS name,
fc.description AS description,
fc.user_id AS user_id
FROM
faqcategories fc
LEFT JOIN
faqcategory_group fg
ON
fc.id = fg.category_id
LEFT JOIN
faqcategory_user fu
ON
fc.id = fu.category_id
GROUP BY
id
ORDER BY
id


PMF_Linkverifier->loadConfigurationFromDB() in line 152:

SELECT type, url, reason FROM faqlinkverifyrules WHERE enabled = 'y'


PMF_Comment->getNumberOfComments() in line 128:

SELECT
COUNT(id) AS anz,
id
FROM
faqcomments
GROUP BY id
ORDER BY id


db_mysql->search() in line 189:

SELECT faqdata.id AS id, faqdata.lang AS lang, faqcategoryrelations.category_id AS category_id, faqdata.thema AS thema, faqdata.content AS content FROM faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE MATCH (faqdata.thema,faqdata.content,faqdata.keywords) AGAINST ('kobil' IN BOOLEAN MODE) ORDER BY faqcategoryrelations.category_id, faqdata.id


COOKIES:
pmf_lang: de
pmf_sid: 1913
pmf_auth_15965e0e4172f906776e76a0c51f730e: qc4972nc7bua4416kofl37b7u7

TABLES & RECORDS:
faqadminlog: 1686
faqcaptcha: 36
faqcategories: 35
faqcategory_group: 35
faqcategory_user: 35
faqcategoryrelations: 252
faqchanges: 548
faqcomments: 0
faqconfig: 33
faqdata: 252
faqdata_group: 251
faqdata_revisions: 4
faqdata_tags: 0
faqdata_user: 251
faqdataold: 99
faqfragenold: 0
faqglossary: 0
faqgroup: 1
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 1
faqquestions: 0
faqright: 29
faqsessions: 1913
faqtags: 0
faquser: 6
faquser_group: 1
faquser_right: 73
faquserdata: 6
faquserlogin: 6
faqvisits: 251
faqvoting: 23
mbusche
Posts: 3
Joined: Wed May 23, 2007 7:46 am
Contact:

Re: Suche im Adminbereich

Post by mbusche »

Moin Andy,
Andy wrote:Im Adminbereich beim editieren vorhandener Einträge funktioniert bei mit (phpMyFAQ 2.01.) die Suchfunktion nicht

Wenn ich nach den gleichen Begriffen in der normalen Oberfläche für die Anwender suche, klappt es.
Du stehst nicht ganz alleine da, ich habe das gleiche Problem. Hast Du vielleicht zwischenzeitlich eine Lösung gefunden?

Gruß,

Markus
Gruß,

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

Post by Thorsten »

Hi,

bitte tragt das doch in den Bugtracker auf http://bugs.phpmyfaq.de ein, danke!

Sobald ich wieder etwas mehr Zeit habe, schaue ich mir das an.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Andy
Posts: 87
Joined: Fri Mar 07, 2003 10:58 am

Post by Andy »

OK, Eintrag ist angelegt unter der ID #1445
Thorsten
Posts: 15724
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

zu spät, der Bug ist seit gestern schon gefixt, den gab es schon.

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