UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Uploading Avatars: Errors

We have our board set up to allow users to upload avatars to a directory on our site. That directory was tested with the "click to test" link on the control panel and passed.

But a user is attempting to upload an avatar and we're getting a mySQL error. Problem is, the error goes by so fast that I can't tell what it's saying.

Can anyone help?

Thanks,
Tracy

Any help on this one???

Please post the error message.
Do you setup Full URL to Avatar Storage Directory in your control panel/profile settings ?

It's possible the avatars are the wrong size as well - might check that first.

I have checked the size and it's OK.

Yes, the full URL is set up.

As far as the actual error message goes, as I said in my first post, I can't see exactly what it is because it's a SQL error that flashes by and then disappears when the page loads. After a few tries, I got enough to see that it is an "open base_dir restriction" error of some kind.

Any thoughts?

Thanks! <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

take a closer look to your control panel. If you enter it you will see on the right side: Logs. Under it there should be a link to display all sql errors from ubbthreads.

I didn't have logging turned on, but I have activated it now. I activated it for both error and control panel logging, the tests for the directories passed, the test.file is in the error logging directory, but...

When I tried to add the avatar and generate the mySQL errors (which did briefly appear again), they were not added to the log file.

Suggestions on what's going on with the log file, so I can finally resolve the avatar thing?

Thanks for your help/patience,
Tracy

I'm not sure on the logging issue, but lets try this for now to find out what the SQL error is. Just a quick edit to the changebasic.php file. Down at the very bottom, you'll see this:

// ---------------------------------------------------
// Send them to their start page with the confirmation
$html -> start_page($Cat);

Right before that, add this:

exit;

That will make it so it doesn't forward you to the next page so you can actually copy and paste the error here.

Hi again,

After SOOOOO long, I'm getting back to investigating this issue. I did what you suggested, Rick, and here's what I got in return:

Warning: copy(): open_basedir restriction in effect. File(/var/tmp/php2ajsMI) is not within the allowed path(s): (/www/u/p/pluscomm) in /www/u/p/pluscomm/public_html/ubbthreads/changebasic.php on line 246

Warning: getimagesize(/www/u/p/pluscomm/public_html/ubbthreads/images/avatars/user//1006.jpg): failed to open stream: No such file or directory in /www/u/p/pluscomm/public_html/ubbthreads/changebasic.php on line 248

Any suggestions?

Thanks again very much,
Tracy

Any help for my last post? Thanks in advance!

Hi Tracy. Sorry, I missed your last post. There is an issue with open_base_dir and user avatars. You can fix this with a quick edit to changebasic.php. Line 246 of that file looks like this:

copy($HTTP_POST_FILES['userfile']['tmp_name'], "{$config['avatars']}/$Picturefile");

That, needs to be changed to this:

move_uploaded_file($HTTP_POST_FILES['userfile']['tmp_name'], "{$config['avatars']}/$Picturefile");

Cool, you're awesome, thanks, Rick! I will try that. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Tracy