forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: Ferret_dude on November 27, 2005, 01:17:16 pm
-
i have installed phpBB2.0.18 and cpg1.4.2 (stable) on my linux server but when i try to access the user albums i get an error message witch relates to the DB (the boards db i guess)
The address for the board is http://www.stig-larsen.com/forum user test password test
-
Link to your gallery?
-
http://www.stig-larsen.com/cpg142/ is the link to the gallery
-
right now nothing works unles cpg is in standalone mode >:( and it looks like i can't even log into the board ...
-
Run the bridge wizard - follow the instructions in the documentation.
-
i have done that .. i did fill in what i was asked to fill in but it seem lik it won't work at all :(
i will remove both phpBB an cpg and reinstall em both from scratch hope it works better
-
Don't do that. Run the bridge wizard, and then post the exact SQL error message. We can't help if you don't provide us with any useful information.
-
i did a fresh reinstall of both php BB and cpg but i still got the problems ... when i bridge em i can't even log on to the goard :(
seem like the DB get messed up ... if you like you can have a go at it since the board is just a testing place befor i take various scripts over to the live forum
-
One last time: post the actual SQL error message you receive.
-
ok let me explain the problem a little closer ... when i'm bridgin the gallery to the board i'm not able to log in to the board ...when i got to the gallery and try to log in from it it just bring me back to the board to log in there witch isn't possible when it is bridged ...
that is the reason wht i can't give you the SQL error message ... anyway thanks for the help .. i will be around to see if anyone else have that problem and how it is solved .. Ps i think coppermine is a nice gallery as a standalone :)
Ps if anyone has a solution or want to have a go at it pls feel fre to send me a PM
-
http://forum.coppermine-gallery.net/index.php?topic=24032.0
-
ok but how do i get to the errorr message from the sql when things are working when the gallery is in standalone mode but are totaly messed up when i bridge it like i explained in my previous post ?? i have turned on the debug mode in cpg but that dosen't help much when im brought to the board to sign in .. anyway i won't bother you with this little problem since adding the gallery isn't a big thing :)
-
Bridge it and leave it bridged! I have no idea what it looks like if you keep unbridging it.
-
ok i did bridge it ... thought i had left it bridget
-
What's the problem? Everything works fine for the test user. Clear your cookies.
-
yeah i noticed it was working now but i haven't cleard my cockeis so i'm really not sure what happend .. it might be a server related thing ... i aslo had a few people trying it out befor the reinstalation and they had the same problem ...
i just got one more question ... to be able to log on as admin in bridge mode do i need to make an account with the same usernam/password on the phpBB ??
-
ok i did install it on the main board but when i try to get to the user galleris i get this errormessage when im not logged in
Template error
Failed to find block 'log_ecards'(#(<!-- BEGIN log_ecards -->)(.*?)(<!-- END log_ecards -->)#s) in :
<div align="center">
<table cellpadding="0" cellspacing="1">
<tr>
<td class="admin_menu"><a href="admin.php" title="{ADMIN_TITLE}">{ADMIN_LNK}</a></td>
<td class="admin_menu"><a href="catmgr.php" title="{CATEGORIES_TITLE}">{CATEGORIES_LNK}</a></td>
<td class="admin_menu"><a href="albmgr.php{CATL}" title="{ALBUMS_TITLE}">{ALBUMS_LNK}</a></td>
<td class="admin_menu"><a href="groupmgr.php" title="{GROUPS_TITLE}">{GROUPS_LNK}</a></td>
<td class="admin_menu"><a href="usermgr.php" title="{USERS_TITLE}">{USERS_LNK}</a></td>
<td class="admin_menu"><a href="banning.php" title="{BAN_TITLE}">{BAN_LNK}</a></td>
<td class="admin_menu"><a href="reviewcom.php" title="{COMMENTS_TITLE}">{COMMENTS_LNK}</a></td>
<td class="admin_menu"><a href="picmgr.php" title="{PICTURES_TITLE}">{PICTURES_LNK}</a></td>
<td class="admin_menu"><a href="searchnew.php" title="{SEARCHNEW_TITLE}">{SEARCHNEW_LNK}</a></td>
<td class="admin_menu"><a href="util.php" title="{UTIL_TITLE}">{UTIL_LNK}</a></td>
<td class="admin_menu"><a href="profile.php?op=edit_profile" title="{MY_PROF_TITLE}">{MY_PROF_LNK}</a></td>
<!-- BEGIN documentation -->
<td class="admin_menu"><a href="{DOCUMENTATION_HREF}" title="{DOCUMENTATION_TITLE}" target="cpg_documentation">{DOCUMENTATION_LNK}</a></td>
<!-- END documentation -->
</tr>
</table>
</div>
the debug info gave me this output
While executing query "SELECT user_id as user_id,username as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg140_albums AS a INNER JOIN `ilderfor_phpbb1`.phpbb_users as u on u.user_id+10000=a.category LEFT JOIN cpg140_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000) GROUP BY category ORDER BY category LIMIT 0, 12 " on 0
mySQL error:
what can i do to solve this problem ??
Ps there were no more text after the mySQL error:
-
Either move phpbb and cpg into the same db, allow access to both from the same db user, or wait for me to upgrade the code.
-
thanks for the help .. it was probably the fact that i did use the same DB on the test who made it work
btw when wil the code be upgraded ??
-
About.....now ! :D
-
sweet ;D however i added it to my board's DB and it seem to be working :)
Thanks for the help