vb.org Archive - View Single Post - Mini Mods

yoyoyoyo · #27 09-19-2007, 01:09 PM

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE `whatismyip` SET `enabled`='1', `ipinfo`='' WHERE `id`='1';

MySQL Error : Unknown column 'enabled' in 'field list'
Error Number : 1054
Date : Wednesday, September 19th 2007 @ 08:53:01 AM
Script : http://mysite.com/forum/admincpx/whatismyip.php?do=update
Referrer : http://mysite.com/forum/admincpx/whatismyip.php
IP Address : XX.XX.XXX.XXX
Username : Administrator
Classname : vb_database

I tried running the install.php, hoping that would take care of this, but I received this error:

Quote:

Database error in vBulletin 3.6.8:

Quote:

Invalid SQL:
CREATE TABLE `whatismyip` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`ebabled` INT NOT NULL ,
`ipinfo` LONGTEXT NOT NULL
);;

MySQL Error : Table 'whatismyip' already exists
Error Number : 1050
Date : Wednesday, September 19th 2007 @ 08:56:28 AM
Script : http://mysite.com/forum/ipinstall.php
Referrer :
IP Address : XX.XX.XXX.XXX
Username : Administrator
Classname : vb_database

I went to my ACP and ran the SQL query: DROP TABLE `whatismyip` and tried to run the install script again and received this error:

Quote:

MySQL Error : Unknown column 'enabled' in 'field list'
Error Number : 1054
Date : Wednesday, September 19th 2007 @ 09:01:44 AM
Script : http://mysite.com/forum/ipinstall.php
Referrer :
IP Address : XX.XX.XXX.XXX
Username : Administrator
Classname : vb_database

BTW - IMO, if you are going to let people rely on an installer script, I suggest having an "uninstall" option as well.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01260 seconds Memory Usage 1,766KB 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 (4)bbcode_quote (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
Messages: