View Single Post
  #2  
Old 11-26-2014, 04:12 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01080 seconds
  • Memory Usage 1,792KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete