yashsingh1/xdaforums huggingface dataset:
[Sony Cross-Device General] vint_o_rez:
Hi, that's awesome tool.

Here is an error after some user -- for D5503 CustNo 1279-6212 not RU it's for China, user flash .142 firmware uploaded by Dogsly, and then add this CustNo with wrong mapping to country

Can I offer to do premoderate for added CustNo by users, i mean that added CustNo is showing with some tag before a few other users confirm that mapping is correct?
[Sony Cross-Device General] Macmol:
I have replaced the country.
[Sony Cross-Device General] RyomaEchizen:
:confused: :confused: :confused:
[Sony Cross-Device General] RyomaEchizen:
Sorry, works now

Enviado desde mi C6502 mediante Tapatalk
[Sony Cross-Device General] Ilko:
okay, but in that case I suppose these entries must have confirmed values. I guess that with a such feature, the program may remove an entry by mistake... (ie : bad link, unavailable service etc...) isn't it ?
[Sony Cross-Device General] Macmol:
Actually, the time for disabling the entry is 14 days.

If the entry can be succesfully checked within these 14 days, the errorflag is set to "none" again.

Next time the entry has an error, the 14 days periad starts again and so on...
[Sony Cross-Device General] Ilko:
you're the boss

Made in ZR
[Sony Cross-Device General] tyw7:
Getting error about inability to connect to SQL Database
[Sony Cross-Device General] Macmol:
Do you still get the error?
[Sony Cross-Device General] tyw7:
I got the error yesterday.
[Sony Cross-Device General] dogsly:
Sony Xperia Z2

D6502

update url:

http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=en-US&model=D6502&devId=352494060837963&tac_mc=35249406&swId=1278-4770&swVer=17.1.A.1.2&fsVariant=GLOBAL-HSPA&cdfVer=R1A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable&cdfId=

cust: 1279-0968 Commercial And Journalists

D6503

update url:

http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=en-US&model=D6503&devId=352876060125894&tac_mc=35287606&swId=1278-4770&swVer=17.1.A.1.2&fsVariant=GLOBAL-LTE&cdfVer=R1A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable&cdfId=

cust: 1279-0989 Commercial And Journalists

Thanks IaguCool - original post
[Sony Cross-Device General] Macmol:
Updated, thank you very much.
[Sony Cross-Device General] 1jkan:
Will you do on the Z1 Compact?
[Sony Cross-Device General] Macmol:
What do you mean?

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] 1jkan:
Is the help of the part program can check the firmware for the Z1 Compact?
[Sony Cross-Device General] Macmol:
As far as I know I have already integrated the z1c

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] 1jkan:
Yes. Now I've found. Thanks!
[Sony Cross-Device General] istux:
Hello, thank you for this helpful tool. :good:

Just a question: any chance to remove wrong links from "check for firmwares" section? :confused:
[Sony Cross-Device General] Macmol:
I have removed the links whithout a valid url. And some double links :)
[Sony Cross-Device General] istux:
Thank you, please could you delete the last link too? It's wrong (the right one is three lines above)

It wasn't me, it was a kind of revenge for the list which I take care of for the Xperia T/V/TX/TL, that you can find here: http://xdaforums.com/showthread.php?t=2648320

I don't tell the story, because it doesn't worth it... anyway this childish guy thought to mess up Updatechecker list using my name as a revenge.

Sad but true :rolleyes:

I suggest to remove the "posted by" column just to avoid very stupid situation like this one in the future. ;)

Cheers
[Sony Cross-Device General] Macmol:
In germany we call this "Kindergarten" :)

I have removed the entry.
[Sony Cross-Device General] dogsly:
Macmol

Please remove my link to the firmware. I added a different model.

Perhaps we should find a way to notify you of an incorrect or harmful link to firmware? Often mistaken myself or other users add the wrong firmware.
[Sony Cross-Device General] Macmol:
Removed...

I have no idea at the moment, how i can implement a system to remove wrong or dead links.

I don't want to give everyone the right to remove something because i am afraid of some people misusing the system.

Any suggestions are welcome!
[Sony Cross-Device General] Rootk1t:
votes can be implemented, for example user downloaded firmware, flashed, it works good, user makes comment that this firmware/link is good or just clicks on button that increases counter on good side. If it is not working or there are another problems, user clicks on another button. Smth like a "Like" :good: system on social.
[Sony Cross-Device General] haresh311999:
Please add support for Xperia M Dual C2005/C2004.
[Sony Cross-Device General] Macmol:
As far as I know the M dual is already integrated

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] haresh311999:
Thank you for your response, I asked because I didn't see it in the supported device list......
[Sony Cross-Device General] MagicMagicD:
Not sure how you've got it setup at the moment but certainly for the actual update check it feels as though the web service calls are being done on the UI thread as the application seems to become intermittently unresponsive.

