I need your help, please advise

Home

Forum I need your help, please advise

	Welcome, Guest. Please login or register. Did you miss your activation email? December 02, 2008, 05:38:50 AM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

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

I need your help, please advise

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: I need your help, please advise (Read 1254 times)

Brad

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 3

I need your help, please advise

« on: August 14, 2006, 12:54:32 PM »

Hello everyone, I simply love joomla and wanted to integrate my old forum into a new site design. I am having some problems getting the install to work and getting my SMF users onto my Joomla database. My SMF was originally installed by fantastico a few years ago.

During the configuration process it propmts me for the database prefix. When typing in my prefix it still shows that it isn't correct. Is their anyway to fix this? I have a alot of posts and members and I really dont want to start over.

I am using the latest version of Joomla and SMF 1.1 RC2 as info. Any help is greatly appreciated.


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: I need your help, please advise

« Reply #1 on: August 14, 2006, 02:39:23 PM »

fantastico installs SMF in a separate database. If the un/pw for both the joomla and smf dbs are the same you can prefix the table name with your smf db name


	Logged

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

Brad

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 3

Re: I need your help, please advise

« Reply #2 on: August 14, 2006, 05:59:06 PM »

Quote from: -Wolverine on August 14, 2006, 02:39:23 PM

fantastico installs SMF in a separate database. If the un/pw for both the joomla and smf dbs are the same you can prefix the table name with your smf db name

Okay, assuming I change the joomla info in the configuration.php file to match the un/pw where do I go after that. right now my db names for both are as follows:

Joomla: brad_joom2
SMF: brad_bradkazsmf

Excude my st$p$dity but im lost and need to get this working Grin

Thanks in advance!


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: I need your help, please advise

« Reply #3 on: August 14, 2006, 06:50:21 PM »

if the un/pw used to access both those databases is *exactly* the same, then your smf table prefix would be

brad_bradkazsmf.smf_

I have not tested this, but in theory it should work.


	Logged

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

Brad

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 3

Re: I need your help, please advise

« Reply #4 on: August 14, 2006, 08:26:06 PM »

I did it and got this error message:

Code:

DB function failed with error number 1146
Table 'bradkaz_bradkazsmf.smf_session' doesn't exist SQL=SELECT session_id FROM smf_session WHERE session_id = 'ece436344264166d9dc5081ca5be182f'
SQL =

SELECT session_id
FROM smf_session
WHERE session_id = 'ece436344264166d9dc5081ca5be182f'

I can't believe something like this is this difficult, it should't be!


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: I need your help, please advise

« Reply #5 on: August 14, 2006, 09:36:40 PM »

I can't believe it is that difficult to install both on the same database. This is a bridge with requirements, and one of them is that both systems use the same database. Sorry it didn't work, but this is what we offer. If it isn't difficult I'd be happy to see the code you write for it. Just let me know.