Welcome!
Welcome! ( Recent posts | Mark all | Login | Register )
» Quicksilver Forums » Project » Support » Field 'settings_tos' doesn't ...

Field 'settings_tos' doesn't have a default value
< Newer Topic :: Older Topic > New Install and running into proble

Post is unread #1 Feb 15, 2010, 5:30 am   Last edited Feb 15, 2010, 5:33 am by Grafter
Go to the bottom of the page Go to the top of the page
This member is currently offline Grafter
Newbie Member Level
GroupMembers
Posts1
JoinedFeb 15, 2010
PM

Operating System: Windows XP SP3
Server Software:
Apache 2.2.14 (Win32)
PHP v5.3.1
Mysql v5.1.39-community using PHP MySQLi extensions

had the error BLOB-TEXT column 'group_perms' can't have a default value
in the mysql_data_tables.php file, changed:
text NOT NULL default ''
to
text NOT NULL

new error messages:
Code:
Quicksilver installer v1.4.2
Quicksilver Forums has exited with an error
Field 'settings_tos' doesn't have a default value 

Query Error [1364]:
This type of error is reported by MySQL. 

Query:
INSERT INTO qsf_settings (settings_id, settings_data) VALUES (1, 'a:57:{s:14:"admin_incoming";s:4:"root";s:14:"admin_outgoing";s:4:"root";s:12:"attach_types";a:8:{i:0;s:3:"jpg";i:1;s:3:"gif";i:2;s:3:"png";i:3;s:3:"bmp";i:4;s:3:"zip";i:5;s:3:"tgz";i:6;s:2:"gz";i:7;s:3:"rar";}s:18:"attach_upload_size";i:25600;s:13:"avatar_height";i:75;s:18:"avatar_upload_size";i:51200;s:12:"avatar_width";i:75;s:10:"banned_ips";a:0:{}s:17:"clickable_per_row";i:5;s:6:"closed";i:0;s:10:"closedtext";s:86:"We are upgrading to the latest version of Quicksilver Forums. Please check back later.";s:11:"cookie_path";s:1:"/";s:13:"cookie_prefix";s:4:"qsf_";s:13:"cookie_domain";s:0:"";s:13:"cookie_secure";i:0;s:15:"emailactivation";i:1;s:9:"flash_avs";i:1;s:10:"flood_time";i:30;s:10:"forum_name";s:18:"Quicksilver Forums";s:9:"hot_limit";i:20;s:12:"loc_of_board";s:0:"";s:11:"last_member";s:0:"";s:14:"last_member_id";i:0;s:11:"link_target";s:6:"_blank";s:9:"logintime";i:31536000;s:10:"mailserver";s:9:"****";s:8:"max_load";i:0;s:10:"mostonline";i:0;s:14:"mostonlinetime";i:0;s:13:"output_buffer";i:1;s:5:"posts";i:0;s:14:"posts_per_page";i:15;s:14:"register_image";i:0;s:10:"servertime";i:151;s:6:"topics";i:0;s:15:"topics_per_page";i:20;s:18:"vote_after_results";i:0;s:12:"default_skin";s:7:"default";s:19:"default_email_shown";i:0;s:12:"default_lang";s:2:"en";s:13:"default_group";i:2;s:16:"default_timezone";i:151;s:10:"default_pm";i:1;s:20:"default_view_avatars";i:1;s:17:"default_view_sigs";i:1;s:18:"default_view_emots";i:1;s:13:"flood_time_pm";i:30;s:17:"flood_time_search";i:10;s:7:"members";i:0;s:13:"spider_active";i:1;s:11:"spider_name";a:16:{s:9:"googlebot";s:6:"Google";s:5:"lycos";s:6:"Google";s:10:"ask jeeves";s:6:"Google";s:7:"scooter";s:9:"Altavista";s:15:"fast-webcrawler";s:9:"AlltheWeb";s:13:"slurp@inktomi";s:7:"Inktomi";s:11:"turnitinbot";s:12:"Turnitin.com";s:7:"gigabot";s:7:"Gigabot";s:5:"yahoo";s:12:"Yahoo! Slurp";s:6:"msnbot";s:10:"MSN Search";s:20:"mediapartners-google";s:7:"AdSense";s:8:"naverbot";s:5:"Naver";s:6:"jetbot";s:6:"JetEye";s:5:"alexa";s:5:"Alexa";s:15:"ArchitextSpider";s:10:"Excite-Bot";s:9:"pipeLiner";s:15:"PipeLine Spider";}s:10:"debug_mode";i:0;s:14:"rss_feed_title";s:0:"";s:13:"rss_feed_desc";s:0:"";s:14:"rss_feed_posts";i:5;s:13:"rss_feed_time";i:60;s:16:"optional_modules";a:11:{i:0;s:6:"active";i:1;s:2:"cp";i:2;s:5:"email";i:3;s:4:"help";i:4;s:7:"members";i:5;s:3:"mod";i:6;s:2:"pm";i:7;s:7:"profile";i:8;s:6:"search";i:9;s:6:"recent";i:10;s:7:"rssfeed";}}')

Backtrace:

