vb.org Archive - After uninstall Panjo, can't connect to database

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - After uninstall Panjo, can't connect to database (https://vborg.vbsupport.ru/showthread.php?t=315643)

gnrx	11-26-2014 04:01 PM

After uninstall Panjo, can't connect to database

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:

Code:

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

Error Number  : 1054

I'm pretty scared...

Thank you!

kh99	11-26-2014 04:12 PM

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

11-26-2014 04:48 PM

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

gnrx	11-26-2014 04:58 PM

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

11-26-2014 05:05 PM

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	11-26-2014 05:45 PM

Quote:

Originally Posted by ForceHSS (Post 2524263)

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	11-26-2014 06:28 PM

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

11-26-2014 06:54 PM

1 Attachment(s)

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

11-26-2014 07:21 PM

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

11-26-2014 07:50 PM

the reason the error comes it is the xml in 4.2.3

All times are GMT. The time now is 02:45 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01051 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: