Page 2 of 3

Posted: Sun Oct 22, 2006 9:57 pm
by RMcGirr83
That's a bug which I just verified. :(

Posted: Mon Oct 23, 2006 9:38 pm
by RMcGirr83
and another
General Error Message:

Could not obtain picture information<br /><br /><b><u>DEBUG MODE</u></b><br /><br />SQL Error : 1064 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 2<br /><br />SELECT pid FROM cpg135_pictures
WHERE aid = </br /><br />Line : 723<br />File : usercp_viewprofile.php


code

Code: Select all

$sql = "SELECT p.filename, p.filepath, p.aid, p.pid, p.title as p_title, p.caption, p.pic_rating, p.ctime, a.* FROM " . PICTURES_TABLE . " p, " . ALBUMS_TABLE . " a
WHERE a.aid = p.aid

Posted: Tue Oct 24, 2006 6:16 am
by Joe Belmaati
RMcGirr83 wrote: and another
General Error Message:

Could not obtain picture information<br /><br /><b><u>DEBUG MODE</u></b><br /><br />SQL Error : 1064 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 2<br /><br />SELECT pid FROM cpg135_pictures
WHERE aid = </br /><br />Line : 723<br />File : usercp_viewprofile.php


code

Code: Select all

$sql = "SELECT p.filename, p.filepath, p.aid, p.pid, p.title as p_title, p.caption, p.pic_rating, p.ctime, a.* FROM " . PICTURES_TABLE . " p, " . ALBUMS_TABLE . " a
WHERE a.aid = p.aid


That's not where that error is produced.

Code: Select all

WHERE aid = $albumid";
...I am wondering why the album_id might be empty. The pic has to be in one album or another. Can you send me a link to that page?

As for the sorting order being off that one stumps me a bit as well. That said, the CPG method of placing pictures into chronological position is bizarre and extremely in-efficient. My code tries to work around this fact, but who knows what kind of anomalies may creep in.

Posted: Tue Oct 24, 2006 11:36 am
by RMcGirr83
I have initiated the test users account

user: test
password: test

the users it seems to be effecting have one or two pics in their album in coppermine

Posted: Tue Oct 24, 2006 12:51 pm
by RMcGirr83
Never mind I overwrote the code I had with that in the download and all seems to be working fine.

Posted: Tue Oct 24, 2006 5:05 pm
by z28cave
RMcGirr83 wrote: Never mind I overwrote the code I had with that in the download and all seems to be working fine.


even the picture order?

Posted: Tue Oct 24, 2006 5:08 pm
by RMcGirr83
no not the picture order...doesn't seem to be getting the last pic and the issue that you mentioned earlier.

No biggie for me but the mod is not "complete" IMHO (In My Humble Opinion)

Posted: Fri Oct 27, 2006 7:14 pm
by Joe Belmaati
Is there a pattern to when the order seems to be off? I am not able to reproduce that error on my site.

Posted: Fri Oct 27, 2006 7:57 pm
by JaymeS
In my case, this is what's happening Joe:
When a Member only has one category Album, the thumbnails on the profile page appear to be linked directly opposed in the order, ie tnail for last post to the first image on the album, tnail for second to last post to the second image uploaded to the album etc. Symmetrically opposed to the intended targets I should say.
This is rather odd Joe as others have stated that there is a switch on the code to obey Descending order.
I disabled registration for a time in case you wish to look at this:

http://illusions-designs.net/phpBB2/index.php

Thanks for your attention,
Jayme

Posted: Fri Oct 27, 2006 8:11 pm
by JaymeS
Actually I created and account. Better that way, I feel.

Login: guest
Pass: guest

http://illusions-designs.net/phpBB2/

Posted: Fri Oct 27, 2006 9:24 pm
by RMcGirr83
either the image or the pos is off by one. For example the image with pos=7 is actually (in coppermine) pos=6.

Posted: Sat Nov 11, 2006 4:39 pm
by All4yu.com
Does it work when the databse isn't the same for PHPBB and COPPERMINE ?

I just installed the mod and nothing happens :-(

Posted: Wed Dec 06, 2006 3:58 pm
by alien13
No, the idea is the two systems must be integrated.

Joe Belmaati, is there way to make, when the user is not upload any pictures in the gallery, in Profile Page to appear some message, for example - No uploaded pictures. Thanks in advance!

Posted: Wed Dec 06, 2006 4:29 pm
by Joe Belmaati
alien13 wrote: Joe Belmaati, is there way to make, when the user is not upload any pictures in the gallery, in Profile Page to appear some message, for example - No uploaded pictures. Thanks in advance!


Easy,

OPEN includes/usercp_viewprofile.php

FIND

Code: Select all

			'WIDTH' => 100/NUM_PICS
		));
	}
}
AFTER, ADD

Code: Select all

else
{
    $template->assign_block_vars('switch_no_pics', array(
    	'L_NO_PICS' =>  sprintf($lang['No_pics'], $profiledata['username'])
    	)
    );
}
OPEN language/lang_english/lang_main.php

FIND

Code: Select all

$lang['Latest_pics'] ='Latest pictures from %s (Files uploaded: %d)';
AFTER, ADD

Code: Select all

$lang['No_pics'] = '<b>%s</b> has not uploaded any pictures yet';
OPEN templates/subSilver/profile_view_body.tpl

FIND

Code: Select all

<!-- BEGIN switch_pics -->
BEFORE, ADD

Code: Select all

<!-- BEGIN switch_no_pics -->
<table width="100%" border="0" cellspacing="1" cellpadding="4" align="center" class="forumline">
	<tr>
		<td class="row1" align="center"><span class="genmed">{switch_no_pics.L_NO_PICS}</span></td>
	</tr>
</table>
<!-- END switch_no_pics -->

.........as for the problem with the thumbnail that points to the wrong pic - I have not been able to replicate the problem and as such, I am finding it hard to remedy the problem.

Posted: Wed Dec 06, 2006 6:53 pm
by alien13
Thank you for fast reply. It works perfect. I have one more question. I want to show 12 pictures from the gallery. How to make, to show only 4 pictures on line and next 4 pictures to be on new line and last 4 pictures to be on tird line, because now all pictures expand my theme. Example:

| 1 | 2 | 3 | 4 |
| 5 | 6 | 7 | 8 |
| 9 |10 |11 |12|

The numbers are the diffrent pictures.

Thank you in advance!