File: C:\httpd\****\lib\mysql.php
Line: 123
Call: See above for details.

File: C:\httpd\****\install\index.php
Line: 36
Call: db_mysql->query('INSERT INTO %psettings (settings_id, settings_data) VALUES (1, 'a:57:{s:14:"admin_incoming";s:4:"root";s:14:"admin_outgoing";s:4:"root";s:12:"attach_types";a:8:{i:0;s:3:"jpg";i:1;s:3:"gif";i:2;s:3:"png";i:3;s:3:"bmp";i:4;s:3:"zip";i:5;s:3:"tgz";i:6;s:2:"gz";i:7;s:3:"rar";}s:18:"attach_upload_size";i:25600;s:13:"avatar_height";i:75;s:18:"avatar_upload_size";i:51200;s:12:"avatar_width";i:75;s:10:"banned_ips";a:0:{}s:17:"clickable_per_row";i:5;s:6:"closed";i:0;s:10:"closedtext";s:86:"We are upgrading to the latest version of Quicksilver Forums. Please check back later.";s:11:"cookie_path";s:1:"/";s:13:"cookie_prefix";s:4:"qsf_";s:13:"cookie_domain";s:0:"";s:13:"cookie_secure";i:0;s:15:"emailactivation";i:1;s:9:"flash_avs";i:1;s:10:"flood_time";i:30;s:10:"forum_name";s:18:"Quicksilver Forums";s:9:"hot_limit";i:20;s:12:"loc_of_board";s:0:"";s:11:"last_member";s:0:"";s:14:"last_member_id";i:0;s:11:"link_target";s:6:"_blank";s:9:"logintime";i:31536000;s:10:"mailserver";s:9:"****";s:8:"max_load";i:0;s:10:"mostonline";i:0;s:14:"mostonlinetime";i:0;s:13:"output_buffer";i:1;s:5:"posts";i:0;s:14:"posts_per_page";i:15;s:14:"register_image";i:0;s:10:"servertime";i:151;s:6:"topics";i:0;s:15:"topics_per_page";i:20;s:18:"vote_after_results";i:0;s:12:"default_skin";s:7:"default";s:19:"default_email_shown";i:0;s:12:"default_lang";s:2:"en";s:13:"default_group";i:2;s:16:"default_timezone";i:151;s:10:"default_pm";i:1;s:20:"default_view_avatars";i:1;s:17:"default_view_sigs";i:1;s:18:"default_view_emots";i:1;s:13:"flood_time_pm";i:30;s:17:"flood_time_search";i:10;s:7:"members";i:0;s:13:"spider_active";i:1;s:11:"spider_name";a:16:{s:9:"googlebot";s:6:"Google";s:5:"lycos";s:6:"Google";s:10:"ask jeeves";s:6:"Google";s:7:"scooter";s:9:"Altavista";s:15:"fast-webcrawler";s:9:"AlltheWeb";s:13:"slurp@inktomi";s:7:"Inktomi";s:11:"turnitinbot";s:12:"Turnitin.com";s:7:"gigabot";s:7:"Gigabot";s:5:"yahoo";s:12:"Yahoo! Slurp";s:6:"msnbot";s:10:"MSN Search";s:20:"mediapartners-google";s:7:"AdSense";s:8:"naverbot";s:5:"Naver";s:6:"jetbot";s:6:"JetEye";s:5:"alexa";s:5:"Alexa";s:15:"ArchitextSpider";s:10:"Excite-Bot";s:9:"pipeLiner";s:15:"PipeLine Spider";}s:10:"debug_mode";i:0;s:14:"rss_feed_title";s:0:"";s:13:"rss_feed_desc";s:0:"";s:14:"rss_feed_posts";i:5;s:13:"rss_feed_time";i:60;s:16:"optional_modules";a:11:{i:0;s:6:"active";i:1;s:2:"cp";i:2;s:5:"email";i:3;s:4:"help";i:4;s:7:"members";i:5;s:3:"mod";i:6;s:2:"pm";i:7;s:7:"profile";i:8;s:6:"search";i:9;s:6:"recent";i:10;s:7:"rssfeed";}}')')

File: C:\httpd\****\install\new_install.php
Line: 143
Call: execute_queries('DROP TABLE IF EXISTS %pactive', '')

File: C:\httpd\****\install\index.php
Line: 137
Call: new_install->install_board('2')

Debug:

Notice: Undefined index: db_host in C:\httpd\quicksilver\install\new_install.php  on line 62

Notice: Undefined index: db_user in C:\httpd\quicksilver\install\new_install.php on line 62

Notice: Undefined index: db_pass in C:\httpd\quicksilver\install\new_install.php on line 62

Notice: Undefined index: db_name in C:\httpd\quicksilver\install\new_install.php on line 62

Notice: Undefined index: db_port in C:\httpd\quicksilver\install\new_install.php on line 62

Notice: Undefined index: db_socket in C:\httpd\quicksilver\install\new_install.php on line 62

Notice: Undefined index: prefix in C:\httpd\quicksilver\install\new_install.php on line 62
Couldn't connect to a database using the specified information.
       
Pages:<< prev 1 next >>