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: Critical error
There was an error while processing a database query
When entering the User galleries category it says:
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 !
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?
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 ?
Just tested with another theme, and it gives the same error, so that cant be it.
Update to the latest udb_base.inc.php (http://cvs.sourceforge.net/viewcvs.py/*checkout*/coppermine/stable/bridge/udb_base.inc.php) from CVS.
Tnx for your advice nibbler, but it didnt work :(
Any other ideas ?
Enable debug mode in config and reproduce the error. See what the actual mysql error message is.
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.
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.
Uuhm, i havent modified anything. where can i tell CPG in wich DB to look ?
It reads it automatically from SMF's Settings.php file.
Hmm, this is weird. Its correct in the smf config file.
And joomla.members is definetly wrong, should be someting like jos_members.
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:
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:
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:
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.
Quote from: n3n on December 06, 2005, 12:31:37 AM
Really dont understand why it looks for the mambo/joomla users :(
I already told you:
Quote from: Nibbler on December 04, 2005, 10:33:57 PM
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.