[Help] GRR... always error with ascent.exe

[LordJedi]

pls help me for that error i executed some sql files but i tryed the other database too (sry about my english )

[Clain]

Get the structure for the tables item_randomprop_groups and item_randomsuffix_groups. I can't get you the structure for the tables atm

[**Sweeny**]

Have you tried using other repacks/databases or just that one?

[Gastricpenguin]

Save this code as an SQL file then execute it into your world database, and it should work fine.

-- MySQL dump 10.13
--
-- Host: localhost    Database: world
-- ------------------------------------------------------
-- Server version 5.1.22-rc-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `item_randomsuffix_groups`
--
DROP TABLE IF EXISTS `item_randomsuffix_groups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `item_randomsuffix_groups` (
  `entry_id` int(30) NOT NULL,
  `randomsuffix_entryid` int(30) NOT NULL,
  `chance` float NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `item_randomsuffix_groups`
--
LOCK TABLES `item_randomsuffix_groups` WRITE;
/*!40000 ALTER TABLE `item_randomsuffix_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_randomsuffix_groups` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2007-10-14 22:28:52
 
-- MySQL dump 10.13
--
-- Host: localhost    Database: world
-- ------------------------------------------------------
-- Server version 5.1.22-rc-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `item_randomprop_groups`
--
DROP TABLE IF EXISTS `item_randomprop_groups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `item_randomprop_groups` (
  `entry_id` int(30) NOT NULL,
  `randomprops_entryid` int(30) NOT NULL,
  `chance` float NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `item_randomprop_groups`
--
LOCK TABLES `item_randomprop_groups` WRITE;
/*!40000 ALTER TABLE `item_randomprop_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_randomprop_groups` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2007-10-14 22:29:04

[Spartansp]

try using other repacks Spartansp Repack V3 is already been released BTW :P

[**Sweeny**]

soz for double post but here are the tables

 
CREATE TABLE `item_randomprop_groups` (  `entry_id` int(30) NOT NULL,  `randomprops_entryid` int(30) NOT NULL,  `chance` float NOT NULL,  PRIMARY KEY  (`entry_id`,`randomprops_entryid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';

 
CREATE TABLE `item_randomsuffix_groups` (  `entry_id` int(30) NOT NULL,  `randomsuffix_entryid` int(30) NOT NULL,  `chance` float NOT NULL,  PRIMARY KEY  (`entry_id`,`randomsuffix_entryid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item System';

[LordJedi]

Save this code as an SQL file then execute it into your world database, and it should work fine.


Code:
-- MySQL dump 10.13---- Host: localhost Database: world-- -------------------------------------------------------- Server version 5.1.22-rc-community/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `item_randomsuffix_groups`--DROP TABLE IF EXISTS `item_randomsuffix_groups`;SET @saved_cs_client = @@character_set_client;SET character_set_client = utf8;CREATE TABLE `item_randomsuffix_groups` ( `entry_id` int(30) NOT NULL, `randomsuffix_entryid` int(30) NOT NULL, `chance` float NOT NULL,) ENGINE=MyISAM DEFAULT CHARSET=latin1;SET character_set_client = @saved_cs_client;---- Dumping data for table `item_randomsuffix_groups`--LOCK TABLES `item_randomsuffix_groups` WRITE;/*!40000 ALTER TABLE `item_randomsuffix_groups` DISABLE KEYS */;/*!40000 ALTER TABLE `item_randomsuffix_groups` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2007-10-14 22:28:52 -- MySQL dump 10.13---- Host: localhost Database: world-- -------------------------------------------------------- Server version 5.1.22-rc-community/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `item_randomprop_groups`--DROP TABLE IF EXISTS `item_randomprop_groups`;SET @saved_cs_client = @@character_set_client;SET character_set_client = utf8;CREATE TABLE `item_randomprop_groups` ( `entry_id` int(30) NOT NULL, `randomprops_entryid` int(30) NOT NULL, `chance` float NOT NULL,) ENGINE=MyISAM DEFAULT CHARSET=latin1;SET character_set_client = @saved_cs_client;---- Dumping data for table `item_randomprop_groups`--LOCK TABLES `item_randomprop_groups` WRITE;/*!40000 ALTER TABLE `item_randomprop_groups` DISABLE KEYS */;/*!40000 ALTER TABLE `item_randomprop_groups` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2007-10-14 22:29:04

i tryed but it says...

[LordJedi]

soz for double post but here are the tables


Code:
CREATE TABLE `item_randomprop_groups` ( `entry_id` int(30) NOT NULL, `randomprops_entryid` int(30) NOT NULL, `chance` float NOT NULL, PRIMARY KEY (`entry_id`,`randomprops_entryid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
Code:
CREATE TABLE `item_randomsuffix_groups` ( `entry_id` int(30) NOT NULL, `randomsuffix_entryid` int(30) NOT NULL, `chance` float NOT NULL, PRIMARY KEY (`entry_id`,`randomsuffix_entryid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item System';

YEAH!!!!!! Dude thx +repu yeah ty