Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Installation problem at Forum infusion

Hello everyone

I am installing new stable version of Php Fusion 8.00.50 just downloaded from the downloads.

After the installation when I click Forum link I am gettin below error;

db_handlers/mysqli_functions_include.php
Trying to get property 'num_rows' of non-object Line: 90

I tried to delete and install several times. I did everything according to read me file. Still same.

Does anyone know the solution or had this before?

Thanks in advance for help.
Sounds like a zero content report. I think you need to add some forums in the Admin and it will go away.
Hi Falk

Thank you for your quick reply.

I have added categories and forums from the admin panel. They are shown in admin panel but nothing changes in regular page. It says no forums.

It is same for article categories as well. Eventhough I add the categories and they are shown in admin panel. On the page it says no categories.
When you add a forum, first you need to add a Forum Category, then below this you also need to add a active forum for it to be displayed. I am not sure of the other issue you describe, Sounds like it could be some sticky cache on your hosting side as well. It pre-cache your empty content and reads it for a certain period of time.
I added the category then, I added the forum. But I will check about the cache. Thanks for your support. I will check and tell what is going on.
Hi again

I deleted everything including database. Made them again freshly.

I made forum categories and forums. I made article categories. Then I visited the front end getting same error :

Error: Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'allabout_dream.t.thread_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by There are no Forums defined.

And when I check the error log under the link :

db_handlers/mysqli_functions_include.php
Trying to get property 'num_rows' of non-object Line: 90

I got this.

Any ideas?
open from forum the index.php search
CodeDownload  
GROUP BY forum_id ORDER BY



change to
CodeDownload  
GROUP BY forum_id, thread_id ORDER BY

Hello Ernst

Sorry for my late reply. I was hopeless and searching for alternatives.

To make it clear; If I do the change you advice, will I still have to contact with hosting provider and ask them to change the php setup of mysql?

And one more thing the same thing happens with the articles too. So if I do the similar change with articles will it work too?

Thank you for your time and support.
It is better to have a more standard configuration instead of changing Core files. It is very uncommon to have that setting as is. I think this is second time I see it in 15 years. You can also pick our hosting to void any hassle smile
More and more MySQL servers are running in STRICT MODE with web hosts. Such rework is then unfortunately necessary. But all changes for the STRICT mode continue to work normally even in the weighted mode. Therefore, those responsible should change PHP fusion to STRICT MODE. Then it is usable again for all users!

Sorry for the bad english.
Ernst

Thank you very much. Your code has solved my problem. I appreciate that.
Thread Information
Author
Replies
13 posts
Views
236 times
Last Post
Last updated on 7 days ago
Related Threads
Problem with (IMG) (/IMG)
Started by
C
conans2 - 6 posts
"contact me" problem
Started by
N
neophytos - 1 post
Problem with "new flag"
Started by
B
Bene - 1 post
"Who is Here?" in forum?
Started by skpacman skpacman - 6 posts
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Falk, Charon, RobiNN, Ernst74