Update Error (Also tried reinstall)

A signature and avatar generator addon

Moderator: zanix

Update Error (Also tried reinstall)

Postby deenkids » Sun Dec 02, 2007 8:54 am

Newest version of Roster today, tried updating Siggen to the newest release as well and get this error:

Code: Select all
Install error in query 4. MySQL said:
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
The query was:
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);
User avatar
deenkids
WR.net Apprentice
WR.net Apprentice
 
Posts: 27
Joined: Fri Oct 12, 2007 7:30 am
Location: Northern Illinois

Update Error (Also tried reinstall)

Postby deenkids » Sun Dec 02, 2007 9:21 am

Nevermind, I missed a fix on the other thread:

tuigii wrote:file install.def.php
Line 283
[long : 4490 character ^^]
- look for the first image_order - the opening apostrohe is missing on position 330.

SQL isn't happy about it.

I'll redownload the ZIP - but I'm pretty sure about it.


Thanks to tuigii for the fix. <3
User avatar
deenkids
WR.net Apprentice
WR.net Apprentice
 
Posts: 27
Joined: Fri Oct 12, 2007 7:30 am
Location: Northern Illinois


Return to SigGen

Who is online

Users browsing this forum: No registered users and 1 guest

cron