Home arrow Forum Help Request:
  Welcome, Guest. Please login or register.
Did you miss your activation email?
November 22, 2008, 07:44:14 PM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)
| | | |-+  Help Request:		 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Help Request:  (Read 1585 times)
Turmoil
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 1


View Profile
Help Request:
« on: January 27, 2007, 12:46:22 PM »
Quote from: Joomla-SMF Bridge Request
JOOMLA-SMF BRIDGE Version: 2.0
JOOMLA Version: Joomla! 1.0.11 Stable [ Sunbow ] 28 August 2006 20:00 UTC
SMF Version:1.1.1

Please Describe the Issue:
The problem is the following:
I installed recently this bridge and when I try to log in (at the website) with my old Admin account (or the new forum admin account) I can't! It says that the username or password is wrong.
I installed the SMF login Module, I followed the user guide and nothing happens!
After that I realized that I forgot to sycronize in the Joomla-SMF forum-> installation menu, but when I click "done [verify]      Optional: Synchronize Joomla and SMF users(username or real name)." in the [verify] this error appears:
Quote
Failed:Error verifying user synchronization.: db_error:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation \\\'=\\\' SQL=SELECT count(*) FROM smf_members LEFT JOIN jos_users ON jos_users.username=smf_members.memberName WHERE jos_users.username IS NULL1
Please help me!!!
Website: www.marchadium.net
« Last Edit: January 27, 2007, 01:36:29 PM by Turmoil » Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Help Request:
« Reply #1 on: January 27, 2007, 07:47:51 PM »
it looks like your joomla tables are MySQL collation latin1_swedish_ci but your SMF tables are utf8_general_ci.  You can change this in phpmyadmin, you will have to set each joomla table ot utf8_general_ci.
Logged
Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
rok123
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2


View Profile
Re: Help Request:
« Reply #2 on: March 22, 2007, 11:02:18 AM »
Hi I just wanted to say I am having a similar problem and I cant find a way to fix it:

MY Joomla version is: 1.0.12
SMF version is: 1.1.2
Joomla-SMF version: 2.0
CB is 2.0

+ I successfuly bridged gallery2 2.2 + joomla + CB + smf forum - (But smf login only works perfect when loging directly in forum not the smf module)

My first problem was verifying user synchronization:

Failed:Error verifying user synchronization.: db_error:Illegal mix of collations (utf8_slovenian_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation \\\'=\\\' SQL=SELECT count(*) FROM smf_members LEFT JOIN jos_users ON jos_users.username=smf_members.memberName WHERE jos_users.username IS NULL1

In phpmyadmin I fixed all the database tables to utf8_general_ci but still no changes when i try to synchronize it..still same error report. Cry

I would be very happy if you have any advice how to fix this error since i am trying to fix this for a few days now with no luck...

I think this error is causing my next problem when trying to log in directly to smf login: incorect username or password please try again. (Login module doesnt work)

My second error was when (not always) when i refresh the page sometimes login module reports a:

Warning: Invalid argument supplied for foreach() in C:\Program files\apache\xampp\htdocs\components\com_smf\smf.class.php on line 804

Please help, i would realy appriciate some feedback...I can even help testing new components if needed. Keep up the great work! Grin 
Logged
rok123
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2


View Profile
Re: Help Request:
« Reply #3 on: March 23, 2007, 08:08:58 AM »
I read some other topics but still havent found the right solution. Is it possible that synchoronization problem started when i installed joomla and smf in the same database with no root user password?

If that is true is ther a way to fix it in my phpadmin or do I need to reinstall both aplications?
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Help Request:
« Reply #4 on: March 23, 2007, 09:30:21 PM »
The problem is the way you have installed and configured your database.  It is fixed by changing the collation of your database tables.  The login problem is because the table collations are not the same, which is like one set of tables speaking english and the other set of tables speaking german, they don't understand each other.  If you install SMF using UTF-8 all tables and the database must by utf8_general_ci
Logged
Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
RJ
Joomla Newbie
*

Karma: +1/-2
Offline Offline

Posts: 34


View Profile WWW
Re: Help Request:
« Reply #5 on: April 01, 2007, 02:07:27 PM »
Quote from: -Wolverine on March 23, 2007, 09:30:21 PM
The problem is the way you have installed and configured your database.  It is fixed by changing the collation of your database tables.  The login problem is because the table collations are not the same, which is like one set of tables speaking english and the other set of tables speaking german, they don't understand each other.  If you install SMF using UTF-8 all tables and the database must by utf8_general_ci
Would the login start working if I change the SMF collation to latin1 to match the Joomla! table collation? I would prefer to keep the latin1 collation.
Update: I just double checked my smf tables and some are in utf8_general_ci and some are in latin1_swedish_ci. I do not recall overtly setting them this way. Here is the list:
smf_attachments thru smf_log_search_subjects are utf8_general_ci
smf_log_search_topics thru  smf_topics are latin1_swedish_ci.
« Last Edit: April 01, 2007, 02:19:10 PM by RJ » Logged
RJ
Atlanta, GA
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Help Request:
« Reply #6 on: April 01, 2007, 04:03:28 PM »
they must be the same and they must match the joomla tables and the db collation.
Logged
Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
RJ
Joomla Newbie
*

Karma: +1/-2
Offline Offline

Posts: 34


View Profile WWW
Re: Help Request:
« Reply #7 on: April 01, 2007, 04:07:57 PM »
Quote from: -Wolverine on April 01, 2007, 04:03:28 PM
they must be the same and they must match the joomla tables and the db collation.
Okay so are you saying that I can simply change the remainder of the SMF utf8 tables to latin1_swedish_ci to match the Joomla tables? If so, will I need to do anything else or will it start working at that point?
Logged
RJ
Atlanta, GA
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Help Request:
« Reply #8 on: April 01, 2007, 04:10:41 PM »
You may need to reinstall the SMF tables to get it to work, I don't know at this point.  I think MySQL doesn't change table/db collations correctly.  It is better to get it right on the install.
Logged
Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
RJ
Joomla Newbie
*

Karma: +1/-2
Offline Offline

Posts: 34


View Profile WWW
Re: Help Request:
« Reply #9 on: April 01, 2007, 04:12:26 PM »
Quote from: -Wolverine on April 01, 2007, 04:10:41 PM
You may need to reinstall the SMF tables to get it to work, I don't know at this point.  I think MySQL doesn't change table/db collations correctly.  It is better to get it right on the install.
Reinstall the tables? Is that difficult? Would I lose the data? How do I make sure they would install as latin1?
Logged
RJ
Atlanta, GA
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: Help Request:
« Reply #10 on: April 01, 2007, 04:18:23 PM »
I suggest you jump over to mysql.org and read up about managing databases.  You should be able to easily find all the answers to your questions there.
Logged
Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Pages: [1] Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com 		Valid XHTML 1.0! Valid CSS!

Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use
Joomla Hacks



Joomla Hacks
 German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Search Contact About Advertise Blogs Topsites Submit News Register Login