News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Error after Mambo/SMF bridge install

Started by SmokeyUK, June 06, 2009, 11:43:39 AM

Previous topic - Next topic

SmokeyUK

Just installed Mambo 4.5 and SMF 2.0 with the bridge, and I get this displayed when I go into the bridge config page.

Warning: Invalid argument supplied for foreach() in /home/****/public_html/cms/administrator/components/com_smf/admin.smf.php on line 125 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/****/public_html/cms/administrator/components/com_smf/admin.smf.php on line 152

I have both SMF and Mambo installed on the same database.

All the folders have been chmod to 777 as per read me.

I do not have the permission option in my hosts control panel, and no its not cPanel.

Any ideas??

Orstio

Mambo 4.5 is obsolete.  The bridges for Mambo work only with Mambo 4.6.x.

SmokeyUK


Orstio


SmokeyUK

Version SMF 2.0 Mambo 4.6 bridge 2.0beta1

Orstio

Were there any errors when you performed the installation?

SmokeyUK

Nope the install went fine, it only when you click Components/SMF Bridge/Configuration that I get this error, I make changes to the configuration going through the tabs, and click save, but it then goes back to default and the 1st tab once saved  :(

Orstio

Can you check phpMyAdmin for the mos_smf_config table?


Orstio

OK, then in the SQL tab of phpMyAdmin, paste this:

CREATE TABLE mos_smf_config (
`variable` VARCHAR( 20 ) NOT NULL ,
`value1` VARCHAR( 80 ) NOT NULL ,
`value2` VARCHAR( 50 ) ,
`value3` VARCHAR( 50 ) ,
`value4` VARCHAR( 50 ) ,
INDEX ( `variable` )
) TYPE = MYISAM ;


ANd click "Go".

When that's done, paste in this:

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('smf_path','Path Not Set')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('bridge_reg', 'bridge')


INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('wrapped', 'true')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('smf_css','true')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('synch_lang','true')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('agreement_required','on')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('im','on')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('pmOnReg','on')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('use_realname',false)

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('cb_reg', 'off')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('cb_profile','off')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('bridge_version','2.0')

INSERT INTO #__smf_config
(`variable`, `value1`)
VALUES ('newsboard','')


And click "Go".

Then all should work as expected.

kravron

#10
I have the Same Error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/h/e/l/hellbringers/html/administrator/components/com_smf/admin.smf.php on line 152



i tried the posted fix and it didn't work i got another error about syntax i didn't try it again in fear of messing up my DB


Current SMF version: SMF 1.1.9
Mambo version: 4.6.5

Kindred

what version of the bridge did you install?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

mikeill

Hi and thanks.

I have just installed:

Mambo 4.6.5
SMF 1.1.9
SMF Bridge 2.0

and am also getting the "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in URL_PATH/administrator/components/com_smf/admin.smf.php on line 152" error on the SMF Bridge configuration page.

Have read the manual and

1. set the following permissions to 777:

/components
  /modules
  /mambots/system (You may need to create this directory)
  /mambots/authenticator
  /administrator/components

2. Added users for both databases to each other, confirmed via cpanel

and via forum threads

3. confirmed existence of mos_smf_config table, which contains data.

4. Published SMF_header_include.

URL for Mambo is hxxp:wafflehousenc.com/community [nonactive].

URL for SMF is hxxp:wafflehousenc.com/board [nonactive].

Thanks for any help/input.

Mike

Orstio

WHat did you use as the absolute path to SMF?

mikeill

hey orstio,


used the path listed in SMF server settings (home/user/public_html/board), but the MySQL error was there before I configured that, when it still said (paraphrasing here) "PATH NOT SPECIFIED".

This may be a clue. When I tried to log out, I think through the bridge, I get the following error:

8: Undefined property: stdClass::$logout
File: /home/user/public_html/community/components/com_smf/smf.php
Line: 875Database Error: Table '[i]user[/i]_comambo.smf_sessions' doesn't exist
File: /home/user/public_html/board/Sources/Load.php
Line: 2017


user_comambo is the Mambo db. table smf_sessions doesn't exist there. It does exist in the SMF db.

Thank you so much.

Mike


Orstio

Go to your Mambo admin panel.

GO to the Modules menu.  Click on Site Modules.

Find the mod_smf_login in the list of modules.  It might not be on the first page.  When you find it, click on it.

Set the parameters to your liking.

Click Save.  Even if you change nothing, click Save.

mikeill

Hmmmm. Thanks.

I've done as you explained. When the mod_smf_login is published, I get the following error when not logged in as admin:

Notice: Undefined variable: configuration in /home/user/public_html/community/modules/mod_smf_login.php on line 110

Fatal error: Call to a member function get() on a non-object in /home/user/public_html/community/modules/mod_smf_login.php on line 110


And there is still the original MySQL error warning:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/userpublic_html/community/administrator/components/com_smf/admin.smf.php on line 152

Man, sorry this is being so troublesome.

Mike

Orstio

Aha.  I hadn't caught this in your previous post:

QuoteSMF 1.1.9
SMF Bridge 2.0

The bridge for SMF 2.0 will not work with SMF 1.1.x.

mikeill

ahh. so is it an older version of SMF i would need to install in order to bridge users within mambo?

mikeill

okay i think i see. either an older version of the bridge or a NEWER version of SMF.

Advertisement: