wiki:TracQuery

Trac Ticket Queries

In addition to reports, Trac provides support for custom ticket queries, used to display lists of tickets meeting a specified set of criteria.

To configure and execute a custom query, switch to the View Tickets module from the navigation bar, and select the Custom Query link.

Filters

When you first go to the query page the default filter will display tickets relevant to you:

  • If logged in then all open tickets it will display open tickets assigned to you.
  • If not logged in but you have specified a name or email address in the preferences then it will display all open tickets where your email (or name if email not defined) is in the CC list.
  • If not logged and no name/email defined in the preferences then all open issues are displayed.

Current filters can be removed by clicking the button to the left with the minus sign on the label. New filters are added from the pulldown lists at the bottom corners of the filters box ('And' conditions on the left, 'Or' conditions on the right). Filters with either a text box or a pulldown menu of options can be added multiple times to perform an or of the criteria.

You can use the fields just below the filters box to group the results based on a field, or display the full description for each ticket.

Once you've edited your filters click the Update button to refresh your results.

Clicking on one of the query results will take you to that ticket. You can navigate through the results by clicking the Next Ticket or Previous Ticket links just below the main menu bar, or click the Back to Query link to return to the query page.

You can safely edit any of the tickets and continue to navigate through the results using the Next/Previous/Back to Query links after saving your results. When you return to the query any tickets which were edited will be displayed with italicized text. If one of the tickets was edited such that it no longer matches the query criteria the text will also be greyed. Lastly, if a new ticket matching the query criteria has been created, it will be shown in bold.

The query results can be refreshed and cleared of these status indicators by clicking the Update button again.

Saving Queries

Trac allows you to save the query as a named query accessible from the reports module. To save a query ensure that you have Updated the view and then click the Save query button displayed beneath the results. You can also save references to queries in Wiki content, as described below.

Note: one way to easily build queries like the ones below, you can build and test the queries in the Custom report module and when ready - click Save query. This will build the query string for you. All you need to do is remove the extra line breaks.

Note: you must have the REPORT_CREATE permission in order to save queries to the list of default reports. The Save query button will only appear if you are logged in as a user that has been granted this permission. If your account does not have permission to create reports, you can still use the methods below to save a query.

You may want to save some queries so that you can come back to them later. You can do this by making a link to the query from any Wiki page.

[query:status=new|assigned|reopened&version=1.0 Active tickets against 1.0]

Which is displayed as:

Active tickets against 1.0

This uses a very simple query language to specify the criteria (see Query Language).

Alternatively, you can copy the query string of a query and paste that into the Wiki link, including the leading ? character:

[query:?status=new&status=assigned&status=reopened&group=owner Assigned tickets by owner]

Which is displayed as:

Assigned tickets by owner

Using the [[TicketQuery]] Macro

The TicketQuery macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.

Example:

[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]

This is displayed as:

