You are browsing the old.JoomlaHacks.com. Checkout the newly redesigned responsive JoomlaHacks.com.
Home arrow Forum FAQ: Joomla-SMF Forum 1.0.x
  Welcome, Guest. Please login or register.
October 21, 2014, 09:28:42 AM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  FAQ's
| | |-+  Joomla-SMF Forum
| | | |-+  FAQ: Joomla-SMF Forum 1.0.x
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: FAQ: Joomla-SMF Forum 1.0.x  (Read 6707 times)
Editor in Chief
Administrator
Joomla Guru
*****

Karma: +86/-23
Offline Offline

Posts: 1171



View Profile WWW
FAQ: Joomla-SMF Forum 1.0.x
« on: November 05, 2005, 02:33:38 PM »

« Last Edit: November 07, 2005, 09:55:08 AM by Editor (cowboy) » Logged
Editor in Chief
Administrator
Joomla Guru
*****

Karma: +86/-23
Offline Offline

Posts: 1171



View Profile WWW
2. How to find the email from SMF that already exist in Joomla?
« Reply #1 on: November 07, 2005, 09:49:14 AM »

You have to manually query it from SMF table using phpMyAdmin or using your MySQL Control Center.

Here's how you find the email from SMF that already exist in Joomla:

Code:
SELECT jos1.username, jos1.email, smf.memberName, smf.emailAddress
FROM smf_members smf, jos_users jos1
LEFT JOIN jos_users jos ON smf.memberName = jos.username
WHERE jos.username is NULL
AND jos1.email = smf.emailAddress

so for example:
user "test1" with email "test1@test.com" is in Joomla.
and "test111" with email "test1@test.com" is in SMF.
You see that test1 and test111 is using the same email!

The query will give you:
"test1", "test1@test.com", "test111", "test1@test.com"
therefore, you have to change "test111" email from smf_members.

Here's how you find duplicate emails from single table, example SMF:

Code:
SELECT memberName, emailAddress,
COUNT(emailAddress) AS NumOccurrences
FROM smf_members
GROUP BY emailAddress
HAVING ( COUNT(emailAddress) > 1 )
« Last Edit: November 07, 2005, 09:55:25 AM by Editor (cowboy) » Logged
Editor in Chief
Administrator
Joomla Guru
*****

Karma: +86/-23
Offline Offline

Posts: 1171



View Profile WWW
3. Cannot modify header information error.
« Reply #2 on: November 07, 2005, 09:50:37 AM »

I see the following error:

Warning: Cannot modify header information - headers already sent by (output started at /home2/dreamers/public_html/smf/Sources/Load.php:840) in /home2/dreamers/public_html/index.php on line 238

Solution:
In Joomla/Mambo index.php ... look for the following lines:

header( 'Expires: Mon, 26 Jul 1997 05:00:00 GMT' );
header( 'Last-Modified: ' . gmdate( 'D, d M Y H:i:s' ) . ' GMT' );
header( 'Cache-Control: no-store, no-cache, must-revalidate' );
header( 'Cache-Control: post-check=0, pre-check=0', false );
header( 'Pragma: no-cache' );

then... enclose it with

if (!headers_sent()) {
  header( 'Expires: Mon, 26 Jul 1997 05:00:00 GMT' );
  header( 'Last-Modified: ' . gmdate( 'D, d M Y H:i:s' ) . ' GMT' );
  header( 'Cache-Control: no-store, no-cache, must-revalidate' );
  header( 'Cache-Control: post-check=0, pre-check=0', false );
  header( 'Pragma: no-cache' );
}
Logged
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 German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
About Advertise

You are browsing the old JoomlaHacks.com
Click here for the redesigned JoomlaHacks.com!