Support Forum

I just had a look through the files for the pm plugin.

There is something missing (from what I can tell)

In the sp-pm-plugin.php file, there is the following:

define('SPPMBUDDIES',        SF_PREFIX.'sfbuddies');

Then in sp-pm-install.php, unlike all of the other defined tables, there is no:

CREATE TABLE IF NOT EXISTS ".SPPMBUDDIES."

That CREATE TABLE IF NOT EXISTS, is there for every other table but not that one.

In the sp-pm-upgrade.php that instruction does exist.

            CREATE TABLE IF NOT EXISTS ".SPPMBUDDIES." (
                id bigint(20) NOT NULL auto_increment,
                user_id bigint(20) NOT NULL,
                buddy_id bigint(20) NOT NULL,
                PRIMARY KEY  (id),
                KEY user_idx (user_id),
                KEY buddy_idx (buddy_id)
            ) ENGINE=MyISAM ".spdb_charset().";";

But it sure is not in the install.php file.

I'm not real good at coding, so I am not going to attempt to code in what should be there. If you could tell me what to place in the code, or provide a corrected sp-pm-install.php file, I will sure be happy to start over with it..

Thanks

Thanks Yellow Swordfish,

Much appreciated. I hope I am correct in what I think I was seeing there..

I copied from the upgrade file the script to create the table.

        # need new table for buddies
        $sql = "
            CREATE TABLE IF NOT EXISTS ".SPPMBUDDIES." (
                id bigint(20) NOT NULL auto_increment,
                user_id bigint(20) NOT NULL,
                buddy_id bigint(20) NOT NULL,
                PRIMARY KEY  (id),
                KEY user_idx (user_id),
                KEY buddy_idx (buddy_id)
            ) ENGINE=MyISAM ".spdb_charset().";";
        spdb_query($sql);       

And placed it at line 73.

Then I copied and pasted the following

        if (!in_array(SPPMBUDDIES, $tables)) $tables[] = SPPMBUDDIES;

at the new line 216 right under

        if (!in_array(SPPMADVERSARIES, $tables)) $tables[] = SPPMADVERSARIES;

Then I uninstalled the plugin and activated it again. The table is created now. However, sfbuddies and sfadversaries tables have no rows.

I went to the frontend and attempted to add buddies, and noting it happening. The script says that the buddies have been saved, but none show up in either the send PM or the Manage Buddies.

I went back to the db and looked in the table, and there are still no rows in sfbuddies.

I thought maybe the rows might be created upon first use, but that didn't happen.

I am not quite sure where to look to make the rows created, and to update so that the buddies are actually saved to the database.

Thanks,