Can't create categories

Please report bugs here!

Moderator: Thorsten

Post Reply
bavade
Posts: 10
Joined: Fri Feb 28, 2014 5:48 pm

Can't create categories

Post by bavade »

Hello all,

I've got a very strange issue; I just set up a new PhpMyFaq installation on a very simple LAMP server (it's in a test environment).
Everything was working (few issues with permissions, but it's sorted out now), but I noticed I can't create Categories ; When I go to Admin > Content > Categories > Add A Category, I can fill in the fields, then I click on "Add a category", no errors message... but no category too ! Nothing appears in the Category Overview.

When I try to create an article, the "Categories" field is empty, as if no category has been created. Ditto on the main page. No categories... But there's something strange: I connected to my MySQL server in order to check if (at least) categories were created on my database, then SELECT * FROM faq_categories... surprise ! All the categories I created are there. But why do they not appear on the website, nowhere ?

It's not a permission issue (Firstly because I tried to create it with chmod 0777 on all folders, secondly categories wouldn't be in the MySQL database if it was a permission issue), not a java issue (I got the latest version), not a browser issue (tried with Chrome & Mozilla), I have no idea what could cause this issue.

Few more details ; I also noticed that I can create an article, but I can't delete it (the trash button doesn't work), and I cannot click on the "Save" button on the translation editor. It's as if java buttons doesn't work. Dunno why.

Many thanks for your help in advance :)
Thorsten
Posts: 15561
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can't create categories

Post by Thorsten »

Hi,

first, we don't use any Java. ;)

Can I get access to your FAQ to check your issues as I cannot reproduce your errors?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
bavade
Posts: 10
Joined: Fri Feb 28, 2014 5:48 pm

Re: Can't create categories

Post by bavade »

Hi Thorsten,

Sure, I'll be pleased :)

Only one problem, it's not accessible via internet (as said in my first post, it's only in a test environment). How could you access ? It would be too long to get it accessible via HTTP on internet.

Many thanks for your help ! :)
Thorsten
Posts: 15561
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can't create categories

Post by Thorsten »

Hi,

maybe you can create a screencast with http://www.screenr.com/

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
bavade
Posts: 10
Joined: Fri Feb 28, 2014 5:48 pm

Re: Can't create categories

Post by bavade »

Hi Thorsten,

I sent you a PM with the link for the Screenr. Many thanks for your help :)
Thorsten
Posts: 15561
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can't create categories

Post by Thorsten »

Hi,

tried to reproduce your bug and it works for me. What PHP version, which database version and which browser do you use?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
bavade
Posts: 10
Joined: Fri Feb 28, 2014 5:48 pm

Re: Can't create categories

Post by bavade »

Hi Thorsten,

I run on an : Apache 2.0 Handler
PHP Version 5.3.28
MySQL Version : 5.0.95
MySQLi plugin version : 5.0.95

Tests was made with browser Google Chrome Version 33.0.1750.117 m
And Firefox 27.0.1

Thanks again for your help :)
Thorsten
Posts: 15561
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can't create categories

Post by Thorsten »

Hi,

looks good. As I saw on your screen cast the categories are saved in the database, but every second fetch from the DB returns obviously nothing... maybe a strange timing issues?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
bavade
Posts: 10
Joined: Fri Feb 28, 2014 5:48 pm

Re: Can't create categories

Post by bavade »

Yes, indeed :(

Tried to update at 5.4.25 PHP version, still the same :(

Do you see any mistake in the following :
phpMyFAQ Version --- 2.8.7
Server Software --- Apache/2.2.23 (CentOS)
Server Document root --- /var/www/html
phpMyFAQ installation path --- /var/www/html/faq
PHP Version --- 5.4.25
Webserver Interface ---APACHE2HANDLER

PHP Extensions --- Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imap, json, ldap, exif, mysql, mysqli, odbc, PDO, pdo_mysql, PDO_ODBC, pdo_sqlite, Phar, shmop, SimpleXML, sockets, tokenizer, xml, wddx, xmlreader, xmlrpc, xmlwriter, xsl, zip, mhash

PHP Session path --- /var/lib/php/session
Database Server --- mysql
Database Server Version --- 5.0.95
Database Client Version --- 5.0.95
Thorsten
Posts: 15561
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can't create categories

Post by Thorsten »

Hi,

could you please enable the debug mode in inc/Bootstrap.php and try it again? Maybe some errors were thrown...

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
melpheos
Posts: 15
Joined: Thu Feb 27, 2014 3:07 pm

Re: Can't create categories

Post by melpheos »

Looks like the same issue as mine but slightly different
viewtopic.php?f=3&t=16325
bavade
Posts: 10
Joined: Fri Feb 28, 2014 5:48 pm

Re: Can't create categories

Post by bavade »

Hi,

Yes, I got the same problems ! When I create more than one category, everything starts to stop working. I even got a blank page, sometimes. No errors in apache logs.

Thorsten : Sorry for delay. Therefore, I did all the thing you told on the other thread, here what's I do get :

Code: Select all

#0 PMF_DB_Mysqli->fetchArray() called at [/var/www/html/faq/inc/PMF/Category.php:226] #1 PMF_Category->getOrderedCategories(1) called at [/var/www/html/faq/inc/PMF/Category.php:141] #2 PMF_Category->__construct(PMF_Configuration Object ([] => faqconfig,[config] => Array ([core.database] => PMF_DB_Mysqli Object ([] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[error_list] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[stat] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[] => /var/www/html/faq/inc/Bootstrap.php:
PMF_Configuration->getAll() in line 139: SELECT config_name, config_value FROM faq_faqconfig
/var/www/html/faq/inc/PMF/User/CurrentUser.php:
PMF_User->getUserById() in line 436: SELECT user_id, login, account_status FROM faq_faquser WHERE user_id = 1
/var/www/html/faq/inc/PMF/User/CurrentUser.php:
PMF_User->getUserById() in line 436: SELECT pass FROM faq_faquserlogin WHERE login = 'admin'
/var/www/html/faq/inc/PMF/User.php:
PMF_User_UserData->load() in line 305: SELECT last_modified, display_name, email FROM faq_faquserdata WHERE user_id = 1
/var/www/html/faq/inc/PMF/User/CurrentUser.php:
PMF_User_CurrentUser->getSessionInfo() in line 445: SELECT session_id, session_timestamp, ip FROM faq_faquser WHERE user_id = 1
/var/www/html/faq/index.php:
PMF_Perm_Basic->getAllRightsData() in line 151: SELECT right_id, name, description, for_users, for_groups FROM faq_faqright ORDER BY right_id ASC
/var/www/html/faq/inc/PMF/Perm/Basic.php:
PMF_Perm_Basic->getUserRights() in line 274: SELECT fr.right_id AS right_id FROM faq_faqright fr, faq_faquser_right fur, faq_faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = 1 AND fu.user_id = fur.user_id
/var/www/html/faq/index.php:
PMF_Session->checkSessionId() in line 224: SELECT sid FROM faq_faqsessions WHERE sid = 1 AND ip = '192.168.1.21' AND time > 1394132785
/var/www/html/faq/index.php:
PMF_Session->checkSessionId() in line 224: UPDATE faq_faqsessions SET time = 1394219185, user_id = 1 WHERE sid = 1 AND ip = '192.168.1.21'
/var/www/html/faq/inc/PMF/Category.php:
PMF_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 FROM faq_faqcategories fc LEFT JOIN faq_faqcategory_group fg ON fc.id = fg.category_id LEFT JOIN faq_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.lang = 'fr' GROUP BY fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id ORDER BY fc.id
Can't create/write to file '/tmp/#sql_f11_0.MYI' (Errcode: 13),[tableNames] => Array ()),[main.currentVersion] => 2.8.7,[main.currentApiVersion] => 1,[main.language] => language_fr.php,[main.languageDetection] => true,[main.phpMyFAQToken] => e064000830b3c35275a0014c68a5f691,[main.referenceURL] => http://192.168.1.199/faq,[main.administrationMail] => google,[main.contactInformations] => ,[main.enableAdminLog] => true,[main.enableRewriteRules] => false,[main.enableUserTracking] => true,[main.metaDescription] => phpMyFAQ should be the answer for all questions in life,[main.metaKeywords] => ,[main.metaPublisher] => Google,[main.send2friendText] => ,[main.titleFAQ] => phpMyFAQ Codename Perdita,[main.urlValidateInterval] => 86400,[main.enableWysiwygEditor] => true,[main.enableWysiwygEditorFrontend] => false,[main.templateSet] => default,[main.optionalMailAddress] => false,[main.dateFormat] => Y-m-d H:i,[main.maintenanceMode] => false,[main.enableGravatarSupport] => false,[records.numberOfRecordsPerPage] => 10,[records.numberOfShownNewsEntries] => 3,[records.defaultActivation] => false,[records.defaultAllowComments] => false,[records.enableVisibilityQuestions] => false,[records.numberOfRelatedArticles] => 5,[records.orderby] => id,[records.sortby] => DESC,[records.orderingPopularFaqs] => visits,[records.disableAttachments] => true,[records.maxAttachmentSize] => 100000,[records.attachmentsPath] => attachments,[records.attachmentsStorageType] => 0,[records.enableAttachmentEncryption] => false,[records.defaultAttachmentEncKey] => ,[records.enableCloseQuestion] => false,[records.enableDeleteQuestion] => false,[records.autosaveActive] => false,[records.autosaveSecs] => 180,[records.randomSort] => false,[search.useAjaxSearchOnStartpage] => false,[search.numberSearchTerms] => 10,[search.relevance] => thema,content,keywords,[search.enableRelevance] => false,[security.permLevel] => basic,[security.ipCheck] => false,[security.enableLoginOnly] => false,[security.ldapSupport] => false,[security.bannedIPs] => ,[security.ssoSupport] => false,[security.ssoLogoutRedirect] => ,[security.useSslForLogins] => false,[security.useSslOnly] => false,[security.forcePasswordUpdate] => false,[spam.checkBannedWords] => true,[spam.enableCaptchaCode] => true,[spam.enableSafeEmail] => true,[socialnetworks.enableTwitterSupport] => false,[socialnetworks.twitterConsumerKey] => ,[socialnetworks.twitterConsumerSecret] => ,[socialnetworks.twitterAccessTokenKey] => ,[socialnetworks.twitterAccessTokenSecret] => ,[socialnetworks.enableFacebookSupport] => false,[cache.varnishEnable] => false,[cache.varnishHost] => 127.0.0.1,[cache.varnishPort] => 2000,[cache.varnishSecret] => ,[cache.varnishTimeout] => 500,[security.salt] => f934450658a0fda5229df4f2af50ec38,[core.language] => PMF_Language Object ([acceptedLanguage] => fr,[] => PMF_Configuration Object ( *RECURSION*))), Array ([0] => -1), 1) called at [/var/www/html/faq/index.php:275] 
Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/html/faq/inc/PMF/DB/Mysqli.php on line 158
Thanks for your help !
Post Reply