Customizing SMF > Mambo Bridge Support

MAMBO installation HOW-TO (Notice: Table 'smf.mos_modules' doesn't exist)

(1/3) > >>

marcnyc:
Hello.
This started out as a request for help, but half way through I got inspired by something I have read somewhere (while searching for people with similar issues) and I was able to solve the issue myself so I decided to post it as a how-to in case somebody faces a similar problem and can't find the solution on the two forums.

Admins can decide if it's worth keeping or they can trash it if they please. No prob.

Once you have successfully installed and integrated Mambo with SMF and once you have followed all the instructions on Orstio's bridge and installed com_smf first, then com_smf_registration and mod_smf_login last you can proceed to install the four universal modules for the smf/mos integration.

At this point you might get this error:


--- Code: ---Notice: Table 'Your_SMF_database.mos_modules' doesn't exist in /Library/WebServer/Documents/content/includes/database.php on line 184

Warning: Invalid argument supplied for foreach() in /Library/WebServer/Documents/content/includes/frontend.php on line 58
--- End code ---

Which is possibly triggered by code like this:

--- Code: --- if ( mosCountModules( 'left' ) )
mosLoadModules('left');
--- End code ---

If you get this error it means you have installed Mambo in a different databse (as I did initially).
Turns out the two databases have to be the same database.
The database can be called whatever you please (if you have already installed SMF then it will be the name of the SMF database of course) and instead of the 35 smf_ tables you will have 70 tables of which 35 for SMF with smf_ prefix and 35 from MOS with mos_ prefixes.

I found this http://www.simplemachines.org/community/index.php?topic=18678.0 which is somewhat similar to my situation (I have less problems but a similar error output) and Orstio mentions that the Mambo and SMF tables have to be in the same database.

Good luck to all.
I am loving it so far.

kahuna:
Hello,
thanks for your info. Just how exactly do I add the smf_tables to the mambo_tables? I'm not very familiar with mysql, so I wonder how to do it (with phpMyAdmin?) Currently I have two different databases. After putting them together are there just one? Sorry, for its possibly a rather stupid question ...

Thanks!
Volker :)

marcnyc:
If you are installing Mambo for the first time in order to integrate it with SMF simply provide Mambo with the SMF database details during the Mambo installation. In other words instead of creating a new database (like the Mambo installation readme file suggests) don't create a new database and when Mambo asks you for the database details type in the details of the database you use for SMF and just leave the mos_ prefix for the tables that mambo will create inside it so you can distinguish the tables of Mambo from the ones of SMF.
If on the other hand you have already installed Mambo it's too late. The only solution is to burn your computer and jump out the window while screaming 'mambooooooooo!'... just kidding...
If you have already installed Mambo and now have two databases, either start from the top and do like I said or use the EXPORT tab section of phpMyAdmin to export all the tables of the mambo database and then import it inside the SMF database (using the SQL tab of phpMyAdmin). Then go to your Mambo administration and change the database details so it connects to the new database (the one where the SMF tables are). After that you can delete the old mambo-only database.

kahuna:
OK, thank you! I think I get the point. It's not possible to start from the scratch with mambo, but with smf. So what is the best location for a smf installation? In a subdirectory or outside of mambo? Currently it's outside of mambo, but I can change if necessary. Just if it's a possible problem for exporting the mambo-tables to the smf-tables. Or doesn't this matter?

best wishes!
Volker :)

marcnyc:
As far as I know you have to install SMF first and MAMBO after SMF so if both are already installed do NOT reinstall SMF, just do what I said.

Navigation

[0] Message Index

[#] Next page