Droplets error: Unknown column 'admin_view' in 'field list'

[macsmet]

Hi there all,

I had some trouble with Droplets (WB 2.. Tried to make one, couldn't save and all of a sudden didn't have access to Droplets anymore. I de-installed the Droplets module. Downloaded version 1.02 from AMASP and reinstalled it.
Now I get the error described in the title.
I know there is a upgrade script but how do I call it? You can't do this from your browser.
Do I have to use PHPMyAdmin? And what do I do then?

Any help is appreciated!

Greetings,

MacSmet

[macsmet]

Anyone? please, please, please!!!

[pcwacht]

Make a code section,
in it try:

Code:

$table = TABLE_PREFIX .'mod_droplets';
$info = $database->query("SELECT * from `$table` limit 0,1" );
$fields = $info->fetchRow();
if (!array_key_exists("admin_edit", $fields)) {
    /**
     *    Call from the upgrade-script
     */
   
    if (function_exists('db_add_field')) {
        db_add_field("admin_edit", 'mod_droplets', "INT NOT NULL default '0'");
        db_add_field("admin_view", 'mod_droplets', "INT NOT NULL default '0'");
        db_add_field("show_wysiwyg", 'mod_droplets', "INT NOT NULL default '0'");
    } else {
        /**
         * Not call by the upgrade-script
         */
        $database->query("ALTER TABLE `$table` (
            `admin_edit` INT NOT NULL default '0',
            `admin_view` INT NOT NULL default '0',
            `show_wysiwyg` INT NOT NULL default '0'
            )");
    }
}

Have fun,
John

[macsmet]

@ John:

Thanks for your suggestion, but no luck!
Any other idea's?

greetings,

MacSmet

[aldus]

I know there is a upgrade script but how do I call it? You can't do this from your browser.

You can use the "advanced" options in "add-ons" -> "modules" ... and select "droplets" and
use "install" or "upgrade" ...

Regards
Aldus

[macsmet]

@Aldus: Thanks, I already tried the 'upgrade' in this way but that didn't work.
Now first I did the 'instal'l and then the 'upgrade' (to be sure) and now everything is fine again.
Thanks a lot!!

greetings,

MacSmet