Trying to add the wd_item entry for monuments_nl_(nl) crashes the sql job. This is the first wd_item occurence so likely it is not an issue spcific to the dataset.
From the log:
Update all monuments table... ERROR 1054 (42S22) at line 1902: Unknown column 'wd_item' in 'field list'
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Recreate source table prior to run | labs/tools/heritage | master | +42 -22 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | JeanFred | T137457 Hold a Wiki Loves Monuments coding sprint at Wikimania Hackathon 2016 | |||
| Resolved | Lokal_Profil | T138606 updating monuments_all fails due to wd_item |
I can't exactly remember but do you maybe need to recreate the monument tables (or at least one) after any change to monuments_config?
more from the logs
Unknown error occurred when processing country nl in lang nl (1054, "Unknown column 'wd_item' in 'field list'")
Looks like the table just needs to be recreated. Since this is likely an issue with multiple tables I'm just going to run
python /data/project/heritage/erfgoedbot/monument_tables.py
for i in `ls /data/project/heritage/erfgoedbot/sql/create_table_monuments*`
do
echo $i
mysql -h tools-db s51138__heritage_p < $i
done
for i in `ls /data/project/heritage/erfgoedbot/sql/create_table_wlpa_*`
do
mysql -h tools-db s51138__heritage_p < $i
doneThose lines should probably also be added to update_monuments.sh so that we always start by loading the latest changes to monuments_config.
Mentioned in SAL [2016-06-24T22:48:19Z] <Lokal_Profil> Recreated source tables (T138606)
Note that we don't want to simply call create_all_monuments_tables.sh since this also recreates the images table (which is not populated as often)
The job does not seem to have started again. This could possibly be due to the commonscat bit of yesterday's job still running?
Change 296466 had a related patch set uploaded (by Lokal Profil):
Recreate source table prior to run