New Install Questions New Install Questions
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

New Install Questions

Started by doctoreast, January 10, 2007, 12:58:48 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

doctoreast

January 10, 2007, 12:58:48 AM
Hi,
  First, let me state that install was stunningly instant,
painless, and thorough.  The only serious error on your
quick installation instruction was not mentioning the
Bridge Manager. 

  I'm getting critical error when I click the admin menu's
Sort My Files tab.  I added images to one album,
but not my personal album, and so I am wondering what
album Sort My Files is looking for?  Any pointers
here? 

  Also, in config I entered the location for my header and footer
includes, but am wondering how to enter the css/js link references.
Should I just put those on the header include?  How would
you configure/use this option?  What cpg page would I modify to add
linkref tags,  for css and js?  I could put everything on the header
include, but wouldn't that fail validation?

Thanks in Advance,
East

Nibbler

#1
January 10, 2007, 01:28:29 AM
Please try to keep to one question per thread (as per the rules), it keeps things organised.

Bridge manager is an optional feature, I don''t understand what the problem is.

Post the exact error message if you get error messages. See if enabling debug mode in config gives you more details about the error.

Custom headers and footers are meant for including php files, if you want to add css/js files edit your theme's template.html and add them into the <head> section as normal.

doctoreast

#2
January 10, 2007, 01:51:55 AM
Nibbler,
  Thanks for your feedback.  Here is the exact Sort My Pictures Error.
Also, If I logout as admin, and login as a member, this error does not occur. 
Also, it will not let me log-out from cpg; I have to go to SMF to logout.  I
recall reading something about enabling subdomain independent cookies in SMF.
Would this help?

Error Follows: CPG Said:
###################


Critical error
There was an error while processing a database query.

Debug Said:
While executing query "SELECT aid, CONCAT('(', memberName, ') ', a.title) AS title
                                                        FROM cpg1410_albums AS a
                                                        INNER JOIN `mikey`.smf_members AS u
                                                        ON category = (10000 + ID_MEMBER)
                                                        ORDER BY title" on 0

mySQL error: Illegal mix of collations for operation 'concat'
File: /home/m/i/mikey/public_html/cpg1410/include/functions.inc.php - Line: 249


Nibbler

#3
January 10, 2007, 02:04:45 AM
That means you are using a different charset/encoding for SMF and Coppermine's databases. We don't really have a solution for that. Try moving them to separate databases with separate mysql users. If you want to get a solution to your login issues then post on the bridging sub board, posting the info requested in the sticky thread there.

doctoreast

#4
January 11, 2007, 07:35:33 AM
Hi,
  This issue has become critical, to where will will try to fix the database files.
I went into phpmyadmin and see some latin1/swedish encode tags on many of
the tables.  Looking at the list to change to, there are many UTF8-yourlanguage,
and one UTF8 Unicode-ci.  Can someone please tell me what coppermine uses,
that I can try to make them uniform?
Mike

doctoreast

#5
January 11, 2007, 02:00:03 PM
Also, question pertaining to your conclusion, is does
the manual recommend,  as you do, using seperate
databases?
east

Nibbler

#6
January 12, 2007, 11:40:00 PM
We don't really make recommendations either way. The bridge system is designed to work both ways. When they share a database Coppermine joins the cpg and smf tables directly to each other. If they have different encodings then this does not work out so well. If you place them in different databases accessed via different mysql accounts then the tables are not joined (the information is combined in the code not in database) so encoding should not be an issue. I don't know enough about SMF to advise you about changing the encoding. You would need to refer to the SMF documentation/forums. Coppermine uses UTF-8 from 1.4 onwards, and I always use utf8_general_ci when working with mysql.

doctoreast

#7
January 12, 2007, 11:51:11 PM
Nib,
  One of the SMF specialists wanted to follow this thread, asked me
for the url, and so I'm wondering if this is a known issue with the
current updated versions.  I'm hesitant to put them on one dbase,
but SMF is saying that this should never be a problem. 
  I just acquired new faster hosting, and so i might try this first on a
test version to see what happens.  Still, with media gallery, it might
make better sense to keep them seperate.
MIke East

Nibbler

#8
January 13, 2007, 12:02:16 AM
Looks like SMF supports UTF-8, see http://docs.simplemachines.org/index.php?topic=865. Sharing DBs won't be an issue unless you expect the DB to be huge.

doctoreast

#9
January 13, 2007, 12:08:30 AM
Nib,
  Well, this puts me back at square one,
wondering what the errors are really all about.
You said they were language problems, but
it may be something else????  Of coarse,  I
did install a few mods.  Could  a mod have
fouled the engine? 
  It's probably going to work out best to
use two dbases, and so this has been a lesson
for us all.
Mike

Nibbler

#10
January 13, 2007, 12:12:43 AM
No it doesn't. If you set SMF to use UTF-8 following the instructions on that link your issue should be solved. That way both Coppermine and SMF will be using the same encoding.

doctoreast

#11
January 13, 2007, 01:09:25 AM
Nib,
  Thanks for waking me up there. I had
assumed that SMF was already set for utf8.
  So, it looks like smf/cpg needs to get
together and eliminate this little inconsistancy.
Mike E.

doctoreast

#12
January 13, 2007, 01:15:29 AM

Nib,
  For the record, please note where SMF was asking me about this thread:
http://www.simplemachines.org/community/index.php?topic=141589.msg903018#msg903018

Mike

doctoreast

#13
January 13, 2007, 01:25:44 AM
Man, that's a triple pain, downloading
all language packs in utf8 is ridiculous.
I aint going there, will use seperate dbase
until smf gets it in gear.
me

doctoreast

#14
January 13, 2007, 10:29:51 PM
FOR THE RECORD:
  I fought this for a week, and then found that, all along, SMF was
already running UTF-8.  Look at the very base of your SMF
"settings.php" file for yor language setting.  Turns out that the
error, if due to language difference, is difference between the two
utf8 versions?????  I'm going to seperate the two.  Nuff said........
Mike
Print
Go Up Pages1
User actions