CPG 1.4.2 and SMF 1.0.5 integration error

[ultraming]

I have the following issue when trying to bridge coppermine 1.4.2 and SMF 1.0.5
When click on Users tab (administrator login)
When click on Users galleries (both admin and regular user login)
Critical error
There was an error while processing a database query

Coppermine install: http://www.doriskevin.com/gallery/
Forum install: http://www.doriskevin.com/bb/
Coppermine version: cpg1.4.2
Forum version: SMF 1.0.5
Test user account: tester / 123456

BridgeManager settings:
Forum URL:  http://www.doriskevin.com/bb
Relative path to your BBS's config file:  ../bb/ 
Use post-based groups?:  0 

[Joachim Müller]

enable debug mode in coppermine's config to see the actual query that fails and post it here (the error message, not the debug_output). Upgrade to cpg1.4.3!

[ultraming]

When click Users tab in administrator mode

While executing query "SELECT count(*) FROM `doris2_smf1`.smf_members WHERE 1" on 0

mySQL error:

----------------------------------

When click on User Galleries

While executing query "SELECT ID_MEMBER as user_id,memberName 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 cpg_albums AS a INNER JOIN `doris2_smf1`.smf_members as u on u.ID_MEMBER+10000=a.category LEFT JOIN cpg_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:


Does that matter if I have CPG and SMF run on a separate dbase?  I installed both from cPanel.  Thanks.

[Joachim Müller]

Upgrade to the most recent stable version cpg1.4.3 (download it from our page, don't wait for the auto-installer like fantastico, they're buggy)

[ultraming]

If I do a manual install with CPG 1.4.3, should I use the same SMF database or a different one?  Does that matter?  Thanks.

[Joachim Müller]

installing coppermine and the bbs in the same database usually causes less issues. However, I suggest you upgrade instead of doing a fresh install.

[ultraming]

Could you point me to the direction where I can find the procedure to perform the upgrade from 1.4.2 to 1.4.3?  If I do the upgrade, is there an option to change the database?  Or I have to stick with whatever database I am using right now.  I am currently using two seperate DBs between CPG and SMF.  Thanks.

[Joachim Müller]

come on, don't be lazy: RTFM

[ultraming]

I upgraded from 1.4.2 to 1.4.3 by following the direction in the manual.  I got two red lines when I run the versioncheck.php.  Is that normail, or I have to fix that?  Thanks.

anycontent.php 1.4.2  1.4.3 -
albums/edit/no_FTP-uploads_into_this_folder!   -  -

Also, should I remove the update.php from the directory after the upgrade.  Thanks.

[Tranz]

Neither are critical. Leaving update.php won't hurt.

[ultraming]

I can't upload photos now.  I log on as admin and do a batch file upload.  I got this error.

Error executing ImageMagick - Return value: 127


Cmd line :
/usr/bin/convert -quality 80 -antialias -geometry 100x75 'albums/dkphoto/DSC00153.JPG' 'albums/dkphoto/thumb_DSC00153.JPG'



The convert program said:
sh: line 1: /usr/bin/convert: No such file or directory

Any help would be appreciated.  Thanks.

[Joachim Müller]

different issue, should have gone into a new thread (respecting our "one issue per thread" policy), but anyway: you haven't specified the correct path to ImageMagick's convert executable, or you don't have ImageMagick at all. Try using GD (coppermine config, "Method for resizing pics"). Search for your error message if you need details. Marking this thread as solved, as your initial question has been solved. If you need details, start a new thread in the uploads sub-board after reading the upload troubleshooting section of the docs and doing as suggested there. Locking thread.