It'd be great if you could push all that IO (maybe even the database startup code too) in to the background to stop the application hanging. I know you're using .net 3.5 so that means you can't use any of the new async/await functionality added in 4.5 but you should still be able to make use of the ThreadPool or even just a BackgroundWorker for a single background thread.

It's one of my bugbears as Microsoft always tell developers never to make blocking calls on the UI thread but then seem to do it all the time themselves... drives me crazy! ;)

Anyway, cheers dude and keep up the good work... :)
[Sony Cross-Device General] mrjraider:
I keep getting this error:

Windows 8.1 64bit

All the required programs etc are installed and updated to last version...

So I dont get it...
[Sony Cross-Device General] Macmol:
Strange. Do you still get the error or was this a temporary problem?
[Sony Cross-Device General] Macmol:
Thank you for your suggestions to improve the tool.

But at the moment i am a little bit busy. I have a lot of work and free time is rare.

As soon as it is possible i going to implement some new things.

Cheers, Mac
[Sony Cross-Device General] mrjraider:
All the time. Sometimes the programm/tools loads but after a few minutes the error comes.

Also sometimes just an error..

And sometimes it opens but gets stuck or the list stays empty..
[Sony Cross-Device General] Macmol:
It seems that the connection to the database is some kind of "instable".

But to be honest: I have no clue why.....

Is there anybody else with the same problem?
[Sony Cross-Device General] Gjole86:
i do,

the app works only the first time used after unzipping

after that i need to do upzip again so i dont get the error
[Sony Cross-Device General] Macmol:
Only once??

Very strange.

Try this:

Open the MySQL website, download the .Net - connector and install it.

Delete the mysql-dll in the tool directory.

Maybe this helps.

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] Rootk1t:
maybe several tips:

1). you should try to find free mysql/web hosting which is not so laggy, cause the existing is very slow.

2). fix interface hang while programme working, as was requested several pages ago.
[Sony Cross-Device General] pascalbrax:
[MENTION=5230217]Macmol[/MENTION], I can provide you a free mysql db if you need, just pm me.
[Sony Cross-Device General] Macmol:
I#ll do my best... If i find some time to do it.

I am open to all tips and suggestions. If you can give me a free hoster, let me know.
[Sony Cross-Device General] Macmol:
A Beta update is coming tomorrow.

I hope you'll like it.

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] Macmol:
A new beta-version 1.5.3.3 is available!

What's new?

The database requests and the check of the sony servers are now running in a different thread.

While checking data, the UI remains responsive with this version.

A report system for the firmwares has been integrated. If you find a dead link, you can press the "report-button" and i will check it out.

Link

https://app.box.com/s/6z9o3g5tm14ttq2hp09x

You don't have to download this version, it's just for testing purposes.

But if you like, feel free to use it!

PS. For the Beta-Testers: Are there any bugs in the new version?

Plese give me some feedback...

EDIT:

If you get an error while starting the tool, please download again. Sorry, my mistake...
[Sony Cross-Device General] Rootk1t:
Great Job!

It definitely feels more responsive now. No new bugs noticed.
[Sony Cross-Device General] RyomaEchizen:
Unable to connect to any of the specified MySQL hosts :confused:

Error while connecting to the database :(
[Sony Cross-Device General] ArtBcn:
+1, exactly the same errors
[Sony Cross-Device General] dogsly:
Update tool to version 1.5.3.3
[Sony Cross-Device General] Macmol:
Nothing has changed. No new version and the database is up and running (tested a few moments ago).

Please download the latest version.

Mac
[Sony Cross-Device General] Macmol:
I need help!

I need help!

in the last version i introduced the "report-feature" for broken firmware links.

So far, so good... BUT:

Almost every reported link i check is downloadable without problems.

Can someone explain me why the links are reported? Is it possible that they are down only in some countries ?

I (WE) need an idea how to get rid of the "false-reports". Every tip is welcome.

Feel free to revive this thread ;)

Mac
[Sony Cross-Device General] RyomaEchizen:
I have it
[Sony Cross-Device General] Macmol:
Has it ever worked?
[Sony Cross-Device General] RyomaEchizen:
Yes. 2 days ago

Enviado desde mi Sony Xperia ZL (C6502) mediante Tapatalk 4
[Sony Cross-Device General] Macmol:
Strange, have you installed any OS updates? Or any thing else?

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] RyomaEchizen:
Maybe Windows Update yes

