TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 28, 2024, 08:39:53 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,104
  • Total Topics: 21,212
  • Online today: 175
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 174
  • Total: 174

Link goes no where

Started by bigguy, December 03, 2018, 03:04:29 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

tino

Quote from: @rjen on December 03, 2018, 11:59:41 AM
Can you check the settings for the allowed tags?

It seems that the url tag is causing it.
If I disable the url tag I can leave the autolink URL on, and it also works...

Makes no difference to me.  :'( Works on both of them.

bigguy

If I uncheck url than all looks good. The problem with me doing that is it breaks all my videos I have up from youtube.

tino

Quote from: bigguy on December 03, 2018, 12:28:13 PM
If I uncheck url than all looks good. The problem with me doing that is it breaks all my videos I have up from youtube.

Can you enable $db_show_debug = true;

Then copy all the queries used?

bigguy

Where do I enable that again.

* bigguy feels a little embarrassed

bigguy

I found it. Here is mine:
Browser ID: firefox (is_firefox63, is_firefox, is_gecko)
Templates: 4: index (default), TPsubs (default), TPBlockLayout (default), TPortal (default).
Sub templates: 8: init, html_above, body_above, tp_above, main, tp_below, body_below, html_below.
Language files: 6: index+Modifications.english (default), Arcade.english (default), ArcadeAdmin.english (default), TPortal.english (default), Stats.english (default), TPListImages.english (default).
Style sheets: 3: index.css, jquery.custom-scrollbar.css, responsive.css.
Hooks called: 58 (show)
Files included: 39 - 1335KB. (show)
Memory used: 6183KB.
Tokens: post-admin-login, post-admin-dbsc.
Cache hits: 9: 0.01069s for 36,912 bytes (show)
Cache misses: 3: (get modSettings, get tpFrontTheme, get menu_buttons-1_9-english)
Queries used: 27.

tino

Quote from: @rjen on December 03, 2018, 01:22:05 PM
Quote$db_show_debug
Version: SMF 1.0+
Default value: (not set)
If set, enables query debug features -- full text of SQL queries will be displayed before execution. These are very useful for debugging purposes. To enable add $db_show_debug = true; to your Settings.php file before the closing ?>. Keep in mind that once this is enabled the output is shown to everyone.

I just did just that in my test site. Attached the queries...

Why is your's calling doTPpage? Or is that not from the frontpage.

tino

Quote from: bigguy on December 03, 2018, 01:22:52 PM
I found it. Here is mine:
Browser ID: firefox (is_firefox63, is_firefox, is_gecko)
Templates: 4: index (default), TPsubs (default), TPBlockLayout (default), TPortal (default).
Sub templates: 8: init, html_above, body_above, tp_above, main, tp_below, body_below, html_below.
Language files: 6: index+Modifications.english (default), Arcade.english (default), ArcadeAdmin.english (default), TPortal.english (default), Stats.english (default), TPListImages.english (default).
Style sheets: 3: index.css, jquery.custom-scrollbar.css, responsive.css.
Hooks called: 58 (show)
Files included: 39 - 1335KB. (show)
Memory used: 6183KB.
Tokens: post-admin-login, post-admin-dbsc.
Cache hits: 9: 0.01069s for 36,912 bytes (show)
Cache misses: 3: (get modSettings, get tpFrontTheme, get menu_buttons-1_9-english)
Queries used: 27.


Thanks, can you also put the queries used? There is a button to press to show them all.

@rjen

Sorry, that was not the frontpage...

attached the correct one
Running Latest TP on SMF2.1 at: www.fjr-club.nl

bigguy