#37
gramsci needs updates
#69
chavez.mayfirst.org TLS certificate expired
#83
Forever Isn't
#120
Are postgresql databases available to MFPL members?
#132
Be clear about Drupal login vs May First login
#150
Thinking about a different approach to membership blogs
#189
Re podcast problem
#272
How to change header, etc.
#301
Pumpkin (new shared hosting installer) should force users of phpmyadmin to use https
#306
GVSHP, cannot set up working email accounts with Outlook
#329
transfer CircusAmok.org
#342
Unable to Use Because Files Directory Not Writable
#344
still permission denied to SFTP style sheet to resistinmarch
#354
Still have odbc problems
#377
I can't find our current group office
#385
mailman list not responding
#393
MX Record / A Record
#398
Internationalization of our trac installation
#401
New Blog
#442
https://members.dev.mayfirst.org/ is a user account page, with no evident access to webmail
#451
centralized webmail should be able to guess the user's "home" server
#468
Vulnerability in Blogs site
#471
Further on ticket #470
#472
Yet further on ticket #470
#473
Problem with webmail
#474
Development Server for Drupal
#486
can't get email
#493
email domain mix up
#504
List post delayed for two hours
#518
Question about answer to ticket # 517
#540
reopen ticket
#565
website log in - still having problems
#617
Blast fax-email problem again
#644
still need a little help
#650
Users should have the ability to create new mysql database via the members control panel
#660
Storage reccomendation
#697
Move backup system to zinn
#741
Hard Error
#757
graphical menu
#760
Switch viewsic's Drupal setup from using multi-site to using symlinks
#763
Members should be able to setup awstats themselves
#836
Some articles not visible on After Downing Street
#840
restrict ftp access (#833 cont.).
#843
Mailman Archive Help
#873
Increase file upload size
#889
Blackberry reply email not working
#917
More Info Needed
#919
Setup new servers to test IPv6 connectivity
#929
private tickets
#940
autonomedia needs assistance in website setup
#968
Drupal "node queue" function on our website "frozen"
#981
new account on survey.dev.mayfirst.org
#988
Do you provide access via WebDAV?
#1052
sites down
#1101
please take page off "stick at top"
#1109
lost emails?
#1205
theme fixed, module not
#1208
Convert ticket tracking database from sqlite to postgres
#1216
mx record for domain local340unite.com
#1250
account password
#1271
error message and next month
#1272
site was down early morning
#1273
same error message each time
#1316
Stat package for Drupal sites
#1327
E mail configured wierdly as sent
#1349
Data storage
#1417
change hugoballz.com to buschmanninc.com
#1427
Setup new standard server on new hardware purchase
#1434
please switch hugoballz.com into buschmanninc.com
#1448
releasing the site
#1503
Mayfirst installing SSL certificates for members
#1510
Need a way to expire old tickets
#1511
deleting email addresses
#1553
drupal upgrade for madness radio site
#1589
script for email subscription
#1602
I'm in for the Malcolm X Museum Upgrade
#1617
new IPs?
#1651
Albizu down again, I think
#1658
Migrate globaljusticenow sites to new server
#1700
Yahoo members are not receiving the CLG Newsletter
#1714
adobe contribution conection problem
#1715
Follow-up post for Ticket #1709 (Mailing list file)
#1771
Unable to reload website page
#1785
configure second remote power rpc device
#1808
Can I set up a user that can ftp in and only upload/download files from a particular directory on the server?
#1849
Email setup question
#1861
wordpress db install
#1904
Re: Ticket #1902: Security certificate error
#1941
Hosting a new web-blog for NESRI???
#2008
drupal upgrades
#2017
really urgen: no Chavez Email
#2023
drupal upgrade
#2061
Secure ftp via the web
#2070
deleting attached image on page-drupal
#2083
problems setting up email account
#2111
Drupal Upgrade
#2236
Spammers & Backlinkers Help
#2254
Hey Jamie, need to talk
#2260
new blogger account
#2287
Email is replicating itself yikes
#2297
FTP access, mysql database set up and mod_rewrite needs ...
#2349
sftp issues?
#2354
someone sent me this
#2375
question on database import
#2398
deleted a file, how to access backup?
#2411
New Database for PHPBB3 conversion
#2414
New Member Welcome E-mail
#2426
new control panel email list edit feature
#2433
password
#2437
Members Control Panel: Email address pager broken
#2441
denied access to server
#2442
problems deleting directory folders
#2450
Install SSL Certificate
#2506
Sending two files from Account debtorsanon for PBX upload
#2513
meetings.mayfirst.org: reporting
#2523
Creating a Paper Tiger Blog in Drupal
#2524
May First/People Link's central drupal installation should be able to handle translations
#2525
Ok, now I have the blog up and running...
#2526
Paper Tiger FTP Information + apology
#2531
E-mail removal from listserve
#2567
Adding drupal to "studentsorsoldiers.org"
#2568
need password
#2589
New Site
#2596
Can't access the mysql-details file
#2641
cannot login in billing contact email to reset website password
#2669
pls ignore the last ticket re: consolidation of emails
#2678
drupal upgrade
#2693
Replace disk on kiyoshi
#2710
redirecting pointer/interface page/website hosting regarding ticket 2706
#2713
redirecting pointer/interface page/website hosting regarding ticket 2706 and 2710
#2747
Please delete this file
#2757
Requesting Dedicated IP Address for www.LSNTAP.org
#2765
Drupal Upgrade
#2770
Domain Aliases Not Working!!
#2776
dreamweaver crashing or error on upload with contact administrator message.
#2800
Not seeing sent mail
#2810
please can we upgrade ADS Drupal?
#2832
need keyboard-interactive authentication
#2856
Exporting from Excel
#2922
To clarify previous ticket
#2960
Asking for a MySQL Database
#3032
reverse DNS peculiarities on some HE-allocated subnets
#3052
mf-drupalize suggestions
#3066
Integrating MailMan into Wordpress site (clarify earlier ticket)
#3152
Can I add categories to a feed?
#3219
Democracy Uprising MailMan
#3228
Posting to our website
#3248
ibew25.org went down
#3275
Sites Are Down
#3282
Max needs his group office email back
#3284
lumumba down
#3289
Server Down?
#3318
Mailman 'stuck' - subscribe/unsub notices not processing, newsletter not flying
#3337
AIDS LIbrary website and problems with Moodle
#3357
Jamie - If there's any way you can call/email me - we need your help!
#3358
Hosting order
#3365
switching from Register.com
#3383
name accompanying email address is misspelled
#3410
More LimeSurvey
#3415
Jones Sites Are Down!
#3446
Accessing the foodshedmarket.com directory
#3478
Cannot log in
#3489
Transfer New Site for www.dignityinschools.org
#3521
dev.dignityinschools.org to go live
#3545
Deleting "Out of Office" Receipts
#3579
purchase a new server
#3602
what caused telehouse outage 2010-11-07
#3696
Server Access control panel should be monkeysphere aware
#3756
still having trouble with password
#3800
upgrade disks on fred.mayfirst.org
#3852
adjust resource limits for makhno
#3861
masslegal.org mysql tables
#3884
Call hurricane electric to reboot goofball
#3892
Server Load has been over 70 on daza
#3907
Client experiencing site, occaisionally, as non-responsive.
#3910
missing service advisories for the last month
#3925
Recipient address rejected / address abandoned delivery refusal
#3944
Killing a KVM guest locks network on host
#3976
Not sending emails
#3989
Site Down
#3992
Out of space on /var on chavez
#4013
On audio listening online, users complain file stops in middle
#4040
we need safe streets password sent
#4052
Improve sessions table expiration by default on Drupal 6 installs
#4101
sanctuarymovement.org recovery
#4113
User can't connect to server
#4118
Latency and ssh login problems on June
#4146
jojobe.mayfirst.org (mfpl nagios webui) should use only https, not http
#4232
Cannot see all of Critpath websites
#4234
AIDS Library Websitehas been hacked
#4252
Re: email backup
#4280
Don't use SSL anymore
#4302
Autonomedia online bookstore is down
#4321
error msgs at top of charlottesvillepeace.org
#4344
Website receiving errors after server update
#4354
please help with a question, need my host and username, I know my password
#4362
stopping allende on vilma
#4384
Okay, I installed WYSIWYG, but...
#4385
Trying again w/email...
#4386
Sorry, but you can see that this is getting to me... : )
#4395
Pictures and text edits not displaying on website
#4412
Hard Drive Mounting Screws (and hard drive?)
#4415
USB Drive in Ken
#4465
support.mayfirst.org doesn't return you to your page after login
#4472
not receiving emails again
#4509
NOT DUPLICATE - NEW NOTICE - Notice of Claimed Infringement - Case ID 1353310013
#4511
site is off-line
#4513
move my website over...for real this time
#4558
Automatically created cron jobs don't work for Drupal 7
#4569
Two quick quentions
#4613
cant log in to MayFirst to file ticket or request help
#4626
openid server cancels login if you are already logged in
#4684
email not working
#4685
URGENT - cannot get into Portside queue or Listserve
#4693
Wordpress as Web App
#4715
mirror mayfirst.org on XO server
#4718
SSL certificate for Startingbloc.org
#4754
SSL certficate issues
#4784
Followup on https://support.mayfirst.org/ticket/4736
#4797
upgrade disks on fred
#4809
PHP problems with startingblo.org's checkout
#4842
Git repo for Occupy Vancouver website
#4855
Expired x509 certificate for keys.mayfirst.org
#4862
Git repo for Occupy Vancouver web
#4876
disappeared mailing lists
#4892
login
#4910
Certificate errors are starting again
#4950
Fatal error on every attempt to create content
#4972
can't login to support system
#4994
Website is down
#5001
Website Space Problem
#5016
Cannot get into IMP mail
#5051
SMTP mail is timing out Please check
#5054
baileyscafe.org is down
#5161
Limesurvey access?
#5197
setup caching dns server on each host
#5274
Web Configuration ServerAlias Error?
#5279
How should we install python modules?
#5297
Spec and Implement a filesystem checker in freepuppet
#5422
Unable to upload file on USSF wiki
#5439
New MFPL Members in February
#5473
marx RAM increase, tresca RAM decrease
#5478
Password for Control Panel
#5479
Google Postini block
#5490
File gone again
#5500
Upgrade to Drush 5?
#5505
Website down
#5516
ignore last ticket please (request for hard reboot)
#5517
assata.mayfirst.org is in SORBS spam directory
#5521
continued problem with password
#5534
AutoResponder Not Working
#5538
advancing justice/apalc site: Need change in directory owner
#5546
login to http://blogs.mayfirst.org/ using MF/PL openid hangs/fails
#5620
Is there a site monitoring tool used by MFPL?
#5621
CP Wordpress Website will not load/loads very slowly
#5625
Install Trac Tagging plugin
#5694
IMap seems to be down on Kerr
#5702
Add Keyword autocomplete suggestions to trac
#5713
install new server in telehouse
#5727
unable to access server
#5743
kvm-manager requires distinct MAC address for virtual guests
#5769
Can MayFirst use a different server for mailing lists to circumvent SORBS' Assata block?
#5786
AT&T and its domains are (suddenly) blocking CLG Newsletter
#5803
Please Call IMMEDIATELY - EMAIL Server Completely Down
#5829
Cannot get into list-serv
#5836
Another hard error ...
#5846
Website: www.youth4justice.org not working - PLEASE HELP
#5847
Site in Forbidden State
#5852
Requesting additional IP address for SSL
#5888
never mind kesey not coming back!
#5915
Webmail still not working
#6011
Restore Default Settings
#6064
interoccupy.net Error establishing a database connection
#6082
Password Reset Problems
#6101
Deleted user account caused a Hard Error
#6152
fflic.org
#6165
Critpath Email Server Down
#6181
Starting Bloc
#6189
Error 503 website is interemitentgly unresponsive today
#6219
Spam problem continued
#6249
SSL Certificate for Fight.org
#6252
Still need user name
#6253
21DaysCambridge.org Problem
#6296
Right to the City site down
#6350
disable ckeditor module
#6357
Deleting on RoundCube
#6374
one IP address slamming bernsteintapes.com
#6382
Ideas for taking translation of service-advisories
#6397
Mumble to Icecast
#6411
Junk Email
#6425
CLG Newsletters not reaching rr.com, roadrunner.com, adelphia.net
#6441
Site is down
#6447
mls is down
#6482
Secure pages on jewishvoiceforpeace.org not available
#6518
can't login to the support system!
#6520
endless loop from support login to openID to support login
#6523
Shared varnish configuration page needs updating
#6545
Site repeatedly going off line, modules disabled, errors being thrown
#6565
Trouble logging into server
#6576
membership info
#6589
PhillyBlack Pride
#6633
apt-get update, sent same warning on several servers
#6640
ID system gets confused if you're logged into control panel & support w/different accounts
#6641
Cannot load email account
#6692
i want to receive mail at a second mayfirst email address
#6703
javascript problem
#6742
no response to ticket 6717
#6745
Question About Your Services
#6777
no response from two previous tickets re dreamweaver and home page
#6779
MySQL databe creation should default to utf8?
#6821
Translation Aaron Swarz Feb13 Lowdown
#6846
migrating emails 2
#6881
Need To Reset MySQL Server So Site Goes Back Online
#6882
Explore use of GroupServer for Lists
#6893
Drupal 7 authorize.php could not found
#6898
Roundcube filters
#6909
TOO MUCH SPAM getting through
#6927
Site slow and periodically offline
#6968
daza - Internal Server error
#6974
CPU and disk I/O contention on ottorene
#6976
Thunderbird server certificate
#7005
High Load on June
#7008
how to set Reply in a discussion list
#7023
Oaklandrising.org giving 503 error
#7085
Notice of outage on Email
#7097
Configure Apache to support multiple SSL sites on a single IP address
#7112
ThisCantBeHappening.net is not available this morning using any browser
#7117
Changed password and forgot it
#7128
need to give a user additional permissions
#7140
cannot log on
#7141
Need Assistance Setting up CiviMail
#7149
Finalize new server setup for wolf.mayfirst.org
#7153
site inaccessible, in browser and SFTP
#7162
not sure my ticket went through
#7168
following up on ticket 7161
#7169
following up on ticket 7161
#7171
Email not apperas to be now sending
#7173
#7159: decidiresunderecho.org hosted on mx1 is down
#7186
again messages not going out to Mods list using Mailman -think this is Stallman
#7254
Dedicated IP for HTTPS access
#7267
New signature won't save
#7288
dns routing
#7289
routing dns
#7306
Alternate ROOTS SSL Certificate
#7316
Disappeared all messages from my inbox and also my contact list
#7320
nueva lista - palestinaderechoshumanos
#7335
I have an open ticket
#7390
build a "what if?" OpenPGP certification verification monitor
#7407
setting up email adress
#7417
trouble leaves a repository in a locked state when user cancels
#7435
Need to move a Hosting Order
#7472
My password is not working on my webmail
#7511
SMTP errors email accounts
#7512
This Can't be Happening Latent
#7531
Help getting and setting up SSL for website
#7541
Roundcube webmail dropping connection for a single user
#7542
/ on fannie.mayfirst.org is full
#7546
Constant Bounces on Galaei
#7547
Slow emails coming through
#7549
In regards to Ticket, 7548
#7571
slow site
#7574
Bounces still happening at GALAEI
#7581
URGENT donate page does not work and people are trying to donate -its a mess!
#7598
Username
#7599
fatal error
#7614
import wordpress database sql file
#7616
Import Wordpress sql Database File
#7648
Critical Path not working
#7712
No se descargan los corroes del servidor de laneta al thunderbird de mi computadora
#7718
No se descargan los correos del servidor de la Neta a mi Thunderbird
#7763
login problem
#7799
spam is not being properly identified
#7827
add email dialog options obscured by blue popups
#7848
emails bouncing to hotmail accounts
#7861
Need to update SSL certificate for "lists.critpath.org"
#7862
dignityinschools.org website down - urgent!
#7892
Website is down
#7917
EMERGENCY- OUR SITE IS DOWN
#7918
Still unable to delete emails
#7933
Urgent: Website Not Loading
#7934
Urgent: Website Not Loading
#7949
I deleted the user I was logged in with the members control panel, makes a persistent whitepage in the browser
#8012
disabling DNS records in control panel did not make them go away
#8143
CSR Request for www.fight.org
#8144
my site isn't loading
#8176
Permanent application process
#8229
need new password for TCBH member Gary Lindorff
#8262
our site is off line for some reason
#8341
Urge com unicacion para reactivar mi email
#8345
NO TENGO ACCESO A MIS EMAILS
#8375
purchase new physical server
#8385
Error Messages Displaying on dreamschoolnyc.org website
#8389
Issue with Drupal for Facebook Mod
#8395
All Sites on chelsea.mayfirst.org are Down
#8417
Unwanted links appearing on website
#8420
adding a home link to members.MF control panel
#8465
Shell and CP access to Hashmi
#8492
Jubilee USA hacked
#8505
ensure data integrity of the control panel database
#8539
No email at all, AGAIN, two business days in a row!! YIKES!!
#8541
FTP
#8562
ticket 8554
#8658
Suddenly, content 'rearranged' on CLG pages; HTML editing disabled
#8674
Error 503! en Cimac
#8694
Non urgent question about spam
#8876
email access problems for some users at rutgersaaup.org domain name
#8877
email access problems for some users at rutgersaaup.org domain name
#8878
email access problems for some users at rutgersaaup.org domain name
#8879
unable to login
#8930
upgrade roundcube to 1.0.0
#8953
heartbleed
#8966
no recibó ni puedo enviar mensajes
#8995
Sites on marx not loading or errors.
#9074
Getting an error uploading a file to a ticket
#9233
Drupal install link
#9559
cw2.mayfirst.org not working
#9563
drupal error - urgent
#9578
No response to my earlier ticket
#9611
Listserv modification - this has been pending for six weeks
#9632
Problemas con la dirección electrónica servicios@tlatolli.com
#9712
Listserves Not Working
#9713
Cannot connect to list
#9717
Website Broken
#9722
keep getting bounce backs
#9728
emails continue to bounce when sending to certain addresses
#9795
PCI compliance
#9807
Getting Drupal Setup
#9823
Drupal 7.29
#9827
Mailman bug?
#9828
DWN listserv seems to be down
#9834
SSL CERTIFICATE
#9858
nginx on viewsic
#9885
Security salt BBB for http://ctamlibre.org
#9901
Email list: cannot submit pending requests
#9910
Place wagingnonviolence.org behind varnish cache
#9980
email and website URLs do not match
#9999
Slow everything
#10002
slow website / service unavailable
#10003
Web site down
#10057
website down
#10132
urgent help needed: site down
#10227
Can't Login on Phone
#10285
Double copies triggered of CLG Newsletters for *months* - please help!
#10302
Problem with receiving email form Jan 7, 2015
#10320
Website down
#10326
Website down again
#10327
Encoding problem with new postgres DB on ossie
#10341
SRLP email down
#10398
Website down
#10413
.htaccess not working
#10469
Error Message CiviCRM while sending out Email Blast
#10479
Email list does not allow posting without administrator approval - how can I change this??
#10495
Reopen Ticket #10486
#10507
Interoccupy.net is down
#10511
Cómo vincular el dominio, el templete y el hosting
#10611
Website Transfer
#10624
Upgrading Drush on June, Installing Composer
#10678
Esta es una solicitud para migrar las cuentas de correo según ustedes lo han sugirido para los usuarios de laneta en México. This is a request in order to fulfill de procedures that you need in order to migrate de accouns of laneta in México.
#10686
Jaime, en la PC donde tengo instalado thunderbird me sigue pidiendo la contraseña "maestra" para bajar los correos de entrada.
#10708
email server keeps disconnecting
#10781
Two questions on Drupal 6 issues
#10794
PHP Redis Library: Predis\Connection\ConnectionException: Connection refused [tcp://127.0.0.1:6379]
#10801
respuesta
#10831
Problems switching from courier to dovecot ossie
#10852
Sigue el problema
#10866
I need to know the IP address of the server that USI Civi CRM database is on?
#10983
existing ticket: #10979: problem sending
#10986
getting in touch re ticket #10591
#10991
Nuevamente FALLA mi login para RECIBIR correo
#11097
NO PUEDO RECIBIR NI ENVIAR MENSAJES
#11106
auxilio
#11110
Web configuration issue
#11144
mandarininschools.org compromised
#11172
Unable to do ssh login from the terminal
#11212
artragegallery.org compromised
#11336
Add Drupal 8 as Web application
#11351
Need help configuring audio stream
#11373
website loading very slowly
#11391
mover DNS mail a MFPL
#11400
npm (package manager for Node.js) on ossie
#11474
Apache Proxy to access NodeJs server - Shared server
#11522
postgresql 9.1 to 9.4 migration
#11548
Strange situation
#11574
Screenshot showing hosttor.com not resolving to IP 216.66.23.38
#11617
We cant send any e mails out
#11716
We can´t connect to the hosting
#11732
Migrating local site to live site using Duplicator and Cyberduck
#11745
Roundcube incorrectly allows case-insensitive logins
#11816
Problem showing multilingual civicrm in a view
#11842
Connection problems.
#11847
We can´t connect to the hosting
#11848
We can´t connect to the hosting
#11961
WarIsACrime.org is gone
#11962
Seriously Urgent - Please at Least Acknowledge
#11975
URGENT: worldbeyondwar.org down AGAIN and needed urgently
#11978
Site down
#12061
https://desinformemonos.org/ 503 Service Temporarily Unavailable nginx/1.6.2
#12166
Spam II
#12253
Civi not loading
#12335
mysql on ossie died with out of memory error
#12338
Not abel to send or receive email
#12360
Urgente ayuda
#12404
can't send e-mail
#12408
Help with web page
#12440
XMPP authentication error in Gajim and sometimes Conversations
#12453
SITE COMPLETELY DOWN
#12454
CVH Power Website is down!
#12487
apache2 sometimes dies on chavez with strange error in logs
#12506
Increase file upload size
#12514
Civi again not working
#12610
no puedo configurar el dns
#12621
Necesito saber mi dirección DNS
#12622
Necesito saber mi dirección DNS
#12628
Civi/website
#12690
healthcare-now.org is down
#12730
SMW 17 AN UALOCAL7 MAYBE MORE DOWN AGAIN OR EXTREME ISSUES
#12744
Pauline Sites Timing Out Again
#12808
Site down
#12857
Not receiving emails
#12884
UHAB Website Ticket # 12893
#13140
Outgoing email not working
#13168
Instalación Wordpress
#13230
Running into a max_user_connections error on juanita
#13319
fflic.org down, seeing server errors
#13377
tech support assistance
#13383
OAuth access to MayFirst OpenIDs
#13396
allowing security monitoring
#13435
Correos rechazados de la cuenta: junax@laneta.apc.org
#13520
Mayfirst System Glitch?
#13523
Upload/Page Creation Error
#13527
Full site backup and Update script
#13530
Full site backup and Update script
#13627
site compromised
#13628
Website down
#13744
Left Forum Website we cannot upload images....
#13759
Site not loading
#13785
Asesoría instalación de aplicación
#13817
Trouble Setting Up WordPress FTP for Auto-Update
#13871
Deflect edges are being rejected
#13895
NextCloud - can't access files
#13896
Problem accessing nextcloud
#13901
pleroma install?
#13954
¿Es posible acceder al servidor por medio de una llave SSH?
#13955
¿Es posible acceder al servidor por medio de una llave SSH?
#14103
URGENT - nhlp.mayfirst.org
#14280
No podemos ingresar noticias en nuestro blog

Just like the query: wiki links, the parameter of this macro expects a query string formatted according to the rules of the simple ticket query language. This also allows displaying the link and description of a single ticket:

[[TicketQuery(id=123)]]

This is displayed as:

#123
Move fflic backup off of richie

A more compact representation without the ticket summaries is also available:

[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]

This is displayed as:

#37, #69, #83, #120, #132, #150, #189, #272, #301, #306, #329, #342, #344, #354, #377, #385, #393, #398, #401, #442, #451, #468, #471, #472, #473, #474, #486, #493, #504, #518, #540, #565, #617, #644, #650, #660, #697, #741, #757, #760, #763, #836, #840, #843, #873, #889, #917, #919, #929, #940, #968, #981, #988, #1052, #1101, #1109, #1205, #1208, #1216, #1250, #1271, #1272, #1273, #1316, #1327, #1349, #1417, #1427, #1434, #1448, #1503, #1510, #1511, #1553, #1589, #1602, #1617, #1651, #1658, #1700, #1714, #1715, #1771, #1785, #1808, #1849, #1861, #1904, #1941, #2008, #2017, #2023, #2061, #2070, #2083, #2111, #2236, #2254, #2260, #2287, #2297, #2349, #2354, #2375, #2398, #2411, #2414, #2426, #2433, #2437, #2441, #2442, #2450, #2506, #2513, #2523, #2524, #2525, #2526, #2531, #2567, #2568, #2589, #2596, #2641, #2669, #2678, #2693, #2710, #2713, #2747, #2757, #2765, #2770, #2776, #2800, #2810, #2832, #2856, #2922, #2960, #3032, #3052, #3066, #3152, #3219, #3228, #3248, #3275, #3282, #3284, #3289, #3318, #3337, #3357, #3358, #3365, #3383, #3410, #3415, #3446, #3478, #3489, #3521, #3545, #3579, #3602, #3696, #3756, #3800, #3852, #3861, #3884, #3892, #3907, #3910, #3925, #3944, #3976, #3989, #3992, #4013, #4040, #4052, #4101, #4113, #4118, #4146, #4232, #4234, #4252, #4280, #4302, #4321, #4344, #4354, #4362, #4384, #4385, #4386, #4395, #4412, #4415, #4465, #4472, #4509, #4511, #4513, #4558, #4569, #4613, #4626, #4684, #4685, #4693, #4715, #4718, #4754, #4784, #4797, #4809, #4842, #4855, #4862, #4876, #4892, #4910, #4950, #4972, #4994, #5001, #5016, #5051, #5054, #5161, #5197, #5274, #5279, #5297, #5422, #5439, #5473, #5478, #5479, #5490, #5500, #5505, #5516, #5517, #5521, #5534, #5538, #5546, #5620, #5621, #5625, #5694, #5702, #5713, #5727, #5743, #5769, #5786, #5803, #5829, #5836, #5846, #5847, #5852, #5888, #5915, #6011, #6064, #6082, #6101, #6152, #6165, #6181, #6189, #6219, #6249, #6252, #6253, #6296, #6350, #6357, #6374, #6382, #6397, #6411, #6425, #6441, #6447, #6482, #6518, #6520, #6523, #6545, #6565, #6576, #6589, #6633, #6640, #6641, #6692, #6703, #6742, #6745, #6777, #6779, #6821, #6846, #6881, #6882, #6893, #6898, #6909, #6927, #6968, #6974, #6976, #7005, #7008, #7023, #7085, #7097, #7112, #7117, #7128, #7140, #7141, #7149, #7153, #7162, #7168, #7169, #7171, #7173, #7186, #7254, #7267, #7288, #7289, #7306, #7316, #7320, #7335, #7390, #7407, #7417, #7435, #7472, #7511, #7512, #7531, #7541, #7542, #7546, #7547, #7549, #7571, #7574, #7581, #7598, #7599, #7614, #7616, #7648, #7712, #7718, #7763, #7799, #7827, #7848, #7861, #7862, #7892, #7917, #7918, #7933, #7934, #7949, #8012, #8143, #8144, #8176, #8229, #8262, #8341, #8345, #8375, #8385, #8389, #8395, #8417, #8420, #8465, #8492, #8505, #8539, #8541, #8562, #8658, #8674, #8694, #8876, #8877, #8878, #8879, #8930, #8953, #8966, #8995, #9074, #9233, #9559, #9563, #9578, #9611, #9632, #9712, #9713, #9717, #9722, #9728, #9795, #9807, #9823, #9827, #9828, #9834, #9858, #9885, #9901, #9910, #9980, #9999, #10002, #10003, #10057, #10132, #10227, #10285, #10302, #10320, #10326, #10327, #10341, #10398, #10413, #10469, #10479, #10495, #10507, #10511, #10611, #10624, #10678, #10686, #10708, #10781, #10794, #10801, #10831, #10852, #10866, #10983, #10986, #10991, #11097, #11106, #11110, #11144, #11172, #11212, #11336, #11351, #11373, #11391, #11400, #11474, #11522, #11548, #11574, #11617, #11716, #11732, #11745, #11816, #11842, #11847, #11848, #11961, #11962, #11975, #11978, #12061, #12166, #12253, #12335, #12338, #12360, #12404, #12408, #12440, #12453, #12454, #12487, #12506, #12514, #12610, #12621, #12622, #12628, #12690, #12730, #12744, #12808, #12857, #12884, #13140, #13168, #13230, #13319, #13377, #13383, #13396, #13435, #13520, #13523, #13527, #13530, #13627, #13628, #13744, #13759, #13785, #13817, #13871, #13895, #13896, #13901, #13954, #13955, #14103, #14280

Finally, if you wish to receive only the number of defects that match the query, use the count parameter.

[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]

This is displayed as:

567

Customizing the table format

You can also customize the columns displayed in the table format (format=table) by using col=<field> - you can specify multiple fields and what order they are displayed by placing pipes (|) between the columns like below:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]

