search

JeroenDeDauw / Replicator

CLI tool for importing entities from Wikidata / Wikibase
https://wikibase.consulting
Other
23 stars 6 forks source link

Table 'my_wiki.es_items' doesn't exist #19

Open kerphi opened 3 years ago

kerphi commented 3 years ago

Hello,

I try to use replicator to import data from wikidata to a local wikibase but i got this error:

php replicator import:api Q129 -v

Importing entity 1: Q129...
        * Deserializing... done.
        * Inserting into Dump store... FAILED!
         Error details: An exception occurred while executing 'DELETE FROM es_items WHERE item_id = ?' with params [129]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_wiki.es_items' doesn't exist

Import stats:
Entities: 1 (0 succeeded, 1 (100%) failed)
Duration: 0.883887 seconds (1 entities/second)

I checked and there is not es_items table into my local wikibase. It's a strange error. Maybe table in recent wikibase version have been renamed?

JeroenDeDauw commented 3 years ago

This tool does not directly integrate with Wikibase. In other words, you cannot use it to import data into Wikibase without some programming work.

kerphi commented 3 years ago

I configured config/db.json to match wikibase mysql. What did I miss? What should the database be?