Windows Acc Maker by Gesior for TFS 0.3.6, STEP 4

[Tekno92]

Hello. I'm installing the accmaker mentioned in topic and while I'm on step 4 it says:

Add samples to DB:
News ticker sample is already in database. New sample is not needed.
Added first news.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'direction' at row 1' in C:\xampp\htdocs\install.php:505 Stack trace: #0 C:\xampp\htdocs\install.php(505): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 505

I'm using TFS Crying Damson 0.3.6 for tibia 8.54 and I have no idea what does this error mean... please help anyone.

 

[Cykotitan]

post install.php, it's because the new mysql is being nazi about default values

 

[Tekno92]

That's the line 505 he is bitching about, I don't think it's necessary to post whole file since it's kinda huge:

$SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Rook Sample", 1, 1, 1, 0, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');

 

[swordman]

go start again from the beginning with adding tables to database, but use this install.php

 <?PHP $config['site'] = parse_ini_file('config/config.ini'); session_start(); - Pastebin.com[/url]

 

[Tekno92]

Thanks swordman, I've pasted the new install.php and it works fine, but I tried to create a new account on the website and error popped out:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1364 Field 'page_lastday' doesn't have a default value' in C:\xampp\htdocs\pot\OTS_Account.php:200 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(200): PDO->query('INSERT INTO `ac...') #1 C:\xampp\htdocs\createaccount.php(261): OTS_Account->create(0, 9999999, 'TEST') #2 C:\xampp\htdocs\index.php(136): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 200

I don't know why do I get so many errors...

 

[Tekno92]

Refresh