I have the following issue when trying to bridge coppermine and SMF:
[While executing query "SELECT * FROM cpg1410_bridge" on 0 mySQL error: Table 'dataave1_gallery.cpg1410_bridge' doesn't exist]
Coppermine install: http://thefishingstation.com/gallery/
Forum install: http://www.thefishingstation.com/hook/
Coppermine version: cpg1.4.2
Forum version: SMF v1.1.5
Test user account: test / coppermine
BridgeManager settings:
Forum URL: http://thefishingstation.com/
Relative path to your BBS's config file: /home/dataave1/public_html/thefishingstation.com/hook
Use post-based groups?: 0 <---Don't know what this is
Cookie name/preifx (not applicable - but SMFCookie11 for SMF)
I have had the forum working and had issues with a previous hosting company (unrelated). Moved all to a new server and SMF transfered like a champ, but Coppermine doesn't want to play nice. Thanks in advance.
Upgrade. Most recent stable release currently is cpg1.4.19. You're running cpg1.4.10, so you're 9 versions behind. Upgrading is mandatory in terms of security, as there are known security flaws in all coppermine versions before cpg1.4.19 that are actively being exploited.
After upgrading, try again: unbridge as per docs, then use phpMyAdmin to veryify that the coppermine table yourPrefix_bridge is already there. If it isn't: create it.
My thought exactly, but will not upgrade - I get even more errors. I will post.
QuoteAfter upgrading, try again: unbridge as per docs, then use phpMyAdmin to veryify that the coppermine table yourPrefix_bridge is already there. If it isn't: create it.
1) How do I unbridge. If I type link in, it will not let me login to Coppermine, it goes back to SMF and seems bridge not connected - Coppermine still wants me to login, although I am (logged in) at the SMF side.
2) How do I create "coppermine table yourPrefix_bridge"? I believe the problems lie here.
3) Thanks in advance for your help!
Running update.php will create that table. I have just done so for you. Now go to the bridge manager and redo the bridge.
If you can't unbridge as suggested in the docs (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#bridge_manager_recover_start), take a look at the preliminary docs for cpg1.5.x (http://documentation.coppermine-gallery.net/en/bridging.htm#bridge_manager_recover_start) - they explain how to manually unbridge if you can't access coppermine's user interface any longer.
As Nibbler suggested, that table is being created when updating. That's why I told you to upgrade - during that process, you would have had to run update.php, which would have fixed your missing table as well.
If this doesn't work as expected, you can alternatively run the query
CREATE TABLE IF NOT EXISTS cpg1410_bridge (
name varchar(40) NOT NULL default '0',
value varchar(255) NOT NULL default '',
UNIQUE KEY name (name)
) TYPE=MyISAM COMMENT='Stores the bridging data, not used when unbridged'; in the SQL tab of phpMyAdmin.
However, the error message you get now is different: when going to http://thefishingstation.com/gallery/, the error message now is
QuoteFatal error: require_once() [function.require]: Failed opening required 'bridge/.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dataave1/public_html/thefishingstation.com/gallery/include/init.inc.php on line 239
, so you appera to be fiddling with stuff that you're not suppossed to fiddle with. Don't remove the bridge file just because that file outputs the error - this is as if you removed a wheel from the car just because of a flat tire, trying to drive the car with only three wheels instead of four.
Haven't "touched" anything. I was upping new files. Will that error occur by you "running the update" while I was actually uploading the new files? When I go to phpMyAdmin, I see cpg14x_ and cpg1410_.
That error message is to be expected, since the bridge is enabled but not configured. You probably have 2 sets of prefixes as a result of updating incorrectly.
I fixed the "config.inc.php" from "$CONFIG['TABLE_PREFIX'] ='cpg1410_';" to "$CONFIG['TABLE_PREFIX'] ='cpg14x_';"
I get these errors now...but I am getting closer though...thanks!
QuoteUSER:
------------------
Array
(
[ID] => e9da379ee95db62b40d6a1d5b02fd301
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
- => 1
)
[group_quota] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 0
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[upload_form_config] => 3
[num_file_upload] => 5
[num_URI_upload] => 3
[custom_user_upload] => 0
[disk_max] => 0
[disk_min] => 0
[ufc_max] => 3
[ufc_min] => 3
[has_admin_access] => 0
[group_name] => Guests
[can_see_all_albums] => 0
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => SELECT * FROM cpg14x_bridge (0s)
[3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0s)
[4] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 (0s)
[5] => DELETE FROM cpg14x_banned WHERE expiry < '2008-11-29 14:05:20' (0s)
[6] => SELECT * FROM cpg14x_banned WHERE (ip_addr='173.68.126.247' OR ip_addr='173.68.126.247' OR user_id=0) AND brute_force=0 (0s)
[7] => SELECT aid FROM cpg14x_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (1) (0s)
[8] => SELECT aid FROM cpg14x_albums (0s)
[9] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = '' ORDER BY pos (0s)
[10] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
[11] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
[12] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = '1' ORDER BY pos (0s)
[13] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
[14] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
[15] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
[16] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0s)
[17] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
[18] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0s)
[19] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
[20] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) (0s)
[21] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) ORDER BY RAND() LIMIT 8 (0s)
[22] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) (0s)
[23] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) ORDER BY pid DESC LIMIT 0 ,8 (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
Page generated in 0.073 seconds - 24 queries in 0 seconds - Album set : ; Meta set: AND aid IN (-1) ;
Take a look here:
http://thefishingstation.com/gallery/versioncheck.php
When I try to unbridge, I get this:
QuoteYou supplied the wrong credentials. You will have to supply the admin account data of the standalone version (usually the account you set up during Coppermine install).
I have a password saver and the credentials are correct. I CAN log into SMF admin panel with those very same credentials.
Is there anyway to circumvent the 5000+ seconds before I can log in again? ???
Can't seem to find "bridge_enable" to disable bridge in phpMyAdmin. Little help, please?
Sorry, found it. ::)
My SMF password worked fine after I unbridged, but doesn't if bridged. Unbridged and Back in action - no errors, but no photos. Photos are in the album file, just don't show. Any suggestions here?
Strange, still says "Gallery Configuration - Coppermine Photo Gallery 1.4.10 (stable)" in the admin.
Uploaded file "init.inc.php" It now reflects most recent version. Still no albums or categories. Any suggestions?
Set the prefix back to cpg1410_
k
Back to "saying" Gallery Configuration - Coppermine Photo Gallery 1.4.10 (stable)
...which of course changed this: http://thefishingstation.com/gallery/versioncheck.php
I have no idea what you are doing now. You are not following instructions (changing the prefix will not affect the version number or versioncheck output whatsoever) and posting links to admin only pages is pointless.
Changing the prefix did chane the version page. If you would like me to change it back, I will and you can see.
Standing by.
I can give you admin info and you can check it out. Everything is in green (except update file-1.4.19-no color, but beside it, says 1.4.10 in yellow).
It is very difficult to give tech support over the phone or via a BB/email...etc. Frustrates the heck out of me-if I was there, I can fix the issue in seconds (most cases), but I am usually giving the tech support (I do Homeland Security). It is so much easier when in front of the problem/issue. The reason why I am saying this is because I don't want the help guru's here to misconstrue what I say. It also is (I am learning) very difficult to be on the receiving end (the one with the issue). That said, I appreciate all of your help.
You know, the hours I have tried to get this upgrade to work, I just could have recreated the whole gallery...so I am off to do just that! The only thing is, is that members will not see their uploads, I will batch uploaded. Thanks for all your help. Please close thread as solved.