SMFHacks.com

SMF Gallery Pro => Support => Topic started by: Mike66 on February 20, 2015, 05:41:05 am

Title: New database error
Post by: Mike66 on February 20, 2015, 05:41:05 am
I'm getting a new gallery database syntax error when users try post image upload today ...... any ideas what might be causing this?
They are unable to upload an image.

I'll attach an error log screenshot.

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 20, 2015, 09:14:37 am
What version of SMF Gallery Pro are you using?
Title: Re: New database error
Post by: Mike66 on February 20, 2015, 09:26:58 am
What version of SMF Gallery Pro are you using?

I'm using gallery 6.7 with SMF 2.0.9

Have asked more members to try posting an image, as I can upload photos fine and it could possibly be just one member that is experiencing this problem. I'm not seeing any errors for other members in the error logs.

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 20, 2015, 09:32:50 am
Yeah I am not seeing any easy way to trigger that error. I do suggest though upgrading to 7.0 for SMF Gallery Pro
http://www.smfhacks.com/index.php/topic,8659.0.html
Title: Re: New database error
Post by: Mike66 on February 20, 2015, 09:36:04 am
Do we simply uninstall in package manager and then install the new version without deleting the files?

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 20, 2015, 09:38:34 am
Yes that is the best way to upgrade for this release.
Title: Re: New database error
Post by: Mike66 on February 20, 2015, 10:10:23 am
Install done, I'll let you know if this solves the error.

I'm noticing a new bug since the install when I view users online, this appears at the top of the page:
Quote
// Begin SMF Gallery $txt['whoall_gallery'] = 'In the Gallery'; // END SMF Gallery Strings

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 20, 2015, 10:12:15 am
Open themes/default/languages/who.english.php
Find near end of that file.
Code: [Select]
?>
And move it all the way to the end of the file
Title: Re: New database error
Post by: Mike66 on February 20, 2015, 11:19:31 am
Should have remembered that from the last update :) ...... fixed now thanks.

Back to the original error problem. It is not just the one user, I am getting an error too now.

If I'm in the gallery and I select edit for my user gallery, I get the attached "user gallery error".

If I try to add an image to a post via post image upload, I get the attached "post image upload error", which I personally wasn't getting before the upgrade, but at least one member was getting.

I can still upload an image via the main gallery without problems.

Strange!

Best wishes
Mike
Title: Re: New database error
Post by: Mike66 on February 20, 2015, 11:37:59 am
and the attached is what I now find in the error logs.
Title: Re: New database error
Post by: Mike66 on February 20, 2015, 12:17:21 pm
Following the link to the file gives me the attached.

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 20, 2015, 02:14:11 pm
Copy the attached file to your sources folder and let me know if it helps
Title: Re: New database error
Post by: Mike66 on February 21, 2015, 04:27:44 am
That has helped with the line error thanks.

We are still unable to add images to posts with the post image upload mod. We can add to categories directly via the gallery, but not via post image upload for most categories, it only works if we select the main gallery.

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 21, 2015, 08:56:38 am
Are you getting an error with the post image upload? So just user user galleries don't work with it is that correct?
Title: Re: New database error
Post by: Mike66 on February 21, 2015, 09:36:35 am
Just did a full test with post image upload, uploading 3 images to one post at the same time.

I selected main category for one, a second category for two and a user gallery for three.

All three images uploaded and displayed in the post.

I then went to the gallery and the only image of the three that is now in one of those categories is the one in the user gallery.

All three appear under "recent items", clicking on the recent items thumbnails - the one uploaded to the main category will open, the one uploaded to the user gallery will open, but the one uploaded to the second category has an error message that says "No picture exists"

The only error that this produces in the error logs is the usual "Undefined index: keywords", which I believe is caused by not bothering to enter keywords in post image upload. This relates to line 2260 in Sources Gallery2 . php

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 21, 2015, 07:28:08 pm
Have it solved now

Posted an update
7.0.2
!Fixed bug with "Post Image Upload" addon to SMF Gallery Pro to main user gallery and undefined keywords error log.

Download update at: http://www.smfhacks.com/index.php/topic,8659.0.html
Title: Re: New database error
Post by: Mike66 on February 22, 2015, 03:59:01 am
Excellent ..... well done!

I'll upload the new version and let you know how we get on ...... Thanks!

Best wishes
Mike
Title: Re: New database error
Post by: Mike66 on February 22, 2015, 05:53:57 am
Hi again,

That seems to have worked, the images are uploading to the correct galleries and we can open them there, the link is going in the editor and the images display in the post ........ excellent thanks, well done!

The only issue that I'm left with is that the member who originally brought this to my attention still has a problem. His images now upload to the correct galleries and he can open them there, but the link is not going in the editor for him.

I have checked out the update with both my admin account and my standard member testing account and everything works fine for me. Can you think of any reason why that one member should continue to have an issue? I asked him to create a second account to test everything and that second account works fine!

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 22, 2015, 09:18:18 am
Which link? Can you copy and past the example?
Title: Re: New database error
Post by: Mike66 on February 22, 2015, 10:48:21 am
Hi again,

I'll attach a screenshot that includes the link that the member does not get, I hope that makes sense.

As far as I know this only seems to happen to one member account.

Best wishes
Mike
Title: Re: New database error
Post by: SMFHacks on February 22, 2015, 12:00:03 pm
Might be a browser issue? What browser are they using?
Title: Re: New database error
Post by: Mike66 on February 23, 2015, 11:04:16 am
It appears to be something specific to this member's account. Everybody else's account seems to be working fine now ....... and this user has plenty of experience using the gallery system as he has uploaded lots of images to posts in the past.

He has tried on various PCs. Windows with Chrome, Firefox and IE, Mac with chrome.

Best wishes
Mike

Title: Re: New database error
Post by: SMFHacks on February 23, 2015, 11:52:34 am
Odd not sure where to go form there if it is just that link on the editor not working.
Title: Re: New database error
Post by: Mike66 on February 23, 2015, 12:41:27 pm
Yes, I'm lost with this one too.

Luckily, the member is very understanding and will upload images to the gallery and copy the URL to then paste this in his posts, the only solution that I can think of at the moment.

Thanks for all your help!

Best wishes
Mike