The error is saying the table does not exist
Uninstall and reinstall

Here is the complete fixed

install.def.php

Okay, but there is an installation problem. When attempting to install, I get the following Database Error.

I have tried this on two different hosts.. the following is Windows/Apache, and I've also tried this on a Debian setup.

Code: Select all

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 '`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_pre' at line 1
SQL:
INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
File: lib\dbal\mysql.php
Line: 207
Backtrace (most recent call last):

    * lib\functions.lib.php
          o Line: 240
          o Function Called: backtrace
    * lib\dbal\mysql.php
          o Line: 207
          o Function Called: die_quietly
          o Arguments:
                + 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 '`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_pre' at line 1
                + Database Error
                + C:\xampp\htdocs\roster\lib\dbal\mysql.php
                + 207
                + INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
    * lib\install.lib.php
          o Line: 271
          o Function Called: query
          o Arguments:
                + INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
    * admin\addon_install.php
          o Line: 514
          o Function Called: install
    * admin\addon_install.php
          o Line: 46
          o Function Called: processAddon
    * pages\rostercp.php
          o Line: 116
          o Function Called: require_once
          o Arguments:
                + C:\xampp\htdocs\roster\admin\addon_install.php
    * index.php
          o Line: 83
          o Function Called: require
          o Arguments:
                + C:\xampp\htdocs\roster\pages\rostercp.php


I get the same error as fadedroses when trying to install the latest version.
Seems like the query has lost a quote on the image_order tablename:

`font_dir`, `link_type`, image_order`, `default_message`,

(note the missing ` before image_order)

Fixing that quote in install.def.php seemed to have fixed the problem. Thanks!

I am getting an error when i try to re-install siggen after upgrading my roster

Code: Select all

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 ''image_order`, `default_message`, `save_images`, `save_only_mode
SQL:
INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, 'image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
File: lib/dbal/mysql.php
Line: 207
Backtrace (most recent call last):
lib/functions.lib.php
Line: 240
Function Called: backtrace
lib/dbal/mysql.php
Line: 207
Function Called: die_quietly
Arguments:
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 ''image_order`, `default_message`, `save_images`, `save_only_mode
Database Error
/homepages/35/d114412699/htdocs/sboj/roster/lib/dbal/mysql.php
207
INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, 'image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
lib/install.lib.php
Line: 271
Function Called: query
Arguments:
INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, 'image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
admin/addon_install.php
Line: 514
Function Called: install
admin/addon_install.php
Line: 46
Function Called: processaddon
pages/rostercp.php
Line: 116
Function Called: require_once
Arguments:
/homepages/35/d114412699/htdocs/sboj/roster/admin/addon_install.php
index.php
Line: 83
Function Called: require
Arguments:
/homepages/35/d114412699/htdocs/sboj/roster/pages/rostercp.php


I have had the same SQL Message Error [1064:] the misstake is the [`] missing in the file [install.def.php] like mentioned above.

in my Editor I have searched for [image_order`,] secound match shouldn't have the first [`] just add, than fixed.

After deinstall and reinstall everything works fine.

thx for the grate addon.

Leftaf

ill try it again, but i had already made that edit,


NM


I put in the wrong thing - i put in ' not `

fadedroses wrote:I'm having a weird error when I try to use this. It's a current install of Roster and SigGen, and the addon management said SigGen was activated even though there are no options for it, just a disabled "Update" button.
Anyway, here's what I get..

Error result

Does this require any image packs or something I forgot?

I'm having the same problem as this guy, Link
I've uninstalled and reinstalled it four or five times, with no luck.

I get the same error as well, when I try to generate a preview.

I hade teh same problem as fadedroses after installing the addon i got the upgrade button, i did a uninstall now i get



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 ', `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_pref' at line 1
SQL:
INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
File: lib/dbal/mysql.php
Line: 207
Backtrace (most recent call last):

