Can't upload census

Narlash · Post by **Narlash** » Mon Nov 24, 2014 6:16 am

So, since yesterday I can't seem to get my uploads uploaded. When I try and upload the censusplus.lua I get a page that says:

"IP: 37.123.160.xx
United States"
(last digits omited for privacy)

Nothing else, no processing message, no new status in my uploads under my user.

Anyone else experiencing this?

Post by **bringoutyourdead** » Mon Nov 24, 2014 11:19 am

how big is your upload file?
The upload via web post to this site hits a limit near 10MB..
I would recommend not going above 8MB.

The uniuploader method will handle much larger files since the data is pre-compressed before sending.

Post by **bringoutyourdead** » Mon Nov 24, 2014 1:22 pm

Did some more checking and verified your full IP (noticed it had been reset recently.. not an issue)
Confirmed you have been doing straight web uploading, but couldn't check what the file sizes were as that is data I don't normally need so I don't have access.
I do have a work around.. if I know the date/time of the upload attempt.

I would suggest that if your data file is over 8MB.. then prune your data and try again.
If it isn't over 8MB then try again.. and if you get the same failure to finish the upload then send me a PM with as close as you can the exact date/time of your upload and what the current byte count is on that file.

At this point as far as I can tell the failure point was the upload never finished getting to the site.

Narlash · Post by **Narlash** » Mon Nov 24, 2014 7:00 pm

I prune it daily actually, my server is just really REALLY busy. And I submit both Horde and Alliance entries. I've tried getting UniUploader to work following the instructions, but I couldn't get it to last time.
Let me try setting it up again and I'll report back.

Narlash · Post by **Narlash** » Mon Nov 24, 2014 7:08 pm

UniUploader keeps telling me to click Browse to select the SV file.
Problem is, there's no button that's called browse, anywhere. I've tried every button simple and advanced.

Post by **bringoutyourdead** » Tue Nov 25, 2014 12:29 am

same problem I am fighting...
you have a WoW account that starts with an Alpha character..

newer accounts are all numeric based.
how many days are you keeping when you prune?

Narlash · Post by **Narlash** » Tue Nov 25, 2014 7:43 am

default - I think 30 days? I should probably do the manual syntax prune.

Post by **bringoutyourdead** » Tue Nov 25, 2014 11:28 am

Depending on your play time usage..
If you only really play on one realm, I would suggest logging in on that realm and doing
/census serverprune
that will remove census data from all of the other realms (cross realms etc.)

If you play on more then one realm and want to keep some/most of that data...
then log in each realm/faction and
/census prune number of days to keep.... eg. /census prune 20

If you want you can do a prune down 29,28,27....n until you get a successful upload. Then for safety buffer reasons prune a couple more days off.

Re: uniuploader
I do intend to get around to finding a fix for that program.
It is as far as I can tell mostly orphaned.
While the (some?) source code is available, it is written in C#.
I don't currently have tools for nor do I have that much knowledge about the C# language.

Padanfain · Post by **Padanfain** » Tue Nov 25, 2014 11:23 pm

Using UU Ver 2.8.1.74... Not sure if that was the last version available or not but...

Upload of

C:\Program Files (x86)\World of Warcraft\WTF\Account\CAEDMONXXX\SavedVariables\CensusPlus.lua

Edit: XXX are numbers edited out.......

resulted:
Nov 25, 14 22:44:06 349 3136 Y

And these
C:\Program Files (x86)\World of Warcraft\WTF\Account\91641360#1\SavedVariables\CensusPlus.lua
C:\Program Files (x86)\World of Warcraft\WTF\Account\401186967#1\SavedVariables\CensusPlus.lua

would not start. I get the pop up telling me to 'browse to select the SV file.' Looks to me like the # sign in the account name might be the problem.

Padanfain · Post by **Padanfain** » Wed Nov 26, 2014 12:55 am

Just for kicks I took census on
C:\Program Files (x86)\World of Warcraft\WTF\Account\91387526#1\SavedVariables\CensusPlus.lua
and tried to upload with UU.
'browse to select the SV file.'
then I renamed 91387526#1 to 913875261 and oohhhh, yeah, not # sign, same popup...
then I renamed 913875261 to joe4321blow9876 and doh, same popup...
then I renamed joe4321blow9876 to JOE4321BLOW9876 and doh, same popup...
then I renamed JOE4321BLOW9876 to caedmonxxx and <<< yeah xxx are actually numbers edited out and same popup
then I renamed caedmonxxx to CAEDMONXXX and yepper, same popup...

Oh, one of those worked because I got....
Nov 26, 14 00:12:41 0 6 Y
but I had no successful upload according to UU

So what does that mean? LOL I did not wait an appropriate amount of time between uploads since none were successful. Tomorrow I will wait at least one half hour between uploads to make sure the site isn't giving me the toll finger.

Post by **bringoutyourdead** » Wed Nov 26, 2014 11:24 am

The number#1 accounts upload fine for me.

looking at google collected site data.. it appears they were reworking the uniuploader code from 2.7.xx to 2.8.xx and then went dark
I expect the programmer hadn't got around to the edge conditions..
the debug section of the code is a joke.. you only get debug info for successful operations!

If I had written the code instead of that silly bad path display.. I would have had..
this is the full path I tried....
This is what it needs to look like.

Then you would at least have a clue where the problem was as a user.

Post by **bringoutyourdead** » Wed Nov 26, 2014 4:45 pm

Ok I figured out the problem.

