按照
http://wenda.wecenter.com/question/28963 帖子上 baofeng_song 网友提供的方法,
PHP7.1.4 上安装Wecenter 3.1.9 成功
方法如下:
修改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;
问题解决
问题如下
在PHP7.1.4 环境中安装官方最新的Wecenter 3.1.9 出现以下错误:
SQL Error: Invalid bind-variable name ':50'
Query: INSERT INTO `aws_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:15:"49319322@qq.com";'),('img_url', 's:0:"";'),('upload_url', 's:32:"http://www.xiaopaxia.com/uploads";'),('upload_dir', 's:39:"/home/wwwroot/www.xiaopaxia.com/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:"20160523";'),('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:"";')
你好