This is displayed as:

Results (1 - 3 of 11142)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#14330 fixed Problemas con certificado de sitio Web guancascodemedios.org https://id.mayfirst.org/jaimev https://id.mayfirst.org/comppa
#14329 fixed idepsca.org returns a HTTP status code of 500 https://id.mayfirst.org/bdrr
#14324 fixed Mail no recibido https://id.mayfirst.org/martin.s
1 2 3 4 5 6 7 8 9 10 11

Full rows

In table format you can also have full rows by using rows=<field> like below:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]

This is displayed as:

Results (1 - 3 of 11142)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#14330 fixed Problemas con certificado de sitio Web guancascodemedios.org https://id.mayfirst.org/jaimev https://id.mayfirst.org/comppa
Description

al intentar ingresar a la pagina web guancascosdemedios.org nos aparece esto, agradeceriamos su apoyo

guancascodemedios.org usa un certificado de seguridad no válido. El certificado es válido solo para claudette.mayfirst.org. Código de error: SSL_ERROR_BAD_CERT_DOMAIN

https://guancascodemedios.org/admin No es posible comunicar de forma segura con el otro extremo de la conexión porque el nombre de dominio solicitado no coincide con el certificado del servidor. Seguridad de transporte HTTP estricta: false Fijar clave pública HTTP: false

