phpBB2.0.18 cpg1.4.2 (stable) DB problems

[Ferret_dude]

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

[kegobeer]

Link to your gallery?

[Ferret_dude]

http://www.stig-larsen.com/cpg142/ is the link to the gallery

[Ferret_dude]

right now nothing works unles cpg is in standalone mode  and it looks like i can't even log into the board  ...

[kegobeer]

Run the bridge wizard - follow the instructions in the documentation.

[Ferret_dude]

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

[kegobeer]

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.

[Ferret_dude]

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

[kegobeer]

One last time: post the actual SQL error message you receive.

[Ferret_dude]

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

[kegobeer]

http://forum.coppermine-gallery.net/index.php?topic=24032.0

[Ferret_dude]

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 

[kegobeer]

Bridge it and leave it bridged!  I have no idea what it looks like if you keep unbridging it.

[Ferret_dude]

 ok i did bridge it ... thought i had left it bridget 

[kegobeer]

What's the problem?  Everything works fine for the test user.  Clear your cookies.

[Ferret_dude]

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 ??

[Ferret_dude]

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

Code Select Expand

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

Code Select Expand

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:

[Nibbler]

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.

[Ferret_dude]

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 ??

[Nibbler]

About.....now !