* lib/functions.lib.php
o Line: 240
o Function Called: backtrace
* lib/dbal/mysql.php
o Line: 207
o Function Called: die_quietly
o Arguments:
+ 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 ', `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_pref' at line 1
+ Database Error
+ /home/.giglet/wcguild/without-conscience.com/roster2/lib/dbal/mysql.php
+ 207
+ INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
* lib/install.lib.php
o Line: 271
o Function Called: query
o Arguments:
+ INSERT INTO `roster_addons_siggen_config` (`config_id`, `db_ver`, `trigger`, `guild_trigger`, `clear_dir`, `main_image_size_w`, `main_image_size_h`, `image_dir`, `char_dir`, `class_dir`, `backg_dir`, `user_dir`, `pvplogo_dir`, `frame_dir`, `level_dir`, `border_dir`, `font_dir`, `link_type`, image_order`, `default_message`, `save_images`, `save_only_mode`, `uniup_compat`, `save_prefix`, `save_suffix`, `save_images_dir`, `save_images_format`, `etag_cache`, `image_type`, `image_quality`, `gif_dither`, `backg_disp`, `backg_fill`, `backg_fill_color`, `backg_default_image`, `backg_force_default`, `backg_data_table`, `backg_data`, `backg_translate`, `backg_search_1`, `backg_search_2`, `backg_search_3`, `backg_search_4`, `backg_search_5`, `backg_search_6`, `backg_search_7`, `backg_search_8`, `backg_search_9`, `backg_search_10`, `backg_search_11`, `backg_search_12`, `backg_file_1`, `backg_file_2`, `backg_file_3`, `backg_file_4`, `backg_file_5`, `backg_file_6`, `backg_file_7`, `backg_file_8`, `backg_file_9`, `backg_file_10`, `backg_file_11`, `backg_file_12`, `font_fullpath`, `outside_border_image`, `frames_image`, `charlogo_disp`, `charlogo_default_image`, `charlogo_loc_x`, `charlogo_loc_y`, `class_img_disp`, `class_img_loc_x`, `class_img_loc_y`, `pvplogo_disp`, `pvplogo_loc_x`, `pvplogo_loc_y`, `lvl_disp`, `lvl_font_name`, `lvl_font_color`, `lvl_font_size`, `lvl_text_shadow`, `lvl_loc_x`, `lvl_loc_y`, `lvl_text_loc_x`, `lvl_text_loc_y`, `lvl_image`, `expbar_disp`, `expbar_disp_bdr`, `expbar_disp_inside`, `expbar_max_disp`, `expbar_max_level`, `expbar_max_hidden`, `expbar_disp_text`, `expbar_string_before`, `expbar_string_after`, `expbar_max_string`, `expbar_loc_x`, `expbar_loc_y`, `expbar_length`, `expbar_height`, `expbar_color_border`, `expbar_color_bar`, `expbar_color_inside`, `expbar_color_maxbar`, `expbar_trans_border`, `expbar_trans_bar`, `expbar_trans_inside`, `expbar_trans_maxbar`, `expbar_font_name`, `expbar_font_color`, `expbar_font_size`, `expbar_text_shadow`, `expbar_align`, `expbar_align_max`, `skills_disp_primary`, `skills_disp_secondary`, `skills_disp_mount`, `skills_disp_desc`, `skills_disp_level`, `skills_disp_levelmax`, `skills_desc_loc_x`, `skills_desc_loc_y`, `skills_level_loc_x`, `skills_level_loc_y`, `skills_desc_length`, `skills_desc_length_mount`, `skills_align_desc`, `skills_align_level`, `skills_desc_linespace`, `skills_level_linespace`, `skills_gap`, `skills_shadow`, `skills_font_name`, `skills_font_color`, `skills_font_size`, `text_name_disp`, `text_name_loc_x`, `text_name_loc_y`, `text_name_align`, `text_name_shadow`, `text_name_font_name`, `text_name_font_color`, `text_name_font_size`, `text_honor_disp`, `text_honor_loc_x`, `text_honor_loc_y`, `text_honor_align`, `text_honor_shadow`, `text_honor_font_name`, `text_honor_font_color`, `text_honor_font_size`, `text_class_disp`, `text_class_loc_x`, `text_class_loc_y`, `text_class_align`, `text_class_shadow`, `text_class_font_name`, `text_class_font_color`, `text_class_font_size`, `text_guildname_disp`, `text_guildname_loc_x`, `text_guildname_loc_y`, `text_guildname_align`, `text_guildname_shadow`, `text_guildname_font_name`, `text_guildname_font_color`, `text_guildname_font_size`, `text_guildtitle_disp`, `text_guildtitle_loc_x`, `text_guildtitle_loc_y`, `text_guildtitle_align`, `text_guildtitle_shadow`, `text_guildtitle_font_name`, `text_guildtitle_font_color`, `text_guildtitle_font_size`, `text_servername_disp`, `text_servername_loc_x`, `text_servername_loc_y`, `text_servername_align`, `text_servername_shadow`, `text_servername_font_name`, `text_servername_font_color`, `text_servername_font_size`, `text_sitename_disp`, `text_sitename_remove`, `text_sitename_loc_x`, `text_sitename_loc_y`, `text_sitename_align`, `text_sitename_shadow`, `text_sitename_font_name`, `text_sitename_font_color`, `text_sitename_font_size`, `text_spec_disp`, `text_spec_loc_x`, `text_spec_loc_y`, `text_spec_align`, `text_spec_shadow`, `text_spec_font_name`, `text_spec_font_color`, `text_spec_font_size`, `text_talpoints_disp`, `text_talpoints_loc_x`, `text_talpoints_loc_y`, `text_talpoints_align`, `text_talpoints_shadow`, `text_talpoints_font_name`, `text_talpoints_font_color`, `text_talpoints_font_size`, `text_custom_disp`, `text_custom_loc_x`, `text_custom_loc_y`, `text_custom_text`, `text_custom_align`, `text_custom_shadow`, `text_custom_font_name`, `text_custom_font_color`, `text_custom_font_size`) VALUES ('avatar', '1.6', 0, 0, 0, 100, 85, 'img/', 'character/default/', 'class/square/', 'background/defaultava/', 'members/', 'pvp/default/', 'frame/', 'level/', 'border/', 'fonts/', 'default', 'char:frames:border:class:lvl:pvp', 'SigGen Works', 0, 0, 0, '', '', '%sava/', 'png', 1, 'png', 85, 1, 1, 0, '#000000', 'default.png', 0, 'players', 'race', 1, 'Night Elf', 'Human', 'Gnome', 'Dwarf', 'Orc', 'Troll', 'Tauren', 'Undead', 'Draenei', 'Blood Elf', '', '', 'darnassus.png', 'stormwind.png', 'ironforge.png', 'ironforge.png', 'orgrimmar.png', 'orgrimmar.png', 'thunderbluff.png', 'undercity.png', 'exodar.png', 'silvermoon.png', '', '', 1, 'av-black.png', 'av-default.png', 1, 'default-alliance.png', 0, 0, 1, 65, 51, 0, 3, 25, 1, 'GREY.TTF', '#FF9900', 11, '#000000', 77, 68, 11, 15, '', 1, 0, 1, 1, 70, 1, 0, '[', ']', 'Max XP', 2, 79, 62, 3, '#000000', '#0B9BFF', '#FFFFFF', '#0B9BFF', 0, 20, 80, 0, 'VERANDA.TTF', '#FFFFFF', 6, '#000000', 'center', 'center', 0, 0, 0, 1, 1, 0, 3, 48, 65, 48, 10, 20, 'left', 'right', 7, 7, 2, '#000000', 'VERANDA.TTF', '#FF9900', 6, 1, 3, 22, 'left', '#000000', 'GREY.TTF', '#FFFF66', 14, 0, 3, 53, 'left', '#000000', 'GREY.TTF', '#99FF33', 7, 0, 97, 35, 'right', '#000000', 'VERANDA.TTF', '#99FF33', 7, 1, 3, 71, 'left', '#000000', 'GREY.TTF', '#0066FF', 8, 1, 12, 8, 'left', '#000000', 'VERANDA.TTF', '#FFCC66', 6, 1, 3, 78, 'left', '#000000', 'VERANDA.TTF', '#99FF33', 6, 0, 1, 50, 82, 'center', '#000000', 'VERANDA.TTF', '#FFFFFF', 6, 1, 3, 32, 'left', '#000000', 'GREY.TTF', '#FF6600', 7, 1, 97, 32, 'right', '#000000', 'GREY.TTF', '#CCFF33', 6, 0, 3, 84, 'Custom Text', 'left', '#000000', 'VERANDA.TTF', '#FFFFFF', 6);
* admin/addon_install.php
o Line: 514
o Function Called: install
* admin/addon_install.php
o Line: 46
o Function Called: processAddon
* pages/rostercp.php
o Line: 116
o Function Called: require_once
o Arguments:
+ /home/.giglet/wcguild/without-conscience.com/roster2/admin/addon_install.php
* index.php
o Line: 83
o Function Called: require
o Arguments:
+ /home/.giglet/wcguild/without-conscience.com/roster2/pages/rostercp.php


Should i wipe the database and start over
PHP Version 5.2.3
MySQL version: 5.0.16

zxaltan wrote:I hade teh same problem as fadedroses after installing the addon i got the upgrade button, i did a uninstall now i get

Shame on you (for an 'Addon dev') ;-)

The solution is already in this thread, a couple of posts above.

An ' (singele quote) is missing - as the SQL error said.

I do use the addon svn for siggen
And the latest commit fixes these issues

i have a small problem. i can`t see the sig. preview is not working and when i use the link i got a database error.

here are the images

can you help me ?

Right now when I Upload a Profile - both with and without the guild update seleceted No Sig is generated for anyone.

I am actually LVL 29 on this toon, but during the update process blank boxes show up where the signatures would be.

Attached is a screenshot of the Blank boxes.

LMK if you need anything else