Thread

Ok, I’m seeing something different than you are - but the symptoms are similar.  When I try to edit a file upload preference or create a new one, Safari gives me this:

Safari can’t open the page.
Safari can’t open the page “http://www.photographyblog.com/system/index.php?S=0&C=admin&M=blog_admin&P=edit_upload_pref&id=1”. The error was: “Operation could not be completed. (kCFErrorDomainCFNetwork error 302.)” (kCFErrorDomainCFNetwork:302) Please choose Report Bugs to Apple from the Safari menu, note the error number, and describe what you did before you saw this message.

I don’t think this is a Safari issue; but I suspect that yours is trying longer then timing out and getting a blank page. Figuring out *why* it’s doing that is going to be the next step.

While we look into that, you might see if your host has any ideas on that error code.  A google search of this (kCFErrorDomainCFNetwork:302) seems to indicate that .htaccess redirects/rewrites may be part of the problem. I’m not sure why this would be seen on only the file upload pages though.  We’ll keep looking, but you might see if your host has further ideas with this information.

Does it do the same thing when you choose Utilities > SQL Manager?

And also try to edit the Default Field Groups?

They also timeout for me.

I’ve sent the info to my webhost and asked for their input.

It’s 8pm here in the UK, so I’m off home for the day 😊

In the meantime I’ve asked my webhost for some feedback on the error code, will let you know what they say tomorrow.

My webhost has replied:

“It doesn’t really matter what the web side says, I can see the request causing apache to segfault so its a server-side issue, but it’s not obvious why that’s happening, so I was hoping they could suggest why.”

Hi,

Just wondering if you’d found out any more info about this?

Mark, if the webserver segfaults this is a serious, server-side issue. There is really not much that we can do about this; your host would be in the best position to address this, having access to Apaches logs and config files. In the meantime, please go ahead and upgrade to the latest build. It might not solve the issues at hand, but it gives us a common set of files to work with, and if nothing else should rule out corrupted files.

I am unclear if you actually remove index.php from your URLs? If so, try disabling your .htaceess rewrite rules temporarily.

Yep- something odd is going on, and I think we’ll need host input.  We found where the mysql manager breaks down- at least one spot.

In the ‘SQL Manager’, it breaks down between these two exit tests.  So basically?  That query.  I even hard coded the db name to eliminate the prefs.  BUT I don’t believe that particular SHOW TABLE is used anywhere else, so it’s not going to explain the file upload borkage.  And ugrade is still a good idea- but w/the SQL bit, not seeing how it’s a corrupted file.

$DB->fetch_fields = TRUE;
        
        //exit($PREFS->ini('db_name'));

        //$query = $DB->query("SHOW TABLE STATUS FROM `".$PREFS->ini('db_name')."`");
        $query = $DB->query("SHOW TABLE STATUS FROM `hardcoded_name`");        

        $totsize = 0;
        $records = 0;
        
        exit('tre');

Which is a long way of saying- in phpmyadmin, what happens if you run this query

HOW TABLE STATUS FROM `hardcoded_name`

where the hardcoded_name bit is the name of your database?

And note- this doesn’t really explain the other blank pages, because that query is pretty unique.  But testing- if I exit on the preference bit, the page loads and is speedy.  If I exit on the ‘tre’ bit, the page fails to load.  It can’t be all queries bogging it down- or the whole site would be down.  So… it’s just odd.

Hi Robin,

I can give you phpmyadmin access if that would help…

Hang tight, Mark.  I’m dropping you an email.  Or you can just do it yourself if you’re more comfortable that way.  Like I say- this isn’t really a solution to the site problems- I can’t find the pattern on the pages that break.

Details sent.

Looks like the query times out phpmyadmin as well.  Same query works fine on mine.  I don’t think this is EE specific- might contact the host- give them that query as an example and see if it helps.  I’m replying in email w/a bit more info.

Hi Robin,

I’ve passed this onto my host, and asked them to try the query.

Does this means there’s a problem with my EE database, or with mySQL itself?

Good news!

My host has just upgraded the server to apache2.2 / php5, and it’s fixed all the Control Panel issues 😊

Thanks to everyone for their help with this issue - much appreciated!

I think it was with mysql itself.  Which seems supported by the upgrade fixing it.  May have been a bug- I think I passed along one that seemed possible.

But bottom line- very glad they got you squared away!

Have you had a chance to really surf around frontend and backend?  Are you comfortable that all is well now?

I think so - all of the problem areas that resulted in blank pages before, now load instantly.

And the site itself is behaving exactly the same as before.