problem with the upgrade to version 3.0.2

Please report bugs here!

Moderator: Thorsten

Post Reply
blondin62
Posts: 34
Joined: Sun Mar 11, 2018 11:06 am

problem with the upgrade to version 3.0.2

Post by blondin62 » Fri Apr 24, 2020 6:17 pm

Hi

I have a problem with the upgrade to version 3.0.2
I am currently using version 3.0.1 and in particular the function
"show on the home page" (with a photo) for my most important categories and everything worked perfectly
but with the upgrade it no longer works

(my database was upgraded too by using the update.php program)

I have enabled debug mode but I don't see any error message

i made a mistake ?

C:\wamp64\www\phpmyfaq\src\Bootstrap.php:
phpMyFAQ\Configuration->getAll() in line 140: SELECT config_name, config_value FROM faqconfig
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User->getUserById() in line 492: SELECT user_id, login, account_status, is_superadmin FROM faquser WHERE user_id = 1 AND account_status != 'blocked'
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User.php:
phpMyFAQ\User\UserData->load() in line 919: SELECT last_modified, display_name, email FROM faquserdata WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User\CurrentUser->getSessionInfo() in line 502: SELECT session_id, session_timestamp, ip, success FROM faquser WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User\CurrentUser.php:
phpMyFAQ\User\CurrentUser->updateSessionId() in line 516: UPDATE faquser SET session_id = 'k9118leu8nb7tika5io6468d8q', session_timestamp = 1587748365, ip = '192.168.0.141' WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\Session.php:
phpMyFAQ\Database\Mysqli->nextId() in line 96: SELECT MAX(sid) AS current_id FROM faqsessions
C:\wamp64\www\phpmyfaq\index.php:
phpMyFAQ\Session->userTracking() in line 235: INSERT INTO faqsessions (sid, user_id, ip, time) VALUES (5084, 1, '192.168.0.141', 1587748365)
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\Category.php:
phpMyFAQ\Category->getOrderedCategories() in line 141: 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, fc.group_id AS group_id, fc.active AS active, fc.image AS image, fc.show_home AS show_home 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 WHERE ( fg.group_id IN (-1) OR (fu.user_id = -1 AND fg.group_id IN (-1))) AND fc.active = 1 AND fc.lang = 'fr' GROUP BY fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id, fc.group_id, fc.active, fc.image, fc.show_home ORDER BY fc.parent_id, fc.id
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User.php:
phpMyFAQ\User\UserData->get() in line 937: SELECT display_name FROM faquserdata WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\Helper\CategoryHelper.php:
phpMyFAQ\Category\CategoryRelation->getNumberOfFaqsPerCategory() in line 44: SELECT fcr.category_id AS category_id, COUNT(fcr.record_id) AS number FROM faqcategoryrelations fcr, faqdata fd WHERE fcr.record_id = fd.id AND fcr.record_lang = fd.lang GROUP BY fcr.category_id
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User.php:
phpMyFAQ\User\UserData->get() in line 937: SELECT display_name FROM faquserdata WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\Helper\CategoryHelper.php:
phpMyFAQ\Category\CategoryRelation->getNumberOfFaqsPerCategory() in line 44: SELECT fcr.category_id AS category_id, COUNT(fcr.record_id) AS number FROM faqcategoryrelations fcr, faqdata fd WHERE fcr.record_id = fd.id AND fcr.record_lang = fd.lang GROUP BY fcr.category_id
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\Permission\BasicPermission.php:
phpMyFAQ\User->getUserById() in line 149: SELECT user_id, login, account_status, is_superadmin FROM faquser WHERE user_id = 1 AND account_status != 'blocked'
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User.php:
phpMyFAQ\User\UserData->load() in line 919: SELECT last_modified, display_name, email FROM faquserdata WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\User.php:
phpMyFAQ\User\UserData->get() in line 937: SELECT display_name FROM faquserdata WHERE user_id = 1
C:\wamp64\www\phpmyfaq\src\phpMyFAQ\Tags.php:
phpMyFAQ\Tags->getAllTags() in line 405: SELECT MIN(t.tagging_id) AS tagging_id, t.tagging_name AS tagging_name FROM faqtags t LEFT JOIN faqdata_tags dt ON dt.tagging_id = t.tagging_id LEFT JOIN faqdata d ON d.id = dt.record_id WHERE 1=1 AND d.active = 'yes' GROUP BY tagging_name ORDER BY tagging_name ASC
C:\wamp64\www\phpmyfaq\index.php:
phpMyFAQ\Faq->getRecordsWithoutPagingByCategoryId() in line 675: SELECT fd.id AS id, fd.lang AS lang, fd.thema AS thema, fcr.category_id AS category_id, fv.visits AS visits FROM faqdata fd LEFT JOIN faqcategoryrelations fcr ON fd.id = fcr.record_id AND fd.lang = fcr.record_lang LEFT JOIN faqvisits fv ON fd.id = fv.id AND fv.lang = fd.lang LEFT JOIN faqdata_group fdg ON fd.id = fdg.record_id LEFT JOIN faqdata_user fdu ON fd.id = fdu.record_id WHERE fd.date_start <= '20200424191245' AND fd.date_end >= '20200424191245' AND fd.active = 'yes' AND fcr.category_id = 0 AND fd.lang = 'fr' AND ( fdu.user_id = 1 OR fdu.user_id = -1 ) GROUP BY fd.id,fd.lang,fcr.category_id,fv.visits ORDER BY thema DESC

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

Re: problem with the upgrade to version 3.0.2

Post by Thorsten » Sat Apr 25, 2020 8:02 pm

Hi,

yes, unfortunately we added a bug here in 3.0.2, we're working on a fast 3.0.3 release.

Here's the fix: https://github.com/thorsten/phpMyFAQ/co ... b6fbd0e3e9

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply