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.

Suspected Bugs and Errors - 8

If you suspect you have found a bug or a code error post here.
3,976 posts | Last Activity on 10-10-2019 12:45 by RobiNN
RobiNN
RobiNN 10-10-2019 12:45, 9 days ago
Re: Error in print.php https://github.com/php-fusion/PHP-Fus...ee/8.00.22
Oleg
Oleg 10-10-2019 12:33, 9 days ago
Re: Error in print.php

RobiNN wrote:

@RobiNN
- Update your system. This is already fixed


Version 8.00.21 is available for download on this site, which I installed. Is there a newer version??
RobiNN
RobiNN 10-10-2019 11:28, 9 days ago
Re: Error in print.php Update your system. This is already fixed
Oleg
Oleg 10-10-2019 10:15, 9 days ago
Re: Error in print.php Good day! There is an error in print.php:

Code

Query Error: SELECT ta.article_subject, ta.article_article, ta.article_breaks, article_datestamp, ta.article_visibility, tu.user_id, tu.user_name, tu.user_status FROM fusion_articles ta INNER JOIN fusion_article_cats tac ON ta.article_cat=tac.article_cat_id LEFT JOIN fusion_users tu ON ta.article_name=tu.user_id WHERE article_id='1' AND article_draft='0'

Stack Trace: #0 /site.ru/includes/db_handlers/pdo_functions_include.php(42): PDO->prepare('SELECT ta.artic...') #1 /site.ru/print.php(54): dbquery('SELECT ta.artic...') #2 {main}
Error Nature: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ta.article_visibility' in 'field list'

helmuth
helmuth 20-09-2019 06:24, 29 days ago
Re: wrong sorting after upgrade in forum_threads_list_panel
Code
$result = dbquery(
 "SELECT   f.forum_id, f.forum_cat, f.forum_name, f.forum_description, f.forum_moderators, f.forum_lastpost, f.forum_postcount,
 f.forum_threadcount, f.forum_lastuser, f.forum_access, f2.forum_name AS forum_cat_name, f2.forum_description AS forum_cat_description,
 t.thread_id, t.thread_lastpost, t.thread_lastpostid, t.thread_subject, t.thread_postcount, t.thread_views, t.thread_lastuser, t.thread_poll,
 u.user_id, u.user_name, u.user_status, u.user_avatar
 FROM ".DB_FORUMS." f
 LEFT JOIN ".DB_FORUMS." f2 ON f.forum_cat = f2.forum_id
 LEFT JOIN ".DB_THREADS." t ON f.forum_id = t.forum_id AND f.forum_lastpost=t.thread_lastpost
 LEFT JOIN ".DB_USERS." u ON f.forum_lastuser = u.user_id
 ".(multilang_table("FO") ? "WHERE f2.forum_language='".LANGUAGE."' AND" : "WHERE")." ".groupaccess('f.forum_access')." AND f.forum_cat!='0' AND t.thread_lastpost >= ".$timeframe." AND t.thread_hidden='0'
 GROUP BY thread_id ORDER BY t.thread_lastpost DESC LIMIT ".$settings['numofthreads'].""
);



DESC entered into the last line ... did the trick :-)
Homdax
Homdax 19-09-2019 11:53, 30 days ago
Re: wrong sorting after upgrade in forum_threads_list_panel I don't think you can without editing the code and change asc to desc or vice versa in the panel code itself...
helmuth
helmuth 19-09-2019 10:53, 30 days ago
Re: wrong sorting after upgrade in forum_threads_list_panel http://heatpump.dk/news.php

link goes to page after an upgrade from v7 to v8.00.21

forum_threads_list_panel shows oldest at the top ... it should show newest at the top

where to change that?
E
Ernst74 01-09-2019 08:42, 2 months ago
Re: Search problem I have a problem with the sitesearch. If i search over the complete site the results are not complete. On site 1 i have only 7 results, on site 2 i have 7 results too and on site 3 i have 5 results by search over the complete site. Totally it must be 21 results but i have only 19 results.

If i search only in Downloads or Forum or News all is fine.
douwe_yntema
douwe_yntema 08-08-2019 07:02, 2 months ago
Re: Bug in /messages.php sender_id $_GET['msg_read'] - 1

Use this value in the query.

To set the read flag, use where message_id = sender_id.

You cannot update a record with a join
Wanabo
Wanabo 07-08-2019 21:48, 2 months ago
Re: Bug in /messages.php

douwe_yntema wrote:

@douwe_yntema - The problem is the message for the receiver is an other record in the database than the message from the sender.
I know, so I need to get message_id='".$_GET['msg_read']."' minus 1, there is the message_read value I need. But I can't code it.

