Go to main content

Navigation menu

Textpattern CMS support forum

You are not logged in. Register | Login | Help

  1. Index
  2. » How do I…?
  3. » [Solved] Having issues with txp:article SQL

Pages: 1

#1 2011-04-26 16:12:44

richtestani
Plugin Author
Registered: 2009-11-08
Posts: 128

[Solved] Having issues with txp:article SQL

For some reason when I go to a section page, with nothing more than: <txp:article />
I get no articles listed. I do have article in the section.

Here is some of the debugged output:

<txp:article listform="article_listing" limit="5" />
	[SQL (0.00022006034851074): select name from txp_section where searchable != '1']
	[SQL (0.00052404403686523): select count(*) from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (`Title` like '%case-results%' or `Body` like '%case-results%') ]
	[SQL (0.00053596496582031): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (`Title`, `Body`) against ('case-results') as score from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (`Title` like '%case-results%' or `Body` like '%case-results%')  order by score desc limit 0, 5]
[ ~~~ secondpass ~~~ ]

The SQL seems to be checking if article have the section within the content but not checking the section for articles.
Any ideas on what’s happening?

Thanks
Rich

Last edited by richtestani (2011-04-26 19:49:08)

Offline

#2 2011-04-26 16:23:51

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: [Solved] Having issues with txp:article SQL

richtestani wrote:

Any ideas on what’s happening?

Can you post your full tag trace and high diagnostics (TXP/Admin/Diagnostics > Select High, copy+paste the contents).

The SQL seems to be checking if article have the section within the content but not checking the section for articles.

According to that small piece, section isn’t set (you are on the frontpage, or something is conflicting something) and search is active (q parameter is set with value “case-results”). Thus the resulting query.

Last edited by Gocom (2011-04-26 16:29:42)

Rah | GitHub

Offline

#3 2011-04-26 18:12:09

richtestani
Plugin Author
Registered: 2009-11-08
Posts: 128

Re: [Solved] Having issues with txp:article SQL

Textpattern version: 4.3.0 (r3451)
Last Update: 2011-03-24 20:34:29/2010-11-04 10:59:40
Document root: /Library/WebServer/Documents/ronvil
$path_to_site: /Library/WebServer/Documents/ronvil
Textpattern path: /Library/WebServer/Documents/ronvil/textpattern
Permanent link mode: section_id_title
Temporary directory path: /private/var/tmp
Site URL: ronvil.krd-design.net
PHP version: 5.3.3
GD Image Library: bundled (2.0.34 compatible); supported formats: GIF, JPG, PNG.
Server TZ: America/New_York
Server Local Time: 2011-04-26 14:34:10
DST enabled?: 0
Automatically adjust DST setting?: 0
Time Zone: America/New_York (-18000)
MySQL: 5.4.3-beta-log
Locale: en_GB.UTF-8
Server: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8l DAV/2 PHP/5.3.3 SVN/1.6.5
Apache version: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8l DAV/2 PHP/5.3.3 SVN/1.6.5
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Darwin 10.5.0
Admin-side theme: classic 4.3.0

.htaccess file contents: ————————————
  1. For full documentation and other suggested options, please see
  2. http://svn.modxcms.com/docs/display/MODx096/Friendly+URL+Solutions
  3. including for unexpected logouts in multi-server/cloud environments
  4. and especially for the first three commented out rules

#php_flag register_globals Off
#AddDefaultCharset utf-8
#php_value date.timezone Europe/Moscow

