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??
Mambo 4.5 is obsolete. The bridges for Mambo work only with Mambo 4.6.x.
Soz typo, meant 4.6.5
What version of the bridge?
Version SMF 2.0 Mambo 4.6 bridge 2.0beta1
Were there any errors when you performed the installation?
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 :(
Can you check phpMyAdmin for the mos_smf_config table?
hmmm not there
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.
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
what version of the bridge did you install?
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 http://wafflehousenc.com/community (http://wafflehousenc.com/community).
URL for SMF is http://wafflehousenc.com/board (http://wafflehousenc.com/board).
Thanks for any help/input.
Mike
WHat did you use as the absolute path to SMF?
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
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.
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
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.
ahh. so is it an older version of SMF i would need to install in order to bridge users within mambo?
okay i think i see. either an older version of the bridge or a NEWER version of SMF.
Correct. Bridge 2.0 is for SMF 2.0. Bridge 1.1.x is for SMF 1.1.x.
okay looking good after uninstalling bridge 2 and installing 1. had to save config before SQL error went away. thank you, orstio.
mikeill, do you require any further assistance? :)
Hey all, I got same problem. After installing i can see in Components -> SMF Bridge this msg:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/zatloukal.eu/subdomains/slackers/administrator/components/com_smf/admin.smf.php on line 152
So i tried to do this step ->
Quote from: Orstio on June 06, 2009, 02:13:35 PM
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.
Fist paste thing working - after click go on second one i got this error msg:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`variable`, `value1`) VALUES ('smf_path','Path Not Set') ' at line 1
Before i tried it i deleted my mos_smf_config.
I use SMF - 1.1.11
Mambo - 4.6.2
bridge - smf_1-1_mambo_4-6_bridge_1-1-2
Thank you
Filip
You need to change #__ to YOUR actual table prefix.
Quote from: Orstio on September 04, 2009, 09:13:38 AM
You need to change #__ to YOUR actual table prefix.
Hey Orstion,
ty for response....however i change code to:
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('smf_path','Path Not Set')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('bridge_reg', 'bridge')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('wrapped', 'true')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('smf_css','true')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('synch_lang','true')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('agreement_required','on')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('im','on')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('pmOnReg','on')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('use_realname',false)
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('cb_reg', 'off')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('cb_profile','off')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('bridge_version','2.0')
INSERT INTO mos_smf_config
(`variable`, `value1`)
VALUES ('newsboard','')
Error is now:
Quote#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO mos_smf_config (`variable`, `value1`) ' at line 5
Should be mos_smf_config for me.
Filip
What if you do this:
INSERT INTO mos_smf_config
(`variable`, `value1`,`value2`,`value3`,`value4`)
VALUES ('smf_path','Path Not Set','','','')
if you install your cms and board in seperated database you have to grant both users to both databases so the error's gone
Hi SmokeyUK, has your issue been solved? Do you still require assistance on this? :)