elliotchance / mbzdb Goto Github PK
View Code? Open in Web Editor NEW🎵 Port of the MusicBrainz database to run on other RDBMSs with replication (previously named MB_MySQL.)
mbzdb's Introduction
FORK OF MBZDB
1- Edit settings.pl to match your environment.
2- Edit settings_mysql.pl or settings_postgresql.pl to match your database environment.
3- Run ./init.pl
You may need to install the following CPAN modules in order to proceed:
perl -MCPAN -e install LWP::UserAgent
perl -MCPAN -e install DBI
perl -MCPAN -e install DBD::Pg
perl -MCPAN -e install DBD::mysql
===== Version log =====
5.0
* Full support for NGS for both PostgreSQL and MySQL.
* settings.pl is now split so that each backend gets its own relevant settings
file.
* A few minor bug fixes.
7.0
* Allow parts of the init script to run in batch mode and/or in parallel:
** Create tables: ./init.pl --action=2 --ask=0
** Download mbdump: ./init.pl --action=10 --ask=0
** Uncompress mbdump: ./init.pl --action=11 --ask=0 --bzip="/usr/bin/pbzip2 -m10240 -p16 -r -v" --pipe-bzip=1 --parallel=1
*** Note at the moment pbzip2 can't make use of all cores when decompressing
because of the format of the mbdump files created by MuscBrainz.
** Load data: ./init.pl --action=4 --ask=0
* After that, you can continue the database creation using the 5, 6 & 7
init.pl options from the interactive menu (indexing, foreign keys creation,
plugins initialization).
===== Further improvements =====
Some ideas may be worth looking at:
* Create primary keys before LOAD DATA: https://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-ddl-operations.html
mbzdb's People
Contributors
Stargazers
Watchers
Forkers
smurfix bts murdos arsenio googled hangar18cc paxxil neirrek ceilingholes suricatomeerkat bbqchickenrobot seatgeek priestd09 ronalimi ivanpgs tejassharma96 razihm baxtermusic aloxey frenzypony kamilzola freybur kalanjdjordje techscientist donaldsteele abaelhe engmohy90 zhubaichuan phreakinmbzdb's Issues
Table area and related tables are missing from the schema
When trying to import the latest dump from http://ftp.musicbrainz.org/pub/musicbrainz/data/fullexport/20130525-003350/ into MySQL I get errors related to the fact that there is no table "ngsdb.area".
The missing tables so far are:
area
area_alias
area_alias_type
area_annotation
area_gid_redirect
area_type
artist_isni
country_area
iso_3166_1
iso_3166_2
iso_3166_3
label_isni
l_area_area
l_area_artist
l_area_label
l_area_recording
l_area_release
l_area_release_group
l_area_url
l_area_work
Create new ./mbzdb tool
v6.0 replaced the interactive ./init and ./update scripts with a single non-interactive ./mbzdb script.
Add SQLite3 backend
Error creating tables
On executing perl init.pl and choosing 2 Install / Update database schematic
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NAME NOT NULL' at line 1 at backend/mysql.pl line 353, line 943.
Error occures while updating / adding tables.
after dbmirror_pending
before dbmirror_Pending
CREATE TABLE dbmirror_Pending (
SeqId SERIAL,
TableName NAME NOT NULL,
Op CHARACTER,
XID INTEGER NOT NULL
);
Notice that TableName is a datatype NAME....
When comparing it to this file you can see the correct table structure:
In replication/ReplicationSetup.sql the table is created as:
CREATE TABLE dbmirror_Pending (
SeqId serial,
TableName varchar NOT NULL,
Op character,
XID int4 NOT NULL,
PRIMARY KEY (SeqId)
);
Create schema problem
When creating a schema
Table over_art_presence AS ENUM ('absent', 'present', 'darkened');
Table release_meta
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cover_art_presence NOT NULL DEFAULT 'absent'' at line 1 at backend/mysql.pl line 463, line 1253.
mbids are wrong
It looks like GID fields on MySQL tables are created as CHAR(32), so when the database dump is loaded all MBID fields lost the last 4 chars.
I think the error is on file backend/mysql.pl, line 312:
$parts[$i] = "CHAR(32)" if(uc(substr($parts[$i], 0, 4)) eq "UUID");
should be
$parts[$i] = "CHAR(36)" if(uc(substr($parts[$i], 0, 4)) eq "UUID");
init.pl option "create index" failed
Hi,
I have an issue with mbzdb.
When i try to create all the index on my database, i get :
Option: 5
The most time consuming option. This will apply indexing to your already loaded
database. If using PostgreSQL, apply the index after you load the raw data because
it is faster.... if you cancel, you can safely return by running this again.
Ready to proceed? (y/n): y
CREATE UNIQUE INDEX artist_alias_idx_locale_artist ON artist_alias (artist,locale(256))
DBD::mysql::db do failed: Specified key was too long; max key length is 767 bytes at src/functions.pl line 92, line 288.
SQL: 'CREATE UNIQUE INDEX artist_alias_idx_locale_artist ON artist_alias (artist,locale(256))'
Have you an idea, on how to fix this issue ?
thx,
ML
Add MongoDB backend
pendinglog plugin is truncating the table name
Offset for SQL substring should be 16, not 11. This has changed with NGS.
"Install/Update database schematic" table creation error.
When choosing option 2 from init.pl, the following attempt to create a non table is performed...here is a section of the output:
Table release_annotation
Table release_gid_redirect
Table over_art_presence AS ENUM ('absent', 'present', 'darkened');
Table release_meta
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cover_art_presence NOT NULL DEFAULT 'absent'' at line 1 at backend/mysql.pl line 446, line 1253.
Table release_coverart
Table release_label
Table release_packaging
At first glance it looks like the script has a problem parsing the ENUM data type as a result of the ");"
Another schema issue: release group cover art
DBD::mysql::db do failed: Incorrect table name 'cover_art_archive.release_group_cover_art' at src/functions.pl line 95, line 31.
[ERROR] SQL: 'CREATE TABLE cover_art_archive.release_group_cover_art (dummycolumn int) engine=InnoDB'
404
runing init.pl, then option 1:
Downloading schema... Error downloading http://git.musicbrainz.org/gitweb/?p=musicbrainz-server.git;a=blob_plain;f=admin/sql/CreateTables.sql;hb=master: 404 Not Found
404
why?
FTP Install
When I start init.pl with option 1 when software try to download tarball from musicbrainz give me this critical error.
Unable to download file mbdump-derived.tar.bz2: Illegal PORT command
I have to change something in the code? Or I have wrong dependencies on my OS, I have checked it but I have all.
Thank you.
Regards,
Error on isrc table
Today I was installing a fresh copy of the database on mysql and got the following error creating the isrc table:
It seems the mysql backend doesn't remove the CHECK constaints correctly, I've managed to get it working editing backend/mysql.pl around line 320 and adding this:
@parts = @parts[0 .. ($i - 1)];
last;
}
I'm still building the database, but it seems it has done the trick (there are no errors shown on the terminal):
mysql> use mb_ngs20110817;
Database changed
mysql> explain isrc;
+---------------+-------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------------------+-------+
| id | int(11) | NO | | NULL | |
| recording | int(11) | NO | | NULL | |
| source | smallint(6) | YES | | NULL | |
| edits_pending | int(11) | NO | | 0 | |
| created | timestamp | NO | | 0000-00-00 00:00:00 | |
| isrc | char(12) | NO | | NULL | |
+---------------+-------------+------+-----+---------------------+-------+
6 rows in set (0.34 sec)
mysql> show create table isrc;
+-------+----------------------------------------------------------------------+
| Table | Create Table
+-------+----------------------------------------------------------------------+
| isrc | CREATE TABLE `isrc` (
`id` int(11) NOT NULL,
`recording` int(11) NOT NULL,
`source` smallint(6) DEFAULT NULL,
`edits_pending` int(11) NOT NULL DEFAULT '0',
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`isrc` char(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------+
1 row in set (0.25 sec)
Apply CreateFKConstraints.sql?
The data that comes out of MusicBrainz is assumed to be relationally correct since the data has already passed all the referential integrity checks of the main server. Up until now there was no reason to apply FKs since it would only add an unnecessary extra workload to the replications; however some things to consider:
Pros:
- Some tables rely on the foreign key, like artist_gid_redirect. Without the FK artist_gid_redirect is left with no indexes at all.
- While FKs for the most part are redundant in this situation it may add an extra layer of protection (on top of the PKs) for replications that might perform twice.
- It could be argued that the query planner for your favourite RDBMS uses the FKs to better plan execution methods.
Cons:
- Assuming the data is perfect there is no need for the extra CPU or I/O.
- The majority of people who use mbzdb use MySQL, in conjuction with MyISAM which does not support FKs and so would make no difference.
Feel free to give your opinions on this. From a technical standpoint this is relatively easy to implement.
Add better versioning info
init.pl should show the mbzdb version.
Unknown column 'lastupdate' in MySQL-Update-command for table 'artist_meta'
After manually adding the value 100 to 'current_replication_sequence' in the table 'replication_control' as ID 1, I get the following update-error executing 'Update.pl':
Current replication is 100
Looking for previous pending changes... 0 pending
===== 101 =====
Sat Dec 11 14:04:48 2010: Downloading... Done
Sat Dec 11 14:04:48 2010: Uncompressing... Done
Sat Dec 11 14:04:49 2010: Loading pending tables... Done
Sat Dec 11 14:04:49 2010: Processing Transactions...
DBD::mysql::db do failed: Unknown column 'lastupdate' in 'field list' at src/functions.pl line 94.
SQL: 'UPDATE artist_meta SET lastupdate='2010-06-30 00:57:31.821045+00',ratingcount='10',id='65',rating='94' WHERE id='65''
The update process terminates at this line.
This issue should be tracked and resolved when NGS becomes stable.
Soundex plugin fails to initialize
Creating soundex tables... Done
DBD::mysql::db do failed: Table 'ngs_final.album' doesn't exist at src/functions.pl line 92.
SQL: 'insert into album_soundex select id, soundex(name) from album'
It tries to create index for tables that does not exist on NGS. I'm currently editing soundex.pl so it indexes all *_name tables.
Rename sanitised tables
"release_meta_sanitised" must be renamed to "release_meta"
Errors while creating tables
Is this project still running?
I get errors at NGS or Non-NGS tables creation.
I am creating database from scratch.
Non-NGS option gives me following errors:
Table album
DBD::mysql::db do failed: BLOB/TEXT column 'attributes' can't have a default value at backend/mysql.pl line 353, line 1018.
Table album_amazon_asin
Table Pending
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SeqId")' at line 1 at backend/mysql.pl line 353, line 25.
Table PendingData
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SeqId", "IsKey")' at line 1 at backend/mysql.pl line 353, line 25.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SeqId") REFERENCES "Pending" ("SeqId") ON UPDATE CASCADE ON DELETE CASCADE' at line 1 at backend/mysql.pl line 353, line 25.
NGS option gives me following errors:
Table ATE array_cat_agg(anyarray)
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= array_cat' at line 1 at backend/mysql.pl line 353, line 37.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= anyarray' at line 1 at backend/mysql.pl line 353, line 37.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1 at backend/mysql.pl line 353, line 37.
DBD::mysql::db do failed: You can't delete all columns with ALTER TABLE; use DROP TABLE instead at backend/mysql.pl line 353, line 37.
Table dbmirror_Pending
Table dbmirror_PendingData
Records from the table 'release_name' is not fully copied
I run this query from \backend\mysql.pl
mysql> LOAD DATA LOCAL INFILE 'C:\release_name' INTO TABLE release_name1 FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' STARTING BY '';
and saw
Query OK, 790828 rows affected, 3 warnings (44.42 sec)
Records: 802086 Deleted: 0 Skipped: 11258 Warnings: 0
Why do so many records missing?
Replications need to be transactional
If the update script is killed in between applying the replicated SQL and deleting it from dbmirror_Pending then the next time update.pl runs it will apply the replicated SQL twice, usually ending up in a unique violation.
MusicBrainz Schema seems to have changed
DBD::mysql::st execute failed: Incorrect table name 'statistics.statistic' at backend/mysql.pl line 189.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at backend/mysql.pl line 190.
Sun Jan 13 18:23:12 2013: Loading data into 'statistics.statistic' (94 of 112)...
DBD::mysql::db do failed: Incorrect table name 'statistics.statistic' at src/functions.pl line 93.
[ERROR] SQL: 'LOAD DATA LOCAL INFILE 'mbdump/statistics.statistic' INTO TABLE statistics.statistic FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' STARTING BY '''
Split up settings.pl
For better separation of backends there should be:
settings.pl
settings_mysql.pl
settings_postgresql.pl
etc...
ftp connection
You should add Passive => 1 in the ftp->new() it didn't worked here before I changed this.
update.pl not working
After "perl init.pl". When i try to update the database it does nothing. When "perl update.pl" says:
Current replication is (blank)
Looking for previous pending changes... 0 pending
.....................Downloading.... Done
Replication 1 could not be found on the server.
load_data also tries to load data from directories
I accidentally left an mbdump directory within mbdumb and got the following error:
Thu Nov 10 17:49:04 2011: Loading data into 'mbdump' (52 of 81)...
DBD::mysql::db do failed: Table 'ngsdb.mbdump' doesn't exist at src/functions.pl line 92, line 2.
SQL: 'LOAD DATA LOCAL INFILE 'mbdump/mbdump' INTO TABLE mbdump FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' STARTING BY '''
It was obviously my mistake, but it could have been avoided and spared me the time to do it all over ;)
New schema (2012-05-15) not working
Appying indexing fails (some duplicates for PRIMARY keys, etc).
For example, on the link table, adding the PRIMARY KEY shows a "Duplicate entry '2' for key PRIMARY" error. Similar errors adding the PRIMARY KEY on label, label_alias, artist, artist_alias.
The failing tables have a dummycoulumn that I suppose should have been removed/renamed before indexing takes place.
Also I think, because the dummycolumn being the first column on these tables, the LOAD DATA INFILE inserts data on the "wrong" columns (id columns do have lots of duplicates, ).
init.pl options menu
init.pl has 7 options but in the init.pl code if the number entered is > 6 it returns invalid.
Create wikidocs tables on install
If we don't download and run the .sql files form https://github.com/metabrainz/musicbrainz-server/tree/master/admin/sql/wikidocs the update script will fail applying replication packets that update the wikidoc tables, and halt the whole replication process.
Problem generating UPDATE queries for large annotations
Today I was appliying the last changes, which included a massive trim() on annotations on the MB server [http://tickets.musicbrainz.org/browse/MBS-2836], and it seems there is an error generating the SET clause which leads to an empty string or something like that, so we get an UPDATE annotation SET WHERE editor='95678' AND id='184927' (UPDATE with empty SET clause) and a SQL error raises.
This is the full output shown on console:
Current replication is 57156
Looking for previous pending changes... 493854 pending
Mon Feb 27 23:07:46 2012: Processing Transactions...
s only scores which include original compositions. Many dozens of other films and television shows have reused cues from these films, most notably the main theme from "Il buono, il brutto, il cattivo". Films and TV shows which include only reused cues are not listed here.''''
''''''''''1959''''''''''
\* Il lieto fine
\* Morte di un amico ([http://www.imdb.com/title/tt0188069/|IMDb])
## \* AKA: en: Death of a Friend
''''''''''1960''''''''''
## \* Il pappa reale
''''''''''1961''''''''''
\* Il federale ([http://www.imdb.com/title/tt0054870/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19121|soundtrackcollector])
\* AKA: fr: Le fédéral
\* AKA: fr: Mission ultra-secrète
\* AKA: en: Operation Idiot
\* AKA: en: The Fascist
\* Verrò
## \* Vicino al Ciel
''''''''''1962''''''''''
\* Diciottenni al sole ([http://www.imdb.com/title/tt0055906/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19469|soundtrackcollector])
\* AKA: en: Beach Party-Italian Style
\* AKA: en: Eighteen in the Sun
\* Gli italiani e le vacanze ([http://www.imdb.com/title/tt0179906/|IMDb])
\* I motorizzati ([http://www.imdb.com/title/tt0136416/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19501|soundtrackcollector])
\* AKA: sp: Los Motorizados
\* La cuccagna ([http://www.imdb.com/title/tt0055879/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19495|soundtrackcollector])
\* AKA: en: A Girl... and a Million
\* [http://musicbrainz.org/show/url/?urlid=590195|La voglia matta]([http://www.imdb.com/title/tt0056665/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19507|soundtrackcollector])
\* AKA: en: Crazy Desire
\* AKA: en: The Crazy Urge
\* Le pillole di Erole ([http://www.imdb.com/title/tt0054184/|IMDb])
\* The Virginian ([http://www.imdb.com/title/tt0055710/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19262|soundtrackcollector])
## \* AKA: en: The Men From Shiloh
''''''''''1963''''''''''
\* Duello nel Texas (composed as "Dan Savio") ([http://www.imdb.com/title/tt0057016/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19500|soundtrackcollector])
\* AKA: en: Gunfight at Red Sands
\* AKA: sp: Gringo
\* Gli imbroglioni ([http://www.imdb.com/title/tt0057175/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590278|I basilischi]([http://www.imdb.com/title/tt0056856/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19691|soundtrackcollector])
\* AKA: en: The Basilisks
\* AKA: en: The Lizards
\* Il successo ([http://www.imdb.com/title/tt0057540/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19554|soundtrackcollector])
\* AKA: en: The Success
\* La Fidanzata Del Bersagliere ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=26406|soundtrackcollector])
\* [http://musicbrainz.org/show/url/?urlid=590194|Le monachine]([http://www.imdb.com/title/tt0057316/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19540|soundtrackcollector])
\* AKA: en: The Little Nuns
## \* Tutto è musica ([http://www.imdb.com/title/tt0153343/|IMDb])
''''''''''1964''''''''''
\* ...e la donna creò l''uomo ([http://www.imdb.com/title/tt0058728/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=53049|soundtrackcollector])
\* AKA: de: Volles Herz und leere Taschen
\* AKA: en: Full Hearts And Empty Pockets
\* I due evasi di Sing Sing ([http://www.imdb.com/title/tt0058042/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19917|soundtrackcollector])
\* AKA: en: Two Escape from Sing Sing
\* [http://musicbrainz.org/show/url/?urlid=590290|I malamondo]([http://www.imdb.com/title/tt0058321/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=7459|soundtrackcollector])
\* AKA: en: Malamondo
\* I maniaci ([http://www.imdb.com/title/tt0058325/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19916|soundtrackcollector])
\* AKA: en: Beautiful Eyes
\* AKA: en: The Maniacs
\* I marziani hanno dodici mani ([http://www.imdb.com/title/tt0058298/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=20024|soundtrackcollector])
\* AKA: sp: Llegaron los marcianos
\* AKA: it: Siamo quattro marziani
\* AKA: en: The Twelve-Handed Men of Mars
\* In ginocchio da te ([http://www.imdb.com/title/tt0058229/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19686|soundtrackcollector])
\* La scoperta dell''America ([http://www.imdb.com/title/tt0058554/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=592046|Le pistole non discutono]([http://www.imdb.com/title/tt0058475/|IMDb])
\* AKA: en: Bullets Don''t Argue
\* AKA: en: Bullets Don''t Lie
\* AKA: de: Die letzten Zwei vom Rio Bravo
\* AKA: en: Guns Don''t Talk
\* AKA: sp: Las pistolas no discuten
\* [http://musicbrainz.org/show/url/?urlid=142449|Per un pugno di dollari](composed as) ([http://www.imdb.com/title/tt0058461/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=19977|soundtrackcollector])
\* AKA: sp: A Fistful of Dollars
\* AKA: de: Für eine Handvoll Dollar
\* AKA: en: Por un puñado de dólares
\* Prima della rivoluzione ([http://www.imdb.com/title/tt0056371/|IMDb])
## \* AKA: en: Before the Revolution
''''''''''1965''''''''''
\* Agente 077 missione Bloody Mary ([http://www.imdb.com/title/tt0058882/|IMDb])
\* AKA: en: Agent 077 - Mission Bloody Mary
\* AKA: fr: Agente 077
\* Altissima pressione ([http://www.imdb.com/title/tt0058899/|IMDb])
\* AKA: en: Highest Pressure
\* Gli amanti d''oltretomba ([http://www.imdb.com/title/tt0060097/|IMDb])
\* AKA: en: Lovers Beyond the Tomb
\* AKA: en: Lovers from Beyond the Tomb
\* AKA: en: Night of the Doomed
\* AKA: en: Nightmare Castle
\* AKA: en: Orgasmo
\* AKA: en: The Faceless Monster
\* [http://musicbrainz.org/show/url/?urlid=590279|I pugni in tasca]([http://www.imdb.com/title/tt0059619/|IMDb])
\* AKA: en: Fist in His Pocket
\* AKA: en: Fists in the Pocket
\* Idoli controluce ([http://www.imdb.com/title/tt0059306/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=238622|Il ritorno di Ringo]([http://www.imdb.com/title/tt0060903/|IMDb])
\* AKA: en: The Angry Gun
\* AKA: sp: El retorno de Ringo
\* AKA: en: The Return of Ringo
\* Menage all''italiana ([http://www.imdb.com/title/tt0165389/|IMDb])
\* AKA: en: Menage Italian Style
\* Non son degno di te ([http://www.imdb.com/title/tt0059517/|IMDb])
\* Per qualche dollaro in più ([http://www.imdb.com/title/tt0059578/|IMDb])
\* AKA: en: For a Few Dollars More
\* AKA: de: Für ein paar Dollar mehr
\* AKA: no: For en neve dollar mer
\* AKA: sp: La muerte tenía un precio
\* AKA: sp: Por unos cuantos dólares más
\* AKA: sp: Por unos pocos dólares más
\* Se non avessi più te ([http://www.imdb.com/title/tt0059690/|IMDb])
\* Slalom ([http://www.imdb.com/title/tt0059728/|IMDb])
\* AKA: en: Snow Job
\* Thrilling ([http://www.imdb.com/title/tt0059799/|IMDb])
\* Uccellacci e uccellini ([http://www.imdb.com/title/tt0061132/|IMDb])
\* AKA: en: Hawks and Sparrows
\* AKA: en: The Hawks and the Sparrows
\* [http://musicbrainz.org/show/url/?urlid=238621|Una pistola per Ringo]([http://www.imdb.com/title/tt0059601/|IMDb])
\* AKA: en: A Gun for Ringo
\* AKA: en: A Pistol for Ringo
\* AKA: en: Ballad of Death Valley
\* AKA: en: Ringo: The Killer
## \* AKA: sp: Una pistola para Ringo
''''''''''1966''''''''''
\* Agent 505: Todesfalle Beirut ([http://www.imdb.com/title/tt0058878/|IMDb])
\* AKA: en: Agent 505 - The Trap Door Falls in Beirut
\* AKA: en: Agent 505: Death Trap Beirut
\* AKA: fr: Baroud à Beyrouth pour F.B.I. 505
\* AKA: en: Formula C-12 Beirut
\* AKA: en: Formula C-12/Beirut
\* AKA: en: From Beirut with Love
\* AKA: it: La trappola scatta a Beyrut (Italy)
\* AKA: de: Rififi in Beirut
\* Alla scoperta dell''America ([http://www.imdb.com/title/tt0277567/|IMDb])
\* Das gewisse Etwas der Frauen ([http://www.imdb.com/title/tt0060456/|IMDb])
\* AKA: it: Come imparai ad amare le donne
\* AKA: fr: Comment j''ai appris à aimer les femmes
\* AKA: en: How I Learned to Love Women
\* AKA: en: Love Parade
\* El chuncho, quien sabe? ([http://www.imdb.com/title/tt0061429/|IMDb])
\* AKA: en: A Bullet for the General
\* AKA: it: Quién sabe?
\* [http://musicbrainz.org/show/url/?urlid=592049|El Greco]([http://www.imdb.com/title/tt0057026/|IMDb])([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=20090|soundtrackcollector])
\* [http://musicbrainz.org/show/url/?urlid=150815|Il buono, il brutto, il cattivo]([http://www.imdb.com/title/tt0060196/|IMDb])
\* AKA: en: The Good, the Bad and the Ugly
\* AKA: no: Den gode, den onde og den grusomme
\* AKA: sp: El bo, el lleig i el dolent
\* AKA: sp: El bueno, el feo y el malo
\* AKA: en: The Magnificent Rogues
\* AKA: de: Zwei glorreiche Halunken
\* [http://musicbrainz.org/show/url/?urlid=590289|La battaglia di Algeri]([http://www.imdb.com/title/tt0058946/|IMDb])
\* AKA: en: The Battle of Algiers
\* AKA: ar: Maarakat madinat al Jazaer
\* La ragazza del bersagliere ([http://www.imdb.com/title/tt0197801/|IMDb])
\* AKA: en: Soldier''s Girl
\* La resa dei conti ([http://www.imdb.com/title/tt0063501/|IMDb])
\* AKA: en: Account Rendered
\* AKA: sp: El halcón y la presa
\* AKA: en: The Big Gundown
\* Lo squarciagola ([http://www.imdb.com/title/tt0458239/|IMDb])
\* Mi vedrai tornare ([http://www.imdb.com/title/tt0060692/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590199|Navajo Joe](composed as) ([http://www.imdb.com/title/tt0061587/|IMDb])
\* AKA: en: A Dollar a Head
\* AKA: sp: Joe, el implacable
\* AKA: en: Savage Run
\* Per Firenze ([http://www.imdb.com/title/tt0193404/|IMDb])
\* Per pochi dollari ancora ([http://www.imdb.com/title/tt0061773/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590196|Sette donne per i MacGregor]([http://www.imdb.com/title/tt0062251/|IMDb])
\* AKA: en: 7 Women for the MacGregors
\* AKA: it: Sette pistole per I MacGregor
\* AKA: en: Seven Guns for the MacGregors
\* AKA: sp: Siete mujeres para los Mac Gregor
\* AKA: sp: Siete pistolas para los Mac Gregor
\* AKA: en: Up the MacGregors
\* Sugar Colt ([http://www.imdb.com/title/tt0061040/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590266|Svegliati e uccidi]([http://www.imdb.com/title/tt0061049/|IMDb])
\* AKA: it: Il solista del mitra
\* AKA: it: Lutrig
\* AKA: fr: Lutring... réveille-toi et meurs
\* AKA: en: Too Soon to Die
\* AKA: en: Wake Up and Die
\* The Bible: In the Beginning... ([http://www.imdb.com/title/tt0060164/|IMDb])
\* AKA: it: La bibbia
\* AKA: en: The Bible
\* Un fiume di dollari (composed as "Leo Nichols") ([http://www.imdb.com/title/tt0060416/|IMDb])
\* AKA: en: The Hills Run Red
\* AKA: en: River of Dollars
\* Un uomo a metà ([http://www.imdb.com/title/tt0059850/|IMDb])
\* AKA: en: Almost a Man
\* AKA: en: Half a Man
## \* AKA: fr: Un homme à moitié
''''''''''1967''''''''''
\* Ad ogni costo ([http://www.imdb.com/title/tt0062636/|IMDb])
\* AKA: sp: Diamantes a gogó
\* AKA: en: Grand Slam
\* AKA: en: Top Job
\* AKA: en: Top Job - Diamantenraub in Rio
\* AKA: de: Um jeden Preis
\* Arabella ([http://www.imdb.com/title/tt0061365/|IMDb])
\* AKA: it: Ragazza del Charleston
\* Dalle Ardenne all''inferno ([http://www.imdb.com/title/tt0062855/|IMDb])
\* AKA: en: Dirty Heroes
\* AKA: de: ...und morgen fahrt ihr zur Hölle
\* AKA: fr: De la gloire à l''enfer
\* AKA: en: From Hell to Victory
\* AKA: en: Heroes Five
\* AKA: fr: La gloire des canailles
\* Destino: Estambul 68 ([http://www.imdb.com/title/tt0062878/|IMDb])
\* AKA: sp: Agente Z-55, misión Coleman
\* AKA: it: Occhio per occhio, dente per dente
\* [http://musicbrainz.org/show/url/?urlid=590260|Faccia a faccia]([http://www.imdb.com/title/tt0061636/|IMDb])
\* AKA: sp: Cara a cara
\* AKA: en: Face to Face
\* I crudeli (composed as "Leo Nichols") ([http://www.imdb.com/title/tt0060261/|IMDb])
\* AKA: en: Hellbenders
\* AKA: sp: Los despiadados
\* AKA: en: The Cruel Ones
\* AKA: en: The Hellbenders
\* I lunghi giorni della vendetta ([http://www.imdb.com/title/tt0060641/|IMDb])
\* AKA: en: Days of Vengeance
\* AKA: it: Faccia d''angelo
\* AKA: fr: Les longs jours de la vengeance
\* AKA: en: Long Days of Vengeance
\* AKA: sp: Los largos días de la venganza
\* AKA: en: The Deadliest Gunfight
\* AKA: en: Vendetta
\* Il giardino delle delizie ([http://www.imdb.com/title/tt0061706/|IMDb])
\* AKA: en: Garden of Delights
\* [http://musicbrainz.org/show/url/?urlid=590280|L''avventuriero]([http://www.imdb.com/title/tt0061377/|IMDb])
\* AKA: en: The Rover
\* L''harem ([http://www.imdb.com/title/tt0063042/|IMDb])
\* AKA: de: Her Harem
\* AKA: fr: Le harem
\* AKA: en: The Harem
\* La Cina è vicina ([http://www.imdb.com/title/tt0061483/|IMDb])
\* AKA: en: China Is Near
\* La ragazza e il generale ([http://www.imdb.com/title/tt0062174/|IMDb])
\* AKA: fr: La fille et le général
\* AKA: en: The Girl and the General
\* Le streghe ([http://www.imdb.com/title/tt0061037/|IMDb])
\* Segment title: La terra vista dalla luna
\* AKA: fr: Les sorcières
\* AKA: en: The Witches
\* [http://musicbrainz.org/show/url/?urlid=590254|Matchless]([http://www.imdb.com/title/tt0060676/|IMDb])
\* OK Connery ([http://www.imdb.com/title/tt0062078/|IMDb])
\* AKA: en: Operation Double 007
\* AKA: en: Operation Kid Brother
\* AKA: en: Secret Agent 00
\* [http://musicbrainz.org/show/url/?urlid=47224|Scusi, facciamo l''amore?]([http://www.imdb.com/title/tt0062241/|IMDb])
\* AKA: fr: Et si on faisait l''amour
## \* AKA: en: Listen, Let''s Make Love
''''''''''1968''''''''''
\* [http://musicbrainz.org/show/url/?urlid=590282|...e per tetto un cielo di stelle]([http://www.imdb.com/title/tt0062618/|IMDb])
\* AKA: en: A Sky Full of Stars for a Roof
\* AKA: en: And for a Roof a Sky Full of Stars
\* Appunti per un film sull''India ([http://www.imdb.com/title/tt0208689/|IMDb])
\* AKA: en: Appunti per un film indiano
\* [http://musicbrainz.org/show/url/?urlid=226363|C''era una volta il West]([http://www.imdb.com/title/tt0064116/|IMDb])
\* AKA: en: Once Upon a Time in the West
\* AKA: en: There Was Once the West
\* Comandamenti per un Gangster ([http://www.imdb.com/title/tt0166138/|IMDb])
\* Corri, uomo, corri ([http://www.imdb.com/title/tt0062825/|IMDb])
\* AKA: en: Big Gundown 2: Run, Man, Run
\* AKA: en: Run, Man, Run
\* AKA: fr: Saludos, hombre
\* [http://musicbrainz.org/show/url/?urlid=238623|Da uomo a uomo]([http://www.imdb.com/title/tt0064208/|IMDb])
\* AKA: en: As Man to Man
\* AKA: en: Death Rides a Horse
\* Diabolik ([http://www.imdb.com/title/tt0062861/|IMDb])
\* AKA: en: Danger: Diabolik
\* AKA: fr: Danger: Diabolik!
\* Ecce Homo ([http://www.imdb.com/title/tt0062923/|IMDb])
\* El magnífico Tony Carrera ([http://www.imdb.com/title/tt0063259/|IMDb])
\* AKA: it: Il magnifico Tony Carrera
\* AKA: de: Samtpfötchen dreht sein letztes Ding
\* AKA: en: The Magnificent Tony Carrera
\* Escalation ([http://www.imdb.com/title/tt0062938/|IMDb])
\* Grazie, zia ([http://www.imdb.com/title/tt0063033/|IMDb])
\* AKA: en: Come Play with Me
\* AKA: en: Thank You Aunt
\* Il grande silenzio ([http://www.imdb.com/title/tt0063032/|IMDb])
\* AKA: en: The Great Silence
\* AKA: fr: Le grand silence
\* AKA: en: The Big Silence
\* Il mercenario ([http://www.imdb.com/title/tt0063293/|IMDb])
\* AKA: en: A Professional Gun
\* AKA: en: Revenge of a Gunfighter
\* AKA: en: Salario para matar
\* AKA: en: The Mercenary
\* Italia vista dal cielo ([http://www.imdb.com/title/tt0068750/|IMDb])
\* La bataille de San Sebastian ([http://www.imdb.com/title/tt0062713/|IMDb])
\* AKA: en: Guns for San Sebastian
\* AKA: it: I cannoni di San Sebastian
\* AKA: sp: Los cañones de San Sebastián
\* Mangiala ([http://www.imdb.com/title/tt0063269/|IMDb])
\* AKA: en: Eat It
\* Partner ([http://www.imdb.com/title/tt0063414/|IMDb])
\* AKA: it: Il sosia
\* AKA: en: Partner
\* Roma come Chicago ([http://www.imdb.com/title/tt0063516/|IMDb])
\* AKA: en: Bandits in Rome
\* AKA: en: Rome Like Chicago
\* AKA: en: The Violent Four
\* Teorema ([http://www.imdb.com/title/tt0063678/|IMDb])
\* AKA: en: Theorem
\* Tepepa ([http://www.imdb.com/title/tt0063679/|IMDb])
\* AKA: en: Blood and Guns
\* AKA: en: Long Live the Revolution
## \* AKA: sp: Tepepa... Viva la revolución
''''''''''1969''''''''''
\* 1943: un incontro ([http://www.imdb.com/title/tt0185135/|IMDb])
\* Cuore di mamma ([http://www.imdb.com/title/tt0195621/|IMDb])
\* AKA: en: Mother''s Heart
\* [http://musicbrainz.org/show/url/?urlid=590130|Dio è con noi]([http://www.imdb.com/title/tt0064386/|IMDb]) ([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=41706|soundtrackcollector])
\* AKA: fr: À l''Aube Du Cinquième Jour
\* AKA: en: Crime of Defeat
\* AKA: de: Die im Dreck krepieren
\* AKA: en: God with Us
\* AKA: de: Gott Mit Uns
\* AKA: en: The Fifth Day of Peace
\* AKA: en: The Last Five Days of Peace
\* Fräulein Doktor ([http://www.imdb.com/title/tt0064350/|IMDb])
\* AKA: en: Fraulein Doktor
\* AKA: sr: Gospodjica Doktor - Spijunka bez imena
\* AKA: en: The Betrayal
\* [http://musicbrainz.org/show/url/?urlid=590241|Galileo]([http://www.imdb.com/title/tt0062998/|IMDb])
\* AKA: bl: Галилео Галилей
\* AKA: en: Galileo Galilei
\* Giotto ([http://www.imdb.com/title/tt0214720/|IMDb])
\* Gli intoccabili ([http://www.imdb.com/title/tt0065895/|IMDb])
\* AKA: en: For a Price
\* AKA: en: Machine Gun McCain
\* H2S ([http://www.imdb.com/title/tt0178544/|IMDb])
\* Красная палатка ([http://www.imdb.com/title/tt0067315/|IMDb])
\* AKA: ru: Krasnaya palatka
\* AKA: it: La tenda rossa
\* AKA: en: The Red Tent
\* AKA: ga: Tsiteli karavi
\* L''alibi ([http://www.imdb.com/title/tt0064001/|IMDb])
\* AKA: en: Alibi
\* L''assoluto naturale ([http://www.imdb.com/title/tt0064047/|IMDb])
\* AKA: en: She and He
\* La donna invisibile ([http://www.imdb.com/title/tt0064249/|IMDb])
\* AKA: en: The Fantasies of a Sensuous Woman
\* AKA: en: The Invisible Woman
\* [http://musicbrainz.org/show/url/?urlid=590261|La monaca di Monza]([http://www.imdb.com/title/tt0064682/|IMDb])
\* AKA: it: La monaca di Monza: Una storia lombarda
\* AKA: en: The Awful Story of the Nun of Monza
\* AKA: en: The Lady of Monza
\* AKA: en: The Nun of Monza
\* [http://musicbrainz.org/show/url/?urlid=590198|La stagione dei sensi]([http://www.imdb.com/title/tt0063640/|IMDb])
\* AKA: en: Season of the Senses
\* Le clan des siciliens ([http://www.imdb.com/title/tt0064169/|IMDb])
\* AKA: en: The Sicilian Clan
\* Metti una sera a cena ([http://www.imdb.com/title/tt0064660/|IMDb])
\* AKA: en: Love Circle
\* AKA: en: One Night at Dinner
\* Queimada ([http://www.imdb.com/title/tt0064866/|IMDb])
\* AKA: en: Burn!
\* AKA: en: The Mercenary
\* Ruba al prossimo tuo ([http://www.imdb.com/title/tt0064329/|IMDb])
\* AKA: en: A Fine Pair
\* Sai cosa faceva Stalin alle donne? ([http://www.imdb.com/title/tt0138769/|IMDb])
\* AKA: en: What Did Stalin Do to Women?
\* Senza sapere niente di lei ([http://www.imdb.com/title/tt0173184/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=104576|Un bellissimo novembre]([http://www.imdb.com/title/tt0062722/|IMDb])
\* AKA: fr: Ce merveilleux automne
\* AKA: en: That Splendid November
\* Un esercito di cinque uomini ([http://www.imdb.com/title/tt0064300/|IMDb])
\* AKA: en: The Five Man Army
\* Un tranquillo posto di campagna ([http://www.imdb.com/title/tt0065119/|IMDb])
\* AKA: en: A Quiet Place in the Country
\* AKA: en: Un coin tranquille à la campagne
\* Una breve stagione ([http://www.imdb.com/title/tt0128974/|IMDb])
\* AKA: en: A Brief Season
\* Vergogna, schifosi ([http://www.imdb.com/title/tt0065175/|IMDb])
\* AKA: en: Dirty Angels
\* Zenabel ([http://www.imdb.com/title/tt0065240/|IMDb])
## \* AKA: fr: Zenabel
''''''''''1970''''''''''
\* Città violenta ([http://www.imdb.com/title/tt0065555/|IMDb])
\* AKA: fr: La cité de la violence
\* AKA: en: The Family
\* AKA: en: Violent City
\* Giochi particolari ([http://www.imdb.com/title/tt0065192/|IMDb])
\* AKA: fr: Le voyeur
\* AKA: en: The Voyeur
\* Giovanni ed Elviruccia ([http://www.imdb.com/title/tt1198254/|IMDb])
\* Hornets'' Nest ([http://www.imdb.com/title/tt0065850/|IMDb])
\* AKA: it: I lupi attaccano in branco
\* AKA: it: Il vespaio
\* [http://musicbrainz.org/show/url/?urlid=590240|I cannibali]([http://www.imdb.com/title/tt0065518/|IMDb])
\* AKA: en: The Cannibals
\* AKA: en: The Year of the Cannibals
\* Indagine su un cittadino al di sopra di ogni sospetto ([http://www.imdb.com/title/tt0065889/|IMDb])
\* AKA: en: Investigation of a Citizen Above Suspicion
\* AKA: en: Investigation of a Citizen... Above Suspicion
\* AKA: en: Investigation of a Private Citizen
\* Krasnaya Palatka ([http://www.imdb.com/title/tt0067315/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=150811|L''uccello dalle piume di cristallo]([http://www.imdb.com/title/tt0065143/|IMDb])
\* AKA: en: Bird with the Glass Feathers
\* AKA: de: Das Geheimnis der schwarzen Handschuhe
\* AKA: en: Phantom of Terror
\* AKA: en: Point of Terror
\* AKA: en: The Bird with the Crystal Plumage
\* AKA: en: The Gallery Murders
\* [http://musicbrainz.org/show/url/?urlid=590224|La califfa]([http://www.imdb.com/title/tt0065516/|IMDb])
\* AKA: en: Lady Caliph
\* La moglie più bella ([http://www.imdb.com/title/tt0232114/|IMDb])
\* AKA: en: The Most Beautiful Wife
\* La sciantosa ([http://www.imdb.com/title/tt0286051/|IMDb])
\* Le foto proibite di una signora per bene ([http://www.imdb.com/title/tt0065677/|IMDb])
\* AKA: sp: Días de angustia
\* AKA: en: Forbidden Photos of a Lady Above Suspicion
\* Metello ([http://www.imdb.com/title/tt0066075/|IMDb])
\* Quando le donne avevano la coda ([http://www.imdb.com/title/tt0066268/|IMDb])
\* AKA: en: When Women Had Tails
\* Two Mules for Sister Sara ([http://www.imdb.com/title/tt0065134/|IMDb])
\* AKA: sp: Dos mulas para la hermana Sara
\* [http://musicbrainz.org/show/url/?urlid=590401|Uccidete il vitello grasso e arrostitelo]([http://www.imdb.com/title/tt0066497/|IMDb])
\* Vamos a matar, compañeros ([http://www.imdb.com/title/tt0066612/|IMDb])
\* AKA: en: Companeros
\* AKA: de: Laßt uns töten, Companeros
\* AKA: sp: Los compañeros
## \* AKA: de: Zwei Compañeros
''''''''''1971''''''''''
\* ¡Viva la muerte... tua! ([http://www.imdb.com/title/tt0067303/|IMDb])
\* AKA: sp: ¡Viva la muerte... tuya!
\* AKA: en: Don''t Turn the Other Cheek
\* AKA: en: Long Live Your Death
\* AKA: it: Viva la muerte... tua!
\* AKA: de: Zwei Galgenvögel geben Zunder
\* AKA: de: Zwei tolle Companeros
\* AKA: de: Zwei wilde Companeros
\* 4 mosche di velluto grigio ([http://www.imdb.com/title/tt0066735/|IMDb])
\* AKA: fr: 4 mouches de velours gris
\* AKA: en: Four Flies on Grey Velvet
\* AKA: en: Four Patches of Grey Velvet
\* AKA: en: The Four Velvet Flies
\* Addio, fratello crudele ([http://www.imdb.com/title/tt0069678/|IMDb])
\* AKA: en: ''Tis Pity She''s a Whore
\* AKA: it: Peccato che sia una puttana
\* Correva l''anno di grazia 1870 ([http://www.imdb.com/title/tt0066948/|IMDb])
\* AKA: en: 1870
\* [http://musicbrainz.org/show/url/?urlid=150805|Forza ''G'']([http://www.imdb.com/title/tt0067113/|IMDb])
\* AKA: en: Winged Devils
\* Giornata nera per l''ariete ([http://www.imdb.com/title/tt0067134/|IMDb])
\* AKA: en: Evil Fingers
\* AKA: en: The Fifth Cord
\* [http://musicbrainz.org/show/url/?urlid=239086|Giù la testa]([http://www.imdb.com/title/tt0067140/|IMDb])
\* AKA: en: A Fistful of Dynamite
\* AKA: it: C''era una volta la rivoluzione
\* AKA: en: Duck, You Sucker
\* AKA: en: Once Upon a Time... the Revolution
\* Gli occhi freddi della paura ([http://www.imdb.com/title/tt0067511/|IMDb])
\* AKA: en: Cold Eyes of Fear
\* AKA: en: Desperate Moments
\* AKA: sp: Los fríos ojos del miedo
\* Il Decameron ([http://www.imdb.com/title/tt0065622/|IMDb])
\* AKA: de: Decameron
\* AKA: pt: Decameron
\* AKA: de: Decamerone
\* AKA: au: Decamerone
\* AKA: fn: Decamerone
\* AKA: fr: Le Décaméron
\* AKA: en: The Decameron
\* [http://musicbrainz.org/show/url/?urlid=590208|Il gatto a nove code]([http://www.imdb.com/title/tt0065761/|IMDb])
\* AKA: en: Cat o'' Nine Tails
\* AKA: de: Die neunschwänzige Katze
\* AKA: fr: Le chat à neuf queues
\* AKA: en: The Cat o'' Nine Tails
\* Il giorno del giudizio ([http://www.imdb.com/title/tt0067135/|IMDb])
\* AKA: en: Day of Judgment
\* AKA: en: Doomsday
\* AKA: en: Drummer of Vengeance
\* Incontro ([http://www.imdb.com/title/tt0067244/|IMDb])
\* L''istruttoria è chiusa: dimentichi ([http://www.imdb.com/title/tt0067256/|IMDb])
\* AKA: fr: Nous sommes tous en liberté provisoire
\* La classe operaia va in paradiso ([http://www.imdb.com/title/tt0066919/|IMDb])
\* AKA: en: Lulu the Tool
\* AKA: en: The Working Class Goes to Heaven
\* La corta notte delle bambole di vetro ([http://www.imdb.com/title/tt0067384/|IMDb])
\* AKA: it: Malastrana
\* AKA: de: Das Todessyndrom
\* AKA: en: Kratka noc leptira
\* AKA: en: Paralyzed
\* AKA: en: Short Night of the Glass Dolls
\* AKA: de: Unter dem Skalpell des Teufels
\* [http://musicbrainz.org/show/url/?urlid=590291|La tarantola dal ventre nero]([http://www.imdb.com/title/tt0069343/|IMDb])
\* AKA: en: Black Belly of the Tarantula
\* AKA: fr: Tarentule au ventre noir
\* [http://musicbrainz.org/show/url/?urlid=590295|Le casse]([http://www.imdb.com/title/tt0068347/|IMDb])
\* AKA: it: Gli scassinatori
\* AKA: en: The Burglars
\* Maddalena ([http://www.imdb.com/title/tt0067376/|IMDb])
\* Nessuno deve sapere ([http://www.imdb.com/title/tt0218459/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590276|Oceano]([http://www.imdb.com/title/tt0067514/|IMDb])
\* AKA: en: The Wind Blows Free
\* Quattro mosche di velluto grigio ([http://www.imdb.com/title/tt0066735/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=438481|Sacco e Vanzetti]([http://www.imdb.com/title/tt0067698/|IMDb])
\* AKA: en: Sacco and Vanzetti
\* AKA: en: Sacco & Vanzetti
\* Sans mobile apparent ([http://www.imdb.com/title/tt0069219/|IMDb])
\* AKA: it: Senza movente
\* AKA: en: Without Apparent Motive
\* [http://musicbrainz.org/show/tag/?tag=film%20tre%20donne Tre donne]([http://www.soundtrackcollector.com/catalog/soundtrackdetail.php?movieid=22090f|soundtrackcollector])
\* AKA: en: Three Women
\* Tre nel mille ([http://www.imdb.com/title/tt0173355/|IMDb])
\* AKA: en: Storie dell''anno mille
\* Una lucertola con la pelle di donna ([http://www.imdb.com/title/tt0067361/|IMDb])
\* AKA: en: A Lizard in a Woman''s Skin
\* AKA: fr: Carole
\* AKA: fr: Le venin de la peur
\* AKA: fr: Les salopes vont en enfer
\* AKA: en: Lizard in a Woman''s Skin
\* AKA: en: Schizoid
\* AKA: sp: Una lagartija con piel de mujer
\* AKA: it: Una lucertola dalla pelle di donna
\* Veruschka ([http://www.imdb.com/title/tt0067942/|IMDb])
## \* AKA: it: Veruschka - poesia di una donna
''''''''''1972''''''''''
\* [http://musicbrainz.org/show/url/?urlid=590217|Anche se volessi lavorare, che faccio?]([http://www.imdb.com/title/tt0068209/|IMDb])
\* Bianchi bandinelli e la Colonna Traiana ([http://www.imdb.com/title/tt0286506/|IMDb])
\* Bluebeard ([http://www.imdb.com/title/tt0068294/|IMDb])
\* AKA: it: Barbablù
\* AKA: fr: Barbe-bleue
\* AKA: en: Blaubart
\* Che c''entriamo noi con la rivoluzione? ([http://www.imdb.com/title/tt0069547/|IMDb])
\* AKA: sp: ¡Qué nos importa la revolución!
\* AKA: en: What Am I Doing in the Middle of the Revolution?
\* [http://musicbrainz.org/show/url/?urlid=590211|Chi l''ha vista morire?]([http://www.imdb.com/title/tt0068367/|IMDb])
\* AKA: en: The Child
\* AKA: de: The Child - Die Stadt wird zum Alptraum
\* AKA: en: Who Saw Her Die?
\* [http://musicbrainz.org/show/url/?urlid=590285|Cosa avete fatto a Solange?]([http://www.imdb.com/title/tt0068416/|IMDb])
\* AKA: de: Das Geheimnis der grünen Stecknadel
\* AKA: en: Solange
\* AKA: en: Terror in the Woods
\* AKA: en: The School That Couldn''t Scream
\* AKA: en: The Secret of the Green Pins
\* AKA: en: What Have They Done to Solange?
\* AKA: en: What Have You Done to Solange?
\* AKA: en: Who Killed Solange?
\* AKA: en: Who''s Next?
\* Crescete e moltiplicatevi ([http://www.imdb.com/title/tt0134596/|IMDb])
\* D''amore si muore ([http://www.imdb.com/title/tt0069937/|IMDb])
\* AKA: en: For Love One Dies
\* Fiorina la vacca ([http://www.imdb.com/title/tt0068590/|IMDb])
\* Guttoso e il ''Marat morto'' di David ([http://www.imdb.com/title/tt0355508/|IMDb])
\* I figli chiedono perché ([http://www.imdb.com/title/tt0069074/|IMDb])
\* AKA: en: Why
\* I nicotera ([http://www.imdb.com/title/tt0437738/|IMDb])
\* I racconti di Canterbury ([http://www.imdb.com/title/tt0067647/|IMDb])
\* AKA: fr: Les contes de Canterbury
\* AKA: en: The Canterbury Tales
\* Il diavolo nel cervello ([http://www.imdb.com/title/tt0068484/|IMDb])
\* AKA: en: Devil in the Brain
\* AKA: fr: Le diable dans la tête
\* Il maestro e Margherita ([http://www.imdb.com/title/tt0068894/|IMDb])
\* AKA: en: Majstor i Margarita
\* AKA: en: The Master and Margaret
\* AKA: en: The Master and Margherite
\* Il ritorno di Clint il solitario ([http://www.imdb.com/title/tt0069184/|IMDb])
\* AKA: en: A Noose Is Waiting for You Trinity
\* AKA: sp: El retorno de Clint el solitario
\* AKA: en: The Return of Clint the Stranger
\* AKA: en: There''s a Noose Waiting for You Trinity!
\* AKA: en: There''s a Noose Waiting for You... Trinity!
\* AKA: sp: Ti attende una corda... Ringo
\* Imputazione di omicidio per uno studente ([http://www.imdb.com/title/tt0068735/|IMDb])
\* L''attentat ([http://www.imdb.com/title/tt0068233/|IMDb])
\* AKA: en: Das Attentat
\* AKA: de: Die tödliche Falle (Die Affäre Sadiel)
\* AKA: it: L''attentato
\* AKA: en: Plot
\* AKA: en: The Assassination
\* AKA: en: The French Conspiracy
\* L''automobile ([http://www.imdb.com/title/tt0237011/|IMDb])
\* L''ultimo uomo di Sara ([http://www.imdb.com/title/tt0069435/|IMDb])
\* AKA: en: Sarah''s Last Man
\* L''uomo e la magia ([http://www.imdb.com/title/tt0069447/|IMDb])
\* La banda J.S.: Cronaca criminale del Far West ([http://www.imdb.com/title/tt0068702/|IMDb])
\* AKA: en: Bandera Bandits
\* AKA: en: Bandits!
\* AKA: de: Die rote Sonne der Rache
\* AKA: en: Far West Story
\* AKA: en: J & S: Criminal Story of an Outlaw Couple
\* AKA: sp: Los hijos del día y de la noche
\* AKA: en: Sonny and Jed
\* La cosa buffa ([http://www.imdb.com/title/tt0068417/|IMDb])
\* Le tueur ([http://www.imdb.com/title/tt0069419/|IMDb])
\* AKA: en: Der Killer und der Kommissar
\* AKA: it: Il commissario Le Guen e il caso Gassot
\* AKA: en: Killer
\* La violenza: Quinto potere ([http://www.imdb.com/title/tt0069463/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=592045|La vita, a volte, è molto dura, vero Provvidenza?]([http://www.imdb.com/title/tt0069468/|IMDb])
\* AKA: en: Life Is Tough, Eh Providence?
\* AKA: de: Mausefalle für zwei schräge Vögel
\* AKA: fr: On m''appelle Providence
\* AKA: de: Providenza - Mausefalle für zwei schräge Vögel
\* AKA: en: Sometimes Life Is Hard - Right, Providence?
\* AKA: de: Zwei schaffen alle
\* Le moine ([http://www.imdb.com/title/tt0068960/|IMDb])
\* AKA: de: Der Mönch und die Frauen
\* AKA: it: Il monaco
\* AKA: en: The Monk
\* Les deux saisons de la vie ([http://www.imdb.com/title/tt0068479/|IMDb])
\* AKA: en: Les deux saisons
\* AKA: en: The Two Seasons of Life
\* AKA: be: Twee seizoenen van het leven
\* Lui per lei ([http://www.imdb.com/title/tt0183436/|IMDb])
\* Mio caro assassino ([http://www.imdb.com/title/tt0067434/|IMDb])
\* AKA: en: My Dear Killer
\* AKA: sp: Sumario sangriento de la pequeña Estefania
\* [http://musicbrainz.org/show/url/?urlid=592044|Quando la preda è l''uomo]([http://www.imdb.com/title/tt0069139/|IMDb])
\* AKA: it: Spogliati, protesta, uccidi!
\* AKA: en: When Man Is The Prey
\* Quando le donne persero la coda ([http://www.imdb.com/title/tt0067639/|IMDb])
\* AKA: de: Toll trieben es die alten Germanen
\* AKA: en: When Women Lost Their Tails
\* Questa specie d''amore ([http://www.imdb.com/title/tt0069148/|IMDb])
\* AKA: en: This Kind of Love
\* Sbatti il mostro in prima pagina ([http://www.imdb.com/title/tt0070641/|IMDb])
\* AKA: en: Slap the Monster on Page One
\* AKA: fr: Viol en première page
\* [http://musicbrainz.org/show/url/?urlid=591939|Un uomo da rispettare]([http://www.imdb.com/title/tt0069446/|IMDb])
\* AKA: en: A Man to Respect
\* AKA: de: Ein achtbarer Mann
\* AKA: en: Hearts and Minds
## \* AKA: en: The Master Touch
''''''''''1973''''''''''
\* Ci risiamo, vero Provvidenza? ([http://www.imdb.com/title/tt0069826/|IMDb])
\* AKA: sp: El bruto, el listo y el capitán
\* AKA: en: Here We Go Again, Eh Providence?
\* [http://musicbrainz.org/show/url/?urlid=592050|Giordando Bruno]([http://www.imdb.com/title/tt0070109/|IMDb])
\* Il mio nome è Nessuno ([http://www.imdb.com/title/tt0070215/|IMDb])
\* AKA: en: My Name Is Nobody
\* AKA: en: Lonesome Gun
\* AKA: de: Mein Name ist Nobody
\* AKA: fr: Mon nom est personne
\* La proprietà non è più un furto ([http://www.imdb.com/title/tt0070568/|IMDb])
\* AKA: fr: La propriété, c''est plus le vol
\* AKA: en: Property Is No Longer a Theft
\* Le Serpent ([http://www.imdb.com/title/tt0069251/|IMDb])
\* AKA: de: Die Schlange
\* AKA: it: Il serpente
\* AKA: en: Night Flight from Moscow
\* AKA: en: The Serpent
\* [http://musicbrainz.org/show/url/?urlid=590213|Libera, amore mio...]([http://www.imdb.com/title/tt0070308/|IMDb])
\* AKA: en: Libera, My Love
\* [http://musicbrainz.org/show/url/?urlid=590255|Quando l''amore è sensualità]([http://www.imdb.com/title/tt0140489/|IMDb])
\* AKA: en: When Love Is Lust
\* Rappresaglia ([http://www.imdb.com/title/tt0070592/|IMDb])
\* AKA: en: Massacre in Rome
\* AKA: fr: Représailles
\* [http://musicbrainz.org/show/url/?urlid=150812|Revolver]([http://www.imdb.com/title/tt0073626/|IMDb])
\* AKA: en: Blood in the Streets
\* AKA: de: Die perfekte Erpressung
\* AKA: en: In the Name of Love
\* AKA: fr: La poursuite implacable
\* Sepolta viva ([http://www.imdb.com/title/tt0152367/|IMDb])
\* Vaarwel ([http://www.imdb.com/title/tt0070862/|IMDb])
\* AKA: en: Farewell
\* AKA: en: The Romantic Agony
## \* AKA: nl: Vaarwel - Een sprookje
''''''''''1974''''''''''
\* Allonsanfàn ([http://www.imdb.com/title/tt0069690/|IMDb])
\* AKA: it: Allonsanfan
\* Fatti di gente perbene ([http://www.imdb.com/title/tt0071242/|IMDb])
\* AKA: en: Drama of the Rich
\* AKA: fr: La grande Bourgeoise
\* AKA: en: The Murri Affair
\* Il fiore delle mille e una notte ([http://www.imdb.com/title/tt0071502/|IMDb])
\* AKA: en: A Thousand and One Nights
\* AKA: en: Arabian Nights
\* AKA: en: Flower of the Arabian Nights
\* AKA: fr: Les mille et une nuits
\* [http://musicbrainz.org/show/url/?urlid=590203|Il giro del mondo degli innamorati di Peynet]([http://www.imdb.com/title/tt0178501/|IMDb])
\* Il sorriso del grande tentatore ([http://www.imdb.com/title/tt0073733/|IMDb])
\* AKA: en: The Devil Is a Woman
\* AKA: en: The Tempter
\* L''anticristo ([http://www.imdb.com/title/tt0071150/|IMDb])
\* AKA: en: Blasphemy
\* AKA: en: The Antichrist
\* AKA: en: The Tempter
\* [http://musicbrainz.org/show/url/?urlid=591944|La cugina]([http://www.imdb.com/title/tt0071377/|IMDb])
\* AKA: en: The Cousin
\* Le secret ([http://www.imdb.com/title/tt0072131/|IMDb])
\* AKA: it: Il segreto
\* AKA: en: The Secret
\* Le trio infernal ([http://www.imdb.com/title/tt0072320/|IMDb])
\* AKA: en: The Infernal Trio
\* AKA: de: Trio Infernal
\* AKA: it: Trio infernale
\* Milano odia: la polizia non può sparare ([http://www.imdb.com/title/tt0071840/|IMDb])
\* AKA: en: Almost Human
\* AKA: en: The Death Dealer
\* AKA: en: The Kidnap of Mary Lou
\* Moses the Lawgiver ([http://www.imdb.com/title/tt0072547/|IMDb])
\* AKA: it: Mosè
\* AKA: it: Mosè, la legge del deserto
\* AKA: en: Moses
\* Mussolini: Ultimo atto ([http://www.imdb.com/title/tt0071880/|IMDb])
\* AKA: en: Mussolini: The Last Four Days
\* AKA: en: The Last Days of Mussolini
\* AKA: en: The Last Four Days
\* AKA: en: The Last Tyrant
\* Sesso in confessionale ([http://www.imdb.com/title/tt0218598/|IMDb])
\* Spasmo ([http://www.imdb.com/title/tt0072196/|IMDb])
## \* AKA: en: The Death Dealer
''''''''''1975''''''''''
\* A Escola Aberta ([http://www.imdb.com/title/tt0132123/|IMDb])
\* Der Richter und sein Henker ([http://www.imdb.com/title/tt0075140/|IMDb])
\* AKA: it: Assassinio sul ponte
\* AKA: en: Deception
\* AKA: en: End of the Game
\* AKA: en: Getting Away with Murder
\* AKA: en: Murder on the Bridge
\* AKA: en: The Judge and His Hangman
\* [http://musicbrainz.org/show/url/?urlid=591892|Divina creatura]([http://www.imdb.com/title/tt0079058/|IMDb])
\* AKA: en: The Divine Nymph
\* [http://musicbrainz.org/show/url/?urlid=590277|Gente di rispetto]([http://www.imdb.com/title/tt0072123/|IMDb])
\* AKA: en: The Flower in His Mouth
\* AKA: en: The Masters
\* AKA: en: The Schoolmistress and the Devil
\* [http://musicbrainz.org/show/url/?urlid=591947|L''ultimo treno della notte]([http://www.imdb.com/title/tt0073836/|IMDb])
\* AKA: en: Don''t Ride on Late Night Trains
\* AKA: en: Last Stop on the Night Train
\* AKA: en: Late Night Trains
\* AKA: en: New House on the Left
\* AKA: en: Night Train Murders
\* AKA: en: Second House on the Left
\* AKA: en: The New House on the Left
\* AKA: en: Torture Train
\* AKA: it: Violenza sull''ultimo treno della notte
\* AKA: en: Xmas Massacre
\* La donna della domenica ([http://www.imdb.com/title/tt0074423/|IMDb])
\* AKA: fr: La femme du dimanche
\* AKA: en: The Sunday Woman
\* [http://musicbrainz.org/show/url/?urlid=590204|La faille]([http://www.imdb.com/title/tt0072910/|IMDb])
\* AKA: de: Der dritte Grad
\* AKA: it: La smagliatura
\* AKA: en: Weak Spot
\* Labbra di lurido blu ([http://www.imdb.com/title/tt0125826/|IMDb])
\* Leonor ([http://www.imdb.com/title/tt0073278/|IMDb])
\* AKA: fr: Léonor
\* AKA: en: Mistress of the Devil
\* Macchie solari ([http://www.imdb.com/title/tt0073327/|IMDb])
\* AKA: en: Autopsy
\* AKA: en: Sun Spots
\* AKA: en: Tarot
\* AKA: en: Tension
\* AKA: en: The Magician
\* AKA: en: The Victim
\* Per le antiche scale ([http://www.imdb.com/title/tt0073529/|IMDb])
\* AKA: en: Down the Ancient Staircase
\* AKA: en: Down the Ancient Stairs
\* AKA: fr: En descendant les marches d''antan
\* AKA: fr: Vertiges
\* [http://musicbrainz.org/show/url/?urlid=590296|Peur sur la ville]([http://www.imdb.com/title/tt0073535/|IMDb])
\* AKA: en: Fear Over the City
\* AKA: it: Il poliziotto della brigata criminale
\* AKA: en: The Night Caller
\* [http://musicbrainz.org/show/url/?urlid=591954|Salò o le 120 giornate di Sodoma]([http://www.imdb.com/title/tt0073650/|IMDb])
\* AKA: fr: Salo ou les 120 journées de Sodome
\* AKA: en: Salo, or the 120 Days of Sodom
\* Space: 1999 ([http://www.imdb.com/title/tt0072564/|IMDb])
\* AKA: it: Spazio: 1999
\* Storie di vita e malavita ([http://www.imdb.com/title/tt0073749/|IMDb])
\* AKA: en: Prostitute
\* AKA: en: The Teenage Prostitution Racket
\* The Human Factor ([http://www.imdb.com/title/tt0073131/|IMDb])
\* Un genio, due compari, un pollo ([http://www.imdb.com/title/tt0073036/|IMDb])
\* AKA: en: A Genius, Two Friends, and an Idiot
\* AKA: en: A Genius, Two Partners and a Dupe
\* AKA: de: Nobody ist der Größte
\* AKA: en: Nobody''s the Greatest
\* AKA: en: The Genius
\* AKA: en: Trinity Is Back Again
## \* AKA: fr: Un génie, deux associés, une cloche
''''''''''1976''''''''''
\* Ariel Limon ([http://www.imdb.com/title/tt0402805/|IMDb])
\* Attenti al buffone ([http://www.imdb.com/title/tt0159258/|IMDb])
\* AKA: en: Eye of the Cat
\* Drammi gotichi ([http://www.imdb.com/title/tt0206697/|IMDb])
\* Il deserto dei tartari ([http://www.imdb.com/title/tt0074400/|IMDb])
\* AKA: de: Die Tartarenwüste
\* AKA: fr: Le désert des Tartares
\* AKA: en: The Desert of the Tartars
\* [http://musicbrainz.org/show/url/?urlid=590275|L''agnese va a morire]([http://www.imdb.com/title/tt0074100/|IMDb])
\* AKA: en: And Agnes Chose to Die
\* L''arriviste ([http://www.imdb.com/title/tt0252240/|IMDb])
\* AKA: en: The Thruster
\* [http://musicbrainz.org/show/url/?urlid=592040|L''eredità Ferramonti]([http://www.imdb.com/title/tt0074487/|IMDb])
\* AKA: en: The Inheritance
\* Novecento ([http://www.imdb.com/title/tt0074084/|IMDb])
\* AKA: en: 1900
\* AKA: de: 1900 - Gewalt, Macht, Leidenschaft
\* AKA: de: 1900 - Kampf, Liebe, Hoffnung
\* AKA: fr: 1900: Seconde époque
\* Per amore ([http://www.imdb.com/title/tt0075054/|IMDb])
\* AKA: en: For Love
\* San Babila ore 20: un delitto inutile ([http://www.imdb.com/title/tt0201057/|IMDb])
\* AKA: en: San Babila-8 P.M.
\* Todo modo ([http://www.imdb.com/title/tt0075335/|IMDb])
## \* [http://musicbrainz.org/show/url/?urlid=591960|Una vita venduta]([http://www.imdb.com/title/tt0132607/|IMDb])
''''''''''1977''''''''''
\* Autostop rosso sangue ([http://www.imdb.com/title/tt0077188/|IMDb])
\* AKA: en: Death Drive
\* AKA: en: Hitch Hike
\* AKA: en: Hitchhike: Last House on the Left
\* AKA: en: The Naked Prey
\* Corleone ([http://www.imdb.com/title/tt0075879/|IMDb])
\* AKA: en: Father of the Godfathers
\* Exorcist II: The Heretic ([http://www.imdb.com/title/tt0076009/|IMDb])
\* AKA: en: The Exorcist 2
\* [http://musicbrainz.org/show/url/?urlid=590214|Holocaust 2000]([http://www.imdb.com/title/tt0077332/|IMDb])
\* AKA: en: Rain of Fire
\* AKA: en: The Chosen
\* AKA: en: The Hex Massacre
\* Il gatto ([http://www.imdb.com/title/tt0076069/|IMDb])
\* AKA: fr: Qui a tué le chat?
\* AKA: en: The Cat
\* Il mostro ([http://www.imdb.com/title/tt0076411/|IMDb])
\* AKA: en: The Fiend
\* Il prefetto di ferro ([http://www.imdb.com/title/tt0076564/|IMDb])
\* AKA: en: The Iron Prefect
\* Le ricain ([http://www.imdb.com/title/tt0076624/|IMDb])
\* AKA: en: The Man from Chicago
\* [http://musicbrainz.org/show/url/?urlid=590215|Orca]([http://www.imdb.com/title/tt0076504/|IMDb])
\* AKA: en: Orca: Killer Whale
\* AKA: en: The Killer Whale
\* [http://musicbrainz.org/show/url/?urlid=590242|René la canne]([http://www.imdb.com/title/tt0075130/|IMDb])
\* AKA: en: Rene the Cane
\* AKA: it: Tre simpatiche carogne
## \* Stato interessante ([http://www.imdb.com/title/tt0209351/|IMDb])
''''''''''1978''''''''''
\* An Englishman''s Castle ([http://www.imdb.com/title/tt0077007/|IMDb])
\* Così come sei ([http://www.imdb.com/title/tt0077373/|IMDb])
\* AKA: sp: Así como eres
\* AKA: en: Stay as You Are
\* AKA: en: Stay the Way You Are
\* [http://musicbrainz.org/show/url/?urlid=590244|Days of Heaven]([http://www.imdb.com/title/tt0077405/|IMDb])
\* Dove vai in vacanza? ([http://www.imdb.com/title/tt0077465/|IMDb])
\* AKA: en: Where Are You Going on Holiday?
\* FIFA World Cup 1978 (theme) ([ http://www.imdb.com/title/tt0397219/IMDb])
\* Forza Italia! ([http://www.imdb.com/title/tt0077577/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590251|Il prigioniero]([http://www.imdb.com/title/tt0480715/|IMDb])
\* Invito allo sport ([http://www.imdb.com/title/tt0307761/|IMDb])
\* L''immoralità ([http://www.imdb.com/title/tt0077726/|IMDb])
\* [http://www.imdb.com/title/tt0077288/ La cage aux folles]([http://www.imdb.com/title/tt0077288/|IMDb])
\* AKA: en: Birds of a Feather
\* AKA: it: Il vizietto
\* Le mani sporche ([http://www.imdb.com/title/tt0218423/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=591927|Noi lazzaroni]([http://www.imdb.com/title/tt0307796/|IMDb])
\* One, Two, Two: 122, rue de Provence ([http://www.imdb.com/title/tt0250630/|IMDb])
\* AKA: en: One Two Two
\* Pedro Páramo ([http://www.imdb.com/title/tt0329492/|IMDb])
## \* AKA: sp: El hombre de la media luna
''''''''''1979''''''''''
\* Bassie en Adriaan en de diamant ([http://www.imdb.com/title/tt0319947/|IMDb])
\* AKA: nl: De diamant
\* Bassie en Adriaan en het geheim van de sleutel ([http://www.imdb.com/title/tt0101043/|IMDb])
\* Bloodline ([http://www.imdb.com/title/tt0078879/|IMDb])
\* AKA: en: Blutspur
\* AKA: en: Sidney Sheldon''s Bloodline
\* De uitnodiging ([http://www.imdb.com/title/tt1079478/|IMDb])
\* Dedicato al mare Egeo ([http://www.imdb.com/title/tt0079037/|IMDb])
\* AKA: en: Dedicated to the Aegean Sea
\* AKA: jp: Ege-kai ni sasagu
\* Dietro il processo
\* I... comme Icare ([http://www.imdb.com/title/tt0079322/|IMDb])
\* AKA: en: I as in Icarus
\* AKA: en: I for Icarus
\* Il giocattolo ([http://www.imdb.com/title/tt0079211/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590257|Il prato]([http://www.imdb.com/title/tt0079745/|IMDb])
\* AKA: en: The Meadow
\* Kottan ermittelt ([http://www.imdb.com/title/tt0083438/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=128571|L''umanoide]([http://www.imdb.com/title/tt0080058/|IMDb])
\* AKA: en: Humanoid
\* AKA: en: The Humanoid
\* La luna ([http://www.imdb.com/title/tt0079495/|IMDb])
\* AKA: en: Luna
\* Le buone notizie ([http://www.imdb.com/title/tt0078917/|IMDb])
\* AKA: en: Good News
\* [http://musicbrainz.org/show/url/?urlid=590259|Operación Ogro]([http://www.imdb.com/title/tt0079655/|IMDb])
\* AKA: en: Ogro
\* AKA: en: Operation Ogre
\* Orient-Express ([http://www.imdb.com/title/tt0220255/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=591943|Viaggio con Anita]([http://www.imdb.com/title/tt0080094/|IMDb])
\* AKA: en: A Trip with Anita
\* AKA: en: Lovers and Liars
\* AKA: en: Travels with Anita
## \* AKA: fr: Voyage avec Anita
''''''''''1980''''''''''
\* Bugie bianche ([http://www.imdb.com/title/tt0080477/|IMDb])
\* AKA: it: Bugie veneziane
\* AKA: en: Footloose
\* AKA: it: Professione figlio
\* AKA: en: Venetian Lies
\* Il bandito dagli occhi azzurri ([http://www.imdb.com/title/tt0083667/|IMDb])
\* AKA: en: The Blue-Eyed Bandit
\* [http://musicbrainz.org/show/tag/?tag=film%20il%20pianeta%20d%20acqua&show=release Il pianeta d''acqua]
\* L''oeil ([http://www.imdb.com/title/tt0148545/|IMDb])
\* AKA: fr: L''oeil pervers
\* AKA: fr: Le facteur en vadrouille
\* La banquière ([http://www.imdb.com/title/tt0080415/|IMDb])
\* AKA: en: The Woman Banker
\* [http://musicbrainz.org/show/url/?urlid=590287|La cage aux folles II]([http://www.imdb.com/title/tt0080489/|IMDb])
\* AKA: it: Il vizietto II
\* Nouvelles rencontres ([http://www.imdb.com/title/tt0148540/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590253|Si salvi chi vuole]([http://www.imdb.com/title/tt0081509/|IMDb])
\* Stark System ([http://www.imdb.com/title/tt0081555/|IMDb])
\* The Fantastic World of M.C. Escher ([http://www.imdb.com/title/tt0133759/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590243|The Island]([http://www.imdb.com/title/tt0080934/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=591949|Un sacco bello]([http://www.imdb.com/title/tt0079839/|IMDb])
\* AKA: en: Fun Is Beautiful
\* Uomini e no ([http://www.imdb.com/title/tt0081692/|IMDb])
\* AKA: en: Men or Not Men
## \* Windows ([http://www.imdb.com/title/tt0081759/|IMDb])
''''''''''1981''''''''''
\* [http://musicbrainz.org/show/url/?urlid=591950|Bianco, rosso e Verdone]([http://www.imdb.com/title/tt0082073/|IMDb])
\* Il ladrone ([http://www.imdb.com/title/tt0078926/|IMDb])
\* AKA: it: Le ali della libertà
\* AKA: fr: Le larron
\* AKA: en: The Good Thief
\* AKA: en: The Thief
\* Il pianeta azzurro ([http://www.imdb.com/title/tt0194234/|IMDb])
\* La disubbidienza ([http://www.imdb.com/title/tt0082268/|IMDb])
\* AKA: fr: La désobéissance
\* La storia vera della signora dalle camelie ([http://www.imdb.com/title/tt0082230/|IMDb])
\* AKA: de: Die Kameliendame
\* AKA: fr: La dame aux camélias
\* AKA: en: Lady of the Camelias
\* AKA: en: The True Story of Camille
\* [http://musicbrainz.org/show/url/?urlid=590272|La tragedia di un uomo ridicolo]([http://www.imdb.com/title/tt0084813/|IMDb])
\* AKA: en: The Tragedy of a Ridiculous Man
\* AKA: en: Tragedy of a Ridiculous Man
\* La vera storia della signora dalle camelie ([http://www.imdb.com/title/tt0082230/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=515976|Le professionnel]([http://www.imdb.com/title/tt0082949/|IMDb])
\* AKA: en: The Professional
\* [http://musicbrainz.org/show/url/?urlid=240533|Occhio alla penna]([http://www.imdb.com/title/tt0082835/|IMDb])
\* AKA: en: Buddy Goes West
\* [http://musicbrainz.org/show/url/?urlid=590267|So Fine]([http://www.imdb.com/title/tt0083099/|IMDb])
## \* The Life and Times of David Lloyd George ([http://www.imdb.com/title/tt0163945/|IMDb])
''''''''''1982''''''''''
\* A Time to Die ([http://www.imdb.com/title/tt0086442/|IMDb])
\* AKA: en: Seven Graves for Rogan
\* Blood Link ([http://www.imdb.com/title/tt0083659/|IMDb])
\* AKA: de: Blood Link - Blutspur
\* AKA: it: Extrasensorial
\* AKA: en: The Link
\* [http://musicbrainz.org/show/url/?urlid=590246|Butterfly]([http://www.imdb.com/title/tt0082122/|IMDb])
\* Espion, lève-toi ([http://www.imdb.com/title/tt0082342/|IMDb])
\* Maja Plisetskaja ([http://www.imdb.com/title/tt0142638/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590283|Marco Polo]([http://www.imdb.com/title/tt0083446/|IMDb])
\* Nana ([http://www.imdb.com/title/tt0084387/|IMDb])
\* AKA: en: Nana, the True Key of Pleasure
\* AKA: en: Nana: La vera chiave del piacere
\* Porca vacca ([http://www.imdb.com/title/tt0195153/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=167772|The Thing]([http://www.imdb.com/title/tt0084787/|IMDb])
\* AKA: en: John Carpenter''s The Thing
## \* [http://musicbrainz.org/show/url/?urlid=590268|White Dog]([http://www.imdb.com/title/tt0084899/|IMDb])
''''''''''1983''''''''''
\* [http://musicbrainz.org/show/url/?urlid=591966|Copkiller]([http://www.imdb.com/title/tt0085366/|IMDb])
\* AKA: en: Order of Death
\* AKA: en: Cop Killers
\* AKA: it: Copkiller - l''assassino dei poliziotti
\* AKA: en: Corrupt
\* AKA: en: Corrupt Lieutenant
\* El tesoro de las cuatro coronas ([http://www.imdb.com/title/tt0084781/|IMDb])
\* AKA: en: Crown in the Temple of Doom
\* AKA: it: Il tesoro delle 4 corone
\* AKA: en: Treasure of the Four Crowns
\* Hundra ([http://www.imdb.com/title/tt0087436/|IMDb])
\* La chiave ([http://www.imdb.com/title/tt0085328/|IMDb])
\* AKA: en: The Key
\* Le marginal ([http://www.imdb.com/title/tt0085900/|IMDb])
\* AKA: en: The Outsider
\* [http://musicbrainz.org/show/url/?urlid=562320|Le ruffian]([http://www.imdb.com/title/tt0086214/|IMDb])
\* AKA: en: The Ruffian
\* Pelota ([http://www.imdb.com/title/tt0378549/|IMDb])
\* Sahara ([http://www.imdb.com/title/tt0086232/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590258|The Scarlet and the Black]([http://www.imdb.com/title/tt0086251/|IMDb])
\* AKA: it: Scarlatto e nero
## \* AKA: en: The Vatican Pimpernel
''''''''''1984''''''''''
\* Die Försterbuben ([http://www.imdb.com/title/tt0089183/|IMDb])
\* AKA: en: The Forester''s Sons
\* Don''t Kill God
\* Geheimcode: Wildgänse ([http://www.imdb.com/title/tt0087068/|IMDb])
\* AKA: it: Arcobaleno selvaggio
\* AKA: en: Code Name: Wild Geese
\* Les voleurs de la nuit ([http://www.imdb.com/title/tt0086557/|IMDb])
\* AKA: en: Thieves After Dark
\* [http://musicbrainz.org/show/url/?urlid=230791|Once Upon a Time in America]([http://www.imdb.com/title/tt0087843/|IMDb])
## \* AKA: it: C''era una volta in America
''''''''''1985''''''''''
\* Il mondo dell''orrore di Dario Argento ([http://www.imdb.com/title/tt0088989/|IMDb])
\* AKA: en: Dario Argento''s World of Horror
\* Il pentito ([http://www.imdb.com/title/tt0091744/|IMDb])
\* AKA: en: The Repenter
\* Kommando Leopard ([http://www.imdb.com/title/tt0089436/|IMDb])
\* AKA: en: Commando Leopard
\* [http://musicbrainz.org/show/url/?urlid=590288|La cage aux folles 3: ''Elles'' se marient]([http://www.imdb.com/title/tt0088873/|IMDb])
\* AKA: it: Il vizietto III
\* AKA: en: La cage aux Folles 3: The Wedding
\* AKA: it: Matrimonio con vizietto
\* [http://musicbrainz.org/show/url/?urlid=265868|La gabbia]([http://www.imdb.com/title/tt0091097/|IMDb])
\* AKA: en: Collector''s Item
\* AKA: en: Dead Fright
\* AKA: sp: La jaula
\* AKA: en: The Trap
\* La piovra 2 ([http://www.imdb.com/title/tt0185815/|IMDb])
\* AKA: de: Allein gegen die Mafia 2
\* AKA: en: The Octopus 2
\* [http://musicbrainz.org/show/url/?urlid=491777|Red Sonja]([http://www.imdb.com/title/tt0089893/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=591928|Via Mala]([http://www.imdb.com/title/tt0088637/|IMDb])
## \* Wer war Edgar Allan? ([http://www.imdb.com/title/tt0088389/|IMDb])
''''''''''1986''''''''''
\* C.A.T. Squad ([http://www.imdb.com/title/tt0090783/|IMDb])
\* AKA: en: Stalking Danger
\* La venexiana ([http://www.imdb.com/title/tt0092157/|IMDb])
\* AKA: en: The Venetian Woman
## \* [http://musicbrainz.org/show/url/?urlid=230790|The Mission]([http://www.imdb.com/title/tt0091530/|IMDb])
''''''''''1987''''''''''
\* Gli occhiali d''oro ([http://www.imdb.com/title/tt0093453/|IMDb])
\* AKA: fr: Les lunettes d''or
\* AKA: en: The Gold Rimmed Glasses
\* Il giorno prima ([http://www.imdb.com/title/tt0092781/|IMDb])
\* AKA: en: Control
\* AKA: fr: Contrôle
\* AKA: en: Mind Control
\* La piovra 3 ([http://www.imdb.com/title/tt0256568/|IMDb])
\* AKA: de: Allein gegen die Mafia 3
\* AKA: en: The Octopus 3
\* Mosca addio ([http://www.imdb.com/title/tt0093571/|IMDb])
\* AKA: en: Farewell Moscow
\* Quartiere ([http://www.imdb.com/title/tt0093807/|IMDb])
\* Rampage ([http://www.imdb.com/title/tt0095958/|IMDb])
## \* [http://musicbrainz.org/show/url/?urlid=221145|The Untouchables]([http://www.imdb.com/title/tt0094226/|IMDb])
''''''''''1988''''''''''
\* [http://musicbrainz.org/show/url/?urlid=590294|A Time of Destiny]([http://www.imdb.com/title/tt0096271/|IMDb])
\* C.A.T. Squad: Python Wolf ([http://www.imdb.com/title/tt0094823/|IMDb])
\* AKA: en: Python Wolf
\* Camillo Castiglioni oder die Moral der Haifische ([http://www.imdb.com/title/tt0094829/|IMDb])
\* [http://musicbrainz.org/show/url/?urlid=590262|Frantic]([http://www.imdb.com/title/tt0095174/|IMDb])
\* Gli angeli del poterev ([http://www.imdb.com/title/tt0277574/|IMDb])
\* Gli indifferenti ([http://www.imdb.com/title/tt0094471/|IMDb])
\* AKA: en: A Time of Indifference
\* Il cuore di mamma ([http://www.imdb.com/title/tt0062842/|IMDb])
\* AKA: en: Mother''s Heart
\* [http://musicbrainz.org/show/url/?urlid=238624|Il segreto del Sahara]([http://www.imdb.com/title/tt0092448/|IMDb])
\* AKA: de: Das Geheimnis der Sahara
\* AKA: sp: El secreto del Sahara
\* AKA: en: The Secret of the Sahara
\* Nuovo cinema Paradiso ([http://www.imdb.com/title/tt0095765/|IMDb])
\* AKA: fr: Cinema Paradiso
## \* AKA: en: Cinéma Paradiso
''''''''''1989''''''''''
\* 12 registi per 12 città ([http://www.imdb.com/title/tt0206251/|IMDb])
\* Casualties of War ([http://www.imdb.com/title/tt0097027/|IMDb])
\* Fat Man and Little Boy ([http://www.imdb.com/title/tt0097336/|IMDb])
\* AKA: en: Shadow Makers
\* I promessi sposi ([http://www.imdb.com/title/tt0094530/|IMDb])
\* AKA: en: The Betrothed
\* La piovra 4 ([http://www.imdb.com/title/tt0254038/|IMDb])
\* AKA: de: Allein gegen die Mafia 4
\* AKA: fr: Raid contre la mafia
\* AKA: en: The Octopus 4
\* Tempo di uccidere ([http://www.imdb.com/title/tt0100762/|IMDb])
\* AKA: fr: Le raccourci
\* AKA: en: The Short Cut
\* AKA: en: Time to Kill
## \* The ''burbs ([http://www.imdb.com/title/tt0096734/|IMDb])
''''''''''1990''''''''''
\* ¡Átame! ([http://www.imdb.com/title/tt0101026/|IMDb])
\* AKA: en: Tie Me Up! Tie Me Down!
\* Cacciatori di navi ([http://www.imdb.com/title/tt0100296/|IMDb])
\* AKA: en: Only One Survived
\* Dimenticare Palermo ([http://www.imdb.com/title/tt0099430/|IMDb])
\* AKA: fr: Oublier Palerme
\* AKA: en: The Palermo Connection
\* AKA: en: To Forget Palermo
\* Ennio Morricone: la musica negli occhi ([http://www.imdb.com/title/tt0317432/|IMDb])
\* AKA: en: Ennio Morricone: Music for the Eyes
\* Hamlet ([http://www.imdb.com/title/tt0099726/|IMDb])
\* La piovra 5 - Il cuore del problema ([http://www.imdb.com/title/tt0249310/|IMDb])
\* AKA: fr: Mort à Palerme
\* AKA: en: The Octopus 5
\* Stanno tutti bene ([http://www.imdb.com/title/tt0100681/|IMDb])
\* AKA: en: Everybody''s Fine
\* AKA: fr: Ils vont tous bien!
\* State of Grace ([http://www.imdb.com/title/tt0100685/|IMDb])
\* The Big Man ([http://www.imdb.com/title/tt0099136/|IMDb])
\* AKA: en: Crossing the Line
\* AKA: en: The Big Man: Crossing the Line
\* The Endless Game ([http://www.imdb.com/title/tt0099501/|IMDb])
\* Tracce di vita amorosa ([http://www.imdb.com/title/tt0100807/|IMDb])
\* AKA: en: Traces of an Amorous Life
\* [http://musicbrainz.org/show/url/?urlid=590265|Tre colonne in cronaca]([http://www.imdb.com/title/tt0202629/|IMDb])
\* Voyage of Terror: the Achille Lauro Affair ([http://www.imdb.com/title/tt0100889/|IMDb])
\* AKA: de: Die Entführung der Achille Lauro
## \* AKA: fr: Embarquement pour l''enfer
''''''''''1991''''''''''
\* Bugsy ([http://www.imdb.com/title/tt0101516/|IMDb])
\* Il principe del deserto ([http://www.imdb.com/title/tt0097988/|IMDb])
\* AKA: en: Desert Law
\* AKA: it: Maktub la legge del deserto
\* AKA: en: The Law of the Desert
\* Ilona und Kurti ([http://www.imdb.com/title/tt0101720/|IMDb])
\* AKA: en: German Guy Sexy! The Story of Ilona and Kurti
\* La domenica specialmente ([http://www.imdb.com/title/tt0101753/|IMDb])
\* AKA: en: Especially on Sunday
\* AKA: fr: Le dimanche de préférence
\* La thune ([http://www.imdb.com/title/tt0105586/|IMDb])
\* AKA: en: Money
\* La villa del venerdì ([http://www.imdb.com/title/tt0105755/|IMDb])
\* AKA: en: Husbands and Lovers
\* AKA: en: In Excess
\* Mio caro dottor Gräsler ([http://www.imdb.com/title/tt0102449/|IMDb])
## \* AKA: en: The Bachelor
''''''''''1992''''''''''
\* A csalás gyönyöre ([http://www.imdb.com/title/tt0104037/|IMDb])
\* AKA: en: Rapture of DeceitCREATE UNIQUE indexes failing.
artist_name_idx_name on table artist_name
label_name_idx_name on label_name
release_name_idx_name on release_name
tag_idx_name on tag
track_name_idx_name on track_name
url_idx_url on url
work_name_idx_name on work_name
Artists that don't exist in artist/artist_credit/artist_credit_name tables but they do in artist_name table
For example, if u query the "artist_name" table where "id" in (178605, 178606, 178607, 178608), u get results like: "David Bowie 'and something else'". And if u do the query in the tables "artist"/"artist_credit"/"artist_credit_name" where name in (the same id's as above) u get no results.
Load table data without decompressing first
Currently we download, decompress and use LOAD DATA INFILE on https://github.com/elliotchance/mbzdb/blob/master/backend/mysql.pl, but I think decompressing to disk isn't really needed: we could decompress to a pipe and LOAD DATA from it, avoiding slow seek times and extra disk space needed for decompression :
mkfifo /tmp/fifo
tar -xjf mbdump.tgz artist -O > /tmp/fifo &
LOAD DATA LOCAL INFILE '/tmp/fifo' INTO TABLE ....
BTW, this should be configurable by user (fifo path, etc).
Update Download Location HTTP 404 NOT FOUND
Seems that the $schema_url in Settings.pl needs to be updated to the new locations.
OLD download location advises...
"OUTDATED. Please see https://github.com/metabrainz/musicbrainz-server instead" ??
However the install I have doesn't let me use https? And trying to install CPAN HTTPS fails?
Can we get this updated?
Kind Regards,
Ryan
As Discussed below:
MySQL text indexes need to be much longer.
MySQL requires all text indexes to have a length. At the moment this is 32 characters which is not enough to define uniqueness on URL strings.
MySQL: Need to rename INTERVAL type
In schema update:
...
Table editor_watch_preferences
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERVAL NOT NULL DEFAULT '1 week'' at line 1 at backend/mysql.pl line 360, line 1028.
Table editor_watch_artist
...
release_meta_sanitised - always null for column coverarturl
Column 'coverarturl' has always a NULL value on 'release_meta' table
Replication file(s) can not be found from windows DEL/RMDIR-command - and not be deleted
After importing the data from the single replication files (actually with 'current_replication_sequence' >= 600) the commands around linenumber 620 in the file 'functions.pl' doesn't work anymore.
This lines works for my Windows 7:
# Clean up. Remove old replication
if($^O eq "MSWin32") {
system("del replication\replication-$currep.tar >nul");
system("rd replication$currep /S /Q");
} else {
system("$g_rm -f "replication/replication-$currep.tar.bz2"");
system("$g_rm -f "replication/replication-$currep.tar"");
system("$g_rm -f -r "replication/$currep"");
}
Maybe you could adjust some global definitions in the 'builtins.pl'
GID redirect tables have no indexes
Currently none of the *_gid_redirect tables have indexes.
Although these tables are relatively small, I think an index should be created at least for the gid field (and possibly on th newid field if we want to do reverse lookups, i.e. get which GIDs have been associated with a particular entity).
Replication not working..
Seems that the replication URL is pointing to the test server, and the test server is not responding. Should we be using the old schema? I tried setting up without using NGS, and with, and pointed replication to http://ftp.musicbrainz.org/pub/musicbrainz/data/replication, as well as http://test.musicbrainz.org:82/pub/musicbrainz/data/replication. Neither combination worked. What is the status of NGS, should I be using that w/replication, or old schema? Which replication url should I be using?
Create views from CreateSimpleViews.sql on install (feature request)
Add option to init.pl for loading mod edits
MySQL: Problems with schema update
From init.pl:
...
Table work_type
Table ATE array_cat_agg(anyarray)
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= array_cat' at line 1 at backend/mysql.pl line 360, line 37.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= anyarray' at line 1 at backend/mysql.pl line 360, line 37.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1 at backend/mysql.pl line 360, line 37.
DBD::mysql::db do failed: You can't delete all columns with ALTER TABLE; use DROP TABLE instead at backend/mysql.pl line 360, line 37.
Table dbmirror_Pending
...
CreateTables.sql
As i understand the latest non-NG DB shema is on this location:
http://svn.musicbrainz.org/mb_server/branches/RELEASE_20090524-BRANCH/admin/sql/CreateTables.sql
It differs from the one you use in mbzdb
Error Install / Update database schematic
I had previous installed MB_MySqL and had existing tables with data in my database. Not sure if this may have caused the issue but figured I would include it just in case.
Table dbmirror_Pending
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NAME NOT NULL' at line 1 at backend/mysql.pl line 353, line 943.
SQL-Errors initializing a new MySQL-DB with NGS tables
Initializing a new created MySQL-DB with the 'Init.pl' from 10.12.2010 show:
...
Tabelle work_name
Tabelle work_tag
Tabelle work_type
Tabelle ATE array_cat_agg(anyarray)
DBD::mysql::db do failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near '= array_cat' at line 1 at backend/mysql.pl line 359, line 37.
DBD::mysql::db do failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near '= anyarray' at line 1 at backend/mysql.pl line 359, line 37.
DBD::mysql::db do failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1 at backend/mysql.pl line 359, line 37.
DBD::mysql::db do failed: You can't delete all columns with ALTER TABLE; use DROP TABLE instead at backend/mysql.pl line 359, line 37.
Tabelle dbmirror_Pending
Tabelle dbmirror_PendingData
Logging into MusicBrainz FTP...
The latest is mbdump is '20101123'
Sat Dec 11 12:40:40 2010: Downloading mbdump-derived.tar.bz2... Done
Sat Dec 11 12:42:37 2010: Downloading mbdump-stats.tar.bz2... Done
...
This issue should be tracked and resolved when NGS becomes stable.
DELETE not working on artist table and maybe other tables
I noticed that statistics from musicbrainz and my database is not equal, so I investigated and found out, that replication updates don't delete the artists.....
I think the issue is in NULL fields in WHERE clause ... if it is empty it means NULL but i think it passes empty string instead, so query gets no results....
23485645 | 56167 | nz"."artist | d | 183711504 | NULL | "id"='53240' "name"='824319' "sort_name"='824319' "type"='2' "country"= "gender"=
I don't know why all this stuff is needed in WHERE clause... ID would be enough.
EDIT:
Just checked it is the same with table "release"
Clean mbdump after load
All the mbdump files need not take up hard disk space once they are loaded in.
Init results in massive amount of errors
I'm not sure if these can be ignored, but I have the user and DB created, but running the init script (and selecting yes) results in the following (using Postgres):
Ready to proceed? (it may take over 24 hours for this script to fully
complete) (y/n): y
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "kv_pkey" for table "kv"
Downloading schema... Done
Table annotation
NOTICE: ALTER TABLE will create implicit sequence "annotation_id_seq" for serial column "annotation.id"
Table artist
NOTICE: ALTER TABLE will create implicit sequence "artist_id_seq" for serial column "artist.id"
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist" ADD "("
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "artist" ADD "(end_date_year" IS NOT NULL OR
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "artist" ADD ")" OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "AND"
LINE 1: ALTER TABLE "artist" ADD "(end_date_year" IS NULL AND
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table artist_alias_type
NOTICE: ALTER TABLE will create implicit sequence "artist_alias_type_id_seq" for serial column "artist_alias_type.id"
Table artist_alias
NOTICE: ALTER TABLE will create implicit sequence "artist_alias_id_seq" for serial column "artist_alias.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "<>"
LINE 1: ALTER TABLE "artist_alias" ADD "(type" <> 3) OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table artist_annotation
Table artist_ipi
Table artist_meta
Table artist_tag
Table artist_rating_raw
Table artist_tag_raw
Table artist_credit
NOTICE: ALTER TABLE will create implicit sequence "artist_credit_id_seq" for serial column "artist_credit.id"
Table artist_credit_name
Table artist_gid_redirect
Table artist_name
NOTICE: ALTER TABLE will create implicit sequence "artist_name_id_seq" for serial column "artist_name.id"
Table artist_type
NOTICE: ALTER TABLE will create implicit sequence "artist_type_id_seq" for serial column "artist_type.id"
Table autoeditor_election
NOTICE: ALTER TABLE will create implicit sequence "autoeditor_election_id_seq" for serial column "autoeditor_election.id"
Table autoeditor_election_vote
NOTICE: ALTER TABLE will create implicit sequence "autoeditor_election_vote_id_seq" for serial column "autoeditor_election_vote.id"
Table cdtoc
NOTICE: ALTER TABLE will create implicit sequence "cdtoc_id_seq" for serial column "cdtoc.id"
Table cdtoc_raw
NOTICE: ALTER TABLE will create implicit sequence "cdtoc_raw_id_seq" for serial column "cdtoc_raw.id"
Table clientversion
NOTICE: ALTER TABLE will create implicit sequence "clientversion_id_seq" for serial column "clientversion.id"
Table country
NOTICE: ALTER TABLE will create implicit sequence "country_id_seq" for serial column "country.id"
Table edit
NOTICE: ALTER TABLE will create implicit sequence "edit_id_seq" for serial column "edit.id"
Table edit_note
NOTICE: ALTER TABLE will create implicit sequence "edit_note_id_seq" for serial column "edit_note.id"
Table edit_artist
Table edit_label
Table edit_release
Table edit_release_group
Table edit_recording
Table edit_work
Table edit_url
Table editor
NOTICE: ALTER TABLE will create implicit sequence "editor_id_seq" for serial column "editor.id"
Table editor_language
DBD::Pg::db do failed: ERROR: type "fluency" does not exist
LINE 1: ALTER TABLE "editor_language" ADD "fluency" FLUENCY NOT NULL
^ at backend/postgresql.pl line 184, line 1410.
Table editor_preference
NOTICE: ALTER TABLE will create implicit sequence "editor_preference_id_seq" for serial column "editor_preference.id"
Table editor_subscribe_artist
NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_artist_id_seq" for serial column "editor_subscribe_artist.id"
Table editor_subscribe_label
NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_label_id_seq" for serial column "editor_subscribe_label.id"
Table editor_subscribe_editor
NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_editor_id_seq" for serial column "editor_subscribe_editor.id"
Table gender
NOTICE: ALTER TABLE will create implicit sequence "gender_id_seq" for serial column "gender.id"
Table isrc
NOTICE: ALTER TABLE will create implicit sequence "isrc_id_seq" for serial column "isrc.id"
Table iswc
NOTICE: ALTER TABLE will create implicit sequence "iswc_id_seq" for serial column "iswc.id"
Table l_artist_artist
NOTICE: ALTER TABLE will create implicit sequence "l_artist_artist_id_seq" for serial column "l_artist_artist.id"
Table l_artist_label
NOTICE: ALTER TABLE will create implicit sequence "l_artist_label_id_seq" for serial column "l_artist_label.id"
Table l_artist_recording
NOTICE: ALTER TABLE will create implicit sequence "l_artist_recording_id_seq" for serial column "l_artist_recording.id"
Table l_artist_release
NOTICE: ALTER TABLE will create implicit sequence "l_artist_release_id_seq" for serial column "l_artist_release.id"
Table l_artist_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_artist_release_group_id_seq" for serial column "l_artist_release_group.id"
Table l_artist_url
NOTICE: ALTER TABLE will create implicit sequence "l_artist_url_id_seq" for serial column "l_artist_url.id"
Table l_artist_work
NOTICE: ALTER TABLE will create implicit sequence "l_artist_work_id_seq" for serial column "l_artist_work.id"
Table l_label_label
NOTICE: ALTER TABLE will create implicit sequence "l_label_label_id_seq" for serial column "l_label_label.id"
Table l_label_recording
NOTICE: ALTER TABLE will create implicit sequence "l_label_recording_id_seq" for serial column "l_label_recording.id"
Table l_label_release
NOTICE: ALTER TABLE will create implicit sequence "l_label_release_id_seq" for serial column "l_label_release.id"
Table l_label_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_label_release_group_id_seq" for serial column "l_label_release_group.id"
Table l_label_url
NOTICE: ALTER TABLE will create implicit sequence "l_label_url_id_seq" for serial column "l_label_url.id"
Table l_label_work
NOTICE: ALTER TABLE will create implicit sequence "l_label_work_id_seq" for serial column "l_label_work.id"
Table l_recording_recording
NOTICE: ALTER TABLE will create implicit sequence "l_recording_recording_id_seq" for serial column "l_recording_recording.id"
Table l_recording_release
NOTICE: ALTER TABLE will create implicit sequence "l_recording_release_id_seq" for serial column "l_recording_release.id"
Table l_recording_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_recording_release_group_id_seq" for serial column "l_recording_release_group.id"
Table l_recording_url
NOTICE: ALTER TABLE will create implicit sequence "l_recording_url_id_seq" for serial column "l_recording_url.id"
Table l_recording_work
NOTICE: ALTER TABLE will create implicit sequence "l_recording_work_id_seq" for serial column "l_recording_work.id"
Table l_release_release
NOTICE: ALTER TABLE will create implicit sequence "l_release_release_id_seq" for serial column "l_release_release.id"
Table l_release_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_release_release_group_id_seq" for serial column "l_release_release_group.id"
Table l_release_url
NOTICE: ALTER TABLE will create implicit sequence "l_release_url_id_seq" for serial column "l_release_url.id"
Table l_release_work
NOTICE: ALTER TABLE will create implicit sequence "l_release_work_id_seq" for serial column "l_release_work.id"
Table l_release_group_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_release_group_release_group_id_seq" for serial column "l_release_group_release_group.id"
Table l_release_group_url
NOTICE: ALTER TABLE will create implicit sequence "l_release_group_url_id_seq" for serial column "l_release_group_url.id"
Table l_release_group_work
NOTICE: ALTER TABLE will create implicit sequence "l_release_group_work_id_seq" for serial column "l_release_group_work.id"
Table l_url_url
NOTICE: ALTER TABLE will create implicit sequence "l_url_url_id_seq" for serial column "l_url_url.id"
Table l_url_work
NOTICE: ALTER TABLE will create implicit sequence "l_url_work_id_seq" for serial column "l_url_work.id"
Table l_work_work
NOTICE: ALTER TABLE will create implicit sequence "l_work_work_id_seq" for serial column "l_work_work.id"
Table label
NOTICE: ALTER TABLE will create implicit sequence "label_id_seq" for serial column "label.id"
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label" ADD "("
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "label" ADD "(end_date_year" IS NOT NULL OR
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "label" ADD ")" OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "AND"
LINE 1: ALTER TABLE "label" ADD "(end_date_year" IS NULL AND
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table label_rating_raw
Table label_tag_raw
Table label_alias_type
NOTICE: ALTER TABLE will create implicit sequence "label_alias_type_id_seq" for serial column "label_alias_type.id"
Table label_alias
NOTICE: ALTER TABLE will create implicit sequence "label_alias_id_seq" for serial column "label_alias.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "<>"
LINE 1: ALTER TABLE "label_alias" ADD "(type" <> 2) OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table label_annotation
Table label_ipi
Table label_meta
Table label_gid_redirect
Table label_name
NOTICE: ALTER TABLE will create implicit sequence "label_name_id_seq" for serial column "label_name.id"
Table label_tag
Table label_type
NOTICE: ALTER TABLE will create implicit sequence "label_type_id_seq" for serial column "label_type.id"
Table language
NOTICE: ALTER TABLE will create implicit sequence "language_id_seq" for serial column "language.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "CONSTRAINT"
LINE 1: ALTER TABLE "language" ADD "ADD" CONSTRAINT iso_code_check
^ at backend/postgresql.pl line 184, line 1410.
Table link
NOTICE: ALTER TABLE will create implicit sequence "link_id_seq" for serial column "link.id"
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "link" ADD "("
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "link" ADD "(end_date_year" IS NOT NULL OR
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "link" ADD ")" OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "AND"
LINE 1: ALTER TABLE "link" ADD "(end_date_year" IS NULL AND
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "link" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "link" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table link_attribute
Table link_attribute_type
NOTICE: ALTER TABLE will create implicit sequence "link_attribute_type_id_seq" for serial column "link_attribute_type.id"
Table link_type
NOTICE: ALTER TABLE will create implicit sequence "link_type_id_seq" for serial column "link_type.id"
Table link_type_attribute_type
Table editor_collection
NOTICE: ALTER TABLE will create implicit sequence "editor_collection_id_seq" for serial column "editor_collection.id"
Table editor_collection_release
Table editor_watch_preferences
Table editor_watch_artist
Table editor_watch_release_group_type
Table editor_watch_release_status
Table medium
NOTICE: ALTER TABLE will create implicit sequence "medium_id_seq" for serial column "medium.id"
Table medium_cdtoc
NOTICE: ALTER TABLE will create implicit sequence "medium_cdtoc_id_seq" for serial column "medium_cdtoc.id"
Table medium_format
NOTICE: ALTER TABLE will create implicit sequence "medium_format_id_seq" for serial column "medium_format.id"
Table puid
NOTICE: ALTER TABLE will create implicit sequence "puid_id_seq" for serial column "puid.id"
Table replication_control
NOTICE: ALTER TABLE will create implicit sequence "replication_control_id_seq" for serial column "replication_control.id"
Table recording
NOTICE: ALTER TABLE will create implicit sequence "recording_id_seq" for serial column "recording.id"
Table recording_rating_raw
Table recording_tag_raw
Table recording_annotation
Table recording_meta
Table recording_gid_redirect
Table recording_puid
NOTICE: ALTER TABLE will create implicit sequence "recording_puid_id_seq" for serial column "recording_puid.id"
Table recording_tag
Table release
NOTICE: ALTER TABLE will create implicit sequence "release_id_seq" for serial column "release.id"
Table release_raw
NOTICE: ALTER TABLE will create implicit sequence "release_raw_id_seq" for serial column "release_raw.id"
Table release_tag_raw
Table release_annotation
Table release_gid_redirect
Table release_meta
DBD::Pg::db do failed: ERROR: type "cover_art_presence" does not exist
LINE 1: ...TER TABLE "release_meta" ADD "cover_art_presence" cover_art_...
^ at backend/postgresql.pl line 184, line 1410.
Table release_coverart
Table release_label
NOTICE: ALTER TABLE will create implicit sequence "release_label_id_seq" for serial column "release_label.id"
Table release_packaging
NOTICE: ALTER TABLE will create implicit sequence "release_packaging_id_seq" for serial column "release_packaging.id"
Table release_status
NOTICE: ALTER TABLE will create implicit sequence "release_status_id_seq" for serial column "release_status.id"
Table release_tag
Table release_group
NOTICE: ALTER TABLE will create implicit sequence "release_group_id_seq" for serial column "release_group.id"
Table release_group_rating_raw
Table release_group_tag_raw
Table release_group_annotation
Table release_group_gid_redirect
Table release_group_meta
Table release_group_tag
Table release_group_primary_type
NOTICE: ALTER TABLE will create implicit sequence "release_group_primary_type_id_seq" for serial column "release_group_primary_type.id"
Table release_group_secondary_type
NOTICE: ALTER TABLE will create implicit sequence "release_group_secondary_type_id_seq" for serial column "release_group_secondary_type.id"
Table release_group_secondary_type_join
Table release_name
NOTICE: ALTER TABLE will create implicit sequence "release_name_id_seq" for serial column "release_name.id"
Table script
NOTICE: ALTER TABLE will create implicit sequence "script_id_seq" for serial column "script.id"
Table script_language
NOTICE: ALTER TABLE will create implicit sequence "script_language_id_seq" for serial column "script_language.id"
Table tag
NOTICE: ALTER TABLE will create implicit sequence "tag_id_seq" for serial column "tag.id"
Table tag_relation
Table track
NOTICE: ALTER TABLE will create implicit sequence "track_id_seq" for serial column "track.id"
Table track_raw
NOTICE: ALTER TABLE will create implicit sequence "track_raw_id_seq" for serial column "track_raw.id"
Table track_name
NOTICE: ALTER TABLE will create implicit sequence "track_name_id_seq" for serial column "track_name.id"
Table tracklist
NOTICE: ALTER TABLE will create implicit sequence "tracklist_id_seq" for serial column "tracklist.id"
Table tracklist_index
Table url
NOTICE: ALTER TABLE will create implicit sequence "url_id_seq" for serial column "url.id"
Table url_gid_redirect
Table vote
NOTICE: ALTER TABLE will create implicit sequence "vote_id_seq" for serial column "vote.id"
Table work
NOTICE: ALTER TABLE will create implicit sequence "work_id_seq" for serial column "work.id"
Table work_rating_raw
Table work_tag_raw
Table work_alias_type
NOTICE: ALTER TABLE will create implicit sequence "work_alias_type_id_seq" for serial column "work_alias_type.id"
Table work_alias
NOTICE: ALTER TABLE will create implicit sequence "work_alias_id_seq" for serial column "work_alias.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "<>"
LINE 1: ALTER TABLE "work_alias" ADD "(type" <> 2) OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "work_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "work_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table work_annotation
Table work_gid_redirect
Table work_meta
Table work_name
NOTICE: ALTER TABLE will create implicit sequence "work_name_id_seq" for serial column "work_name.id"
Table work_tag
Table work_type
NOTICE: ALTER TABLE will create implicit sequence "work_type_id_seq" for serial column "work_type.id"
Table dbmirror_Pending
NOTICE: ALTER TABLE will create implicit sequence "dbmirror_Pending_SeqId_seq" for serial column "dbmirror_Pending.SeqId"
Table dbmirror_PendingData
Logging into MusicBrainz FTP (ftp.musicbrainz.org)...
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.