Rename database filepath for certain pictures

[l0rdenn0n]

phpmyadmin, hence 'manually'. If you search the board you will find previous posts about this, but you need to run a query like

Code Select Expand

UPDATE cpg_pictures SET filepath = 'newpath' WHERE filepath = 'oldpath'

If you are not familiar with phpmyadmin make a backup of the table first.

Hello,

how can i change the database filepath for certain pictures ? The best would be the "aid table", because they`re over 40000 Pictures

[Hein Traag]

Pls do not hijack other threads to ask questions. It is better to start your own thread.

[Joachim Müller]

Thread split from "rename albums folder?"

[l0rdenn0n]

Thanks for the Split, but is does`t help me

[Hein Traag]

It does help the forum in general by not cluttering someone elses thread. If you have a problem and seek answers on the forum then please start your very own thread. This keeps it al nice and tidy and easier for supporters to give support to the right persons.

Cheers
Hein

[Joachim Müller]

how can i change the database filepath for certain pictures ? The best would be the "aid table", because they`re over 40000 Pictures

Use phpMyAdmin to accomplish this. Post details for details.

[l0rdenn0n]

ok again

I want to change with phpMyAdmin the filepath for all Pictures of the "aid table" example "52". I think is easier as the "pid table", because they`re over 40000 Pictures.

Code Select Expand


UPDATE cpg_pictures SET filepath = 'newpath' WHERE filepath = 'oldpath'

Thats the query, but with this i change the filepath for all Pictures. So what is missing ? 

[Joachim Müller]

What's an "aid table"? What's a "pid table"? How do the pics differ, i.e. what could be added to the query in the WHERE segment?

[l0rdenn0n]

Ok here is an image.

I want to change the filepath for all Pictures in the "aid" table (or whatever that is called) nr. 1 for example.

I think i have to use the query

Code Select Expand

UPDATE cpg_pictures SET filepath = 'newpath' WHERE filepath = 'oldpath'

but i must indicate which Pictures i want to change.

[Nibbler]

Just add

Code Select Expand


AND aid = 1


to the query.

[l0rdenn0n]

Thats it. Thanks a lot