Uniuploader is constructing the valid directory to your saved variables by finding a file that Blizzard used(/uses?).
The client on initial account start creates the file and populates it, but now that all this information is stored on the server to prevent hacking.. Blizzard doesn't really care if the file exists anymore.

In your \World of Warcraft\WTF\Account\{your specific account id}\ folder should be a SavedVariables.lua
If this file has been deleted then Uniuploader fails on that account.

the contents are as follows: Though truth be told it could be a blank line only.. Blizzard doesn't look for this anymore.(see edit below)

CHANNELPULLOUT_OPTIONS = {
["displayActive"] = true,
["name"] = "Channel Roster",
}

edit: Actually Blizzard might... but nobody in their right mind would be.. the above config information is/was for Blizzards horrible voice chat.
edit2: Blizzard creates the file for all accounts even if they block the feature on Starter accounts.
edit3: I copied over a standard file from another account and erased everything except a space,CR,LF from the file.. making a 3 byte file.
Game runs fine.. Voice settings can be enable.. voice chat channel can be added.. I didn't actually test voice.. since it never has worked worth beans for me.
on logout and on client exit.. the 3 byte file isn't touched.. Blizzard doesn't use it anymore.

Post by **bringoutyourdead** » Wed Nov 26, 2014 5:03 pm

Non-bug at site...
When setting up Uniuploader.. the default username and password entry fields are what should be used.

If your an old timer like myself and remembered or searched though old forum messages you would have found the valid field names were user and pw... while these still work for the website and you do get credit for your uploads.. the data passed back to the Uniuploader indicates a failure on id...

So just as a reminder if you setup Uniuploader from scratch... use the default field names of username and password.. and in the corresponding spots put your warcraftrealms.com username and password.

Narlash · Post by **Narlash** » Sat Nov 29, 2014 11:56 pm

bringoutyourdead wrote:Ok I figured out the problem.

Uniuploader is constructing the valid directory to your saved variables by finding a file that Blizzard used(/uses?).
The client on initial account start creates the file and populates it, but now that all this information is stored on the server to prevent hacking.. Blizzard doesn't really care if the file exists anymore.

In your \World of Warcraft\WTF\Account\{your specific account id}\ folder should be a SavedVariables.lua
If this file has been deleted then Uniuploader fails on that account.

the contents are as follows: Though truth be told it could be a blank line only.. Blizzard doesn't look for this anymore.(see edit below)

CHANNELPULLOUT_OPTIONS = {
["displayActive"] = true,
["name"] = "Channel Roster",
}

edit: Actually Blizzard might... but nobody in their right mind would be.. the above config information is/was for Blizzards horrible voice chat.
edit2: Blizzard creates the file for all accounts even if they block the feature on Starter accounts.
edit3: I copied over a standard file from another account and erased everything except a space,CR,LF from the file.. making a 3 byte file.
Game runs fine.. Voice settings can be enable.. voice chat channel can be added.. I didn't actually test voice.. since it never has worked worth beans for me.
on logout and on client exit.. the 3 byte file isn't touched.. Blizzard doesn't use it anymore.

Nice job! Figures something like that would happen. I'm gonna try it out

Narlash · Post by **Narlash** » Sun Nov 30, 2014 12:04 am

It worked! I did run into the problem with the username, so I'll have to decipher your instructions, but this is great! Yay!
Edit:
So - Advanced mode > Options Tab > Additional Variables section >

Code: Select all

username
password

or

Code: Select all

user
pw

I'm too tired to think. I always do my census upload before bedtime heh, silly me.

Edit 2:

Disabled Advanced Mode and figure I'd do the simple version, said upload was successful but checked the server response in Advanced Mode and got this:

Code: Select all

<Uploading>



Looking for file
IP&#58; 85.24.195.71<br>
Sweden<br>
85.24.195.xx - se - 
File appears to be valid, checking your version number.
Checking your file
Found CensusPlus Database
Found CensusPlus Info Data
Found Locale => Locale&#58; US <Found> Version&#58; 6.2.0 <=
Attempting to make entry

Getting User/pass
Username &#58; Narlash<Error> Unable to query &#58; 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 '' at line 3 on line&#58; 285 of /home/wrlogin/html/uniupload.php

Which at least gives me a better response than my username not being found. Right?

Post by **bringoutyourdead** » Sun Nov 30, 2014 7:24 pm

did some log and table browsing...
I saw your successful update via web
and then 9 minutes later an almost successful upload via Uniuploader
as your logging indicated the username/password match failed... so it got credited to anonymous.

but what you didn't see is that there was no updates processed from this file not sure why..
deeper looking at log it appears you did a quick census run on Wormrest Accord before submitting the 2nd upload. I guess someone else had just submitted a run on the same realm/faction.

Narlash · Post by **Narlash** » Sun Nov 30, 2014 11:40 pm

Really cool to know what's going in the back-end.
Being credited would be great but I'm not sure what to do about my login from within the UniUploader.

Thanks for all your replies @bringoutyourdead

Post by **bringoutyourdead** » Mon Dec 01, 2014 7:33 pm

did more testing today....
I verified that both of the following work

username yourwarcraftrealms.com_username
password yourwarcraftrealms.com_password

user yourwarcraftrealms.com_username
pw yourwarcraftrealms.com_password

The first combo is I believe the current Uniuploader defaults, the later is historical (what was the only accepted here at Warcraftrealms.com.

NOTE: case is important Username IS NOT username

Narlash · Post by **Narlash** » Tue Dec 02, 2014 12:09 am

Cool! Thanks for all the help!!! This really is going above and beyond