[Characters Samples]

jacksponge · Oct 13, 2010

Could Any1 Help Me please?

Thank you
I WILL REP++

PHP:

STEP 4
Add samples to DB:
News ticker sample is already in database. New sample is not needed.
News sample is already in database. New sample is not needed.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'redskulltime' in 'field list'' in C:\xampp\htdocs\install.php:528 Stack trace: #0 C:\xampp\htdocs\install.php(528): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 528

I dont Have NO SAMPLES AT ALL. Idk Why this error is coming out :/ Help please

Another Error!!!!

STEP 4
Add samples to DB:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theforgottenserver.z_news_tickers' doesn't exist' in C:\xampp\htdocs\install.php:512 Stack trace: #0 C:\xampp\htdocs\install.php(512): PDO->query('SELECT * FROM z...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 512

:/

5mok3 · Oct 13, 2010

To fix the first one

SQL:

ALTER TABLE `players` ADD `redskulltime` BIGINT NOT NULL DEAFULT 0;

About the second one.. im not sure about the structure of that table.. so i won't bother guessing..

Let me know if you can know create your samples

Rivve · Oct 21, 2010

Or you could just
Drop players database and use

-- phpMyAdmin SQL Dump
-- version 3.3.7
-- phpMyAdmin
--
-- Host: 127.0.0.1:3306

-- Generation Time: Oct 21, 2010 at 01:58 AM
-- Server version: 5.1.50
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!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 */;

--
-- Database: `otserv`
--

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

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
`group_id` int(11) NOT NULL DEFAULT '1',
`account_id` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '1',
`vocation` int(11) NOT NULL DEFAULT '0',
`health` int(11) NOT NULL DEFAULT '150',
`healthmax` int(11) NOT NULL DEFAULT '150',
`experience` bigint(20) NOT NULL DEFAULT '0',
`lookbody` int(11) NOT NULL DEFAULT '0',
`lookfeet` int(11) NOT NULL DEFAULT '0',
`lookhead` int(11) NOT NULL DEFAULT '0',
`looklegs` int(11) NOT NULL DEFAULT '0',
`looktype` int(11) NOT NULL DEFAULT '136',
`lookaddons` int(11) NOT NULL DEFAULT '0',
`maglevel` int(11) NOT NULL DEFAULT '0',
`mana` int(11) NOT NULL DEFAULT '0',
`manamax` int(11) NOT NULL DEFAULT '0',
`manaspent` int(11) NOT NULL DEFAULT '0',
`soul` int(10) unsigned NOT NULL DEFAULT '0',
`town_id` int(11) NOT NULL DEFAULT '0',
`posx` int(11) NOT NULL DEFAULT '0',
`posy` int(11) NOT NULL DEFAULT '0',
`posz` int(11) NOT NULL DEFAULT '0',
`conditions` blob NOT NULL,
`cap` int(11) NOT NULL DEFAULT '0',
`sex` int(11) NOT NULL DEFAULT '0',
`lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
`lastip` int(10) unsigned NOT NULL DEFAULT '0',
`save` tinyint(1) NOT NULL DEFAULT '1',
`skull` tinyint(1) unsigned NOT NULL DEFAULT '0',
`skulltime` int(11) NOT NULL DEFAULT '0',
`rank_id` int(11) NOT NULL DEFAULT '0',
`guildnick` varchar(255) NOT NULL DEFAULT '',
`lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
`blessings` tinyint(2) NOT NULL DEFAULT '0',
`balance` bigint(20) NOT NULL DEFAULT '0',
`stamina` bigint(20) NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds',
`direction` int(11) NOT NULL DEFAULT '2',
`loss_experience` int(11) NOT NULL DEFAULT '100',
`loss_mana` int(11) NOT NULL DEFAULT '100',
`loss_skills` int(11) NOT NULL DEFAULT '100',
`loss_containers` int(11) NOT NULL DEFAULT '100',
`loss_items` int(11) NOT NULL DEFAULT '100',
`premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER',
`online` tinyint(1) NOT NULL DEFAULT '0',
`marriage` int(10) unsigned NOT NULL DEFAULT '0',
`promotion` int(11) NOT NULL DEFAULT '0',
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`description` varchar(255) NOT NULL DEFAULT '',
`created` int(11) NOT NULL DEFAULT '0',
`nick_verify` int(11) NOT NULL DEFAULT '0',
`old_name` varchar(255) NOT NULL DEFAULT '',
`hide_char` int(11) NOT NULL DEFAULT '0',
`comment` text NOT NULL,
`redskulltime` bigint(20) NOT NULL DEFAULT '0',
`redskull` smallint(6) NOT NULL DEFAULT '0',
`time` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`deleted`),
KEY `account_id` (`account_id`),
KEY `group_id` (`group_id`),
KEY `online` (`online`),
KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `players`
--

INSERT INTO `players` VALUES(0, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 0, 0, 0, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(1, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(2, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(3, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(4, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);

/*!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 */;

In the SQL

[Characters Samples]

jacksponge

New Member

5mok3

Emporia

Rivve

Seonbae

Similar threads