gracias

#14329 fixed idepsca.org returns a HTTP status code of 500 https://id.mayfirst.org/bdrr
Description

Hi Jaime,

When we last discussed the upgrade plan for idepsca.org below the following steps were outlined.

Update plan to upgrade to Drupal 7

  • Put a maintenance page up [1].
  • Using the Drupal admin account, change the theme to Garland in Drupal 6 from the existing theme (Newsflash) [2].
  • Upload the Drupal 7 Newsflash theme [3] via SFTP to jxxx.mayfirst.org [4].
  • Update the Web App via the May 1st Control Panel to Drupal 7 [5].
  • Run the database upgrade [6].
  • Change the theme to Newsflash in Drupal 7 under the "Appearances" section.
  • Verify functionality and if needed, remove the maintenance page.

[1] http://idepsca.org/admin/settings/site-maintenance
[2] http://idepsca.org/admin/build/themes
[3] https://www.drupal.org/project/newsflash
[4] https://support.mayfirst.org/wiki/faq/files/sftp
[5] https://members.mayfirst.org/cp/index.php
[6] http://idepsca.org/update.php?op=info

The issue is that after the database upgrade the site returns a 500 and because of that, the admin pages are unavailable and we can't change the theme and bring the site back up. Can you please take a look?

$ curl -D - -so /dev/null http://idepsca.org | grep ^HTTP
HTTP/1.1 500 Internal Server Error

