Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1] 2   Go Down

Author Topic: DUPLICATE ALBUMS IN OTHER CAT  (Read 12182 times)

0 Members and 1 Guest are viewing this topic.

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
DUPLICATE ALBUMS IN OTHER CAT
« on: March 06, 2013, 05:36:06 am »

Hi, please if have a solution, my need is duplicate all albums in a category to other

Tnks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #2 on: March 06, 2013, 11:28:22 pm »

Hi, is true but i need duplicate my albums y other cat but uploading different images.

Tnks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #3 on: March 07, 2013, 09:21:55 am »

So you just want to create albums with different content but the same name as in another category? If you don't want to use the album manager, you have to create a corresponding MySQL query or tell me the source and target category IDs if you ask me to create it for you.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #4 on: March 08, 2013, 12:50:05 am »

So you just want to create albums with different content but the same name as in another category? If you don't want to use the album manager, you have to create a corresponding MySQL query or tell me the source and target category IDs if you ask me to create it for you.

Source and target category IDs?, how do that, phpmyadmin or?

Tnks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #5 on: March 08, 2013, 09:30:14 am »

Open each category and search for the parameter cid in your browser's address bar, e.g.
Quote
index.php?cat=4
.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #6 on: March 08, 2013, 09:11:01 pm »

Open each category and search for the parameter cid in your browser's address bar, e.g. .

and send you all of them?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #7 on: March 09, 2013, 08:09:41 pm »

Yes, if you want me to create the code for you.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #8 on: March 11, 2013, 04:42:34 pm »

Yes, if you want me to create the code for you.

Hi again, http://200.116.127.78/nuevasplantillas2013/index.php?cat=4, is four (4) the CID, and have subcategories, i need all albmus, no categorized in http://200.116.127.78/nuevasplantillas2013/index.php?cat=136.

Tnks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #9 on: March 11, 2013, 04:56:07 pm »

Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #10 on: March 11, 2013, 11:04:00 pm »

No Coppermine footer, no support! http://documentation.coppermine-gallery.net/en/theme_copyright.htm#theme_copyright

YES you're right, and I told the technicians to be changed, please refresh the page
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #11 on: March 12, 2013, 10:02:14 am »

Sorry, but I won't click through your gallery to collect the category IDs. Please create a list of all source category IDs.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #12 on: March 13, 2013, 01:03:26 am »

Sorry, but I won't click through your gallery to collect the category IDs. Please create a list of all source category IDs.

7
8
9
10
11
12
13
14
15
16
17
18
19
20
28
29
45
46
47
48
49
50
51
66
67
119

Tnks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #13 on: March 13, 2013, 10:48:51 am »

Here's the prepared SQL statement:
Quote
INSERT INTO cpg15x_albums (title, description, visibility, uploads, comments, votes, pos, category, owner, thumb, keyword, alb_password, alb_password_hint, moderator_group, alb_hits, copyright_info) (SELECT title, description, visibility, uploads, comments, votes, pos, 136, owner, thumb, keyword, alb_password, alb_password_hint, moderator_group, alb_hits, copyright_info FROM cpg15x_albums WHERE category IN (7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 28, 29, 45, 46, 47, 48, 49, 50, 51, 66, 67, 119))

If your table prefix isn't cpg15x_, you have to adjust it twice.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #14 on: March 13, 2013, 10:46:59 pm »

Here's the prepared SQL statement:
If your table prefix isn't cpg15x_, you have to adjust it twice.

I have prefix, but with cms content?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #15 on: March 14, 2013, 10:17:46 am »

Please just try to execute the SQL statement.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #16 on: March 14, 2013, 08:39:30 pm »

Please just try to execute the SQL statement.

One error:

"#1054 - Unknown column 'copyright_info' in 'field list'"
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #17 on: March 14, 2013, 09:04:15 pm »

One error:

"#1054 - Unknown column 'copyright_info' in 'field list'"

I delete two parts with this table, and it works, but CMS field and photo portal is not appear

TNKS
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #18 on: March 14, 2013, 09:11:52 pm »

copyright_info is probably a column I added for somebody's mod in my database, sorry. However, I still don't know how your CMS and "photo portal" is related to your request. If you have modded anything, you have to adjust the query accordingly, as nobody knows your current setup.
Logged

johnfelipe

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Re: DUPLICATE ALBUMS IN OTHER CAT
« Reply #19 on: March 14, 2013, 09:26:08 pm »

copyright_info is probably a column I added for somebody's mod in my database, sorry. However, I still don't know how your CMS and "photo portal" is related to your request. If you have modded anything, you have to adjust the query accordingly, as nobody knows your current setup.

Yes your right, but help me to join to your code cpg15x_cms

Tnks
Logged
Pages: [1] 2   Go Up
 

Page created in 0.029 seconds with 19 queries.