Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Aiwa Posted June 10, 2016 Posted June 10, 2016 I'm running a plain Apache / MySQL setup on my Centos server. PHP 5.6. I'm not able to upload images to Gallery. Rather the image uploads, is available on the server, but when I hit 'continue' to actually save the image in my gallery I get a 500 Internal Server Error. All 500 errors I've ever gotten before have always been logged in the servers error logs. /var/log/httpd. For some reason, any 500 error that's generated by an AJAX request is NOT getting logged. I'm at a loss in diagnosing what the server is getting caught up on here. log_errors On error_reporting E_ALL Things I've done so far... 1) Re-upload all IPS files 2) chown recursively all files in my sites directory to the correct owner. Short of checking each and every file for permissions, I'm at a loss of where to go from here. Does anyone have any ideas on how I can get errors thrown on AJAX requests in the servers error_log so they can be properly diagnosed?
Aiwa Posted June 10, 2016 Author Posted June 10, 2016 4 hours ago, ASTRAPI said: Are files and folders permissions correct? I know ownership is correct. 755 for directories 644 for files? This 'ought to do it, right?... find . -type d -exec chmod 0755 {} \; find . -type f -exec chmod 0644 {} \; Then I just need to hit /datastore, /downloads, /plugins, /applications, /screeenshots, /uploads as 777...
ASTRAPI Posted June 10, 2016 Posted June 10, 2016 What about ownership permissions? nginx:nginx userx:userx or what it needs .... ?
Aiwa Posted June 10, 2016 Author Posted June 10, 2016 Everything is apache:apache. That was the first thing I did was recursively change all files to the above. Just in case some random files changed owner after upload. Forum uploads works fine. It's just Gallery throwing the error.
Mark H Posted June 10, 2016 Posted June 10, 2016 This sounds vaguely familiar...... Is your server using suPHP? And is it a WHM/cPanel server?
Aiwa Posted June 10, 2016 Author Posted June 10, 2016 9 minutes ago, Mark H said: This sounds vaguely familiar...... Is your server using suPHP? And is it a WHM/cPanel server? No and no. Its a VPS running 2 IPS4 sites. I just can't seem to capture this one 500 error that would help point to the issue. Server API: Apache 2.0 Handler Apache 2.2.15 PHP 5.6.22
Mark H Posted June 10, 2016 Posted June 10, 2016 1 hour ago, Aiwa said: No and no. Its a VPS running 2 IPS4 sites. I just can't seem to capture this one 500 error that would help point to the issue. Server API: Apache 2.0 Handler Apache 2.2.15 PHP 5.6.22 Than I'm rather baffled too. The 500 Error you see, though..... is it the "server" 500 page, or "ours"?
Aiwa Posted June 10, 2016 Author Posted June 10, 2016 7 minutes ago, Mark H said: Than I'm rather baffled too. The 500 Error you see, though..... is it the "server" 500 page, or "ours"? It's on an AJAX call, screenshots above. The only reference I can get to a 500 error is in the browser developer tools. As far as Gallery is concerned, it just sites there with a spinning icon for all eternity. I'm not actually delivered ANY error page, only reference is in the browser. There has to be a way to capture this error in the server logs. I've not actually tested Gallery since upgrading to IPS4 two weeks ago. So I don't know if this ever worked. And I am running 4.1.12.2.
Mark H Posted June 10, 2016 Posted June 10, 2016 Hmm... I'd suggest filing a ticket then. This could be a bug, and if it is we'd want to squash it of course.
Aiwa Posted June 10, 2016 Author Posted June 10, 2016 Just now, Mark H said: Hmm... I'd suggest filing a ticket then. This could be a bug, and if it is we'd want to squash it of course. I'll try one more thing before submitting a ticket... I know this is going to be one of those gray area tickets, which is why I started here... If I can just capture the error, it'd point me in the right direction hopefully.
Aiwa Posted June 11, 2016 Author Posted June 11, 2016 Welp, it didn't work. Ticket # 953461 Thanks @Mark H
Simon Woods Posted June 11, 2016 Posted June 11, 2016 I have an open ticket for gallery problems, and this error is now showing for a single member. And I'm on CitC... so weird.
Aiwa Posted June 11, 2016 Author Posted June 11, 2016 1 minute ago, Simon Woods said: I have an open ticket for gallery problems, and this error is now showing for a single member. And I'm on CitC... so weird. So maybe I'm not crazy!
CodingJungle Posted June 11, 2016 Posted June 11, 2016 26 minutes ago, Aiwa said: So maybe I'm not crazy! no you are, its just now you have company I've seen a similar problem to this too with ajax and gallery, it was a problem with the php.ini upload size limits and post size limits (the upload was greater than the post size limit).
Aiwa Posted June 11, 2016 Author Posted June 11, 2016 All those are set to 20M. I'm testing with a 30kb png file. Unless there's another setting that I'm missing somewhere.
CodingJungle Posted June 11, 2016 Posted June 11, 2016 its probably not the same problem i ran into then . I typically make post_max_size a tad bit bigger than upload_max_filesize, you still have to have room for headers and what not
Aiwa Posted June 11, 2016 Author Posted June 11, 2016 3 hours ago, Adlago said: Try without htaccess file The only thing in the .htaccess file is the mod_rewrite for FURL's and some IP denies. I kid you not, this is the most plain jane apache / php server configuration there is...
Aiwa Posted June 15, 2016 Author Posted June 15, 2016 Error was being thrown by IPS. It was logged in the IPS System Logs in the ACP. Uncaught Exception: SQL error, column missing default value.
Aiwa Posted June 15, 2016 Author Posted June 15, 2016 @CheersnGears If you have Gallery, you might also run into this on your upgrade. Your site seems to be having many of the same missing default values as mine.
CheersnGears Posted June 15, 2016 Posted June 15, 2016 1 minute ago, Aiwa said: @CheersnGears If you have Gallery, you might also run into this on your upgrade. Your site seems to be having many of the same missing default values as mine. My IPS 4 Dev site is in drydock with the IPS development team at the moment, or else I'd go check. What they found most recently was that many of my members were missing a nexus_customer row, so the installer would bomb. My database dates back to 2003, i.e. before Nexus existed.... so any members that joined before I installed Nexus circa 2012 would be missing the row.
Aiwa Posted June 15, 2016 Author Posted June 15, 2016 1 minute ago, CheersnGears said: My IPS 4 Dev site is in drydock with the IPS development team at the moment, or else I'd go check. What they found most recently was that many of my members were missing a nexus_customer row, so the installer would bomb. My database dates back to 2003, i.e. before Nexus existed.... so any members that joined before I installed Nexus circa 2012 would be missing the row. Ouch. Keep this Gallery issue in the back of your mind to test once you get access to your site. Simple fix, after the fact, but another thing to potentially address.
Jan Shaw Posted November 30, 2016 Posted November 30, 2016 Hi, Did you get a solution? I am currently getting this error out of the system logs, driving me crazy: INSERT INTO `x_utf_gallery_images_uploads` ( `upload_session`, `upload_member_id`, `upload_location`, `upload_file_name`, `upload_date` ) VALUES ( 'sckpo6km2a3rep8g8fdol0rro6', 6163, 'monthly_2016_11/583ec7a1a6b2c_ScreenShot2016-11-29at17_03_01.png.2b8a191c79da423e17925f06d56815ba.png', 'Screen Shot 2016-11-29 at 17.03.01.png', 1480509346 ) IPS\Db\Exception: Field 'upload_key' doesn't have a default value (1364)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.