Page 1 of 1

(SOLVED) Signature settings in ACP are not applied

PostPosted: Thu Sep 16, 2010 2:10 pm
Author: viragotech
I found this thread in the 140 forum, but Im having the smae problem in 141, said code posted didn't work.


HELP I NEED THIS

#1064 - 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 '('sig_max_lines', '5'); INSERT INTO `phpbb_config` VALUES ('sig_wor' at line 1

"HelterSkelter wrote:
you are correct that these qurries were missed by the phpbb_to_140_update

Line number On/Off | Expand/Contract | Select all

INSERT INTO `phpbb_config` VALUES ('sig_max_lines', '5');
INSERT INTO `phpbb_config` VALUES ('sig_wordwrap', '100');
INSERT INTO `phpbb_config` VALUES ('sig_allow_font_sizes', '1');
INSERT INTO `phpbb_config` VALUES ('sig_min_font_size', '7');
INSERT INTO `phpbb_config` VALUES ('sig_max_font_size', '12');
INSERT INTO `phpbb_config` VALUES ('sig_allow_bold', '1');
INSERT INTO `phpbb_config` VALUES ('sig_allow_italic', '1');
INSERT INTO `phpbb_config` VALUES ('sig_allow_underline', '1');
INSERT INTO `phpbb_config` VALUES ('sig_allow_colors', '1');
INSERT INTO `phpbb_config` VALUES ('sig_allow_quote', '0');
INSERT INTO `phpbb_config` VALUES ('sig_allow_code', '0');
INSERT INTO `phpbb_config` VALUES ('sig_allow_list', '0');
INSERT INTO `phpbb_config` VALUES ('sig_allow_url', '1');
INSERT INTO `phpbb_config` VALUES ('sig_allow_images', '1');
INSERT INTO `phpbb_config` VALUES ('sig_max_images', '0');
INSERT INTO `phpbb_config` VALUES ('sig_max_img_height', '75');
INSERT INTO `phpbb_config` VALUES ('sig_max_img_width', '500');
INSERT INTO `phpbb_config` VALUES ('sig_allow_on_max_img_size_fail', '0');
INSERT INTO `phpbb_config` VALUES ('sig_max_img_files_size', '10');
INSERT INTO `phpbb_config` VALUES ('sig_max_img_av_files_size', '0');
INSERT INTO `phpbb_config` VALUES ('sig_exotic_bbcodes_disallowed', '');
INSERT INTO `phpbb_config` VALUES ('sig_allow_smilies', '1');










you can run these through phpmyadmin for now."

Re: Signature settings in ACP are not applied

PostPosted: Thu Sep 16, 2010 2:19 pm
Author: Helter
"HelterSkelter" wrote:you are correct that these qurries were missed by the phpbb_to_140_update

Code: Select all
INSERT INTO `phpbb_config` VALUES ('sig_max_lines', '5');INSERT INTO `phpbb_config` VALUES ('sig_wordwrap', '100');INSERT INTO `phpbb_config` VALUES ('sig_allow_font_sizes', '1');INSERT INTO `phpbb_config` VALUES ('sig_min_font_size', '7');INSERT INTO `phpbb_config` VALUES ('sig_max_font_size', '12');INSERT INTO `phpbb_config` VALUES ('sig_allow_bold', '1');INSERT INTO `phpbb_config` VALUES ('sig_allow_italic', '1');INSERT INTO `phpbb_config` VALUES ('sig_allow_underline', '1');INSERT INTO `phpbb_config` VALUES ('sig_allow_colors', '1');INSERT INTO `phpbb_config` VALUES ('sig_allow_quote', '0');INSERT INTO `phpbb_config` VALUES ('sig_allow_code', '0');INSERT INTO `phpbb_config` VALUES ('sig_allow_list', '0');INSERT INTO `phpbb_config` VALUES ('sig_allow_url', '1');INSERT INTO `phpbb_config` VALUES ('sig_allow_images', '1');INSERT INTO `phpbb_config` VALUES ('sig_max_images', '0');INSERT INTO `phpbb_config` VALUES ('sig_max_img_height', '75');INSERT INTO `phpbb_config` VALUES ('sig_max_img_width', '500');INSERT INTO `phpbb_config` VALUES ('sig_allow_on_max_img_size_fail', '0');INSERT INTO `phpbb_config` VALUES ('sig_max_img_files_size', '10');INSERT INTO `phpbb_config` VALUES ('sig_max_img_av_files_size', '0');INSERT INTO `phpbb_config` VALUES ('sig_exotic_bbcodes_disallowed', '');INSERT INTO `phpbb_config` VALUES ('sig_allow_smilies', '1');


you can run these through phpmyadmin for now.

Re: Signature settings in ACP are not applied

PostPosted: Thu Sep 16, 2010 2:39 pm
Author: viragotech
Thanks, that worked.