Options +FollowSymlinks
RewriteEngine On
RewriteBase /

  1. Fix Apache internal dummy connections from breaking [(site_url)] cache
    RewriteCond %{HTTP_USER_AGENT} ^.internal\ dummy\ connection.*$ [NC]
    RewriteRule .     – [F,L]
  1. Rewrite domain.com -> www.domain.com — used with SEO Strict URLs plugin
    #RewriteCond %{HTTP_HOST} .
    #RewriteCond %{HTTP_HOST} !^www\.example\.com [NC]
    #RewriteRule (.*) http://www.example.com/$1 [R=301,L]
  1. Exclude /assets and /manager directories and images from rewrite rules
    RewriteRule ^(manager|assets)/*$ – [L]
    RewriteRule \.(jpg|jpeg|png|gif|ico)$ – [L]
  1. For Friendly URLs
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]
  1. Reduce server overhead by enabling output compression if supported.
    #php_flag zlib.output_compression On
    #php_value zlib.output_compression_level 5
    ————————————

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/mysql-5.4.3-beta-osx10.5-x86_64/share/charsets/
17 Tables: OK

10 Custom Fields: custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, custom_10 (10)

PHP extensions: Core/5.3.3, date/5.3.3, ereg, libxml, openssl, pcre, sqlite3/0.7-dev, zlib/1.1, bcmath, bz2, calendar, ctype, curl, dom/20031129, hash/1.0, fileinfo/1.0.5-dev, filter/0.11.0, ftp, gd, session, iconv, json/1.2.1, ldap, mbstring, standard/5.3.3, mysqlnd/mysqlnd 5.0.7-dev – 091210 – $Revision: 300533 $, SPL/0.2, odbc/1.0, mysqli/0.1, PDO/1.0.4dev, pdo_mysql/1.0.2, pdo_sqlite/1.0.1, Phar/2.0.1, posix, Reflection/$Revision: 300393 $, mysql/1.0, shmop, SimpleXML/0.1, snmp, soap, sockets, SQLite/2.0-dev, exif/1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $, sysvmsg, sysvsem, sysvshm, tokenizer/0.1, xml, xmlreader/0.1, xmlrpc/0.51, xmlwriter/0.1, xsl/0.1, zip/1.9.1, apache2handler, xdebug/2.1.0beta3

Apache modules: core, prefork, http_core, mod_so, mod_authn_file, mod_authn_dbm, mod_authn_anon, mod_authn_dbd, mod_authn_default, mod_authz_host, mod_authz_groupfile, mod_authz_user, mod_authz_dbm, mod_authz_owner, mod_authz_default, mod_auth_basic, mod_auth_digest, mod_cache, mod_disk_cache, mod_mem_cache, mod_dbd, mod_dumpio, mod_ext_filter, mod_include, mod_filter, mod_substitute, mod_deflate, mod_log_config, mod_log_forensic, mod_logio, mod_env, mod_mime_magic, mod_cern_meta, mod_expires, mod_headers, mod_ident, mod_usertrack, mod_setenvif, mod_version, mod_proxy, mod_proxy_connect, mod_proxy_ftp, mod_proxy_http, mod_proxy_ajp, mod_proxy_balancer, mod_ssl, mod_mime, mod_dav, mod_status, mod_autoindex, mod_asis, mod_info, mod_cgi, mod_dav_fs, mod_vhost_alias, mod_negotiation, mod_dir, mod_imagemap, mod_actions, mod_speling, mod_userdir, mod_alias, mod_rewrite, mod_bonjour2, mod_php5, mod_dav_svn, mod_authz_svn

/Library/WebServer/Documents/ronvil/index.php: r3189 (b58ca188e05a48b31d1025d61e026725)
/Library/WebServer/Documents/ronvil/css.php: r3189 (5e7fe7ea948c7e9ec2e56e34a01f4bb6)
/Library/WebServer/Documents/ronvil/textpattern/css.php: r3189 (4e131ff20d1da3e20b2c629292138653)
/Library/WebServer/Documents/ronvil/textpattern/include/import/import_b2.php: r3446 (e05c2808566822ed4a6e525ee4bc4192)
/Library/WebServer/Documents/ronvil/textpattern/include/import/import_blogger.php: r3446 (2096da3f746152301620e18a4ccfe0f8)
/Library/WebServer/Documents/ronvil/textpattern/include/import/import_mt.php: r3446 (f0be9ce384eec112f8e70687458173cc)
/Library/WebServer/Documents/ronvil/textpattern/include/import/import_mtdb.php: r3446 (c8f07f5a6db990382e4a30a1d57333e6)
/Library/WebServer/Documents/ronvil/textpattern/include/import/import_wp.php: r3446 (0740155a2d06657893acc7c7d968770d)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_admin.php: r3386 (ffb4129e774cfbb8643c2e05f37f3507)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_article.php: r3440 (db97df274f245047f305ff75b1e20560)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_auth.php: r3374 (a7f13cd308c5c500105f2b5994cc3aad)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_category.php: r3374 (5af7cf31692bb2213f93babfef5a6657)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_css.php: r3379 (88587e0dc2d159be4e521dbf33de7bb7)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_diag.php: r3446 (1903c263988e7ce4d705e5f0d7ee5bdf)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_discuss.php: r3374 (ec56dc03cb9ac06f5f026d0a3daf3bac)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_file.php: r3416 (3159e53e1f35099257be71fe85adf021)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_form.php: r3382 (e6574a6280585918bd7d4c6d202c3b85)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_image.php: r3441 (9a93e09c68754dd10f1dc007914652d9)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_import.php: r3374 (3dbc737eaa1def0771d76344ff7fb116)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_link.php: r3374 (bb85e92bc8df2363676817a10c0d5801)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_list.php: r3374 (88af3230cf8dc28747b10a1fea20800a)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_log.php: r3374 (acb6773311e80fbf87a38587c99a7d2d)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_page.php: r3379 (92d4d3d0dd9d6ef46fb6e1fdb6d1b0b1)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_plugin.php: r3374 (d73a4547e590fc476279278fa8aeb391)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_prefs.php: r3445 (959c2a15daf42c8c6da5957b98b0213d)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_preview.php: r1238 (d55a3df200602c69eb65c72dc8ad7477)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_section.php: r3374 (d496b080b90519a9a6e180b0fd0451f8)
/Library/WebServer/Documents/ronvil/textpattern/include/txp_tag.php: r3444 (b8634c90e7ea16c60d1370a867e91626)
/Library/WebServer/Documents/ronvil/textpattern/index.php: r3451 (dd519f665b0ffb952246f5d91170134c)
/Library/WebServer/Documents/ronvil/textpattern/jquery.js: unknown (e4958bd2e32d9fcd6115a585ed17a9cc)
/Library/WebServer/Documents/ronvil/textpattern/lib/IXRClass.php: r3394 (f8621cd5f0f36c69360aa2033e4065af)
/Library/WebServer/Documents/ronvil/textpattern/lib/admin_config.php: r3386 (6b2b6db38da2baa82f5557a6e29bad97)
/Library/WebServer/Documents/ronvil/textpattern/lib/class.thumb.php: r3301 (6ca1ad88082438f88cae6416dcb29822)
/Library/WebServer/Documents/ronvil/textpattern/lib/classTextile.php: r3438 (734d0ebd2f9e7c4c84bf93bf5cde5d58)
/Library/WebServer/Documents/ronvil/textpattern/lib/constants.php: r3318 (a2b38baeb4ba77f9dfdd4ad71e277549)
/Library/WebServer/Documents/ronvil/textpattern/lib/taglib.php: r2868 (c9676967585577f0a0b329803761d516)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_admin.php: r3047 (d5211ebfac4f3b6d00f22d459f3cdf69)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_db.php: r3389 (3324a5dab30f68bda3fa7218514f91b7)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_forms.php: r3372 (447c117e7072a73e67ebe2dc41fe46ee)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_head.php: r3388 (e59cdf9aa24c4d2fb88d0d45076be68e)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_html.php: r3372 (17041abcc0779d22a6224feb8dfd3492)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_misc.php: r3437 (b9de32008e7a9ac596e637d993aab37e)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_theme.php: r3388 (99262eb207d3b49a343ad4b5c1dd3e64)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_update.php: r2812 (54d6fa23f3f3fc5c2cb31262c6aa343f)
/Library/WebServer/Documents/ronvil/textpattern/lib/txplib_wrapper.php: r2931 (22f292521a595090b46300354db6df57)
/Library/WebServer/Documents/ronvil/textpattern/publish.php: r3433 (3469e21a32b2411d56e57701baf296f6)
/Library/WebServer/Documents/ronvil/textpattern/publish/atom.php: r3399 (9a4eeebe17b8c833bc382b6287fbb168)
/Library/WebServer/Documents/ronvil/textpattern/publish/comment.php: r3395 (8a55386ccfd856bd5df68c84058e5ba0)
/Library/WebServer/Documents/ronvil/textpattern/publish/log.php: r3247 (257c3a247f0ca6a21513beb2f09d76c6)
/Library/WebServer/Documents/ronvil/textpattern/publish/rss.php: r3399 (da9ab0c78c57b4169a360dfa0aa6c753)
/Library/WebServer/Documents/ronvil/textpattern/publish/search.php: r2812 (22762b20f6281fd132248ec42e5ee9af)
/Library/WebServer/Documents/ronvil/textpattern/publish/taghandlers.php: r3443 (e9a2a51863fd241cd8e7e8c0785120ab)
/Library/WebServer/Documents/ronvil/textpattern/textpattern.js: r3369 (b87b0a897cc2259aa5132da030764c9d)
/Library/WebServer/Documents/ronvil/textpattern/theme/classic/classic.php: r3191 (8af2d7091676308c93021843c629812d)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_1.0.0.php: r3047 (8aa7c3d82aad8df47adf96e92f124137)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.2.php: r3047 (81324dcf9bed59bacd73789c2b650305)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.3.php: r3047 (c237b669e57b7fe0ea2f8c7cc9d69557)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.4.php: r3047 (d3e62265ff5ad36a8a7de23e6148f6f9)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.5.php: r2894 (7f5fe789f58a202e23c1b430a2659110)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.6.php: r3047 (687e230c2c6a46a6c73d3e97ee368d92)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.7.php: r3014 (fa83153d09e2e533ce41f69799b90f5c)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.0.8.php: r3057 (26d76a86cb95757355958e06b6063afe)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.2.0.php: r3233 (9bd2be46df10e2f0561634a2de4cdc63)
/Library/WebServer/Documents/ronvil/textpattern/update/_to_4.3.0.php: r3304 (0f57c27668c4f791530830d92b146dde)
/Library/WebServer/Documents/ronvil/textpattern/update/_update.php: r3451 (9d15292f6117490393ff999cd052027e)

————————————

Last edited by richtestani (2011-04-26 18:34:33)

Offline

#4 2011-04-26 18:36:14

richtestani
Plugin Author
Registered: 2009-11-08
Posts: 128

Re: [Solved] Having issues with txp:article SQL

Also – the section I posted the debug was ‘case-results’ which is used in the SQL.
It also does output if I use the section tag.

Not sure what’s happening here though.

Offline

#5 2011-04-26 19:48:48

richtestani
Plugin Author
Registered: 2009-11-08
Posts: 128

Re: [Solved] Having issues with txp:article SQL

Solved -
My .htaccess file was using an old Modx setup.

Offline

Pages: 1

  1. Index
  2. » How do I…?
  3. » [Solved] Having issues with txp:article SQL

Board footer

Powered by FluxBB