The only errors seen from the database update was due to modules that had been moved before or during our conversation.

Error message

    User warning: The following module is missing from the file system: calendar_block. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: civicrm. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: fckeditor. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: upload. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: calendar_block. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: civicrm. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: fckeditor. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).
    User warning: The following module is missing from the file system: upload. For information about how to fix this, see the documentation page. in _drupal_trigger_error_with_delayed_logging() (line 1143 of /usr/local/share/drupal-7.60/includes/bootstrap.inc).

Can you please take a look?

Many thanks,
Ray

#14324 fixed Mail no recibido https://id.mayfirst.org/martin.s
Description

Hola, estoy intentando configurar una nueva dirección de correo en el dominio latamleaks.lat, esta es una redirección. Al hacer un envío de pruebas, recibo un error 454. El DNS está configurado así:

@ 10800 IN SOA ns1.gandi.net. hostmaster.gandi.net. 1543967705 10800 3600 604800 10800
@ 10800 IN A 162.247.75.222
@ 10800 IN MX 10 mail.mayfirst.org.
@ 10800 IN TXT "v=spf1 mx a:erica.mayfirst.org include:erica.mayfirst.org ?all"
webmail 10800 IN CNAME webmail.gandi.net.
www 10800 IN CNAME webredir.vip.gandi.net.

