SQL Error with latest OpenAscent / ABD SVN's menu

User Tag List

Results 1 to 6 of 6
  1. #1
    Xerxe's Avatar Member
    Reputation
    1
    Join Date
    Apr 2008
    Posts
    7
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Error with latest OpenAscent / ABD SVN's

    I recently decided to setup my own server instead of using a repack. I downloaded the newest SVN of OpenAscent as well as the latest SVN of Ascent Blizzlike Database. I got all that setup, and noticed that ADB doesn't come with the character database? (at least I could find it?). So I downloaded a character database and imported that. My server starts up fine, I can login, make a character. But after I make a character, it dissapears. When I check the ascent-world.exe command window, I get the following error:

    Sql query failed due to [Column count doesn't match value count at row 1], Query: [REPLACE INTO characters VALUES etc. etc. etc.

    Anyone have a clue? I'm assuming it's something to do with ABD and my character database that I downloaded? However, I've tried two different blank character databases from different sites and I get the same error both times.

    Would greatly appreciate some help. I guess I could always go back to repacks but I would love to have the control/flexibility of my own.

    SQL Error with latest OpenAscent / ABD SVN's
  2. #2
    1ns0mnia's Avatar Active Member
    Reputation
    67
    Join Date
    Nov 2007
    Posts
    428
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hmm then its an out of date sql but if it doesnt error on the repack DB then maybe run your own COMPILED server off the repack database? then just delete what u dont want.

  3. #3
    SectorSeven's Avatar Banned
    Reputation
    444
    Join Date
    Oct 2007
    Posts
    1,948
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It has nothing to do with ABD its all your character db.

  4. #4
    Xerxe's Avatar Member
    Reputation
    1
    Join Date
    Apr 2008
    Posts
    7
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by SectorSeven View Post
    It has nothing to do with ABD its all your character db.
    That was pretty much my assumption. Is there a better way to get a character DB? I've just been googling 'ascent character database' and downloading them from random sites.

  5. #5
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Xerxe View Post
    That was pretty much my assumption. Is there a better way to get a character DB? I've just been googling 'ascent character database' and downloading them from random sites.
    if you need latest char structure:
    rev 3461 and up:
    Code:
    --
    -- Table structure for table `characters`
    --
    
    DROP TABLE IF EXISTS `characters`;
    SET @saved_cs_client     = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `characters` (
      `guid` int(6) unsigned NOT NULL DEFAULT '0',
      `acct` int(20) unsigned NOT NULL DEFAULT '0',
      `name` varchar(21) NOT NULL DEFAULT '',
      `race` smallint(3) NOT NULL,
      `class` smallint(3) NOT NULL,
      `gender` tinyint(1) NOT NULL,
      `custom_faction` int(30) NOT NULL DEFAULT '0',
      `level` int(3) NOT NULL,
      `xp` int(30) NOT NULL,
      `exploration_data` longtext NOT NULL,
      `skills` longtext NOT NULL,
      `watched_faction_index` bigint(40) NOT NULL,
      `selected_pvp_title` int(30) NOT NULL,
      `available_pvp_titles` int(30) NOT NULL,
      `gold` int(30) NOT NULL,
      `ammo_id` int(30) NOT NULL,
      `available_prof_points` int(30) NOT NULL,
      `available_talent_points` int(30) NOT NULL,
      `current_hp` int(30) NOT NULL,
      `current_power` int(30) NOT NULL,
      `pvprank` int(30) NOT NULL,
      `bytes` int(30) NOT NULL,
      `bytes2` int(30) NOT NULL,
      `player_flags` int(30) NOT NULL,
      `player_bytes` int(30) NOT NULL,
      `positionX` float NOT NULL DEFAULT '0',
      `positionY` float NOT NULL DEFAULT '0',
      `positionZ` float NOT NULL DEFAULT '0',
      `orientation` float NOT NULL DEFAULT '0',
      `mapId` int(8) unsigned NOT NULL DEFAULT '0',
      `zoneId` int(8) unsigned NOT NULL DEFAULT '0',
      `taximask` longtext NOT NULL,
      `banned` int(40) unsigned NOT NULL DEFAULT '0',
      `banReason` varchar(255) NOT NULL,
      `timestamp` int(30) DEFAULT NULL,
      `online` int(11) DEFAULT NULL,
      `bindpositionX` float NOT NULL DEFAULT '0',
      `bindpositionY` float NOT NULL DEFAULT '0',
      `bindpositionZ` float NOT NULL DEFAULT '0',
      `bindmapId` int(8) unsigned NOT NULL DEFAULT '0',
      `bindzoneId` int(8) unsigned NOT NULL DEFAULT '0',
      `isResting` int(3) NOT NULL DEFAULT '0',
      `restState` int(5) NOT NULL DEFAULT '0',
      `restTime` int(5) NOT NULL DEFAULT '0',
      `playedtime` text NOT NULL,
      `deathstate` int(5) NOT NULL DEFAULT '0',
      `TalentResetTimes` int(5) NOT NULL DEFAULT '0',
      `first_login` tinyint(1) NOT NULL DEFAULT '0',
      `forced_rename_pending` tinyint(1) NOT NULL DEFAULT '0',
      `arenaPoints` int(10) NOT NULL,
      `totalstableslots` int(10) unsigned NOT NULL DEFAULT '0',
      `instance_id` int(10) NOT NULL,
      `entrypointmap` int(10) NOT NULL,
      `entrypointx` float NOT NULL,
      `entrypointy` float NOT NULL,
      `entrypointz` float NOT NULL,
      `entrypointo` float NOT NULL,
      `entrypointinstance` int(10) NOT NULL,
      `taxi_path` int(10) NOT NULL,
      `taxi_lastnode` int(10) NOT NULL,
      `taxi_mountid` int(10) NOT NULL,
      `transporter` int(10) NOT NULL,
      `transporter_xdiff` float NOT NULL,
      `transporter_ydiff` float NOT NULL,
      `transporter_zdiff` float NOT NULL,
      `spells` longtext NOT NULL,
      `deleted_spells` longtext NOT NULL,
      `reputation` longtext NOT NULL,
      `actions` longtext NOT NULL,
      `auras` longtext NOT NULL,
      `finished_quests` longtext NOT NULL,
      `honorPointsToAdd` int(10) NOT NULL,
      `killsToday` int(10) NOT NULL DEFAULT '0',
      `killsYesterday` int(10) NOT NULL DEFAULT '0',
      `killsLifeTime` int(10) NOT NULL DEFAULT '0',
      `honorToday` int(10) NOT NULL DEFAULT '0',
      `honorYesterday` int(10) NOT NULL DEFAULT '0',
      `honorPoints` int(10) NOT NULL DEFAULT '0',
      `difficulty` int(4) NOT NULL DEFAULT '0',
      PRIMARY KEY (`guid`),
      KEY `acct` (`acct`),
      KEY `name` (`name`),
      KEY `b` (`banned`),
      KEY `c` (`online`),
      KEY `d` (`forced_rename_pending`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    SET character_set_client = @saved_cs_client;
    
    --
    -- Dumping data for table `characters`
    --
    
    LOCK TABLES `characters` WRITE;
    /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
    /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
    UNLOCK TABLES;
    find it on:
    http://mmoforge.org/svn/ascent/trunk/sql/
    login: anonymous
    no password

  6. #6
    guitargod218's Avatar Banned
    Reputation
    61
    Join Date
    Apr 2008
    Posts
    192
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah, I followed SectorSeven's guide on the ABD site. I first downloaded ascent and installed the latest revision for the Character DB, and then I updated with ABD, and it works fine for me. By the way, thanks for that guide S7!

    Here's the link to the guide: AscentBlizzlike.com • View topic - [Guide] How To Compile Ascent/ABD

    As everyone here will say, compiling yourself is 1000x better than using a repack. I recently learned this, and I'm glad I did sooner than later. Yet, I did have a problem with the Ascent download where I kept supposedly getting cut off from mmoforge.org. I had to continually right-click and press update so that the download would continue, but it wasn't too big of a problem.

    - guitargod218

Similar Threads

  1. [Arcemu]Error with SQL importer and any sql program.
    By 4l3k in forum WoW EMU Questions & Requests
    Replies: 6
    Last Post: 06-02-2009, 03:03 PM
  2. Error with ABD
    By metehan in forum World of Warcraft Emulator Servers
    Replies: 15
    Last Post: 05-09-2008, 12:00 AM
  3. Help with latest revs of everything.
    By fourn443 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 10-29-2007, 09:13 PM
  4. Flying Piggy Glider Keys Remapped to work with latest glider
    By spreech in forum World of Warcraft Bots and Programs
    Replies: 32
    Last Post: 10-13-2007, 03:02 PM
  5. Ac Ultimate Repack Error With Mysql
    By Greatdrak in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 10-03-2007, 08:35 AM
All times are GMT -5. The time now is 03:26 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search