Enviado desde mi Sony Xperia ZL (C6502) mediante Tapatalk 4
[Sony Cross-Device General] Macmol:
I have created a little tool to check out the error.

https://app.box.com/s/dghxyd17hnzqt5nuv01e

Please start the tool and tell what's in the textbox.

Mac
[Sony Cross-Device General] Macmol:
I hoped to get a better error description :(.

The host the tool tries to connect is db4free.Net. What is hsppening if you try to open this in your browser?
[Sony Cross-Device General] Hyins:
There is a list of Xperia Z Ultra C6833 CDA

http://xdaforums.com/showpost.php?p=52545178&postcount=92
[Sony Cross-Device General] Macmol:
Thank you, do you also have some URLs?

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] Hyins:
****-**** = cust. no.

Xperia Z Ultra C6802:
http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=en-US&model=C6802&devId=357656050000000&tac_mc=35765605&swId=****-****&swVer=14.1.B.0.461&fsVariant=HSPA&cdfId=****-****&cdfVer=R0A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

Xperia Z Ultra C6806:
http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=en-US&model=C6806&devId=358081050000000&tac_mc=35808105&swId=****-****&swVer=14.1.B.0.461&fsVariant=LTE&cdfId=****-****&cdfVer=R0A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

Xperia Z Ultra C6833:
http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=en-US&model=C6833&devId=358080050000000&tac_mc=35808005&swId=****-****&swVer=14.1.B.0.461&fsVariant=LTE&cdfId=****-****&cdfVer=R0A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

Xperia Z Ultra BR C6843:
http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=en-US&model=C6843&devId=358934050000000&tac_mc=35893405&swId=1277-0849&swVer=14.1.B.0.461&fsVariant=LTE&cdfId=1277-0849&cdfVer=R0A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

Xperia Z Ultra JP SOL24:
http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=ja-JP&model=SOL24&devId=351849060000000&tac_mc=35184906&swId=1278-7984&swVer=14.1.K.1.215&fsVariant=KDDI-LTE&cdfId=1278-7984&cdfVer=R10A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

Xperia Z Ultra CN XL39h:
http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=zh-CN&model=XL39h&devId=357656050000000&tac_mc=35765605&swId=1275-3244&swVer=14.1.B.0.461&fsVariant=HSPA&cdfId=1275-3244&cdfVer=R0A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable
[Sony Cross-Device General] Macmol:
Ty, I'll check it on monday.

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] john_cena163:
is there any problem with the tool now i get error ,, cannot connect, unable to connect to any of the specified MySQL host

Lol Finaly workn
[Sony Cross-Device General] RyomaEchizen:
Weird

Now i can connect too :eek:
[Sony Cross-Device General] pascalbrax:
"db4free.net is a testing environment, db4free.net is not suitable for production"

You should really use a different DB host. You have one in your Private messages. ;)
[Sony Cross-Device General] Macmol:
Ok.

I think it's time to make a change...

I'll update the tool to use a new host. Thank you very much [MENTION=3189658]pascalbrax[/MENTION].

Mac

EDIT: Update is online, please download it. The old host isn't updated anymore.
[Sony Cross-Device General] pascalbrax:
You can save the reported links in a temp table and use the client IP as primary key and if you get at least 3 (or 4 or five, you should see how it works) different IPs from the same reported link, then we can think it's a legit report from thre (or four, or five) different people, otherwise it's just someone who abused the report function.
[Sony Cross-Device General] dogsly:
Sony Tablet Z2 (SGP521)

http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=ru-RU&model=SGP521&devId=352945060074507&tac_mc=35294506&swId=1278-4804&swVer=17.1.A.2.55&fsVariant=GLOBAL-LTE&cdfId=1281-7867&cdfVer=R7A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

1281-7867 - RU

Thanks leo270789
[Sony Cross-Device General] RyomaEchizen:
Works great :good:
[Sony Cross-Device General] Macmol:
Added...
[Sony Cross-Device General] Macmol:
I'll check that out soon...

Ty!
[Sony Cross-Device General] Rootk1t:
New version doesn't work at all for me:(

Got two errors on start.
[Sony Cross-Device General] Macmol:
I'm gonna sk the owner of the host if we can do something.

I googled the problem an found the following: "When someone connects, the (mysql)server tries to do a reverse lookup of the IP address you are connecting from."

Maybe there is a problem with your DNS...
[Sony Cross-Device General] Rootk1t:
maybe, i''ll try later from another location, but previous version worked good everywhere, at least for me.
[Sony Cross-Device General] pascalbrax:
Weird, the system and the database are up and running.