SET NAMES 'utf8'
    in .../Sources/Load.php line 32, which took 8.202E-5 seconds at 0.02807999 into request.

       SELECT id_theme, variable, value
       FROM smf_themes
       WHERE id_member = 0
          AND id_theme IN (1, 1)
    in .../Sources/ScheduledTasks.php line 953, which took 0.00119996 seconds at 0.04460311 into request.

       SELECT data
       FROM smf_sessions
       WHERE session_id = '93ab053f3298e6d0101ecf700d3ebc35'
       LIMIT 1
    in .../Sources/Session.php line 138, which took 0.00047493 seconds at 0.05304718 into request.

       DELETE FROM smf_sessions
       WHERE last_update < 1543840113
    in .../Sources/Session.php line 248, which took 0.00037003 seconds at 0.05359602 into request.

             SELECT mem.*, COALESCE(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type
             FROM smf_members AS mem
                LEFT JOIN smf_attachments AS a ON (a.id_member = 1)
             WHERE mem.id_member = 1
             LIMIT 1
    in .../Sources/Load.php line 469, which took 0.00076199 seconds at 0.0542531 into request.

             SELECT variable, value, id_member, id_theme
             FROM smf_themes
             WHERE id_member = 1
                AND id_theme = 1
             ORDER BY id_theme asc
    in .../Sources/Load.php line 1815, which took 0.0004108 seconds at 0.06074119 into request.

          SELECT value
          FROM smf_tp_settings
          WHERE name = 'standalone_mode'
    in .../Sources/TPortal.php line 445, which took 0.00052905 seconds at 0.06430507 into request.

       SELECT *
       FROM smf_tp_variables
       WHERE type IN ('layerhook', 'art_not_approved', 'dl_not_approved')
    in .../Sources/TPortal.php line 495, which took 0.00032592 seconds at 0.06839013 into request.

       SELECT id, modulename, blockrender, autoload_run, adminhook,
       frontsection, permissions
       FROM smf_tp_modules WHERE active = 1
    in .../Sources/TPortal.php line 2907, which took 0.00023985 seconds at 0.0687592 into request.

       SELECT * FROM smf_tp_blocks
       WHERE off = 0
       AND bar != 4
       AND (
       
       
       
       
       
       FIND_IN_SET('actio=viewquery', access2) OR FIND_IN_SET('actio=viewquery;sa=hide', access2) OR FIND_IN_SET('actio=allpages', access2))
       AND 1
       ORDER BY bar, pos, id ASC
    in .../Sources/TPortal.php line 2182, which took 0.00060105 seconds at 0.07298708 into request.

          SELECT type, value, item
          FROM smf_tp_data
          WHERE type = 2
          AND id_member = 1
    in .../Sources/TPortal.php line 2809, which took 0.00023103 seconds at 0.07372999 into request.

          SET NAMES 'utf8'
    in .../Sources/Load.php line 32, which took 5.603E-5 seconds at 0.0155139 into request.

       SELECT id_theme, variable, value
       FROM smf_themes
       WHERE id_member = 0
          AND id_theme IN (1, 1)
    in .../Sources/ScheduledTasks.php line 953, which took 0.00061989 seconds at 0.0236001 into request.

       SELECT data
       FROM smf_sessions
       WHERE session_id = '93ab053f3298e6d0101ecf700d3ebc35'
       LIMIT 1
    in .../Sources/Session.php line 138, which took 0.00041199 seconds at 0.02989697 into request.

       DELETE FROM smf_sessions
       WHERE last_update < 1543840113
    in .../Sources/Session.php line 248, which took 0.000247 seconds at 0.03035808 into request.

             SELECT mem.*, COALESCE(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type
             FROM smf_members AS mem
                LEFT JOIN smf_attachments AS a ON (a.id_member = 1)
             WHERE mem.id_member = 1
             LIMIT 1
    in .../Sources/Load.php line 469, which took 0.00048494 seconds at 0.03078604 into request.

             SELECT variable, value, id_member, id_theme
             FROM smf_themes
             WHERE id_member = 1
                AND id_theme = 1
             ORDER BY id_theme asc
    in .../Sources/Load.php line 1815, which took 0.00044513 seconds at 0.03655291 into request.

          SELECT value
          FROM smf_tp_settings
          WHERE name = 'standalone_mode'
    in .../Sources/TPortal.php line 445, which took 0.0003531 seconds at 0.03928494 into request.

       SELECT *
       FROM smf_tp_variables
       WHERE type IN ('layerhook', 'art_not_approved', 'dl_not_approved')
    in .../Sources/TPortal.php line 495, which took 0.00036407 seconds at 0.04305506 into request.

       SELECT id, modulename, blockrender, autoload_run, adminhook,
       frontsection, permissions
       FROM smf_tp_modules WHERE active = 1
    in .../Sources/TPortal.php line 2907, which took 0.00024009 seconds at 0.0434649 into request.

       SELECT * FROM smf_tp_blocks
       WHERE off = 0
       AND bar != 4
       AND (
       
       
       
       
       
       FIND_IN_SET('actio=forum', access2) OR FIND_IN_SET('actio=forumall', access2) OR FIND_IN_SET('actio=forum', access2) OR FIND_IN_SET('actio=allpages', access2))
       AND 1
       ORDER BY bar, pos, id ASC
    in .../Sources/TPortal.php line 2182, which took 0.00075006 seconds at 0.04761004 into request.

          SELECT type, value, item
          FROM smf_tp_data
          WHERE type = 2
          AND id_member = 1
    in .../Sources/TPortal.php line 2809, which took 0.00023794 seconds at 0.04847407 into request.

          UPDATE smf_log_online
          SET log_time = 1543843713, ip = unhex('18eb2dcf'), url = '{\"action\":\"forum\",\"USER_AGENT\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64; rv:63.0) Gecko\\/20100101 Firefox\\/63.0\"}'
          WHERE session = '93ab053f3298e6d0101ecf700d3ebc35'
    in .../Sources/Logging.php line 132, which took 0.00249219 seconds at 0.04902291 into request.

          SELECT
             c.id_cat, c.name AS cat_name, c.description AS cat_desc,
             b.id_board, b.name AS board_name, b.description,
             CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,
             b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,
             COALESCE(m.poster_time, 0) AS poster_time, COALESCE(mem.member_name, m.poster_name) AS poster_name,
             m.subject, m.id_topic, COALESCE(mem.real_name, m.poster_name) AS real_name,
             
             (CASE WHEN COALESCE(lb.id_msg, 0) >= b.id_last_msg THEN 1 ELSE 0 END) AS is_read, COALESCE(lb.id_msg, -1) + 1 AS new_from,
             c.can_collapse,
             COALESCE(mem.id_member, 0) AS id_member, mem.avatar, m.id_msg
          FROM smf_boards AS b
             LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
             LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg)
             LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)
             LEFT JOIN smf_log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = 1)
          WHERE 1=1
             AND b.child_level BETWEEN 0 AND 1
             ORDER BY c.cat_order, b.child_level DESC, b.board_order DESC
    in .../Sources/Subs-BoardIndex.php line 120, which took 0.00300908 seconds at 0.05587292 into request.

       SELECT mem.id_member, mem.real_name, mo.id_board
       FROM smf_moderators AS mo
         INNER JOIN smf_members AS mem ON (mem.id_member = mo.id_member)
       WHERE mo.id_board IN (2, 1, 6, 19, 5, 20, 4, 3, 21, 16, 12, 11, 10, 9, 8, 7, 28, 30, 27, 26, 25, 15, 14, 31, 13)
    in .../Sources/Subs-Boards.php line 1307, which took 0.00045514 seconds at 0.05982089 into request.

       SELECT mg.id_group, mg.group_name, bg.id_board
       FROM smf_moderator_groups AS bg
         INNER JOIN smf_membergroups AS mg ON (mg.id_group = bg.id_group)
       WHERE bg.id_board IN (2, 1, 6, 19, 5, 20, 4, 3, 21, 16, 12, 11, 10, 9, 8, 7, 28, 30, 27, 26, 25, 15, 14, 31, 13)
    in .../Sources/Subs-Boards.php line 1347, which took 0.00036907 seconds at 0.06032991 into request.

       SELECT
          m.poster_time, m.subject, m.id_topic, m.id_member, m.id_msg,
          COALESCE(mem.real_name, m.poster_name) AS poster_name, t.id_board, b.name AS board_name,
          SUBSTRING(m.body, 1, 385) AS body, m.smileys_enabled
       FROM smf_messages AS m
          INNER JOIN smf_topics AS t ON (t.id_topic = m.id_topic)
          INNER JOIN smf_boards AS b ON (b.id_board = t.id_board)
          LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)
       WHERE m.id_msg >= 7091
          AND b.id_board != 14
          AND 1=1
          AND t.approved = 1
          AND m.approved = 1
       ORDER BY m.id_msg DESC
       LIMIT 12
    in .../Sources/Subs-Recent.php line 51, which took 0.0010469 seconds at 0.0674901 into request.

       SELECT
          lo.id_member, lo.log_time, lo.id_spider, mem.real_name, mem.member_name, mem.show_online,
          mg.online_color, mg.id_group, mg.group_name, mg.hidden, mg.group_type, mg.id_parent
       FROM smf_log_online AS lo
          LEFT JOIN smf_members AS mem ON (mem.id_member = lo.id_member)
          LEFT JOIN smf_membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = 0 THEN mem.id_post_group ELSE mem.id_group END)
    in .../Sources/Subs-MembersOnline.php line 78, which took 0.00057602 seconds at 0.09987593 into request.

       SELECT
          mem.id_member, mem.last_login, mem.real_name, mem.member_name, mem.show_online,
          mg.online_color, mg.id_group, mg.group_name
       FROM smf_members AS mem
          LEFT JOIN smf_membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = 0 THEN mem.id_post_group ELSE mem.id_group END)
          WHERE mem.last_login >= 1543757313
    in .../Sources/Subs-UsersOnlineToday.php line 135, which took 0.00039315 seconds at 0.10055494 into request.

       UPDATE smf_log_activity
       SET
          hits = hits + 1
       WHERE date = '2018-12-03'
    in .../Sources/Logging.php line 404, which took 0.00294495 seconds at 0.10179806 into request.

       SELECT id_member, alert_pref, alert_value
       FROM smf_user_alerts_prefs
       WHERE id_member IN (1, 0)
          AND alert_pref IN ('alert_timeout')
    in .../Sources/Subs-Notify.php line 48, which took 0.00050187 seconds at 0.10826206 into request.

       SELECT modulename, permissions, languages
       FROM smf_tp_modules
       WHERE active = 1
    in .../Sources/TPSubs.php line 183, which took 0.00020409 seconds at 0.1090939 into request.

         SELECT value1 AS name , value3 AS href , value7 AS position
FROM smf_tp_variables
WHERE type = 'menubox'
AND value3 LIKE 'menu%'
AND value5 = 0
    in .../Sources/TPassimilate.php line 276, which took 0.00020981 seconds at 0.10941911 into request.

             SELECT COUNT(*)
             FROM smf_log_errors
    in .../Sources/Subs.php line 4633, which took 0.00024509 seconds at 0.10977197 into request.

bigguy