search

Zeruell / ppx-raidplaner

Automatically exported from code.google.com/p/ppx-raidplaner
0 stars 0 forks source link

Unable to log in after update (SyntaxError: Unexpected token <") #72

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Updated from Beta 0.9.8 to 1.0.0
2. Backed up directory (calendar)
3. Deleted calendar directory
4. Moved 1.0.0 files to calendar directory
5. http//website/calendar/update
6. Updated & also Repaired Database
7. Attempting to log in to raid calendar gives me an error popup. 

"A request returned an error.

SyntaxError: Unexpected token <"

What version of the product are you using? Which browser / php version are
you using?
1.0.0 / Chrome / 5.3

Original issue reported on code.google.com by try...@gmail.com on 20 Oct 2013 at 9:22

GoogleCodeExporter commented 9 years ago 
Sorry I forgot to mention. Step 5, I moved my lib/config from 0.9.8a backup to 
1.0.0

Original comment by try...@gmail.com on 20 Oct 2013 at 9:23

GoogleCodeExporter commented 9 years ago 
I need some more info about that.
1. Do you log in with a local user or with a user from an external binding?
2. If external, which binding (e.g. Phpbb)?
3. I need the content of the last messagehub.php result - see 
https://code.google.com/p/ppx-raidplaner/wiki/DetailedBugReports

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 5:24

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Same error occurs after logging in on Calendar and Raid tabs. They share some 
code i guess. I think above error is caused by auto switching to Calendar tab 
after logging in.

Original comment by Osipi...@gmail.com on 21 Oct 2013 at 5:14

Attachments:

GoogleCodeExporter commented 9 years ago 
Your PHP version renders an HTML warning which invalidates any JSON file 
produced.
Disabling warnings in your php.ini (which you should do on a live system 
anyway) should fix the problem.

I will present a fix as soon as I can reproduce the warning here.

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 6:36

GoogleCodeExporter commented 9 years ago 
Just found this (german) explanation of this problem.
Looks like the "date.timezone" setting is not set in the php.ini

source:
http://www.rootz.de/2010/04/php-warning-it-is-not-safe-to-rely-on-the-systems-ti
mezone-settings

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 6:38

GoogleCodeExporter commented 9 years ago 
Warning: mktime(): It is not safe to rely on the system's timezone settings. 
You are *required* to use the date.timezone setting or the 
date_default_timezone_set() function. In case you used any of those methods and 
you are still getting this warning, you most likely misspelled the timezone 
identifier. We selected 'Europe/Paris' for '2.0/DST' instead in 
C:\UwAmp\www\lib\private\message_raid_list.php on line 25

Call Stack:
    0.0020     383304   1. {main}() C:\UwAmp\www\lib\messagehub.php:0
    0.1460    2271944   2. msgRaidList() C:\UwAmp\www\lib\messagehub.php:67
    0.1460    2273640   3. mktime() C:\UwAmp\www\lib\private\message_raid_list.php:25

Warning: mktime(): It is not safe to rely on the system's timezone settings. 
You are *required* to use the date.timezone setting or the 
date_default_timezone_set() function. In case you used any of those methods and 
you are still getting this warning, you most likely misspelled the timezone 
identifier. We selected 'Europe/Paris' for '2.0/DST' instead in 
C:\UwAmp\www\lib\private\message_raid_list.php on line 48

Call Stack:
    0.0020     383304   1. {main}() C:\UwAmp\www\lib\messagehub.php:0
    0.1460    2271944   2. msgRaidList() C:\UwAmp\www\lib\messagehub.php:67
    0.1500    2277184   3. mktime() C:\UwAmp\www\lib\private\message_raid_list.php:48

{"raid":[],"history":[]}

Maybe this will help to pinpoint it.

Original comment by Osipi...@gmail.com on 21 Oct 2013 at 6:42

GoogleCodeExporter commented 9 years ago 
I cannot test this ad-hoc (I need to setup a new server, which takes some 
time), but this may already work.

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 6:52

Attachments:

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Disabling warnings in php.ini resolved the problem.
Also with enabled warnings your fix is working well for me.

Original comment by Osipi...@gmail.com on 21 Oct 2013 at 6:58

GoogleCodeExporter commented 9 years ago 
Great to hear :)

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 7:00

GoogleCodeExporter commented 9 years ago 
Issue 74 has been merged into this issue.

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 9:53

GoogleCodeExporter commented 9 years ago 
From the merged issue:

>> I have tried the fix posted here and unable to log in.  I have also changed 
my php.ini to display_errors = Off
> If the problem persists, I will need the contents of the last messagehub.php 
xhr again, as there is probably a second problem (or the fix did not work in 
your case).

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 9:54

GoogleCodeExporter commented 9 years ago 
Here is the info you requested.  I posted it in the previous newly opened 
ticket that was merged with this one.

"A request returned an error.

SyntaxError: Unexpected token <"

What version of the product are you using? Which browser / php version are
you using?
1.0.0 / Chrome / 5.3

Additional Info:
I have tried the fix posted here and unable to log in.  I have also changed my 
php.ini to display_errors = Off

I need some more info about that.
1. Do you log in with a local user or with a user from an external binding?  
(Yes external - Drupal)

2. If external, which binding (e.g. Phpbb)?  : Drupal (all options are the same 
and selected in the bindings - unchanged)

3. I need the content of the last messagehub.php result - see 
https://code.google.com/p/ppx-raidplaner/wiki/DetailedBugReports

Form Data
Login:project
Action:query_credentials

Response Header
Cache-Control:no-cache, max-age=0, s-maxage=0
Connection:Keep-Alive
Content-Type:application/json
Date:Mon, 21 Oct 2013 19:44:37 GMT
Expires:Thu, 19 Nov 1981 08:52:00 GMT
Keep-Alive:timeout=5, max=58
Pragma:no-cache
Server:Apache
Transfer-Encoding:chunked

No console Errors
==================

Original comment by try...@gmail.com on 21 Oct 2013 at 10:16

GoogleCodeExporter commented 9 years ago 
You posted the XHR headers but I require the XHR response.
Have a look at the images here 
https://code.google.com/p/ppx-raidplaner/wiki/DetailedBugReports if you are not 
sure what I mean.

The result will probably look a lot like what OsipiukD posted.

Original comment by arne.cl...@gmail.com on 21 Oct 2013 at 10:28

GoogleCodeExporter commented 9 years ago 
Sorry i missed a step.  This should be more what you're looking for.

Form Header
Login:project
Action:query_credentials

Response 
<br />
Fatal error:  Call to a member function isActive() on a non-object in 
/home/content/57/11150257/html/outcastorder/calendar/lib/private/userproxy.class
.php on line 756<br />

Original comment by try...@gmail.com on 21 Oct 2013 at 11:43

GoogleCodeExporter commented 9 years ago 
Looks like an external binding does not register correctly. This may be 
happening because of:

- a missing / outdated file (please check if "lib/private/bindings/drupal.php" 
exists and is identical to the one from the 1.0.0 installation package)
- a "corrupted" entry in the user database (no idea how this could have 
happened)

I attached a file that will give me a more detailed error message (hopefully).

Original comment by arne.cl...@gmail.com on 22 Oct 2013 at 6:07

Attachments:

GoogleCodeExporter commented 9 years ago 
Here are the results from your attached file;

Login:project
Action:query_credentials

Response: {"error":[" binding is not registered 
correctly."],"salt":"15:MKJE7.w2","pubkey":"6d01f6741fead8bffe3f1650b56dff97","m
ethod":"cleartext"}

I use cleartext as the password is already encrypted using Drupal.  Setting 
RaidPlaner to cleartext allowed my users to log in quickly to the calendar 
without the hashing delay.

Original comment by try...@gmail.com on 22 Oct 2013 at 2:39

GoogleCodeExporter commented 9 years ago 
Ok, this is getting a little more tricky.
To speed thinks up (I've got only little time to work on this today)

- Have you tried to log in with cleartext passwords disabled?
- could you send me a dump of your raidplaner user table to 
arne.claus@gmail.com (posting it here is a bit risky). This will help me 
reproduce the problem on my system.

You can create a table dump with the export function of phpMyAdmin. Just select 
the user table, export, advanced -> export to file, structure and data.

Original comment by arne.cl...@gmail.com on 22 Oct 2013 at 3:48

GoogleCodeExporter commented 9 years ago 
I have forwarded your request by email.  
Clear passwords disabled also did not help the login issue.

Original comment by try...@gmail.com on 22 Oct 2013 at 5:01

GoogleCodeExporter commented 9 years ago 
Your user database got corrupted somehow (the binding fields got blanked).
I will investigate what may have caused this.
Meanwhile run this SQL statement to fix the issue

UPDATE raid_User SET ExternalBinding='drupal' WHERE ExternalBinding=''

Original comment by arne.cl...@gmail.com on 22 Oct 2013 at 8:42

GoogleCodeExporter commented 9 years ago 
I checked the update calls, but except for one instance this setting is not 
touched.
And that would be unlinking an relinking users, which is part of my regular 
tests (and uses fixed values) ... soo unless you chose to update from e.g. 
version 0.9.7 instead of 0.9.8 the ExternalBinding field cannot be changed.

I'll add a fix for this to the repair tool - that's probably the best thing I 
can do about this.

Original comment by arne.cl...@gmail.com on 22 Oct 2013 at 8:58

GoogleCodeExporter commented 9 years ago 
Everything is working properly now that I've run your UPDATE raid_User.

Much appreciated.

Original comment by try...@gmail.com on 22 Oct 2013 at 9:20

GoogleCodeExporter commented 9 years ago 
Just finished the repair tool, so setting this to done.

Original comment by arne.cl...@gmail.com on 22 Oct 2013 at 9:23

GoogleCodeExporter commented 9 years ago 
Just thought I'd update this.  It's strange.  I have no issues logging in as 
myself (raidlead) and as a backup user (member), though my wife is unable to 
log in to her account (member).

She met with the same error as above.

When I looked a little deeper with Dev tools it showed me there was a calendar 
date issue it seemed.  Which looks like the case since all of our raids, this 
week and past have been moved up a day.   Usually they are Tues/Wed/Thus   now 
they all show Wed/Thurs/Fri  (even passed ones)

Her form data when she attempts to log in is;

Month:10
Year:2013
Action:query_calendar

Response
{"startDay":29,"startMonth":9,"startYear":2013,"startOfWeek":0,"displayMonth":10
,"displayYear":2013,"raid":[{"id":77,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-02","start":"23:30","
endDate":"2013-10-03","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":3,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":1},{"id":78,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-03","start":"23:30","
endDate":"2013-10-04","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":3,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":1},{"id":79,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-04","start":"23:30","
endDate":"2013-10-05","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":2,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":1},{"id":80,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-09","start":"23:30","
endDate":"2013-10-10","end":"02:00","image":"bwd.png","description":"Possible 
Flex Raid due to Vemon and Fuzi being 
out.","status":"ok","attendanceIndex":4,"comment":"Attended by 
project","role":1,"role0Slots":2,"role0":0,"role1Slots":3,"role1":1,"role2Slots"
:5,"role2":1},{"id":81,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-10","start":"23:30","
endDate":"2013-10-11","end":"02:00","image":"bwd.png","description":"","status":
"unavailable","attendanceIndex":-1,"comment":"[project] See Project\'s 
note.","role":1,"role0Slots":2,"role0":1,"role1Slots":3,"role1":0,"role2Slots":5
,"role2":1},{"id":82,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-11","start":"23:30","
endDate":"2013-10-12","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":3,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":1},{"id":83,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-12","start":"23:30","
endDate":"2013-10-13","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":2,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":0},{"id":84,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-16","start":"23:30","
endDate":"2013-10-17","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":1,"role1Sl
ots":3,"role1":2,"role2Slots":5,"role2":2},{"id":85,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-17","start":"23:30","
endDate":"2013-10-18","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":1,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":2},{"id":86,"location":"Siege of 
Orgrimmar","stage":"locked","size":10,"startDate":"2013-10-18","start":"23:30","
endDate":"2013-10-19","end":"02:00","image":"bwd.png","description":"","status":
"ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":1,"role1Sl
ots":3,"role1":1,"role2Slots":5,"role2":1},{"id":87,"location":"Throne of 
Thunder","stage":"open","size":10,"startDate":"2013-10-23","start":"23:30","endD
ate":"2013-10-24","end":"02:00","image":"ulduar.png","description":"","status":"
ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":0,"role1Slo
ts":3,"role1":1,"role2Slots":5,"role2":1},{"id":88,"location":"Throne of 
Thunder","stage":"open","size":10,"startDate":"2013-10-24","start":"23:30","endD
ate":"2013-10-25","end":"02:00","image":"ulduar.png","description":"","status":"
ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":0,"role1Slo
ts":3,"role1":1,"role2Slots":5,"role2":2},{"id":89,"location":"Throne of 
Thunder","stage":"open","size":10,"startDate":"2013-10-25","start":"23:30","endD
ate":"2013-10-26","end":"02:00","image":"ulduar.png","description":"","status":"
ok","attendanceIndex":4,"comment":"","role":1,"role0Slots":2,"role0":0,"role1Slo
ts":3,"role1":1,"role2Slots":5,"role2":1}]}

At this time I'm going to back it up and try a clear 1.0 build.

Original comment by try...@gmail.com on 22 Oct 2013 at 10:01

GoogleCodeExporter commented 9 years ago 
I'll still have it installed should you need a fix tested.

For the moment I'll be using a new database.

Original comment by try...@gmail.com on 22 Oct 2013 at 10:04

GoogleCodeExporter commented 9 years ago 
It would be great if you could send me a dump of your database (again via 
email).
Looks like there are more things that broke and with your data it will be 
easier to investigate.

As for the dates - the dates visible in the XHR result are now always UTC. So 
depending on your timezone the dates may shift a day. If the raids show up ok 
in the calendar, everything is fine. If not - well - that would be another bug.
I hope a clean installation will fix your problem - the errors you have are a 
little bit untypical, especially as I cannot reproduce them here.

Original comment by arne.cl...@gmail.com on 23 Oct 2013 at 7:34

GoogleCodeExporter commented 9 years ago

Original comment by arne.cl...@gmail.com on 26 Oct 2013 at 7:25