JSMF 2.0 Beta

Home

Forum JSMF 2.0 Beta

	Welcome, Guest. Please login or register. Did you miss your activation email? July 24, 2008, 09:07:33 AM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)

JSMF 2.0 Beta

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: 1 [2] 3 4 ... 12

Author

Topic: JSMF 2.0 Beta (Read 25147 times)

Savvas

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 8

Re: JSMF 2.0 Beta - user syncing

« Reply #15 on: September 08, 2006, 08:03:43 AM »

Getting the following error when attempting to sync users with new JSMF 2.0 beta.

"db_error:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation \\\'=\\\' SQL=SELECT count(*) FROM smf_members"

I am using uft8_unicode_ci collation on all my jos_ tables, but the smf_ tables are utf8_general_ci. I use Greek language in my joomla/smf site. I changed the collation of the above mentioned table "smf_members" but still getting the error.

If i change the collation of all the smf_tables to uft8_unicode_ci will it get fixed? It's a lot of work since there are about 30 tables, so i like to know before i spend the time.


	Logged

Savvas.Athens.Greece.World

-Wolverine

Moderator
Joomla Guru

Karma: +373/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: JSMF 2.0 Beta

« Reply #16 on: September 08, 2006, 08:30:07 AM »

Quote from: Savvas on September 08, 2006, 08:03:43 AM

I hadn't seen this error before but reading MySQL bug reports it does appear that the different charset collations cause this problem. I'd recommend setting them to the same collation.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Savvas

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 8

Re: JSMF 2.0 Beta - everything works fine! no Greek!!

« Reply #17 on: September 08, 2006, 08:32:55 AM »

Well, the installation worked, the component is installed, the Joomla index.php had to be patched (copied?) manually, the bridge seems to work ok, also the joomap plugin works, the 3 supplied modules, the discussbot.

Great work, but:
1) the login module although correctly displayed, refuses to accept my credentials, claiming invalid username or password. Obviously this works fine if i logon directly through the SMF login form.
2) after patching the joomla index.php, my greek UTF8 content is displayed incorrectly. Are you doing something with html header meta tags? setting this to ISO or something? Inside SMF greek characters are displayed correctly although as mentioned in previous post above, the collaction of the smf_ tables is not the same as the jos_ tables. Could this have something to do with it.
3) after applying the joomla index.php some of my other addon component modules are now displaying errors such as:

"Warning: filesize() [function.filesize]: stat failed for C:\Program Files\xampp\htdocs\joomla\dmdocuments\Î‘Î™Î¤Î—Î£Î— Î‘Î ÎŸÎ–Î—ÎœÎ™Î©Î£Î—Î£ ALLIANZ.ppt in C:\Program Files\xampp\htdocs\joomla\administrator\components\com_docman\classes\DOCMAN_file.class.php on line 87"

Notice the weird characters? Could this again be due to the collation issue?

I suspect that all problems are interelated and if i find what going on with the collation, everything will be fixed. I promise to post the solution here for other non-english collating people to see.

Well done for the great work.


	Logged

Savvas.Athens.Greece.World

-Wolverine

Moderator
Joomla Guru

Karma: +373/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: JSMF 2.0 Beta

« Reply #18 on: September 08, 2006, 08:39:24 AM »

in regards to the headers, what I have done is simply strip them from the SMF template and add everything to the Joomla headers. In addition, I search for severa specific tags such as meta description, meta keywords, the css, and the title that are in the SMF header and I optionally add them to the Joomla header. Those four items are the only items that might not be included from the SMF header when I strip it and put it in the joomla header.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

-Wolverine

Moderator
Joomla Guru

Karma: +373/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: JSMF 2.0 Beta

« Reply #19 on: September 08, 2006, 08:41:40 AM »

Quote from: Kilian on September 08, 2006, 07:47:48 AM

Hi Wolverine,

thanks for your support. Do you want need an account on the site?

that would probably be helpful, just pm me the info. I don't have time to login until later today though.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Kilian

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: JSMF 2.0 Beta - user syncing

« Reply #20 on: September 08, 2006, 08:52:20 AM »

Quote from: Savvas on September 08, 2006, 08:03:43 AM

Earlier this morning I had the same message. I changed every smf table and row (this is important!) to the collation which the jos_ tables are using.

Quote from: -Wolverine on September 08, 2006, 08:41:40 AM

that would probably be helpful, just pm me the info. I don't have time to login until later today though.

You got a pm!


	Logged

Stefan Nitsche

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 10

Re: JSMF 2.0 Beta

