Jump to content
xisto Community
Sign in to follow this  
MaineFishing45

Ipb 2.0.x Serious Sql Help Immediate Help Please

Recommended Posts

Ok I have some serious issue, all of a sudden the traffic jumped on my board, and the shoutobox dissappered and people were giving me these errors and stuff, so I found this message

mySQL query error: INSERT INTO trap17_ipbcache_store (cs_array,cs_key,cs_value) VALUES(1,'settings','a:283:{s:7:"gl_show";s:1:"1";s:7:"gl_link";s:0:"";s:8:"gl_title";s:16:"Board Guidelines";s:13:"board_offline";s:1:"1";s:18:"show_bday_calendar";s:1:"1";s:14:"show_birthdays";s:1:"1";s:13:"autohide_bday";s:1:"0";s:13:"show_calendar";s:1:"1";s:17:"autohide_calendar";s:1:"0";s:14:"calendar_limit";s:2:"15";s:10:"start_year";s:4:"2006";s:10:"year_limit";s:1:"5";s:21:"converge_login_method";s:8:"username";s:13:"cookie_domain";s:0:"";s:9:"cookie_id";s:0:"";s:11:"cookie_path";s:0:"";s:9:"use_coppa";s:1:"0";s:9:"coppa_fax";s:0:"";s:13:"coppa_address";s:0:"";s:20:"custom_profile_topic";s:1:"1";s:14:"cache_calendar";s:1:"1";s:9:"au_cutoff";s:2:"15";s:20:"db_topic_read_cutoff";s:1:"7";s:16:"show_user_posted";s:1:"1";s:11:"no_au_forum";s:1:"0";s:11:"no_au_topic";s:1:"0";s:11:"show_active";s:1:"1";s:12:"allow_search";s:1:"1";s:11:"show_totals";s:1:"1";s:10:"load_limit";s:0:"";s:15:"min_search_word";s:1:"4";s:7:"nocache";s:1:"1";s:15:"search_post_cut";s:0:"";s:16:"short_forum_jump";s:1:"0";s:11:"time_offset";s:2:"-5";s:11:"time_adjust";s:1:"0";s:11:"clock_short";s:14:"jS F Y - h:i A";s:12:"clock_joined";s:5:"j-F y";s:10:"clock_long";s:12:"M j Y, h:i A";s:17:"time_use_relative";s:1:"1";s:24:"time_use_relative_format";s:11:"{--}, h:i A";s:8:"email_in";s:31:"webmaster@freemansca.trap17.com";s:9:"email_out";s:31:"webmaster@freemansca.trap17.com";s:11:"mail_method";s:4:"mail";s:9:"smtp_host";s:9:"localhost";s:9:"smtp_port";s:2:"25";s:18:"mail_wrap_brackets";s:1:"0";s:9:"smtp_user";s:0:"";s:9:"smtp_pass";s:0:"";s:17:"search_sql_method";s:5:"ftext";s:21:"search_default_method";s:6:"simple";s:10:"board_name";s:22:"Freeman Bulletin Board";s:9:"home_name";s:33:"Douglas S. Freeman Bulletin Board";s:8:"home_url";s:6:"/board";s:10:"upload_url";s:46:"http://forums.xisto.com/no_longer_exists/ currently required--";s:13:"chat04_who_on";s:1:"1";s:24:"chat04_hide_whoschatting";s:1:"1";s:15:"chat04_who_save";s:1:"2";s:12:"chat04_width";s:3:"600";s:13:"chat04_height";s:3:"350";s:14:"chat04_display";s:4:"self";s:13:"chat04_poppad";s:2:"50";s:20:"chat04_access_groups";s:0:"";s:15:"chat_account_no";s:0:"";s:16:"chat_server_addr";s:0:"";s:11:"chat_who_on";s:1:"1";s:22:"chat_hide_whoschatting";s:1:"1";s:17:"chat_refresh_list";s:2:"15";s:13:"chat_pass_md5";s:0:"";s:17:"chat_pass_md5_new";s:0:"";s:10:"chat_width";s:3:"600";s:11:"chat_height";s:3:"350";s:12:"chat_display";s:4:"self";s:11:"chat_poppad";s:2:"50";s:13:"chat_language";s:2:"en";s:18:"chat_access_groups";s:0:"";s:17:"chat_admin_groups";s:0:"";s:15:"ipb_copy_number";s:0:"";s:15:"ips_cp_purchase";s:1:"0";s:8:"csite_on";s:1:"1";s:14:"ipb_reg_number";s:0:"";s:12:"ipb_reg_show";s:1:"0";s:12:"ipb_reg_name";s:0:"";s:13:"news_forum_id";s:1:"2";s:15:"index_news_link";s:1:"1";s:14:"msg_allow_code";s:1:"1";s:14:"msg_allow_html";s:1:"0";s:17:"show_max_msg_list";s:2:"15";s:12:"spider_sense";s:1:"1";s:12:"spider_visit";s:1:"1";s:12:"spider_group";s:1:"2";s:11:"spider_suit";s:1:"2";s:13:"spider_active";s:1:"1";s:11:"spider_anon";s:1:"0";s:18:"search_engine_bots";s:128:"googlebot=Google.comslurp@inktomi=Hot Botask jeeves=Ask Jeeveslycos=Lycos.comwhatuseek=What You Seekia_archiver=Archive.org";s:12:"bot_antispam";s:3:"gif";s:17:"allow_dynamic_img";s:1:"0";s:17:"xforward_matching";s:1:"0";s:18:"session_expiration";s:4:"3600";s:13:"match_browser";s:1:"1";s:13:"use_mail_form";s:1:"1";s:12:"allow_images";s:1:"1";s:11:"allow_flash";s:1:"1";s:13:"reg_auth_type";s:4:"user";s:18:"validate_day_prune";s:1:"7";s:14:"new_reg_notify";s:1:"1";s:11:"force_login";s:1:"0";s:6:"no_reg";s:1:"0";s:15:"strip_space_chr";s:1:"0";s:18:"disable_reportpost";s:1:"0";s:17:"reportpost_method";s:2:"pm";s:13:"flood_control";s:2:"15";s:17:"allow_online_list";s:1:"1";s:18:"disable_admin_anon";s:1:"0";s:17:"disable_online_ip";s:1:"0";s:14:"subsm_show_reg";s:1:"0";s:13:"subsm_enforce";s:1:"0";s:17:"subsm_nopkg_group";s:1:"1";s:18:"display_max_topics";s:2:"30";s:14:"etfilter_punct";s:1:"0";s:14:"etfilter_shout";s:1:"0";s:9:"hot_topic";s:2:"10";s:10:"pre_pinned";s:8:"Pinned: ";s:9:"pre_moved";s:7:"Moved: ";s:9:"pre_polls";s:6:"Poll: ";s:17:"display_max_posts";s:2:"20";s:17:"threaded_per_page";s:3:"100";s:17:"topicmode_default";s:6:"linear";s:17:"post_order_column";s:3:"pid";s:15:"post_order_sort";s:3:"asc";s:8:"max_emos";s:2:"10";s:10:"max_images";s:2:"10";s:15:"max_post_length";s:3:"100";s:11:"max_w_flash";s:3:"199";s:11:"max_h_flash";s:3:"199";s:13:"post_wordwrap";s:2:"80";s:11:"emo_per_row";s:1:"3";s:12:"strip_quotes";s:1:"1";s:7:"img_ext";s:20:"gif,jpeg,jpg,png,bmp";s:15:"show_img_upload";s:1:"1";s:9:"siu_thumb";s:1:"1";s:9:"siu_width";s:3:"100";s:10:"siu_height";s:3:"100";s:14:"guest_name_pre";s:6:"Guest_";s:14:"guest_name_suf";s:2:"_*";s:9:"poll_tags";s:1:"1";s:16:"max_poll_choices";s:2:"20";s:17:"allow_result_view";s:1:"1";s:18:"allow_creator_vote";s:1:"1";s:16:"startpoll_cutoff";s:2:"24";s:20:"poll_disable_noreply";s:1:"0";s:22:"forum_trash_can_enable";s:1:"1";s:18:"forum_trash_can_id";s:2:"17";s:26:"forum_trash_can_use_radmin";s:1:"1";s:25:"forum_trash_can_use_admin";s:1:"1";s:24:"forum_trash_can_use_smod";s:1:"1";s:23:"forum_trash_can_use_mod";s:1:"1";s:11:"allow_skins";s:1:"1";s:16:"post_titlechange";s:3:"500";s:19:"max_location_length";s:4:"1000";s:19:"max_interest_length";s:4:"1000";s:14:"max_sig_length";s:5:"10000";s:14:"sig_allow_html";s:1:"0";s:13:"sig_allow_ibc";s:1:"1";s:17:"postpage_contents";s:22:"5,10,15,20,25,30,35,40";s:18:"topicpage_contents";s:22:"5,10,15,20,25,30,35,40";s:14:"subs_autoprune";s:1:"0";s:20:"autoforum_sub_groups";s:0:"";s:10:"avatars_on";s:1:"1";s:10:"avatar_ext";s:16:"gif,jpg,jpeg,png";s:10:"avatar_url";s:1:"1";s:13:"avup_size_max";s:2:"50";s:11:"avatar_dims";s:5:"90x90";s:10:"avatar_def";s:5:"80x80";s:11:"av_gal_cols";s:1:"5";s:9:"photo_ext";s:20:"gif,jpg,jpeg,png,bmp";s:15:"disable_ipbsize";s:1:"0";s:10:"guests_sig";s:1:"1";s:10:"guests_img";s:1:"1";s:10:"guests_ava";s:1:"1";s:7:"warn_on";s:1:"1";s:8:"warn_min";s:1:"0";s:8:"warn_max";s:2:"15";s:14:"warn_protected";s:1:"4";s:13:"warn_show_own";s:1:"1";s:13:"warn_past_max";s:1:"1";s:16:"warn_show_rating";s:1:"0";s:12:"warn_mod_ban";s:1:"1";s:13:"warn_mod_modq";s:1:"1";s:13:"warn_mod_post";s:1:"1";s:12:"warn_mod_day";s:1:"3";s:13:"warn_gmod_ban";s:1:"1";s:14:"warn_gmod_modq";s:1:"1";s:14:"warn_gmod_post";s:1:"1";s:13:"warn_gmod_day";s:1:"3";s:13:"d2sbox_online";s:1:"1";s:13:"d2sbox_sbname";s:16:"Freeman Shoutbox";s:15:"d2sbox_shoutspp";s:2:"10";s:12:"d2sbox_flood";s:1:"5";s:20:"d2sbox_flood_seconds";s:2:"10";s:15:"d2sbox_wordwrap";s:1:"0";s:16:"d2sbox_defaultsb";s:1:"0";s:16:"d2sbox_sbdisplay";s:1:"L";s:20:"d2sbox_default_color";s:4:"Skin";s:16:"d2sbox_cimg_side";s:5:"right";s:21:"d2sbox_allow_sbiframe";s:1:"1";s:20:"d2sbox_allow_sbpopup";s:1:"1";s:18:"d2sbox_allow_float";s:1:"1";s:14:"d2sbox_iframew";s:2:"85";s:14:"d2sbox_iframeh";s:3:"340";s:14:"d2sbox_refresh";s:2:"90";s:20:"d2sbox_iframe_paging";s:1:"1";s:17:"d2sbox_showglobal";s:1:"1";s:17:"d2sbox_globaltype";s:1:"0";s:20:"d2sbox_global_sbtype";s:3:"new";s:12:"d2sbox_gsnum";s:1:"5";s:25:"d2sbox_gsb_smilies_button";s:1:"1";s:24:"d2sbox_gsb_bbcode_button";s:1:"1";s:23:"d2sbox_gsb_clear_button";s:1:"1";s:25:"d2sbox_gsb_refresh_button";s:1:"1";s:15:"d2sbox_gseffect";s:1:"0";s:23:"d2sbox_fadescroll_speed";s:1:"3";s:19:"d2sbox_marqueespeed";s:1:"5";s:18:"d2sbox_marqueeslow";s:1:"1";s:25:"d2sbox_normalscroll_speed";s:1:"2";s:23:"d2sbox_transcroll_speed";s:1:"3";s:21:"d2sbox_marqueebuttons";s:1:"1";s:20:"d2sbox_global_iframe";s:1:"1";s:21:"d2sbox_giframe_height";s:2:"90";s:22:"d2sbox_giframe_refresh";s:2:"90";s:16:"d2sbox_gsb_shout";s:1:"1";s:17:"d2sbox_global_rlb";s:1:"1";s:18:"d2sbox_global_time";s:1:"1";s:22:"d2sbox_globaltime_type";s:5:"GSBOX";s:24:"d2sbox_globaltime_format";s:11:"n/j/y g:i a";s:20:"d2sbox_allow_preview";s:1:"1";s:19:"d2sbox_smiliestable";s:1:"1";s:19:"d2sbox_allowsmilies";s:1:"1";s:19:"d2sbox_allowbbcodes";s:1:"1";s:16:"d2sbox_allowhtml";s:1:"0";s:20:"d2sbox_allowshoutspp";s:1:"1";s:19:"d2sbox_smilie_limit";s:1:"0";s:23:"d2sbox_max_shout_length";s:1:"0";s:14:"d2sbox_showava";s:1:"1";s:18:"d2sbox_avatar_dims";s:5:"80x80";s:20:"d2sbox_noavatar_name";s:11:"~NO AVATAR~";s:16:"d2sbox_showstime";s:1:"1";s:22:"d2sbox_disablerelative";s:1:"1";s:17:"d2sbox_timemethod";s:4:"SBOX";s:17:"d2sbox_sboxformat";s:17:"D. M. dS, Y h:i A";s:22:"d2sbox_minimum_refresh";s:2:"15";s:22:"d2sbox_maximum_refresh";s:4:"1000";s:19:"d2sbox_showannounce";s:1:"0";s:19:"d2sbox_announcement";s:170:"Please watch the Flood Control, and the Daily Shoutlimit.  I will try to correct these ASAP.  So refer to posting and don\\'t make stupid shouts.  And WATCH YOUR LANGUAGE.";s:16:"d2sbox_showrules";s:1:"1";s:17:"d2sbox_sbox_rules";s:538:"<b><u><center>Shoutbox Rules!</center></u></b><br />Below are listed the main rules of the Shoutbox.  We cant list out every minor detail because it would take forever!<br /><ul><br /><li>Be kind to others using the Shoutbox<br /><li>Do <u>NOT</u> use inappropriate language<br /><li>Respect everyone and treat the forums with care for since it took a good amount of time to create<br /><li>Be active and have fun!<br /></ul><br />Those are just the main features.<br />Remember to abide by these so you dont get banned!";s:13:"d2sbox_showou";s:1:"1";s:17:"d2sbox_autodelete";s:1:"1";s:13:"d2sbox_addays";s:1:"1";s:17:"d2sbox_statstoday";s:1:"5";s:19:"d2sbox_statsoverall";s:2:"10";s:15:"d2sbox_shout_pt";s:1:"1";s:21:"d2sbox_shout_pt_forum";s:2:"17";s:22:"d2sbox_shout_pt_method";s:1:"2";s:23:"d2sbox_shout_pt_effects";s:1:"2";s:25:"d2sbox_shout_pt_increment";s:1:"0";s:20:"d2sbox_shout_pt_sigs";s:1:"0";}')mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 't make stupid shouts.  And WATCH YOUR LANGUAGE.";s:16:"d2sbox_smySQL error code: Date: Thursday 09th of March 2006 03:31:57 PM

I know is a SQL Error, but can anyone help me to figure out what to do?
Sorry for the wacky scrolling over, but what else can you do? This might help you.

1) People reported that there skins went away, and then the shoutbox disappered
2) After that I tried to take it offline and it gave me that error
3) Same as above but tried to take the board offline
4) Left a message on the top exlaning some things, and then I left it alone
5) This happended all in like 5mins

My site is... [link removed for protection of site]

----
Update
----

IPB WARNING [2] Division by zero (Line: 1621 of /sources/functions.php)

Edited by MaineFishing45 (see edit history)

Share this post


Link to post
Share on other sites

Ok BuffaloHelp... I do not have Version 2.0.2 TRAIL. I want to make that clear, and I don't mean to get annoyed, but your pushing my limits. Its Version 2.0.0 Trail Unlimited just before they closed down, please see my PM and other link! Thanks. :( Please have OpaQue, foward the message I sent him down your way. I think it will make more sense to you than to him, so alert him soon, because I'm not in the mood to send out more. But thanks.

Edited by MaineFishing45 (see edit history)

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.