can you tell me if you can reach http://ovh.scavenger.ch/ or if it gives you some error?
[Sony Cross-Device General] Rootk1t:
checked, working good.

I think it is somehow connected with reverse lookup of the IP address, for users who use internet through proxy.

For direct connected, everything should work perfectly.
[Sony Cross-Device General] Macmol:
We changed some parameters. Can you test once again with your proxy?
[Sony Cross-Device General] Rootk1t:
now works perfectly. The speed increase is noticeable.:good:
[Sony Cross-Device General] Macmol:
I have added your information. Thank you very much!
[Sony Cross-Device General] DrizztDWX:
Don't work for me today.
[Sony Cross-Device General] ShinOrochiX:
+1, hasn't been working for me for past few days.
[Sony Cross-Device General] Macmol:
I will have a look on monday.
[Sony Cross-Device General] pascalbrax:
Have you updated to the latest version? Database works for me...
[Sony Cross-Device General] Macmol:
I assume you are on the latest version of the tool.

Can you tell me if you can reach http://ovh.scavenger.ch/ or if it gives you some error?

Are you behind a proxy?
[Sony Cross-Device General] ShinOrochiX:
Hi macmol,

I am using the latest version and still getting the error. When I try to go on the link you provided I get an image of scavenger graphics and the following text...

"This is scavenger.ch crunch data system 2.

This system is powered by AMD Opteron Processor CPU @ 3.00GHz."

No, I am not behind a proxy server.
[Sony Cross-Device General] Macmol:
[MENTION=3189658]pascalbrax[/MENTION] is creating a test-database where you can try to connect with HeidiSql. Maybe we have better error-messages as with the .Net-connector. I'll send you the login data as soon as i have it.
[Sony Cross-Device General] Macmol:
Here we go:

Download HeidiSql (free) and use the following login data:

host: ovh.scavenger.ch

database: demo

user: demo

password: demodb

port: 3303

Please report back, if you can connect or not....
[Sony Cross-Device General] Rootk1t:
Noticed strange behaviour. Checked twice.
[Sony Cross-Device General] Macmol:
This is the URL from ID 753:

http://fuas.sonymobile.com/fuas/ser...mat=delta,image&channel=cable&cdfId=1272-9921

Check yourself,nothing useful in the xml-file... :(

Sometimes, the invalid entries seems to heal themselves magically. Wait until tomorrow and recheck.
[Sony Cross-Device General] Rootk1t:
yep, now it's working good.
[Sony Cross-Device General] Bassheadzero:
"error while connect with the database"

how can i fix this?
[Sony Cross-Device General] Macmol:
Read post #330

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] ShinOrochiX:
Hi,

Just tried it, I've never used that software before so don't know much on how it works, here's a screenshot.
[Sony Cross-Device General] Macmol:
It seems, you are connected. Can you connect with XUC in the meantime?

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] ShinOrochiX:
No, still get the same error. As of now I am just using this site, it seems to work fine (don't know if it is linked to the server your app uses?). Still haven't got 4.3 in the UK! :(
[Sony Cross-Device General] Macmol:
Maybe there is a problem decrypting the login data. I'll check that tomorrow.

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] Macmol:
I have uploaded a new version.

Please check again and report back. I have extended the errorhandling for the database connection.

Mac

P.S:

The datbases are not linked (as far as i know :) ) It's only the same host. [MENTION=3189658]pascalbrax[/MENTION] was so friendly and gave us the possibility to store my database on his server.
[Sony Cross-Device General] pascalbrax:
Nope. The databases are not linked in any way. In fact my website doesn't even have a database, the returned firmware versions are retrieved straight from Sony server or from my site's internal cache. I fully respect Macmol's job and have a strong ethics about his right for secrecy and privacy. In fact I have no idea what's stored in his database or how it works.
[Sony Cross-Device General] dogsly:
Sony Xperia Z2 Tablet SPG512

http://fuas.sonymobile.com/fuas/services/updates?clientName=PCC&clientVersion=3.0&lang=ru-RU&model=SGP512&devId=11003000023640&tac_mc=11003000&swId=1278-4514&swVer=17.1.A.2.36&fsVariant=GLOBAL-WIFI32G&cdfId=1282-4184&cdfVer=R6A&buildVariant=USER&clientCertType=live&updateFormat=delta,image&channel=cable

1282-4184 RU
[Sony Cross-Device General] ShinOrochiX:
Is the new version, 1.5.3.2? If so then the problem persists, if not then could you give me the link to the new version-I downloaded my current one from your op.
[Sony Cross-Device General] Macmol:
1.5.4.2:

https://app.box.com/s/gt2cqxlx2ddben3fcmjp
[Sony Cross-Device General] ShinOrochiX:
Great news, it's working! I think you should update the link in the op, it may well be that the old version became obsolete.
[Sony Cross-Device General] Macmol:
Thank you for the hint.

I have updated the zipfile.

Have fun!
[Sony Cross-Device General] Macmol:
Done.
[Sony Cross-Device General] DooMLoRD:
hi good work with this!

have a request

please fork our FlashTool device repo:

https://github.com/Androxyde/devices

and send pull requests when you add a cust URL (sample):

https://github.com/Androxyde/devices/commit/83100e68a25f35039b9462ba4378b4dd7e8f0c40

https://github.com/Androxyde/devices/blob/master/D65XX/updates/D6503/updateurl

this will help us add larger support in FlashTool!

thanks & regards,

DooMLoRD
[Sony Cross-Device General] Macmol:
Hi DoomLoRD,

i hope i can provide you some information for your very useful tool (thank you very much for it!).

I have created a repository on GitHub, where all the url's of XUC has been saved:

https://github.com/Macmol/XperiaUpdateChecker

Please report back, if this is what you want or if you need some other information.

Mac
[Sony Cross-Device General] kamalmawa:
Z2 Australia

I just added following two for Xperia Z2 D6503

Optus : 1280-9502

Vodafone AU : 1282-1393
[Sony Cross-Device General] Tiu Fiu:
Hey brother,

First of all, great job :good:

Second, could you add support for the D6543, the Brazilian DTV-LTE version of the Z2?

Thanks for your great work.
[Sony Cross-Device General] Macmol:
Done. Now fill it with your data....

Mac
[Sony Cross-Device General] Rootk1t:
Strange thing. Working flawlessly under WinXP, installed Win8 and now it can't connect to DB.

Same conection, same internet provider, same settings.:confused:
[Sony Cross-Device General] Macmol:
...but wrong os :)

Have you checked your firewall?
[Sony Cross-Device General] nonyhaha:
I cannot add under windows 8 any device, i get "there was an error while getting the version information of your device. please correct your input."

Also, smsniff does not work under windows 8. It does not log anything.

Is there any other way to add z1 compact 1280-7983.4 ? countries served: SK, PL, CS.
[Sony Cross-Device General] Macmol:
You can try another sniffer. Maybe another tool may work under Win8.

Another way is trying to look into the folder of the PCC.

As far as i know, there is a file which contains the url after an update.

Mac
[Sony Cross-Device General] Rootk1t:
after several reboots everythings is working good. Didn't change any settings.:p
[Sony Cross-Device General] Macmol:
Me too ☺

Gesendet von meinem C2105 mit Tapatalk
[Sony Cross-Device General] Tiu Fiu:
Xperia T2 Ultra Dual

[MENTION=5230217]Macmol[/MENTION]

A new user - [MENTION=5948475]sknurt[/MENTION] - has just requested me to ask you, if possible, to include another device in your app, the D5322 Xperia T2 Ultra Dual. Since I'm still getting the hang of your Updatechecker's details, I've had no luck in including this device myself.

Could you do the honors and include this model, please?

BTW I've included the details of the D6543 (at least the Generic BR firmware, as it was the only firmware I managed to get the fuas.sonymobile.com full address). I'll try to update it with the other firmwares details as soon as I find some spare time.

I'll PM [MENTION=5948475]sknurt[/MENTION] to let him know and to try to fill in the details of his device as soon as you include it.

Thanks
[Sony Cross-Device General] Macmol:
Hi,

the D5322 database entry is online. Feel free to fill it with data :)

Mac
[Sony Cross-Device General] Macmol:
I have added the ST18i (Xperia Ray).
[Sony Cross-Device General] funky0308:
Any chance to build Android apk instead exe?

Tnx mate ;)
[Sony Cross-Device General] Macmol:
Just rename it ;)

Bad Joke, i know.....

I haven't made any Android-Apps so far but i want to do so.

Don't expect too much, unfortunately my free time is rare.

Cheers, Mac
[Sony Cross-Device General] funky0308:
Yeah… unfortunately we are all limited with our work and other things…

But if you ever find some free time, that could be nice app…

Anyway… tnx for this app/program
[Sony Cross-Device General] darthxa:
great work guys
[Sony Cross-Device General] iBuzman:
Any Linux guru ported this great tool across yet?