Print

[n3n]

Hello


Yesterday i bridged my coppermine 1.4 with SMF (and SMF is bridged with Joomla) After i did this
i was unable to enter My Gallery. It says:

Code: [Select]

Critical error
There was an error while processing a database query
When entering the User galleries category it says:

Code: [Select]

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>

I see theres some sort of code missing, but im not sure how to fix it



My other problem is dat after i wrapped CPG it gives my annoying URLS, im not able to bookmark a page, because they
all fall within the Joomla wrapper component. Is there a way to fix this ? i would mind if the url was like www.test.com/gallery

Cheers !

[Tranz]

It seems as if you are using a custom 1.3 theme that hasn't been properly upgraded. Do you get the same error with a theme that comes with the 1.4 installation?

[n3n]

actually this is the "test" theme that came with this verion. I just renamed it and edited it. Maybe thats where the problem is. That i should change a wrong path that leads to the old "test" folder to the path of my renamed folder ?

[n3n]

Just tested with another theme, and it gives the same error, so that cant be it.

[Nibbler]

Update to the latest udb_base.inc.php from CVS.

[n3n]

Tnx for your advice nibbler, but it didnt work
Any other ideas ?

[Nibbler]

Enable debug mode in config and reproduce the error. See what the actual mysql error message is.

[n3n]

Code: [Select]

While executing query "SELECT memberName as user_name FROM members WHERE ID_MEMBER = '6'" on Resource id #5

mySQL error: Table 'joomla.members' doesn't exist

looks like it looks for the joomla tables, is that correct ? remember i have joomla/smf/cpg in one db.
also when i press the users button, i get the same error.

[Nibbler]

It's looking for the smf user table which the bridge is expecting to be there. It's designed for a regular SMF install and may not be compatible with your modifications.

[n3n]

Uuhm, i havent modified anything. where can i tell CPG in wich DB to look ?

[Nibbler]

It reads it automatically from SMF's Settings.php file.

[n3n]

Hmm, this is weird. Its correct in the smf config file.
And joomla.members is definetly wrong, should be someting like jos_members.

[n3n]

Anyone has any more tips ?
I bridged mambo with SMF with the smf component, and then i bridged coppermine with SMF.

Really dont understand why it looks for the mambo/joomla users

Error messages:

When pressing admin tools:

Code: [Select]

While executing query "
SELECT (ID_MEMBER + 10000) AS id,
CONCAT('(', memberName, ') ') as name
FROM members
ORDER BY name ASC" on Resource id #5

mySQL error: Table 'joomla.members' doesn't exist

When pressing users:

Code: [Select]

While executing query "SELECT count(*) FROM members WHERE 1" on Resource id #5

mySQL error: Table 'joomla.members' doesn't exist

When pressing my gallery:

Code: [Select]

While executing query "SELECT memberName as user_name FROM members WHERE ID_MEMBER = '6'" on Resource id #5

mySQL error: Table 'joomla.members' doesn't exist

And it gives error codes when pressing Upload file, Last Comments, Most Viewed, etc etc

Would really apreciate any more help.

[Nibbler]

Really dont understand why it looks for the mambo/joomla users

I already told you:

It's looking for the smf user table which the bridge is expecting to be there. It's designed for a regular SMF install and may not be compatible with your modifications.

If you don't have a members table in the database your SMF is installed into then you don't have a regular SMF install and the bridge won't work.