Jump to content

Bike Collectives Wiki

Some Firefox users may need to log in more than once to log in. It's a known Firefox bug. Check "keep me logged in," it might help.

Es posible que algunxs usuarixs de Firefox tengan que conectarse más de una vez para iniciar sesión. Es un error conocido de Firefox. Marca "keep me logged in" (mantenerme conectado), puede ayudar.

CargoScheduleTest: Difference between revisions

From Bike Collectives Wiki

Revision as of 03:46, 28 October 2022

Error: The SQL function "CONVERT_TZ()" is not allowed.

Retrieved from "https://wiki2.bikelover.org/wiki/index.php?title=CargoScheduleTest&oldid=49387"

Debug data:

Start request GET /wiki/index.php?diff=49387&oldid=49383&title=CargoScheduleTest IP: 172.18.0.2 HTTP HEADERS: ACCEPT-ENCODING: gzip, br, zstd, deflate USER-AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) ACCEPT: */* X-ORIGINAL-URI: /wiki/index.php?diff=49387&oldid=49383&title=CargoScheduleTest X-FORWARDED-PORT: 443 X-FORWARDED-SSL: on X-FORWARDED-PROTO: https X-FORWARDED-FOR: 18.220.94.189 X-REAL-IP: 18.220.94.189 CONNECTION: close HOST: wiki2.bikelover.org CONTENT-LENGTH: CONTENT-TYPE: (end headers)
[session] SessionManager using store APCUBagOStuff
[localisation] LocalisationCache using store LCStoreCDB
[session] SessionBackend "nj3c41klrlgdhug0au7gsg7q0qnhneo9" is unsaved, marking dirty in constructor
[session] SessionBackend "nj3c41klrlgdhug0au7gsg7q0qnhneo9" save: dataDirty=1 metaDirty=1 forcePersist=0
[cookie] already deleted setcookie: "bikebike_mw__session", "", "1706457756", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "bikebike_mw_UserID", "", "1706457756", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "bikebike_mw_Token", "", "1706457756", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "forceHTTPS", "", "1706457756", "/", "", "", "1", ""
[session] SessionBackend "nj3c41klrlgdhug0au7gsg7q0qnhneo9" data dirty due to dirty(): MediaWiki\Session\SessionManager->getSessionForRequest/MediaWiki\Session\SessionManager->getInitialSession/MediaWiki\Session\Session->getToken/MediaWiki\Session\Session->set/MediaWiki\Session\SessionBackend->dirty
[session] SessionBackend "nj3c41klrlgdhug0au7gsg7q0qnhneo9" save: dataDirty=1 metaDirty=0 forcePersist=0
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0s] database_staging: SET group_concat_max_len = 262144, `sql_mode` = ''
[DBReplication] Wikimedia\Rdbms\LBFactory::getChronologyProtector: request info { "IPAddress": "172.18.0.2", "UserAgent": "Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\/1.0; +claudebot@anthropic.com)", "ChronologyProtection": false, "ChronologyPositionIndex": 0, "ChronologyClientId": false }
[DBReplication] ChronologyProtector using store APCUBagOStuff
[DBReplication] ChronologyProtector fetching positions for 00aba87f0d2b34d22fa7da60bd405aff
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::applySessionReplicationPosition: DEFAULT (database_staging) has no position
[DBConnection] Wikimedia\Rdbms\LoadBalancer::lazyLoadReplicationPositions: executed chronology callback.
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new connection for local/0
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds) [0s] database_staging: BEGIN
[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 49383 LIMIT 1
[SQLBagOStuff] MainObjectStash using store ReplicatedBagOStuff
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] WikiPage::pageData [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `mw_page` WHERE page_namespace = 0 AND page_title = 'CargoScheduleTest' LIMIT 1
[ContentHandler] Registered handler for wikitext: WikitextContentHandler
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 49383 LIMIT 1
Article::view: showing diff page
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecordsFromDb [0s] database_staging: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `mw_slots` JOIN `mw_content` ON ((slot_content_id = content_id)) WHERE slot_revision_id = 49383
DifferenceEngine old '49383' new '49387' rcid '0'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 49387 LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 49383 LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] DifferenceEngine::loadRevisionData [0s] database_staging: SELECT ct_tag_id AS `value` FROM `mw_change_tag` WHERE ct_rev_id = 49383
[DBQuery] DifferenceEngine::loadRevisionData [0s] database_staging: SELECT ct_tag_id AS `value` FROM `mw_change_tag` WHERE ct_rev_id = 49387
[MessageCache] MessageCache using store APCUBagOStuff
[MessageCache] MessageCache::loadUnguarded: Loading en... got from local cache
ParserFactory: using default preprocessor
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::getRelativeRevision [0s] database_staging: SELECT rev_id FROM `mw_revision` IGNORE INDEX (rev_timestamp) WHERE rev_page = 12284 AND (rev_timestamp < '20221027212812' OR (rev_timestamp = '20221027212812' AND rev_id < 49383 )) ORDER BY rev_timestamp DESC,rev_id DESC LIMIT 1
Unstubbing $wgLang on call of $wgLang::getDatePreferenceMigrationMap from Language->internalUserTimeAndDate
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `mw_page` WHERE page_namespace = 2 AND page_title = 'DarinWick' LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `mw_page` WHERE page_namespace = 3 AND page_title = 'DarinWick' LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecordsFromDb [0s] database_staging: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `mw_slots` JOIN `mw_content` ON ((slot_content_id = content_id)) WHERE slot_revision_id = 49387
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecordsFromDb [0s] database_staging: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `mw_slots` JOIN `mw_content` ON ((slot_content_id = content_id)) WHERE slot_revision_id = 49383
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0s] database_staging: SELECT old_id,old_text,old_flags FROM `mw_text` WHERE old_id = 49105
DifferenceEngine old '0' new '0' rcid '0'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::getRevisionIdsBetween [0s] database_staging: SELECT rev_id AS `value` FROM `mw_revision` WHERE rev_page = 12284 AND ((rev_deleted & 1) = 0) AND ((rev_timestamp = '20221027212812' AND rev_id > 49383) OR rev_timestamp > '20221027212812') AND ((rev_timestamp = '20221028034616' AND rev_id < 49387) OR rev_timestamp < '20221028034616') LIMIT 1001
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0.001s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE page_namespace = 0 AND page_title = 'CargoScheduleTest' AND rev_id = 49387 LIMIT 1
[ParserCache] Creating ParserCache instance for pcache
[ParserCache] Creating RevisionOutputCache instance for rcache
[ParserCache] old-revision cache hit
ContextSource::getContext (MediaWiki\Skins\Vector\SkinVector22): called and $context is null. Using RequestContext::getMain()
[DBQuery] MediaWiki::preOutputCommit [0s] database_staging: COMMIT
MediaWiki::preOutputCommit: primary transaction round committed
[DeferredUpdates] DeferredUpdates::run: started MWCallableUpdate_WikiPage->doViewUpdates #657
[DeferredUpdates] DeferredUpdates::run: ended MWCallableUpdate_WikiPage->doViewUpdates #657, processing time: 7.7009201049805E-5
MediaWiki::preOutputCommit: pre-send deferred updates completed
MediaWiki::preOutputCommit: session changes committed
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::persistSessionReplicationPositions: no primary positions/timestamps to save
[DBReplication] Wikimedia\Rdbms\LBFactory::shutdown: finished ChronologyProtector shutdown
[DBReplication] LBFactory shutdown completed
OutputPage::haveCacheVaryCookies: no cache-varying cookies found
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (LinkBatch::doQuery (for Skin::preloadExistence)) [0s] database_staging: BEGIN
[DBQuery] LinkBatch::doQuery (for Skin::preloadExistence) [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_content_model FROM `mw_page` WHERE (page_namespace = 1 AND page_title = 'CargoScheduleTest')
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\User\TalkPageNotificationManager::dbCheckNewUserMessages [0s] database_staging: SELECT user_ip FROM `mw_user_newtalk` WHERE user_ip = '172.18.0.2' LIMIT 1
[gitinfo] Candidate cacheFile=/var/www/html/w/gitinfo.json for /var/www/html/w
[gitinfo] Cache incomplete for /var/www/html/w

@@ Line 1: / Line 1: @@
 {{#cargo_query:tables=bbe22_events
-|fields=date_format(start, '%a, %b %d %h:%i %p')=start,end,nameES,nameEN,zoom,zoomid,zoompw,presenter,tech,interpreter,descriptionES,descriptionEN,recordingES,recordingEN
+|fields=end,CONVERT_TZ(start,'+00:00','-05:00')=start,
+nameES,nameEN,zoom,zoomid,zoompw,presenter,tech,interpreter,descriptionES,descriptionEN,recordingES,recordingEN
 |format=template
 |template=BBE22EventInfo
 |named args=yes
 }}