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]   Go Down

Author Topic: ¿Sirve el Cpmfetch para cpg1.5.x?  (Read 4170 times)

0 Members and 1 Guest are viewing this topic.

carolusabe

  • Coppermine newbie
  • Country: es
  • Offline Offline
  • Gender: Female
  • Posts: 19
¿Sirve el Cpmfetch para cpg1.5.x?
« on: July 13, 2010, 06:36:14 pm »

Hola.
Bueno antes de todo deciros que he leído las reglas, las FAQ, y muchos de los posts que hay en este foro para poder encontrar a alguien con mi problema. He encontrado problemas parecidos y lo he intentado solucionar igual ,pero no da resultado.
Hace muy poco me eliminaron mi galería y como tenía que hacer una nueva (por algunos problemas con el cpanel), me decidí a instalar la nueva cpg1.5.x , y me encanta la verdad es que está genial, muy útil y con muchas cosas nuevas, todo me va perfectamente y no he tenido ningun problema, solo que instalé el Cpmfetch (muchas veces y de formas diferentes) y me sale esto en el install.php:

Quote
"Unknown column 'p.owner_name' in 'field list'

SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM cpg15x_pictures AS p LEFT JOIN cpg15x_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg15x_albums AS a ON p.aid = a.aid LEFT JOIN cpg15x_categories AS c ON a.category = c.cid WHERE 1 AND p.approved='YES' AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = "")) ORDER BY p.ctime DESC LIMIT 0,4

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jdeppco/public_html/galeria/cpmfetch/cpmfetch_dao.php on line 1349

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/jdeppco/public_html/galeria/cpmfetch/cpmfetch_dao.php on line 1353
"

Os dejo una captura:

(http://img441.imageshack.us/img441/4024/installphp.jpg)

La galería es esta: http://jdepp.com/galeria/


Y como lo he desinstalado e instalado muchas veces y siempre me pone el mismo error, he pensado que alomejor en esta version del Cpg no se podía poner el Cpmfetch.
Si se puede poner y no es mucha molestia me encantaría que alguien pudiera ayudarme. Muchas gracias por todo igualmente.

Saludos
Carola.
Logged

jmatute

  • Moderator
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 453
Re: ¿Sirve el Cpmfetch para cpg1.5.x?
« Reply #1 on: July 14, 2010, 01:06:17 pm »

Hola,

Qué pena que al final os echaran.

No se puede usar 'oficialmente' el CPMFetch con la 1.5.6 aún. Ya lo dicen aquí: habrá que esperar.

Mientras sacan la versión buena puedes probar lo que dicen en esta hebra:

Abre install.php y busca alrededor de la línea 61

Code: [Select]
'cfSQLPictureSelect' => 'p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb',


y pon en su lugar

Code: [Select]
'cfSQLPictureSelect' => 'p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb',

aunque si quieres mantener el nombre de quien puso la foto yo intentaría

Code: [Select]
'cfSQLPictureSelect' => 'p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_id as pOwnerId, u.user_name AS pOwner_name, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb',

A ver si hay suerte.

Un saludo,
Logged

carolusabe

  • Coppermine newbie
  • Country: es
  • Offline Offline
  • Gender: Female
  • Posts: 19
Re: ¿Sirve el Cpmfetch para cpg1.5.x?
« Reply #2 on: July 14, 2010, 06:00:57 pm »

Muchisimas gracias jmatute!
Como siempre, me has ayudado y lo he podido solucionar. Muchas gracias de verdad.

Sí, al final me echaron... pero bueno como ya dije en su momento, ya me lo esperaba.

Pues lo dicho, muchisimas gracias por tu ayuda. Saludos!
Carola.
Logged

jmatute

  • Moderator
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 453
Re: ¿Sirve el Cpmfetch para cpg1.5.x?
« Reply #3 on: July 14, 2010, 08:05:19 pm »

Hola,

Dos cosas:

Como siempre, me has ayudado y lo he podido solucionar.

¿qué solución aplicaste? Piensa que vendrá otro buscando y es más fácil si lo dices explícitamente.

Y marca la hebra como solucionada, por favor.

Muchas gracias de verdad.

Un saludo, y me alegro de haber sido útil.
Logged

carolusabe

  • Coppermine newbie
  • Country: es
  • Offline Offline
  • Gender: Female
  • Posts: 19
Re: ¿Sirve el Cpmfetch para cpg1.5.x?
« Reply #4 on: July 14, 2010, 08:27:10 pm »


Abre install.php y busca alrededor de la línea 61

Code: [Select]
'cfSQLPictureSelect' => 'p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb',


y pon en su lugar

Code: [Select]
'cfSQLPictureSelect' => 'p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_id as pOwnerId, u.user_name AS pOwner_name, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb',


Eso fue lo que hize, y me funcionó a la primera :)
Saludos
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 18 queries.