I have the following issue when trying to bridge coppermine and SMF:
There was an error while processing a database query.
While executing query "SELECT count(*) FROM `pxlsmf`.smf_members WHERE 1" on 0
mySQL error:
File: C:\Inetpub\vhosts\pixel.gen.tr\httpdocs\galeri\include\functions.inc.php - Line: 248
Coppermine install: http://www.pixel.gen.tr/galeri/
Forum install: http://www.pixel.gen.tr/smf/
Coppermine version: cpg1.4.2
Forum version: SMF 1.1 RC1
Test user account: test / test
BridgeManager settings:
Forum URL: http://www.pixel.gen.tr/smf/
Relative path to your BBS's config file: ../smf/
Use post-based groups?: yes
Update to the latest udb_base.inc.php (http://cvs.sourceforge.net/viewcvs.py/*checkout*/coppermine/stable/bridge/udb_base.inc.php) and smf.inc.php (http://cvs.sourceforge.net/viewcvs.py/*checkout*/coppermine/stable/bridge/smf.inc.php) from CVS.
Thanx for quick replay,
i did the update but i got this error this time.. :-[
While executing query "SELECT ID_MEMBER as user_id, memberName as user_name, emailAddress as user_email, dateRegistered as user_regdate, UNIX_TIMESTAMP(lastLogin) as user_lastvisit, is_activated as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `pxlsmf`.smf_members AS u INNER JOIN cpg140_usergroups AS g ON u.ID_POST_GROUP+100 = g.group_id LEFT JOIN cpg140_pictures AS p ON p.owner_id = u.ID_MEMBER GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;" on Resource id #22
mySQL error: No database selected
can it be a problem becouse of smf installation?
both of them was fresh installs..but i cant understand this..
Try this: http://forum.coppermine-gallery.net/index.php?topic=24842.msg114300#msg114300
no .. nothing changed..
i will install them again..and bridge again..if i can find the reason for this error,i will post it here
thanx a lot