Quote

On composing the message you need to put info in the message for the receiver, about the record id for the corresponding record of the sender. On reading the message, set a flag in the record for the sender the message is read. You know the record ID becouse its put in on composing.
As above, this is set in message_id='".$_GET['msg_read']."' minus 1 It needs some mysql joining, but I have a limit understanding of it.
douwe_yntema
douwe_yntema 07-08-2019 19:49, 2 months ago
Re: Bug in /messages.php The problem is the message for the receiver is an other record in the database than the message from the sender.

On composing the message you need to put info in the message for the receiver, about the record id for the corresponding record of the sender. On reading the message, set a flag in the record for the sender the message is read. You know the record ID becouse its put in on composing.
Wanabo
Wanabo 06-08-2019 13:46, 2 months ago
Re: Bug in /messages.php Was trying to add a mod when found a bug in the original code.
Around line 415 there is an if statement without snakehooks. Added them, see below.
Code
"outbox")) {
 $result = dbquery("SELECT m.message_id, m.message_subject, m.message_message, m.message_smileys,
      m.message_datestamp, m.message_folder, u.user_id, u.user_name, u.user_status
      FROM ".DB_MESSAGES." m
      LEFT JOIN ".DB_USERS." u ON m.message_from=u.user_id
      WHERE message_to='".$userdata['user_id']."' AND message_id='".$_GET['msg_read']."'");
 if (dbrows($result)) {
 $data = dbarray($result);
 $result = dbquery("UPDATE ".DB_MESSAGES." SET message_read='1' WHERE message_id='".$data['message_id']."'");
 $message_message = $data['message_message'];
 if ($data['message_smileys'] == "y") { $message_message = parsesmileys($message_message); } // mod Wanabo, added missing snakehooks.
 add_to_title($locale['global_201'].$locale['431']);
 opentable($locale['431']);



Was trying to make it so that in a users pm outbox the messages are displayed bold, that the receiver did not read yet. Very important request from 1 of my users, who uses the pm system a lot and wants to know if a message is read or not.
I FAILED. Who can help?
Wanabo
Wanabo 04-08-2019 15:20, 2 months ago
Re: Page navigator not working after enabling permalinks. Also post preview does not work with quick reply and normal reply with permalinks enabled.
Wanabo
Wanabo 28-07-2019 10:23, 3 months ago
Re: Page navigator not working after enabling permalinks. Didn't change the thread subject, but instead I looked for other threads with no special characters in the thread subject. These have the same bug.
Here are two examples:
https://xs4all.gebruikers.eu/forum/th...ing-row-10
https://xs4all.gebruikers.eu/forum/th...35b-row-30
Chan
Chan 28-07-2019 08:48, 3 months ago
Re: Page navigator not working after enabling permalinks. The url has a "!". Can you confirm with us if you changed the thread subject from FRITZ!Box to FRITZbox, will page navigation work?
Falk
Falk 26-07-2019 17:52, 3 months ago
Re: Page navigator not working after enabling permalinks. Issued, https://github.com/php-fusion/PHP-Fusion/issues/2240
Wanabo
Wanabo 26-07-2019 13:53, 3 months ago
Re: Page navigator not working after enabling permalinks. I have received several reports from my users that the page navigation is not working anymore after enabling permalinks/seo engine. I confirm this bug.
Examples:

https://xs4all.gebruikers.eu/forum/thread/view/787/FRITZ!Box-7581-problemen-row-3460 <-- goes to page 1
Hell, every thing is going to page 1.
Falk
Falk 17-07-2019 14:22, 3 months ago
Re: v8 & permalinks error I am not sure if it crashes before it shows where.
Wanabo
Wanabo 17-07-2019 13:46, 3 months ago
Re: v8 & permalinks error Ok. Tried enabling Debug SEO on a good working site with permalinks / seo engine enabled. But no debug output on the front end.
So Debug SEO is not working as you all ready mentioned.

Just curious. If Debug SEO is fixed, would it show any debug output on a site that is completely blank because of "range out of order in character class at offset 4002"? See also post #3

Quote

After enabling SEO Engine/Permalinks the site goes blank! Except for administration.
Mickelvlm
Mickelvlm 17-07-2019 13:16, 3 months ago
Re: User search for new messages: users.json.php missing I'll think more about pointing out the 8.00.21 side of things, then - although I don't think I've discovered anything that works in .21 but not in .22 yet. pfft

Thanks smile
You can view all discussion threads in this forum.
You can start a new discussion thread in this forum.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.