English Amiga Board    


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

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

Doubled entries, one with incorrect title: http://hol.abime.net/hol_search.php?find=forest%20dum
s2325 is offline   Reply With Quote
Old 26 October 2012, 17:32   #2
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
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).
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 26 October 2012, 22:59   #3
prowler
Global Moderator
 
prowler's Avatar
 
Join Date: Aug 2008
Location: Sidcup, England
Posts: 8,694
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   Reply With Quote
Old 26 October 2012, 23:11   #4
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
Send a message via ICQ to lilalurl
Thanks and lol at the title
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 29 October 2012, 14:51   #5
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
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   Reply With Quote
Old 29 October 2012, 15:01   #6
TheCyberDruid
Moderator
 
TheCyberDruid's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 35
Posts: 22,433
Thank you

Can't update Tomek Liebich as I get a DB error Will report back once it's fully fixed.
__________________


"I am Polka and that's why I don't like accordions" - CrazyOne, April 2013
TheCyberDruid is offline   Reply With Quote
Old 29 October 2012, 15:19   #7
CodyJarrett
Global Moderator
 
CodyJarrett's Avatar
 
Join Date: Mar 2001
Location: UK
Age: 35
Posts: 5,439
Check out the box scan for Forest Dump Forever: http://hol.abime.net/606/boxscan
CodyJarrett is offline   Reply With Quote
Old 29 October 2012, 15:23   #8
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
You're right! I think someone who made such "high" quality boxart didn't check title.
s2325 is offline   Reply With Quote
Old 29 October 2012, 20:12   #9
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
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.
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 29 October 2012, 20:18   #10
TheCyberDruid
Moderator
 
TheCyberDruid's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 35
Posts: 22,433
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
__________________


"I am Polka and that's why I don't like accordions" - CrazyOne, April 2013
TheCyberDruid is offline   Reply With Quote
Old 29 October 2012, 20:26   #11
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
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.
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 29 October 2012, 20:28   #12
TheCyberDruid
Moderator
 
TheCyberDruid's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 35
Posts: 22,433
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 )
__________________


"I am Polka and that's why I don't like accordions" - CrazyOne, April 2013
TheCyberDruid is offline   Reply With Quote
Old 29 October 2012, 20:29   #13
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
Yes, the same. Tomek = kid, Tomasz = adult.
s2325 is offline   Reply With Quote
Old 29 October 2012, 20:46   #14
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
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.
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 29 October 2012, 21:15   #15
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
You can see here http://en.wikipedia.org/wiki/Thomas_%28name%29
s2325 is offline   Reply With Quote
Old 03 November 2012, 11:19   #16
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
If you see in polish game something like it's still the same letter. All forms are in use.
s2325 is offline   Reply With Quote
Old 10 November 2012, 14:54   #17
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
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   Reply With Quote
Old 10 November 2012, 17:42   #18
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
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.
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 15 November 2012, 21:41   #19
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
It's not possible to zoom miscshot in World Golf http://hol.abime.net/1771/miscshot
s2325 is offline   Reply With Quote
Old 15 November 2012, 22:04   #20
lilalurl
T32
 
lilalurl's Avatar
 
Join Date: Aug 2001
Location: France
Age: 33
Posts: 2,120
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.
__________________
"Dancing plants are immortal" (s2325)
"I don't want my drumsticks and dragon steaks to vanish" (Thorham)
lilalurl is offline   Reply With Quote
Old 29 January 2013, 07:40   #21
s2325
Zone Friend
 
s2325's Avatar
 
Join Date: Jun 2006
Location: Gargore
Age: 32
Posts: 11,238
Graphician and musician are swapped in Strefa Ciemnosci as you can see on title screen: http://hol.abime.net/4241
s2325 is offline   Reply With Quote
Old 29 January 2013, 07:46   #22
TheCyberDruid
Moderator
 
TheCyberDruid's Avatar
 
Join Date: Sep 2006
Location: Germany
Age: 35
Posts: 22,433
Thanks for spotting it Fixed.
__________________


"I am Polka and that's why I don't like accordions" - CrazyOne, April 2013
TheCyberDruid is offline   Reply With Quote
Reply


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

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Contributions Eclipse HOL contributions 292 Yesterday 20:32
s2325's contributions s2325 HOL contributions 238 06 May 2013 20:22
Various Contributions Tweeky HOL contributions 76 26 February 2013 10:32
Contributions from me :) stainy AMR contributions 0 09 May 2009 14:33


All times are GMT +2. The time now is 03:11.

-->

Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Page generated in 1.22257 seconds with 11 queries