Page MenuHomePhabricator
Authored By
bzimport
Nov 21 2014, 10:07 PM
Size
2 KB
Referenced Files
None
Subscribers
None
Loading from page and revision tables...
$wgRCMaxAge=7862400 (91 days)
Updating links and size differences...
Loading from user, page, and logging tables...
Warning: pg_query(): Query failed: ERROR: insert or update on table "recentchanges" violates foreign key constraint "recentchanges_rc_cur_id_fkey"
DETAIL: Key (rc_cur_id)=(0) is not present in table "page". in /var/www/mysite.com/wiki/includes/db/DatabasePostgres.php on line 580
A database error has occurred
Query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_patrolled,rc_new,rc_this_oldid,rc_last_oldid,rc_type,rc_cur_id,rc_log_type,rc_log_action,rc_logid,rc_params,rc_deleted) SELECT log_timestamp,log_timestamp,log_user,user_name,log_namespace,log_title,log_comment,0,0,1,0,0,0,3,COALESCE(page_id, 0),log_type,log_action,log_id,log_params,log_deleted FROM mwuser,logging LEFT JOIN page ON (log_namespace=page_namespace AND log_title=page_title) WHERE (log_timestamp > '2009-03-18 04:57:54 GMT') AND (log_user=user_id) AND (log_type IN('','block','protect','rights','delete','upload','move','import','patrol','merge','newusers')) ORDER BY log_timestamp DESC
Function: rebuildRecentChangesTablePass3
Error: 1 ERROR: insert or update on table "recentchanges" violates foreign key constraint "recentchanges_rc_cur_id_fkey"
DETAIL: Key (rc_cur_id)=(0) is not present in table "page".
Backtrace:
#0 /var/www/mysite.com/wiki/includes/db/Database.php(502): DatabasePostgres->reportQueryError('ERROR: insert ...', 1, 'INSERT INTO re...', 'rebuildRecentCh...', false)
#1 /var/www/mysite.com/wiki/includes/db/Database.php(1637): DatabaseBase->query('INSERT INTO re...', 'rebuildRecentCh...')
#2 /var/www/mysite.com/wiki/maintenance/rebuildrecentchanges.inc(167): DatabaseBase->insertSelect('recentchanges', Array, Array, Array, 'rebuildRecentCh...', Array, Array)
#3 /var/www/mysite.com/wiki/maintenance/rebuildrecentchanges.inc(14): rebuildRecentChangesTablePass3()
#4 /var/www/mysite.com/wiki/maintenance/rebuildrecentchanges.php(19): rebuildRecentChangesTable()
#5 {main}

File Metadata

Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4340
Default Alt Text
log.txt (2 KB)

Event Timeline