Y este es el error recibido:

Reporting-MTA: dns; googlemail.com
Received-From-MTA: dns; XXXXXX@gmail.com
Arrival-Date: Tue, 11 Dec 2018 11:02:57 -0800 (PST)
X-Original-Message-ID: <e61193f5-1f1f-3e74-9f7c-5e3092487de8@gmail.com>

Final-Recipient: rfc822; hola@latamleaks.lat
Action: delayed
Status: 4.7.1
Remote-MTA: dns; mail.mayfirst.org. (216.66.22.57, the server for the domain latamleaks.lat.)
Diagnostic-Code: smtp; 454 4.7.1 <hola@latamleaks.lat>: Relay access denied
Last-Attempt-Date: Wed, 12 Dec 2018 12:10:30 -0800 (PST)
Will-Retry-Until: Fri, 14 Dec 2018 11:02:58 -0800 (PST)

Me podrían ayudar a configurarlo bien, por favor? Muchas gracias.

1 2 3 4 5 6 7 8 9 10 11

Query Language

query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Basically, the filters are separated by ampersands (&). Each filter then consists of the ticket field name, an operator, and one or more values. More than one value are separated by a pipe (|), meaning that the filter matches any of the values. To include a literal & or | in a value, escape the character with a backslash (\).

The available operators are:

= the field content exactly matches one of the values
~= the field content contains one or more of the values
^= the field content starts with one of the values
$= the field content ends with one of the values

All of these operators can also be negated:

!= the field content matches none of the values
!~= the field content does not contain any of the values
!^= the field content does not start with any of the values
!$= the field content does not end with any of the values

The date fields created and modified can be constrained by using the = operator and specifying a value containing two dates separated by two dots (..). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be left out to avoid having to quote the query string.

created=2007-01-01..2008-01-01 query tickets created in 2007
created=lastmonth..thismonth query tickets created during the previous month
modified=1weekago.. query tickets that have been modified in the last week
modified=..30daysago query tickets that have been inactive for the last 30 days

See also: TracTickets, TracReports, TracGuide

Last modified 6 years ago Last modified on Nov 6, 2012, 2:22:02 AM