Mercury 2.2.5 Database error?

Results 1 to 6 of 6
  1. #1
    Member 1nc1n1gr4t3 is offline
    MemberRank
    Jul 2012 Join Date
    52Posts

    Mercury 2.2.5 Database error?

    Admin close this thread please.
    Last edited by 1nc1n1gr4t3; 27-02-15 at 09:50 AM.


  2. #2
    Member Aron123 is offline
    MemberRank
    Mar 2013 Join Date
    BelgiumLocation
    88Posts

    Re: Mercury 2.2.5 Database error?

    Dont try to add new furni, this emulator is not stable enough for that. Mostly that causes the error.

  3. #3
    Member 1nc1n1gr4t3 is offline
    MemberRank
    Jul 2012 Join Date
    52Posts

    Re: Mercury 2.2.5 Database error?

    I haven't added any furniture. That error was there i just imported the database.

  4. #4
    R.I.P Millercent FatalLulz is offline
    MemberRank
    Nov 2012 Join Date
    AustraliaLocation
    2,248Posts

    Re: Mercury 2.2.5 Database error?

    What's on ItemManager.cs line 57?

  5. #5
    Member 1nc1n1gr4t3 is offline
    MemberRank
    Jul 2012 Join Date
    52Posts

    Re: Mercury 2.2.5 Database error?

    Let me check hang on.
    I'm getting errors importing the database.
    [Err] 2006 - MySQL server has gone away
    [Err] INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_loyalty`, `cost_duckets`, `amounts`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `club_only`, `extradata`, `badge`) VALUES
    (1941, 68, '2180', 'ads_gsArcade_1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1942, 138, '2182', 'ads_mtvtrophy_silver', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1943, 99, '2183', 'ads_spang_sleep', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1944, 138, '2184', 'ads_mtvtrophy_gold', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1945, 115, '2209', 'ads_cl_moodi', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1946, 115, '2223', 'ads_chups', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1947, 115, '2226', 'ads_droetker_paula', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1948, 68, '2252', 'ads_percyrock', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1949, 114, '2254', 'ads_idol_l_logo', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1950, 68, '2303', 'ads_percyw', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1951, 114, '2257', 'ads_mtv_tv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1952, 173, '2302', 'ads_tv_jaapuisto', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1953, 68, '2266', 'byesw_loadscreen', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1954, 114, '2256', 'ads_mtv_bigtv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1955, 114, '2255', 'ads_idol_l_tv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1956, 13, '2176', 'tree2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1957, 16, '2177', 'A7 polyovi', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1958, 94, '2185', 'ktchn_hlthNut', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1959, 72, '2186', 'petfood8', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1960, 72, '2189', 'petfood9', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1961, 72, '2190', 'petfood10', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1962, 72, '2191', 'petfood7', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1963, 72, '2192', 'petfood6', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1964, 72, '2198', 'petfood5', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1965, 72, '2225', 'petfood12', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1966, 72, '2227', 'petfood11', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1967, 72, '2229', 'petfood13', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1968, 173, '2253', 'md_can', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1969, 40, '2259', 'hween09_curt', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1970, 32, '2215', 'china_tiger', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1971, 32, '2217', 'china_plmTree', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1972, 32, '2301', 'china_pstr3', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1973, 67, '1465', 'bump_road', 1, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1974, 155, '2311', 'rare_trex name', 5, 2, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1975, 24, '2312', 'beanstalk', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1976, 68, '2313', 'rare_vdoll name', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1978, 69, '2315', 'crystal_patch', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1979, 68, '2316', 'ads_boost_surfb name', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1980, 68, '2317', 'ads_tlc_wheel name', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1981, 138, '224', 'Dragon Egg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1982, 71, '2318', 'a0 pet5', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1983, 24, '2319', 'garden_lupin4', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1984, 24, '2320', 'garden_mursu3', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1985, 24, '2321', 'garden_lupin5', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1986, 24, '2322', 'garden_seed', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
    (1987, 15, '2323', 'garden_flytrap', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '',
    [Err] 1231 - Variable 'character_set_client' can't be set to the value of 'NULL'
    [Err] --
    -- Volcar la base de datos para la tabla `user_items_songs`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_polldata`
    --

    CREATE TABLE IF NOT EXISTS `user_polldata` (
    `user_id` int(11) unsigned NOT NULL,
    `poll_id` int(11) unsigned NOT NULL,
    `question_id` int(11) unsigned NOT NULL,
    `accepted` enum('0','1') NOT NULL,
    `answer` text NOT NULL,
    UNIQUE KEY `user_id` (`user_id`,`poll_id`,`question_id`,`accepted`) USING BTREE
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    --
    -- Volcar la base de datos para la tabla `user_polldata`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_quests`
    --

    CREATE TABLE IF NOT EXISTS `user_quests` (
    `user_id` int(10) unsigned NOT NULL,
    `quest_id` int(10) unsigned NOT NULL,
    `progress` int(10) DEFAULT '0',
    PRIMARY KEY (`user_id`,`quest_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Volcar la base de datos para la tabla `user_quests`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_relationships`
    --

    CREATE TABLE IF NOT EXISTS `user_relationships` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `target` int(11) NOT NULL,
    `type` enum('1','2','3') NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`) USING BTREE
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

    --
    -- Volcar la base de datos para la tabla `user_relationships`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_roomvisits`
    --

    CREATE TABLE IF NOT EXISTS `user_roomvisits` (
    `user_id` int(10) unsigned NOT NULL,
    `room_id` int(10) unsigned NOT NULL,
    `entry_timestamp` double NOT NULL,
    `exit_timestamp` double NOT NULL,
    `hour` int(11) NOT NULL,
    `minute` int(11) NOT NULL,
    KEY `user_id` (`user_id`) USING BTREE
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Volcar la base de datos para la tabla `user_roomvisits`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_stats`
    --

    CREATE TABLE IF NOT EXISTS `user_stats` (
    `id` int(7) NOT NULL,
    `room_visits` int(7) NOT NULL DEFAULT '0',
    `respect` int(6) NOT NULL DEFAULT '0',
    `gifts_given` int(6) NOT NULL DEFAULT '0',
    `gifts_received` int(6) NOT NULL DEFAULT '0',
    `daily_respect_points` int(1) NOT NULL DEFAULT '3',
    `daily_pet_respect_points` int(1) NOT NULL DEFAULT '3',
    `achievement_score` int(7) NOT NULL DEFAULT '0',
    `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
    `quest_progress` int(10) NOT NULL DEFAULT '0',
    `favourite_group` int(11) NOT NULL DEFAULT '0',
    `tickets_answered` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Volcar la base de datos para la tabla `user_stats`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_subscriptions`
    --

    CREATE TABLE IF NOT EXISTS `user_subscriptions` (
    `user_id` int(10) unsigned NOT NULL,
    `subscription_id` int(50) NOT NULL,
    `timestamp_activated` int(11) NOT NULL,
    `timestamp_expire` int(11) NOT NULL,
    `timestamp_lastgift` int(11) NOT NULL,
    KEY `user_id` (`user_id`) USING BTREE,
    KEY `subscription_id` (`subscription_id`) USING BTREE
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Volcar la base de datos para la tabla `user_subscriptions`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_tags`
    --

    CREATE TABLE IF NOT EXISTS `user_tags` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(10) unsigned NOT NULL,
    `tag` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`) USING BTREE
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

    --
    -- Volcar la base de datos para la tabla `user_tags`
    --


    -- --------------------------------------------------------

    --
    -- Estructura de tabla para la tabla `user_talents`
    --

    CREATE TABLE IF NOT EXISTS `user_tale
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------
    - - - Updated - - -

    This is on line 57
    height = Convert.ToDouble(dataRow["stack_height"]);
    - - - Updated - - -


  6. #6
    Member 1nc1n1gr4t3 is offline
    MemberRank
    Jul 2012 Join Date
    52Posts

    Re: Mercury 2.2.5 Database error?

    Bump, i have mercury 2.3 now help pls.



Advertisement