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:

$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]

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

define('DISABLE_HOOKS', true);To enable plugins again just comment out the line
//define('DISABLE_HOOKS', true);Use notepad++ (http://notepad-plus-plus.org/download/v6.6.8.html) 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

[gnrx]

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).

Really, I thank you very much your attention and help.
During this time, I try some that you indicate but I can't solved the issue, but, your attention and help...really, thank you very much!!

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

define('DISABLE_HOOKS', true);To enable plugins again just comment out the line
//define('DISABLE_HOOKS', true);Use notepad++ (http://notepad-plus-plus.org/download/v6.6.8.html) 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
Well, I don't was think in this possible solution, thank you.
I disabled all pluggins with line in config.php, after this moment, I can access fine to my site.
I install de php file in my FTP, and after, in admincp, I import the xml.
Now appears Panjo product in Products and Pluugins - Products, but in the options of admincp not appears Panjo for configure (and Panjo is enabled) but not appears in the options of admincp.

When you indicate:
"to remove panjo fully uninstall the xml first, then the php file"
If I uninstall the xml, is when I have the problem with Database.

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

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.
Ok, thanks.

the reason the error comes it is the xml in 4.2.3

I forgot indicate, but I use 4.2.2 PL2.

To all, really, thanks.

[ForceHSS]

Really, I thank you very much, your attention and help.
During this time, I try some that you indicate but I can't solve the issue, but, your attention and help... Really, thank you very much!!


Well, I am not thinking in this possible solution, thank you.
I disabled all plugins with a line in config.php, after this moment, I can access fine to my site.
I install the php file in my FTP, and after, in admincp, I import the xml.
Now appears Panjo product in Products and Plugins - Products, but in the options of admincp not appears Panjo to configure (and Panjo is enabled) but not appears in the options of admincp.

When you indicate:
"To remove panjo fully uninstall the xml first, then the php file"
If I uninstall the xml, is when I have the problem with Database.

.
If you don't want to remove it, then why did you do it in the first place. I only said to do that because it is what I thought you wanted if you don't, then don't remove it and with plugins disabled via config you should not have any errors but up to you

[ozzy47]

Also as explained above, don't try and remove Panjo, if you do not want to use it, simply disable it.

This is because any time you upgrade, it will be re installed.

[gnrx]

If you don't want to remove it, then why did you do it in the first place. I only said to do that because it is what I thought you wanted if you don't, then don't remove it and with plugins disabled via config you should not have any errors but up to you

Also as explained above, don't try and remove Panjo, if you do not want to use it, simply disable it.

This is because any time you upgrade, it will be re installed.

My first option is I want remove it, but aftert I continue, sorry for my english, its possible not I'm explained very well.
Yes, I was want remove it, and try to remove it and for this reasson after, I was a problem with Database.

After read all yours posts I understand that, in any time I upgrade the forum, it will be re install, for this reasson and only, when I read this explanation, I understand that, although remove it today, its possible that tomorrow, in the first upgrade, also I have installed a Panjo.

And also, when I view that, with Panjo re installed in mode disabled my forum works again, I took afraid to try again to uninstall it because I was getting many alerts user that does not work.

But I continue want remove it complete, not only disabled, I want view if I can, without any issue, remove it complete with any issue.

Viewing that, with disable mods in config.php not problem for the site, I try again to uninstall like indicate above.

Again, sorry if I'm not explained very well.

[ForceHSS]

Not sure what you are saying but remove the line from the config or put // in front of it and disable just panjo plugin and when you update from now on it will stay disabled and should cause you no more problems. If you are still having a error with it pm me will fix it for you

[gnrx]

Sorry, my english is not very good :o
Yes, put // in front of it, and disable just panjo plugin, now, not have problems (in the forum with database).
Now I go to sleep, in my country are 02:45 am and tomorrow at 08:00 alarm for go to work.
If you want, tomorrow notice to you and if necessary, pm to you.

Again, really, thank you very much for attention and help!

[ForceHSS]

Yes pm me when you are back from work I will be happy to help

[gnrx]

ForceHSS, don't contact with you because I can solved my issue, first, disable the forum for users, then, I try to uninstall product Panjo, the uninstallation was complete and all ok.

I made this a few hours ago, I try 2 or 3 times, and every time, all ok.

Again, thank you very much for your attention and help!

[ozzy47]

Glad to hear you were able to get it sorted. Thanks for reporting back. :)

[gnrx]

Thanks at you/yours :)