首次安装直接提示SQL Error: Invalid bind-variable name ':50'

安装后错误代码如下:
 SQL Error: Invalid bind-variable name ':50'

Query: INSERT INTO `wc_system_setting` (`varname`, `value`) VALUES('site_name', 's:8:"WeCenter";'),('description', 's:30:"WeCenter 社交化知识社区";'),('keywords', 's:47:"WeCenter,知识社区,社交社区,问答社区";'),('sensitive_words', 's:0:"";'),('def_focus_uids', 's:1:"1";'),('answer_edit_time', 's:2:"30";'),('cache_level_high', 's:2:"60";'),('cache_level_normal', 's:3:"600";'),('cache_level_low', 's:4:"1800";'),('unread_flush_interval', 's:3:"100";'),('newer_invitation_num', 's:1:"5";'),('index_per_page', 's:2:"20";'),('from_email', 's:13:"i@liuplus.com";'),('img_url', 's:0:"";'),('upload_url', 's:29:"http://www.cityjx.com/uploads";'),('upload_dir', 's:35:"C:/inetpub/wwwroot/WeCenter/uploads";'),('ui_style', 's:7:"default";'),('uninterested_fold', 's:1:"5";'),('sina_akey', NULL),('sina_skey', NULL),('sina_weibo_enabled', 's:1:"N";'),('answer_unique', 's:1:"N";'),('notifications_per_page', 's:2:"10";'),('contents_per_page', 's:2:"10";'),('hot_question_period', 's:1:"7";'),('category_display_mode', 's:4:"icon";'),('recommend_users_number', 's:1:"6";'),('ucenter_enabled', 's:1:"N";'),('register_valid_type', 's:5:"email";'),('best_answer_day', 's:2:"30";'),('answer_self_question', 's:1:"Y";'),('censoruser', 's:5:"admin";'),('best_answer_min_count', 's:1:"3";'),('reputation_function', 's:78:"[最佳答案]*3+[赞同]*1-[反对]*1+[发起者赞同]*2-[发起者反对]*1";'),('db_version', 's:8:"20150226";'),('statistic_code', 's:0:"";'),('upload_enable', 's:1:"Y";'),('answer_length_lower', 's:1:"2";'),('quick_publish', 's:1:"Y";'),('register_type', 's:4:"open";'),('question_title_limit', 's:3:"100";'),('register_seccode', 's:1:"Y";'),('admin_login_seccode', 's:1:"Y";'),('comment_limit', 's:1:"0";'),('backup_dir', ''),('best_answer_reput', 's:2:"20";'),('publisher_reputation_factor', 's:2:"10";'),('request_route_custom', 's:0:"";'),('upload_size_limit', 's:3:"512";'),('upload_avatar_size_limit', 's:3:"512";'),('topic_title_limit', 's:2:"12";'),('url_rewrite_enable', 's:1:"N";'),('best_agree_min_count', 's:1:"3";'),('site_close', 's:1:"N";'),('close_notice', 's:39:"站点已关闭,管理员请登录。";'),('qq_login_enabled', 's:1:"N";'),('qq_login_app_id', ''),('qq_login_app_key', ''),('integral_system_enabled', 's:1:"N";'),('integral_system_config_register', 's:4:"2000";'),('integral_system_config_profile', 's:3:"100";'),('integral_system_config_invite', 's:3:"200";'),('integral_system_config_best_answer', 's:3:"200";'),('integral_system_config_answer_fold', 's:3:"-50";'),('integral_system_config_new_question', 's:3:"-20";'),('integral_system_config_new_answer', 's:2:"-5";'),('integral_system_config_thanks', 's:3:"-10";'),('integral_system_config_invite_answer', 's:3:"-10";'),('username_rule', 's:1:"1";'),('username_length_min', 's:1:"2";'),('username_length_max', 's:2:"14";'),('category_enable', 's:1:"Y";'),('integral_unit', 's:6:"金币";'),('nav_menu_show_child', 's:1:"1";'),('anonymous_enable', 's:1:"Y";'),('report_reason', 's:50:"广告/SPAM\n违规内容\n文不对题\n重复发问";'),('allowed_upload_types', 's:41:"jpg,jpeg,png,gif,zip,doc,docx,rar,pdf,psd";'),('site_announce', 's:0:"";'),('icp_beian', 's:0:"";'),('report_message_uid', 's:1:"1";'),('today_topics', 's:0:"";'),('welcome_recommend_users', 's:0:"";'),('welcome_message_pm', 's:180:"尊敬的{username},您已经注册成为{sitename}的会员,请您在发表言论时,遵守当地法律法规。\n如果您有什么疑问可以联系管理员。\n\n{sitename}";'),('time_style', 's:1:"Y";'),('reputation_log_factor', 's:1:"3";'),('advanced_editor_enable', 's:1:"Y";'),('auto_question_lock_day', 's:1:"0";'),('default_timezone', 's:9:"Etc/GMT-8";'),('reader_questions_last_days', 's:2:"30";'),('reader_questions_agree_count', 's:2:"10"'),('weixin_mp_token', 's:0:"";'),('new_user_email_setting', 'a:2:{s:9:"FOLLOW_ME";s:1:"N";s:10:"NEW_ANSWER";s:1:"N";}'),('new_user_notification_setting', 'a:0:{}'),('user_action_history_fresh_upgrade', 's:1:"Y";'),('cache_dir', 's:0:"";'),('ucenter_charset', 's:5:"UTF-8";'),('question_topics_limit', 's:2:"10";'),('mail_config', 'a:7:{s:9:"transport";s:8:"sendmail";s:7:"charset";s:5:"UTF-8";s:6:"server";s:0:"";s:3:"ssl";s:1:"0";s:4:"port";s:0:"";s:8:"username";s:0:"";s:8:"password";s:0:"";}'),('auto_create_social_topics', 's:1:"N";'),('weixin_subscribe_message_key', 's:0:"";'),('weixin_no_result_message_key', 's:0:"";'),('weixin_mp_menu', 'a:0:{}'),('new_question_force_add_topic', 's:1:"N";'),('unfold_question_comments', 's:1:"N";'),('report_diagnostics', 's:1:"Y";'),('weixin_app_id', 's:0:"";'),('weixin_app_secret', 's:0:"";'),('weixin_account_role', 's:7:"base";'),('weibo_msg_enabled', 's:1:"N";'),('weibo_msg_published_user', 'a:0:"";'),('admin_notifications', 'a:0:"";'),('slave_mail_config', 's:0:"";'),('receiving_email_global_config', 'a:2:{s:7:"enabled";s:1:"N";s:12:"publish_user";N;}'),('last_sent_valid_email_id', 'i:0;'),('google_login_enabled', 's:1:"N";'),('google_client_id', 's:0:"";'),('google_client_secret', 's:0:"";'),('facebook_login_enabled', 's:1:"N";'),('facebook_app_id', 's:0:"";'),('facebook_app_secret', 's:0:"";'),('twitter_login_enabled', 's:1:"N";'),('twitter_consumer_key', 's:0:"";'),('twitter_consumer_secret', 's:0:"";'),('weixin_encoding_aes_key', 's:0:"";'),('integral_system_config_answer_change_source', 's:1:"Y";'),('enable_help_center', 's:1:"N";'),('ucenter_path', 's:0:"";')
 
已邀请:
我也碰到了同样的问题,我的方法是:
修改install/db/system_setting.sql文件中第77行,
从  ('report_reason', 's:50:"广告/SPAM\n违规内容\n文不对题\n重复发问";'),
修改为  ('report_reason', ''),
 
然后执行安装,安装完成后,在数据库中执行以下sql:UPDATE `aws_system_setting` SET `value` = 's:50:"广告/SPAM\\n违规内容\\n文不对题\\n重复发问";' WHERE `aws_system_setting`.`id` = 77;
同时下载3.1.7和3.1.8,然后用后者覆盖前者并打包上传、解压、再安装即可
 
www kacheng.club

wonkiall

赞同来自: 多元文化

用低版本的php即可,我用php7也是这个错误,换php5.3就没事

杨尘埃2333

赞同来自: liujiazhong

我装也遇到了这个问题,
50:"广告/SPAM\n违规内容\n文不对题\n重复发问";'
把这段代码双引号中的删除刷新就安装成功了,不知道是不是这些文字被服务器防火墙拦截。
50:"";'

星壹醉 - http://itrrr.com/ 欢迎加入 WeCenter QQ交流群:186617300

@wecenter QQ交流群:186617300

该问题目前已经被锁定, 无法添加新回复