DedicatedOT
New Member
Code:
[08/07/2009 00:24:47] > MySQL ERROR mysql_real_query: INSERT INTO `guilds` (`id`, `name`, `ownerid`, `creationdata`, `motd`) VALUES (NULL , 'Ultimatum', '4', '1247030687', 'Your guild has successfully been created, to view all available commands use: <!commands>. If you would like to remove this message use <!cleanmotd>, if you would like to edit it, use <!setmotd newMotd>.'); Field 'description' doesn't have a default valueThis is what happens when I say "!createguild Ultimatum".
And, the following is a dump of my guilds, guild_ranks, guild_invites:
Code:
-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 08, 2009 at 12:27 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `guilds` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL COMMENT 'guild name - nothing else needed here',
`ownerid` int(11) NOT NULL,
`creationdata` int(11) NOT NULL,
`motd` varchar(255) NOT NULL,
`logo_gfx_name` varchar(255) NOT NULL default '''''',
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `guilds`
--
INSERT INTO `guilds` (`id`, `name`, `ownerid`, `creationdata`, `motd`, `logo_gfx_name`, `description`) VALUES
(1, 'Hello', 2, 1245802443, 'Your guild has successfully been created, to view all available commands use: <!commands>. If you would like to remove this message use <!cleanmotd>, if you would like to edit it, use <!setmotd newMotd>.', '''''', ''),
(2, 'You Suck', 2, 1245882577, 'Your guild has successfully been created, to view all available commands use: <!commands>. If you would like to remove this message use <!cleanmotd>, if you would like to edit it, use <!setmotd newMotd>.', '''''', ''),
(3, 'Jarvisland', 4, 1247030433, 'Your guild has successfully been created, to view all available commands use: <!commands>. If you would like to remove this message use <!cleanmotd>, if you would like to edit it, use <!setmotd newMotd>.', '''''', ''),
(4, 'Hallo', 4, 1247030600, 'Your guild has successfully been created, to view all available commands use: <!commands>. If you would like to remove this message use <!cleanmotd>, if you would like to edit it, use <!setmotd newMotd>.', '''''', '');
-- --------------------------------------------------------
--
-- Table structure for table `guild_invites`
--
CREATE TABLE IF NOT EXISTS `guild_invites` (
`player_id` int(10) unsigned NOT NULL default '0',
`guild_id` int(10) unsigned NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `guild_invites`
--
-- --------------------------------------------------------
--
-- Table structure for table `guild_ranks`
--
CREATE TABLE IF NOT EXISTS `guild_ranks` (
`id` int(11) NOT NULL auto_increment,
`guild_id` int(11) NOT NULL COMMENT 'guild',
`name` varchar(255) NOT NULL COMMENT 'rank name',
`level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
PRIMARY KEY (`id`),
KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `guild_ranks`
--
--
-- Constraints for dumped tables
--
--
-- Constraints for table `guild_ranks`
--
ALTER TABLE `guild_ranks`
ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;This is running on 0.2.4 Mystic Spirit. Same thing in 0.2.3.
