Getting errors after SMF plugin integration

Hi, I unzipped the plugin I purchased along with Amember. I uploaded via FTP as instructed to the right area. After I add the plugin in my Amember control panel and activate it, it wants to know 'SMF board db and prefix'

I entered my forum board database name here and that gives me the error
SMF board db and prefix - incorrect value. Error: Table 'amember.forummembers' doesn't exist
Then I tried forum.smf and I get this error...
SMF board db and prefix - incorrect value. Error: SELECT command denied to user 'member'@'localhost' for table 'smfmembers'

I guess I just don't get it... What should be going here? Thanks a lot!

Hi!

Is the database name amember having the table prefix forummembers without an underscore for the configuration amember.forummembers or forum having the name of the table smf for the configuration forum.smf?

Following happens above:

amember.forummembers

- The name of the database is here mentioned amember.
- All the tables are having a prefix forummembers WITHOUT AN UNDERSCORE. This means they would look like this in the database:

forummembersThreads
forummembersPosts
forummembersAdmins
forummembersCategory
forummembersConfiguration
... etc...

PLease see that:

1. You enter EXACTLY the name of the database
2. The name of the database MUST follow a Period
3. Enter the plugin table prefix. Take care if the prefix ends with an underscore.

Hence it will looke like the following:

databasename.tableprefix_

in the field where you are trying to fill in, known as Db and Tablename.

If you do not have any prefix to the tables in that plugin database, then it must look like the following:

databasename.

Here, the database name ends only with a period.

If there is a mistake in this configuration, then the plugins cannot make any connections to the database and will give the above error.

For plugins having external database configuration, residing on the same or a different server, one also has to fill in the password for the access to that plugin database.

Let us know if you could make a connection to the plugin database.

Hi....

I have 2 databases created. 1 was made to install the forum board. I called that database "forum" The other one I created to install Amember. That one is called "amember" both without quotes obviously.


If I am in Plesk and I go into my db webadmin, the forum database has smf prefix... like this... smf_attachments smf_ban_groups s mf_ban_items etc... The amember prefix is like this... amember_access_log amember_admins etc...

So, either way, for the SMF board db and prefix area I've tried what you said above. When I put forum.smf_ I get this...
"SMF board db and prefix - incorrect value. Error: SELECT command denied to user 'member'@'localhost' for table 'smf_members'"
When I put forum. (with period after) I get this... "SMF board db and prefix - incorrect value. Error: SELECT command denied to user 'member'@'localhost' for table 'members'"

I tried it with amember. and amember.smf_ too just to see if I was using the wrong database, and those give me errors as well. The site is working perfectly until I turn on the SMF plugin. Then I get some errors on pages because I haven't configured the SMF like we're trying to do I guess.

Hopefully this info will help, let me know... Thanks a lot...

Hi!

Then anything other than forum.smf_ would not yield any better results.

What surprises me is that you do not have an access to the SELECT command. Very strange... Did you try to run a select command on the mysql monitor? May be I am asking too much... Uh, well

This tells me that the [db] is not passed on in the function of the plugin. That means that the forum. is not recognised at all. Well, then you need to send a support ticket to Alex. May be there is some plugin design changes that needs to meet your situation.

Okay, I just submitted a ticket... You're right, I have no idea what running a select commad on the mysql monitor is. Not even sure where that is located or how to run it.

I do know this... The forum board does work properly, and I called the database that takes care of the forum board "forum" Just can't get it to config with aMember. I'm sure we'll get it done though!

Thanks...

I have same Problem

I have the same Problem with the PhpFox Plugin. I have 2 seperate databases 1 for PhpFox 1 for amember. in Plesk you cant make 1 user access mutiple database it will say user already exist when you try to add. But for plugin user must access 2 databases amember and Phpfox. I am researching how to SSh to mysql to see if I can grant access that way.

any other solution is welcome.

Hi!

May be you are right.

There was someone here who had problems in the joomla database integration. This got sorted out when the function in the plugin was changed where it connects through an Array.

It was working for most condition except to that of a particular software interface like Plesk.

I however find it difficult to understand why should a database be created without any access, not even SELECT? Uh!

This was the reasn why I said to open a ticket thinking that a change in the function would be required that was similar to the earlier nature of the problem.

If you want to find it out EXACTLY if it is in the plugin, which I suspect it is, or in the mysql GRANT ACCESS then you may imply interchange the databases and try to make it work on the database where you know you have an Access.

For thi, simply export each database and import into the other. Thereafter change the config.inc.php the database information and in the respective plugins.

If you have no access in the second database (which was a forum database) where the new aMember connects to, then you can be sure that aMember Main script will not work and crash!

Regardless of aMember or Forum, if you have no access to the second database, then no other installation of any other script i.e. programm will be possible. Without the SELECT ACCESS GRANT PRIVILEGE, nothing will work.

Now tht drives me to a very fundamental and logical question:

If there was no privilege to access the database, then how did the database tables get created. Since each and every well designed script checks an access to the database and if not then at leats does a check of DROP TABLE IF EXITS. IF there was no SELECT PRIVILEGE, then there is also no access to DROP PRIVILEGE.

It is therefore I suggested to review the plugin multiple database connection problem in Plesk, however I am not sure...

Further, there was a dramatic change after I suggested to enter a new variable [db] that gives a gigantic potential to make multiple server connections. This is now so beautifully implemented and works like charm...

But this also needs o be revised into all plugins and all environments.

Further, this new connection architecture within the plugin is working for multiple server connections. What I wonder is why such a function not shifted into the core. There are functions in the plugins that can actually belong to the plugin CORE. For instance the DB-Connection could be designed one and not repeated in all plugins.

This could be also a new problem...