After uninstall Panjo, can't connect to database

[gnrx]

Oh oh...I don't know if I made a some "stupid" process...
Panjo not works fine in my forum, for this reasson I try to uninstall Panjo for after, install again.
Well, I uninstall Panjo and now...my forum not works.
Forum send to me a email of error with connect to database, in all mails appears this line:

MySQL Error   : Unknown column 'user.panjo_selling' in 'field list'
Error Number  : 1054

I'm pretty scared...

Thank you!

[kh99]

Are you trying to make panjo work? Then you need to add that column to the user table. The only place I could find that adds that column in the vb upgrade script, so you could try running that again (I think it's OK to run it even if you are already at that version). Or you could add the fields yourself using phpMyAdmin.

Here's the php from the install scrip that aadds the panjo db fields:

PHP Code:

        $db_alter = new vB_Database_Alter_MySQL($this->db);

        if ($db_alter->fetch_table_info('user')) {
            $db_alter->add_field(array(
                'name' => 'panjo_selling',
                'type' => 'BOOLEAN',
                'null' => true
            ));
        }

        if ($db_alter->fetch_table_info('usergroup')) {
            $db_alter->add_field(array(
                array(
                    'name' => 'panjo_can_sell',
                    'type' => 'BOOLEAN',
                    'null' => false,
                    'default' => true
                ),
                array(
                    'name' => 'panjo_transaction_fee',
                    'type' => 'DECIMAL',
                    'length' => '10, 2',
                    'null' => true
                ),
                array(
                    'name' => 'panjo_listing_fee',
                    'type' => 'DECIMAL',
                    'length' => '10, 2',
                    'null' => true
                )
            ));
        }
    
        if ($db_alter->fetch_table_info('thread')) {
            $db_alter->add_field(array(
                array(
                    'name' => 'panjo_listing_id',
                    'type' => 'VARCHAR',
                    'length' => 255,
                    'null' => true
                )
            ));
        } 


If you're going to do it using phpMyAdmin you have to figure out the right parameters from the above. I'm sure someone here can do it if you need help with that.

[ForceHSS]

remove xml then remove the classifieds.php from your ftp if you dont you will have problems

[gnrx]

x kh99:
Thank you for your reply and help.
Yes I want Try to use Panjo, but I uninstall a Panjo Mod and I have this problem.
I can't access to vb and vb admin for run your code, I need run in phpmyadmin but I don't know how figure the parameters.

x ForceHSS:
I can remove the classifileds.php from my ftp but, the xml I can't access to vbadmin.

Again, thank you very much.

[ForceHSS]

how can you not remove the xml? Can you not login to the admincp?
replace the classifileds.php then remove the xml then delete the classifileds.php

[gnrx]

Originally Posted by ForceHSS

how can you not remove the xml? Can you not login to the admincp?

Correct, this is the problem.

Before post this thread, I was go to admincp, admin products and select Panjo for uninstall (I think that is equal to remove xml), in this moment, crash database, and then, I can not access to admincp (and the forum), appears "Database error".

Thank you very much!

[kh99]

If you're trying to get it to work, then I don't think you should be removing anything, but maybe there's something I don't know.

You can add a column to a table in phpMyAdmin by going to the 'Structure' tab for the user table (after clicking on the database name and the 'user' table name), then scroll down to the bottom and look for the "Add 1 Column(s)..." row and press the Go button.

On the next page, fill in panjo_selling for the name, 'BOOLEAN' for the type, and check the checkbox under 'null'. Then press "Save".

That should add the column that's giving you the error. You'll probably need to add the other columns to the usergroup and thread tables as well. Maybe you can figure out how to fill in the options for those those by looking at the code I posted above (if not I can try to help with those as well).

[ForceHSS]

Ok, I ran a few tests first do this
Disable plugins via config
To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


To enable plugins again just comment out the line

PHP Code:

//define('DISABLE_HOOKS', true); 


Use notepad++ to edit any files

After you have disabled plugins via your config. First install the php file into your FTP then overwrite the plugin with this one in your admincp. Once you have done that if you want to remove panjo fully uninstall the xml first, then the php file, then edit the config file and either remove the line you put in or comment it out with // as shown above

[Mark.B]

You should not uninstall Panjo, only disable it.
Next time you upgrade, the upgrade script will simply put it back.

The best fix to your issue, would be to upload the /install folder, run the upgrade script so that Panjo is back, and then disable it. Then you won't get the database errors.

[ForceHSS]

the reason the error comes it is the xml in 4.2.3