English Amiga Board


Go Back   English Amiga Board > abime.net - Hall Of Light > HOL data problems

 
 
Thread Tools
Old 26 October 2012, 14:43   #1
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
s2325's further contributions

Doubled entries, one with incorrect title: http://hol.abime.net/hol_search.php?find=forest%20dum
s2325 is offline  
Old 26 October 2012, 17:32   #2
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Can a mod move the above post and this one to HOL data problems?

Quote:
Originally Posted by s2325 View Post
Doubled entries, one with incorrect title: http://hol.abime.net/hol_search.php?find=forest%20dum
Thanks.

I suppose you mean "Forest Dumb Forever!!!" and "Forest Dump Forever".

I would correct this, but it is possible that the person who added this as an alternate title read that name in a preview/early release...

So let's wait a week and then I'll modify the entry accordingly if no answer is posted (and anyway it will be easy to revert back).
lilalurl is offline  
Old 26 October 2012, 22:59   #3
prowler
Global Moderator
 
prowler's Avatar
 
Join Date: Aug 2008
Location: Sidcup, England
Posts: 10,300
Quote:
Originally Posted by lilalurl View Post
Can a mod move the above post and this one to HOL data problems?
Done.

Not a very imaginative title, I'm afraid, but I guess it'll do.
prowler is offline  
Old 26 October 2012, 23:11   #4
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Thanks and lol at the title
lilalurl is offline  
Old 29 October 2012, 14:51   #5
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
Kwatermaster developers: http://hol.abime.net/4388
Tomek Liebich should be Tomasz Liebich
Michat Widera should be Michal Widera (letter L with additional diagonal line is special polish character)
s2325 is offline  
Old 29 October 2012, 15:01   #6
TCD
HOL/FTP busy bee
 
TCD's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 46
Posts: 31,608
Thank you

Can't update Tomek Liebich as I get a DB error Will report back once it's fully fixed.
TCD is offline  
Old 29 October 2012, 15:19   #7
CodyJarrett
Global Moderator
 
CodyJarrett's Avatar
 
Join Date: Mar 2001
Location: UK
Age: 46
Posts: 6,160
Check out the box scan for Forest Dump Forever: http://hol.abime.net/606/boxscan
CodyJarrett is offline  
Old 29 October 2012, 15:23   #8
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
You're right! I think someone who made such "high" quality boxart didn't check title.
s2325 is offline  
Old 29 October 2012, 20:12   #9
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Quote:
Originally Posted by TheCyberDruid View Post
Thank you

Can't update Tomek Liebich as I get a DB error Will report back once it's fully fixed.
Probably because there is already an artist called Tomasz Liebich (probably the same).
I guess we will have to correct each game entry and then delete the Tomek artist entry.



And lol at the Forest Dump box. I did not think to check that.
lilalurl is offline  
Old 29 October 2012, 20:18   #10
TCD
HOL/FTP busy bee
 
TCD's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 46
Posts: 31,608
Quote:
Originally Posted by lilalurl View Post
Probably because there is already an artist called Tomasz Liebich (probably the same).
I guess we will have to correct each game entry and then delete the Tomek artist entry.
A little bit more helpful feedback would be nice, but at least I know the reason now. It was the only game with a credit for 'Tomek' Liebich, so I've updated the entry and we'll never talk about it again
TCD is offline  
Old 29 October 2012, 20:26   #11
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Errr more details?

I believe that you tried to update the entry for Tomek L. to Tomasz L.
However, there already existed a Tomasz L.

So I guess (really just a guess) that the database gave you an error because it detected two artist entries with identical content.
lilalurl is offline  
Old 29 October 2012, 20:28   #12
TCD
HOL/FTP busy bee
 
TCD's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 46
Posts: 31,608
The case you outlined is so far correct

If you try to change 'Doug Smith' to 'Gene Smith' (which already exists) you get:
Code:
Query failed
UPDATE data_artist SET S_artist='Gene Smith', D_birth=NULL, D_death=NULL, S_www='', S_private_addresses='', S_email='', N_ref_mothercountry='0', S_notes='', S_private_notes='' WHERE N_id_artist=1266
I bet your first guess would have been 'Ah, duplicate name, of course'
(it's really not visible why the query fails, because you can't see the 'UNIQUE Constraint' for S_artist... if you know what I mean )
TCD is offline  
Old 29 October 2012, 20:29   #13
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
Yes, the same. Tomek = kid, Tomasz = adult.
s2325 is offline  
Old 29 October 2012, 20:46   #14
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Yeah, I don't really know why but duplicate/similar entry would have been my first guess (zerond guess would have been illegal character which can happen with some Polish names ).

Quote:
Originally Posted by s2325 View Post
Yes, the same. Tomek = kid, Tomasz = adult.
Can you tell a bit more?

I guess we can add some notes to the artist entry such as:
"also known as Tomek Liebich. Tomek is actually the name variant for Tomasz used in Poland until an individual is adult"

Not sure what the conditions of the name changes are though.
lilalurl is offline  
Old 29 October 2012, 21:15   #15
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
You can see here http://en.wikipedia.org/wiki/Thomas_%28name%29
s2325 is offline  
Old 03 November 2012, 11:19   #16
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
If you see in polish game something like it's still the same letter. All forms are in use.
s2325 is offline  
Old 10 November 2012, 14:54   #17
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
Graphician Danuta Stenkowska http://hol.abime.net/4606 should be Danuta Sienkowska as you can see here with more readable fonts: http://hol.abime.net/4654
s2325 is offline  
Old 10 November 2012, 17:42   #18
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Thanks, name corrected and credits changed to have the same artist entry.

Since Marek Pasek is also involved in the same games, there is no doubt that it is indeed the same person.
lilalurl is offline  
Old 15 November 2012, 21:41   #19
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 43
Posts: 17,789
It's not possible to zoom miscshot in World Golf http://hol.abime.net/1771/miscshot
s2325 is offline  
Old 15 November 2012, 22:04   #20
lilalurl
Global Moderator
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Posts: 3,289
Send a message via ICQ to lilalurl
Very strange.

I have the same issue as you if I check it as a simple HOL user.
However, if I login as a supercontributor I can zoom in.

I am afraid I can't do anything. Perhaps some core team members will know better.
lilalurl is offline  
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Contributions Eclipse HOL contributions 370 07 February 2022 16:52
Tweeky's Various Contributions Tweeky HOL contributions 136 06 June 2020 22:08
s2325's contributions s2325 HOL contributions 379 13 October 2017 14:20
Contributions from me :) stainy AMR contributions 0 09 May 2009 14:33

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 07:35.

Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Page generated in 0.11046 seconds with 13 queries