Advertisement:

Author Topic: Error after Mambo/SMF bridge install  (Read 29192 times)

Offline SmokeyUK

  • Newbie
  • *
  • Posts: 6
Error after Mambo/SMF bridge install
« on: June 06, 2009, 11:43:39 AM »
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

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #1 on: June 06, 2009, 11:51:56 AM »
Mambo 4.5 is obsolete.  The bridges for Mambo work only with Mambo 4.6.x.

Offline SmokeyUK

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #2 on: June 06, 2009, 12:04:46 PM »
Soz typo, meant 4.6.5

Orstio

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #3 on: June 06, 2009, 12:29:06 PM »
What version of the bridge?

Offline SmokeyUK

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #4 on: June 06, 2009, 12:56:45 PM »
Version SMF 2.0 Mambo 4.6 bridge 2.0beta1

Orstio

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #5 on: June 06, 2009, 01:04:32 PM »
Were there any errors when you performed the installation?

Offline SmokeyUK

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #6 on: June 06, 2009, 01:14:40 PM »
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

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #7 on: June 06, 2009, 01:21:16 PM »
Can you check phpMyAdmin for the mos_smf_config table?

Offline SmokeyUK

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #8 on: June 06, 2009, 01:42:02 PM »
hmmm not there

Orstio

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #9 on: June 06, 2009, 02:13:35 PM »
OK, then in the SQL tab of phpMyAdmin, paste this:

Code: [Select]
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:

Code: [Select]
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.

Offline kravron

  • Newbie
  • *
  • Posts: 1
Re: Error after Mambo/SMF bridge install
« Reply #10 on: June 18, 2009, 06:51:18 PM »
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
« Last Edit: June 18, 2009, 07:42:09 PM by kravron »

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,500
  • Gender: Male
    • Kindred-999 on GitHub
Re: Error after Mambo/SMF bridge install
« Reply #11 on: June 19, 2009, 09:02:51 PM »
what version of the bridge did you install?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline mikeill

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #12 on: July 02, 2009, 07:18:20 PM »
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

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #13 on: July 03, 2009, 12:43:04 AM »
WHat did you use as the absolute path to SMF?

Offline mikeill

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #14 on: July 03, 2009, 12:54:59 PM »
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:

Code: [Select]
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

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #15 on: July 03, 2009, 03:33:12 PM »
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.

Offline mikeill

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #16 on: July 06, 2009, 05:28:49 PM »
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:

Code: [Select]
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:

Code: [Select]
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

  • Guest
Re: Error after Mambo/SMF bridge install
« Reply #17 on: July 06, 2009, 06:43:47 PM »
Aha.  I hadn't caught this in your previous post:
 
Quote
SMF 1.1.9
SMF Bridge 2.0

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

Offline mikeill

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #18 on: July 06, 2009, 09:45:20 PM »
ahh. so is it an older version of SMF i would need to install in order to bridge users within mambo?

Offline mikeill

  • Newbie
  • *
  • Posts: 6
Re: Error after Mambo/SMF bridge install
« Reply #19 on: July 06, 2009, 09:46:40 PM »
okay i think i see. either an older version of the bridge or a NEWER version of SMF.