« Reply #21 on: September 08, 2006, 09:01:13 AM »

Hi, first of all thanks for a great product. JSMF is just the thing I need for a project I've started

I am experiencing some problems however...

After I've patched everything I get this when visiting the site when not logged in:

Code:

Fatal error: Call to a member function on a non-object in /home/nitsche/public_html/lajv/index.php on line 61

The thing is that I think it worked the first time I visited the site. Undecided

I am using Community Builder, could it be something there? (I've installed the CB-plugin and configured JSMF to use CB.)

Any ideas on how to fix this?


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +373/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: JSMF 2.0 Beta

« Reply #22 on: September 08, 2006, 09:04:47 AM »

paste the code from the file /home/nitsche/public_html/lajv/index.php around line 61. That is your joomla index?

Also post your webserver versions, i.e. php ver etc.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Stefan Nitsche

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 10

Re: JSMF 2.0 Beta

« Reply #23 on: September 08, 2006, 09:18:32 AM »

index.php code:

Code:

52: //JOOMLAHACKS.COM : require SMF's SSI and save/restore globals that it cleans
53: defined( 'JPATH_BASE' ) or define('JPATH_BASE', $mosConfig_absolute_path);
54: if (file_exists(JPATH_BASE.'/components/com_jsmf/jsmf.class.php')) {
55: global $context;
56: require_once(JPATH_BASE.'/components/com_jsmf/jsmf.class.php');
57: $jsmf =& jsmfFrontend::singleton();
58: $jsmfConfig = $jsmf->loadParams();
59: $jsmf->saveVars($savedVars);
60: require_once($jsmfConfig->smf_path."/SSI.php");
61: $jsmf->restoreVars($savedVars);
62: }

Webserver info:

Apache 1.3.36
PHP 4.4.2
MySQL 4.1.19


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +373/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: JSMF 2.0 Beta

« Reply #24 on: September 08, 2006, 09:25:17 AM »

the only thing I can suspect here is that the way your webserver is configured the instance of $jsmf got cleared when SSI.php was included. Try this, on line 61 change the code from this:

Code:

$jsmf->restoreVars($savedVars);

to this:

Code:

$jsmf =& jsmfFrontend::singleton();
$jsmf->restoreVars($savedVars);


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Rascal71

Joomla Pro

Karma: +5/-1
Offline

Offline

Posts: 67

Re: JSMF 2.0 Beta

« Reply #25 on: September 08, 2006, 09:31:43 AM »

I did a fresh install of SMF 1.1-RC3 and installed the JSMF 2.0 bridge on a local XAMPP webserver. The Joomla version is 1.0.10 .

Everything seems to be working fine but when I look in the SMF error logs I see a lot of errors (4 pages) generated in a small amount of time.

There are 3 specific errors:

Quote

ruud Today at 02:30:14 pm
127.0.0.1 68759d618985abe87ce961d0e6ca0537
http://localhost/test/smf/index.php?option=com_jsmf&Itemid=30&action=viewErrorLog;desc;start=0
8: Undefined property: query
File: D:\Program Files\xampp\htdocs\test\components\com_jsmf\jsmf.class.php
Line: 647

ruud Today at 02:30:14 pm
127.0.0.1 68759d618985abe87ce961d0e6ca0537
http://localhost/test/smf/index.php?option=com_jsmf&Itemid=30&action=viewErrorLog;desc;start=0
8: Constant _SMF1_ already defined
File: D:\Program Files\xampp\htdocs\test\components\com_jsmf\jsmf.class.php
Line: 1869

ruud Today at 02:24:11 pm
127.0.0.1 c4040587291cdc095ed0ab6018a69e39
http://localhost/test/smf/index.php?option=com_jsmf&Itemid=30&action=logout;sesc
8: Undefined variable: my
File: D:\Program Files\xampp\htdocs\test\components\com_jsmf\jsmf.class.php
Line: 1610

any ideas ?


	Logged

Stefan Nitsche

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 10

Re: JSMF 2.0 Beta

« Reply #26 on: September 08, 2006, 09:33:29 AM »

Quote from: -Wolverine on September 08, 2006, 09:25:17 AM

the only thing I can suspect here is that the way your webserver is configured the instance of $jsmf got cleared when SSI.php was included. Try this, on line 61 change the code from this:

Code:

$jsmf->restoreVars($savedVars);

to this:

Code:

$jsmf =& jsmfFrontend::singleton();
$jsmf->restoreVars($savedVars);

That changed the error a little bit. It know says it's on line 62 (which means it trips over the same line as before). Undecided