Some Registered Users cannot upload photos?

[billy]

This is weird! For some reason some registered users can upload photos and the others can't

They get this error message.

Sorry, you don't have permission to upload photos.

Any suggestions Chuck?

[Chuck S]

well I need to know more about your site here like what your integrated with etc as that error is telling me they belong to a usergroup that does not have permission to upload.

[billy]

Chuck,

It is still happening for some reason mate.

This is what is happening

Photopost Classifieds: Some Registered Members cannot upload ads:

See error message here:
www.beaututes.com/errors/classifieds_error.GIF

All permissions and usergroups are correct

Photopost Gallery:
www.beaututes.com/errors/gallery_error.GIF

All permissions and usergroups are correct

Note error above screen

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /gallery/pp-inc.php on line 4215

Pissing me off because I have not been able to get classifieds or photos from most registered users for a month or three.

I have logged in as a Test user and can upload ads and pics alright, but when I logged in as one of the users reporting these errors, I got the errors they get.

Please help when you find the time Chuck.

Thanks for the installs also!

[Chuck S]

You can turn on debug options in GLOBAL OPTIONS. That will tell you the error in classifieds

In photopost what usergroup is the user in?

This could be an install error if these are new.

[billy]

Turned on gloabl to email me.

The usergroup is registered members for photopost.

[billy]

Chuck here is one ofthe email reports:

An error was encountered during execution of the query:

SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic,payment,uplimit,free FROM classifieds_usergroups WHERE

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[billy]

An error was encountered during execution of the query:

SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic,payment,uplimit,free FROM classifieds_usergroups WHERE

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Chuck S]

What sounds to me like the integration is not set up correctly we would need you to send site info admin login urls and ftp info to the contact us link in our header above.

[Zakhar]

I have the same problem (looks similar).
I logged in as admin, and i can't upload photos with error
"Sorry, you don't have permission to upload photos."

I checked permissions in "PhotoPost Category Editor" in "Usergroup Access Permissions" and everywhere Administrators group have access.

I use Photopost pro 6.2 integrated with vbulletin 3.7.3.
Database encoding and page encoding in vbulletin is utf-8.

I'm turned on "Debug Setting" to "Display Errors", but i don't saw any errors.

Could you help me with this problem?

[Zakhar]

Originally Posted by Zakhar

I have the same problem (looks similar).
I logged in as admin, and i can't upload photos with error
"Sorry, you don't have permission to upload photos."

I checked permissions in "PhotoPost Category Editor" in "Usergroup Access Permissions" and everywhere Administrators group have access.

I use Photopost pro 6.2 integrated with vbulletin 3.7.3.
Database encoding and page encoding in vbulletin is utf-8.

I'm turned on "Debug Setting" to "Display Errors", but i don't saw any errors.

Could you help me with this problem?

I resolve this problem by editing pp_usergroups table.

May be resolved with query like that:

UPDATE `pp_usergroups`
SET
`uploads` = '1',
`comments` = '1',
`editpho` = '1',
`editposts` = '1',
`useralbums` = '1',
`canassign` = '1'
WHERE `pp_usergroups`.`groupid` =6 ;

[Chuck S]

Hello

You would set permissions under admin edit usergroups when logged in as admin as you wish.

[billy]

Originally Posted by Chuck S

Hello

You would set permissions under admin edit usergroups when logged in as admin as you wish.

Chuck,

I have done this, it has always been that way, and still this problem is happening, thats why I purchased an upgrade to resolve this problem, but it did not fix it.

I resolve this problem by editing pp_usergroups table.

May be resolved with query like that:

UPDATE `pp_usergroups`
SET
`uploads` = '1',
`comments` = '1',
`editpho` = '1',
`editposts` = '1',
`useralbums` = '1',
`canassign` = '1'
WHERE `pp_usergroups`.`groupid` =6 ;

What folder is pp_usergroups under?

[Chuck S]

You may want to also resync the usergroups in admin edit usergroups if you have vb groups that are not in photopost.

[billy]

Done all that and also done the pp_usergroups and still my members cant upload photos or classifieds. Any chance of you looking at it since you did the upgrades chuck?

[Chuck S]

what site is this?

[billy]

Main Index - BUY, SELL, TRADE AND AUCTION AUSTRALIAN AUTO, CAR, MOTORBIKE, TRUCK, BOAT & UTE CLASSIFIEDS and Main Index - Australian Ute Photos the site is BeautUtes.com > The Australian Ute Forum

[Chuck S]

Do you have logins etc?

Have you set permissions accordingly, You note doing something in pp_usergroups but thats not a classifieds table. That is a photopost table.

I would suspect you have not resynced your usergroups for classifieds if you have added new groups and set permissions but I would need to see your admin panel. feel free to email us an admin login.

[kingmotox]

ok i am having the same problem with photopost. however i did notice the problem once i added the user to a new usergroup. others in that usergroup can upload pics but the recently added people cannot. how can i fix that. resync? I have vb 3.7.4 and pp 6.2

[Chuck S]

well make sure for one you did not change your vb database if you recently upgraded. make sure in the photopost config file under user database those details match the database info under your vb config file and then yes do a resync under edit usergroups and set permissions.

[kingmotox]

i dont see the resync