Topic on Project:Support desk

Wikipedia Dump Import - Unknown column 'page_counter' in 'field list'

2
24.23.32.176 (talkcontribs)

Below is a sampling of the errors I'm seeing with I try to import the latest EN Wikipedia dump:

REF:: https://dumps.wikimedia.org/enwiki/20170401/enwiki-20170401-pages-articles.xml.bz2

I've used this link to install the HitCounter:

LINK:: Extension:HitCounters

I didn't note any errors that seemed meaningful when I ran update.php from the CLI.

I'm running a fresh install of MediaWiki with what was an empty MySQL database until the MediaWiki installation.

MediaWiki: v.1.28

Apache: v.2.4.23

MySQL: v.5.7.14

PHP: 5.6.25-7.0.10

Used these base instructions to complete the installation:

https://www.extremetech.com/computing/114387-how-to-set-up-your-own-copy-of-wikipedia/2

****

ERROR 1054 (42S22) at line 509336: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 510375: Unknown column 'page_counter' in 'field list'

   170000 pages ( 34.288/s),    170000 revisions ( 34.288/s) in 4958 seconds

ERROR 1054 (42S22) at line 511433: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 512508: Unknown column 'page_counter' in 'field list'

   171000 pages ( 34.289/s),    171000 revisions ( 34.289/s) in 4987 seconds

ERROR 1054 (42S22) at line 513680: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 514814: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 515886: Unknown column 'page_counter' in 'field list'

   172000 pages ( 34.215/s),    172000 revisions ( 34.215/s) in 5027 seconds

ERROR 1054 (42S22) at line 517030: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 518263: Unknown column 'page_counter' in 'field list'

   173000 pages ( 34.190/s),    173000 revisions ( 34.190/s) in 5060 seconds

ERROR 1054 (42S22) at line 519529: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 520613: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 521795: Unknown column 'page_counter' in 'field list'

   174000 pages ( 34.098/s),    174000 revisions ( 34.098/s) in 5103 seconds

   175000 pages ( 34.287/s),    175000 revisions ( 34.287/s) in 5104 seconds

ERROR 1054 (42S22) at line 524364: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 527826: Unknown column 'page_counter' in 'field list'

   176000 pages ( 34.241/s),    176000 revisions ( 34.241/s) in 5140 seconds

ERROR 1054 (42S22) at line 529033: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 530124: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 531374: Unknown column 'page_counter' in 'field list'

   177000 pages ( 34.190/s),    177000 revisions ( 34.190/s) in 5177 seconds

ERROR 1054 (42S22) at line 532574: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 533797: Unknown column 'page_counter' in 'field list'

   178000 pages ( 34.159/s),    178000 revisions ( 34.159/s) in 5211 seconds

ERROR 1054 (42S22) at line 534860: Unknown column 'page_counter' in 'field list'

ERROR 1054 (42S22) at line 535877: Unknown column 'page_counter' in 'field list'

Ciencia Al Poder (talkcontribs)

That script is outdated. You can try adding a page_counter field to the page table