Moving images ....

Tobias Honscha · March 22nd, 2006, 11:15 AM

...from one category to another doesn´t work . I alway get this error :
/home/httpd/vhosts/emuenzen.de/httpdocs/galerie/data// -> /home/httpd/vhosts/emuenzen.de/httpdocs/galerie/data/501/
Copy of the file failed. Operation cancelled.

"Warnung: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/emuenzen.de/httpdocs/galerie/pp-inc.php (Zeile 2667)
"

It is a fresh 5.3 installation ....

I double checked the chmod and file path ....

Chuck S · March 22nd, 2006, 11:18 AM

Where are you moving from using what area?

Tobias Honscha · March 22nd, 2006, 12:17 PM

I want to move an images from the main category to a sub-category ...

Chuck S · March 22nd, 2006, 12:31 PM

Well there is your issue. If you changed a category you uploaded a photo to a parent category that contains no thumbs ( which means it can not contain images ) I can see this happening.

You would have to temporarily change this category back in Admin => edit categories to contains thumbs set to yes and move all photos out of it then you can then reset it to contains thumbs no.

Tobias Honscha · March 22nd, 2006, 12:44 PM

Quote:

Originally Posted by Chuck S

Well there is your issue. If you changed a category you uploaded a photo to a parent category that contains no thumbs ( which means it can not contain images ) I can see this happening.

You would have to temporarily change this category back in Admin => edit categories to contains thumbs set to yes and move all photos out of it then you can then reset it to contains thumbs no.

... I tried this out but the error is still present ... my gallery is her :
www.emuenzen.de/galerie

Tobias Honscha · March 22nd, 2006, 12:49 PM

I think the error is here:
/home/httpd/vhosts/emuenzen.de/httpdocs/galerie/data//

Tobias Honscha · March 22nd, 2006, 12:57 PM

Now I found out that I cannot delete images .... Photopost tell me, that it deleted the image - but it can still be viewed . There seem to be a bigger problem with my installation ...

Chuck S · March 22nd, 2006, 01:07 PM

You can PM me a url and admin login and what cats you mean and I can try and poke around.

Tobias Honscha · March 22nd, 2006, 01:19 PM

I sent you the PM !

Chuck S · March 22nd, 2006, 01:30 PM

Well what have you dont to your install recently?

Trying to understand the issue as the reason it does not work is a query is failing on your install now what is line 2667 of pp-inc.php for you

In my Photopost it is this

Code:

Content visible to verified customers only.

Try downloading the code and updating all the files except the config files and lets go from there.

Tobias Honscha · March 22nd, 2006, 01:41 PM

Quote:

Originally Posted by Chuck S

Well what have you dont to your install recently?

Trying to understand the issue as the reason it does not work is a query is failing on your install now what is line 2667 of pp-inc.php for you

In my Photopost it is this

Code:

Content visible to verified customers only.

Try downloading the code and updating all the files except the config files and lets go from there.

This is exactly the line in my installation

I did not change a thing after installing photopost .(I only tried some chown and chmods on the data and uploads DIR ... )

Chuck S · March 22nd, 2006, 01:47 PM

Okay in admin turn on DISPLAY ERRORS and lets see what happens

Tobias Honscha · March 22nd, 2006, 01:50 PM

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: UPDATE photos SET views=views+1 WHERE id=16

Result: Table 'photopost.photos' doesn't exist

Database handle: Resource id #25

Tobias Honscha · March 22nd, 2006, 01:52 PM

I use the pp_ prefix ....

Chuck S · March 22nd, 2006, 01:57 PM

We need to understand here the true nature of your issue as this is nothing I can reproduce in Photopost

In showphoto as example you use the catmove box we pass to the adm-photo script the $catmove variable and the $pid variable and then this passes that to the function in pp-inc.php to move the image

move_image_cat( $pid, $catmove );

We then go to that function and use $pid to get the pictures cat variable and define it as $pcat

So something is missing here on your install and making the query fail and we need to find out what.

Code:

Content visible to verified customers only.

Tobias Honscha · March 22nd, 2006, 02:03 PM

in the forum integration config-file the pp_ prefix was not set , could this be the reason ?

Tobias Honscha · March 22nd, 2006, 02:05 PM

please have a look at my gallery again - I enabled the error - output ... if you view a single image you will get this error also:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: UPDATE photos SET views=views+1 WHERE id=15

Result: Table 'photopost.photos' doesn't exist

Database handle: Resource id #25

Tobias Honscha · March 22nd, 2006, 02:18 PM

now I try to rename all tables into names without prefix and after that changing both config files to none prefeix...

Tobias Honscha · March 22nd, 2006, 02:23 PM

Quote:

Originally Posted by Tobias Honscha

now I try to rename all tables into names without prefix and after that changing both config files to none prefeix...

Ok ... showing a single image works

Tobias Honscha · March 22nd, 2006, 02:27 PM

but deleting images does not work ... **** . Ok I will try re-uploading all the files again !