Two more upgrade problems

[danielf]

Hi, I've encountered two more upgrade problems. Unfortunately, these problems appear to be specific to my site: the demo and sample site are not affected by this.

The first problem is that I can log into my site using Firefox and Chrome, but not using Explorer. I get an HTTP 500 error directly after logging in. I can get past this, if I turn off 'show friendly http errors' in explorer. When I do this, the site runs without error (bar problem number 2). I'm at a loss here. I'm wondering if this is perhaps a throwback from the 'logout and closeall' code that I used to run on this site, but I can't find anything in the sql file indicative of this.

The second problem relates to the backup function. Once again, this works fine in the updated demo and sample site, but not in my site. In all three browsers tested, I get the following (or similar) error:

Firefox can't find the file at http://127.0.0.1/productionnu2/sqlbacku ... sd=db/test.

Another thing that seems noteworthy is that when I try to backup in Explorer, I get a popup saying it's trying to download the file 'test' without an .sql extension (as I get when trying to backup the demo site). It also says that the file is of type html. There's no option to select another file type.

I'm not sure what to do here. I emailed a copy of my sql file to Shane earlier. Perhaps someone can have a nosey.

Cheers,

Dan.

[admin]

danielf,

Earlier you said

I'm not sure what to do here. I emailed a copy of my sql file to Shane earlier. Perhaps someone can have a nosey.

We provide this forum to help answer user's general questions, that can then be helpful to others.

Not to sort out problems offline for individuals.

That's what commercial support is for.

We will still answer your questions when we can.

Steven

[danielf]

Yes, that's fair enough Steven. My apologies.

Anyway, I've cracked it, and I thought I'd share in case this helps someone else...

After a very long time debugging and upgrading old versions of the site, I've managed to track the problem down. It turned out that when you switch the web developer console in Firefox on, it too is giving HTTP 500 errors, but unlike Explorer, it doesn't block the site. And all errors appeared to trace back to calls that included dbfunctions.php. At some point I found an earlier version of the site that did not throw up any errors in the developer console, so I started removing things from the bugged site that I added later. It turns out the culprit was some PHP code that checks if UK postcodes are valid. I ended up doing the postcode check in Javascript, and forgot to remove the PHP from the code library. And, as anyone reasonable person would expect, it buggers things up (despite not actually doing anything) by letting the site work perfectly well apart from when you try to log into it in Explorer, and when you try to call sqlbackup() ...

This problem may well have been present in the old version of nubuilder, but I simply never noticed, and only started noticing after the upgrade, so I attributed it to that. Wrongly, I now suspect.

Lessons learned: be careful with third party code, and it can be very helpful to use the developer console in Firefox, as there may be errors on the site that aren't obvious in its running.

Aah, time for the weekend. And beer. Lots of it

Thanks to those who helped

[admin]

Good post!

I'm sure this will help other users.

Steven