vb.org Archive - View Single Post - Add-On Releases

Synth · #**343** 10-30-2007, 06:14 PM

Quote:

Originally Posted by Stabatha

Hi there,

I am receiving this error when trying to create a new raid... I have tried uninstalling and reinstalling the product 6 times too!

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT field5,,
FROM userfield
WHERE userid = 1;

MySQL Error : 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 '
FROM userfield
WHERE userid = 1' at line 1
Error Number : 1064

I'm having this same issue as well when I use 1.2.6 and click on the created event. When I try to install 1.2.7 i get:

PHP Code:


			
Database error in vBulletin 3.6.2:

Invalid SQL:

                INSERT INTO setting
                    (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
                VALUES
                    (
                    'wow_font_style',
                    'wow_calendar_style',
                    'Verdana',
                    'Verdana',
                    'free',
                    '',
                    11,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_fontsize_style',
                    'wow_calendar_style',
                    '8pt',
                    '8pt',
                    'free',
                    '',
                    21,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_druid_color',
                    'wow_calendar_style',
                    '#FF3300',
                    '#FF3300',
                    'free',
                    '',
                    71,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_hunter_color',
                    'wow_calendar_style',
                    '#33FF33',
                    '#33FF33',
                    'free',
                    '',
                    82,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_mage_color',
                    'wow_calendar_style',
                    '#33FFFF',
                    '#33FFFF',
                    'free',
                    '',
                    83,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_paladin_color',
                    'wow_calendar_style',
                    '#FF66CC',
                    '#FF66CC',
                    'free',
                    '',
                    84,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_priest_color',
                    'wow_calendar_style',
                    '#FFFFFF',
                    '#FFFFFF',
                    'free',
                    '',
                    85,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_rogue_color',
                    'wow_calendar_style',
                    '#FFFF66',
                    '#FFFF66',
                    'free',
                    '',
                    86,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_shaman_color',
                    'wow_calendar_style',
                    '#FF3333',
                    '#3366FF',
                    'free',
                    '',
                    87,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_warlock_color',
                    'wow_calendar_style',
                    '#CC9966',
                    '#CC66CC',
                    'free',
                    '',
                    88,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_warrior_color',
                    'wow_calendar_style',
                    '#CC66CC',
                    '#CC9966',
                    'free',
                    '',
                    89,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_table_width',
                    'wow_calendar_style',
                    '100%',
                    '100%',
                    'free',
                    '',
                    90,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_time_width',
                    'wow_calendar_style',
                    '18%',
                    '18%',
                    'free',
                    '',
                    91,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_name_width',
                    'wow_calendar_style',
                    '12%',
                    '12%',
                    'free',
                    '',
                    92,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_level_width',
                    'wow_calendar_style',
                    '7%',
                    '7%',
                    'free',
                    '',
                    93,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_class_width',
                    'wow_calendar_style',
                    '8%',
                    '8%',
                    'free',
                    '',
                    94,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_talents_width',
                    'wow_calendar_style',
                    '10%',
                    '10%',
                    'free',
                    '',
                    95,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_gender_width',
                    'wow_calendar_style',
                    '5%',
                    '5%',
                    'free',
                    '',
                    96,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_race_width',
                    'wow_calendar_style',
                    '8%',
                    '8%',
                    'free',
                    '',
                    97,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_genrace_width',
                    'wow_calendar_style',
                    '9%',
                    '9%',
                    'free',
                    '',
                    98,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    ),
    (
                    'wow_comments_width',
                    'wow_calendar_style',
                    '28%',
                    '28%',
                    'free',
                    '',
                    99,
                    0,
                    1,
                    '',
                    0,
                    'wow_calendar'
    );

MySQL Error  : Duplicate entry 'wow_font_style' for key 1
Error Number : 1062
Date         : Tuesday, October 30th 2007 @ 03:17:31 PM
Script       : [url]http://hop-guild.com/forum/admincp/plugin.php?do=productimport[/url]
Referrer     : [url]http://hop-guild.com/forum/admincp/plugin.php?do=productadd[/url]
IP Address   : 74.142.45.149
Username     : Onixx
Classname    : vb_database

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01244 seconds Memory Usage 1,957KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php (1)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: