News:

Join the Facebook Fan Page.

Main Menu

SMF Gallery

Started by SMFHacks.com Team, September 16, 2006, 07:13:02 PM

Previous topic - Next topic

DeadMan...

And there's no way for me to afford the pro version, being on SSI and all that for bills...LOL
Oh well. Will have to try to figure out what to do now.
Thank you, my friend.
I tell it how I see it... Don't like it? Hit Alt+F4!

Sudhakar Arjunan

Installing SMF gallery lite in my upgraded 2.1.3
And while trying to convert from aeva media, got this error.

Database Error
Incorrect integer value: '' for column 'totalratings' at row 1
File: /home/forum/public_html/Sources/Subs-ConvertAeva2.php
Line: 707

Guide me to any old post for resolution if any.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Sudhakar Arjunan

Quote from: Sudhakar Arjunan on April 02, 2023, 01:39:05 AMInstalling SMF gallery lite in my upgraded 2.1.3
And while trying to convert from aeva media, got this error.

Database Error
Incorrect integer value: '' for column 'totalratings' at row 1
File: /home/forum/public_html/Sources/Subs-ConvertAeva2.php
Line: 707

Guide me to any old post for resolution if any.

Admin Error log - line 707

Database Error: Incorrect integer value: '' for column 'totalratings' at row 1

INSERT INTO smf_gallery_pic
 (id_picture,title,description,id_member,id_cat,
 views, filesize, height, width,
 filename, thumbfilename, mediumfilename,totalratings,rating,
 commenttotal, approved, date, keywords,allowcomments )
 VALUES ('1','Mega JOB FAIR - 19th and 20th',
 'Companies - HP, Unisys & More

Walkin Date Jan 19, 20, Bangalore', '1164', '1', '728',
 '347277', '1478', '943',
 'albums/JOB_Album/Dir_1/main_1.png', 'albums/JOB_Album/Dir_1/thumb_1.png','albums/JOB_Album/Dir_1/medium_1.png','','',
 '0',
 '1','1200572255'
 , 'hp, walk in, unisys, jobfair, hello, bpo, it, ites',1)
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

vbgamer45

Try the latest version from the mod site and see if it helps
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Sudhakar Arjunan

Quote from: vbgamer45 on April 02, 2023, 12:00:43 PMTry the latest version from the mod site and see if it helps
WoW working amazingly now, converter from aeva media to smf gallery lite processing like a pro. Thank you vbgamer45
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Sudhakar Arjunan

While processing got one error

Processing: 8599
Processing: 8612
Processing: 15131

Database Error
Data too long for column 'keywords' at row 1
File: /home/forum/public_html/Sources/Subs-ConvertAeva2.php
Line: 734
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

Sudhakar Arjunan

Checked the db table for keyword length found its 248, so we got error, what to do now.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

vbgamer45

Increase the length of the keywords item in smf_gallery_pic table change to 500
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Mike66

It's got me head scratching  ;D

I have moved my forum to a new server ( I'm still running 2.0 ) and everything is working fine apart from 'Post Image Upload'.

When we use Post Image Upload, it uploads the image to the gallery - but it doesn't insert the image linking text into the post and it displays an error in the Post Image Upload pop up box that says:
"Forbidden"
"You don't have permission to access this resource."

I have tried uninstalling Post Image Upload and installing it again, but that didn't work. I get the same error as Admin as the members do ....... so I'm guessing it is possibly a server permissions thing?

Cheers
Mike

vbgamer45

Try disabling mod_security if enabled.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Mike66

Quote from: vbgamer45 on April 22, 2023, 06:50:05 PMTry disabling mod_security if enabled.

Can't find/see mod_security on the server control panel.

Might be best to discuss the problem with my host?

Cheers
Mike

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Mike66

My hosting provider disabled mod_security and can't see any obvious issue at their end.

Have you got any other suggestions of things we could check for? This one has me stumped.

Have moved both my websites to the new server, one has a long term 2.0 forum and the other a test 2.1 forum to evaluate the possible upgrade of the long term one. The post image upload error is happening on both.

Thanks
Mike

vbgamer45

#4233
Things I would do check forum error log when the error happens.
View the request in developer tools the error to see where the request is posted to.
Check php upload limits if image is a bigger file to see if you are not exceeding those.
Make sure on latest version of the gallery software.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Mike66

Interestingly, the error doesn't produce a forum error log.

Max PHP upload size seems to be 128M, could that be it?

vbgamer45

I would make sure post_max_Size is also the same value.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Mike66

Quote from: vbgamer45 on April 25, 2023, 04:23:02 PMI would make sure post_max_Size is also the same value.

Yes, both share the same value.

vbgamer45

I would need an account on the forum to check. not sure what else.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Mike66

More head scratching ..... I uninstalled and removed Gallery Pro, then I downloaded the latest version of Gallery Pro.

When I tried to upload and install Gallery Pro 9.0.8 via Package manager (Add Packages) I got the same error as with Post Image Upload "Forbidden" "You don't have permission to access this resource."

After trying a couple of times, failing, and not seeing any logged errors, I decided to try uploading Gallery Pro 9.0.8 via FTP. This worked, I could then find it in Package Manager via Browse Packages, and was able to install it from there.

So, back to where I started really, Post Image Upload gives the same error in 9.0.8.
But I now have the latest gallery version, and I now know that trying to install something via Add Packages produces the same error.

Cheers
Mike

Mike66

Quote from: vbgamer45 on April 25, 2023, 04:59:57 PMI would need an account on the forum to check. not sure what else.

Thanks for your help, I have sent you a PM.

Advertisement: