[FIXES] Some Basic Fixes for problems that a lot of new Starters have in Gesior Acc

[Mogex]

Hi ho Otlanders,
There's some fixes that may help if you have this errors in gesior.

1ST problem

Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 40
Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 52
Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 63

Fix:

Open your xampp folder, open php folder and edit in text editor file php.ini
Find line with:
error_reporting =
and replace this line (text after = too) with:
error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED
make sure that ; is not a first letter in this line!
Open XAMPP Control and restart Apache or if you don't know how just restart PC

2ND Problem

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 237

Fix:

alter table `accounts` add `vip_time` INT NOT NULL;

3rd Problem

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'priority' in 'field list'' in C:\xampp\htdocs\bug.php:339 Stack trace: #0 C:\xampp\htdocs\bug.php(339): PDO->query('INSERT INTO `z_...') #1 C:\xampp\htdocs\index.php(81): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\bug.php on line 339

Fix:

ALTER TABLE z_bug_tracker
ADD priority int(10);

EDIT 4 Problem

Warning: Error parsing C:/Users/*****/Desktop/*****/config.lua on line 17 in C:\xampp\htdocs\install.php on line 130
File config.lua loaded from C:/Users/*****/Desktop/*****/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.

Rmove Config.lua Notes

BEST SOLUTION IF YOU CAN'T FIX Gesior?

http://otland.net/f479/nothing-full...niform-server-forgotten-server-0-3-6-a-77593/

 

[Mogex]

Refresh

 

[Polat Alemdar]

Good Job this helped me!
thanks bro rep+

 

[Mogex]

Good Job this helped me!
thanks bro rep+

I'm glad that Helped you

 

[Mogex]

f5 gesiors

 

[gullefjung]

Hey, i get this error in "4. Add samples to DB"

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`rlamp`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE)' in C:\xampp\htdocs\install.php:516 Stack trace: #0 C:\xampp\htdocs\install.php(516): PDO->query('INSERT INTO `pl...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 516

 

[renancs]

u save me, ~signed

 

[svettis-]

What do you mean with the last solution? 'Remove config.lua notes'?

 

[sickem]

all the lines with -- infront of it delete it, simple.

 

[Maxens]

EDIT 4 Problem
Lua Code:
Warning: Error parsing C:/Users/*****/Desktop/*****/config.lua on line 17 in C:\xampp\htdocs\install.php on line 130
File config.lua loaded from C:/Users/*****/Desktop/*****/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.


Rmove Config.lua Notes








What u mean with "Rmove Config.lua Notes"?? I dont get it^^



EDIT: Okey now i know it

 

[Mogex]

EDIT 4 Problem
Lua Code:
Warning: Error parsing C:/Users/*****/Desktop/*****/config.lua on line 17 in C:\xampp\htdocs\install.php on line 130
File config.lua loaded from C:/Users/*****/Desktop/*****/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.



Rmove Config.lua Notes








What u mean with "Rmove Config.lua Notes"?? I dont get it^^



EDIT: Okey now i know it

If you have in config.lua
- NOTE: ......
you should delete them or delete two of them, the stamina one and where's something like "FLAGS_" don't remember.

 

[lilramon]

ok were is php

 

[Gollum]

Quite dumb question, im a newbie. Where should i add, alter table `accounts` add `vip_time` INT NOT NULL; ?

 

[Mogex]

Quite dumb question, im a newbie. Where should i add, alter table `accounts` add `vip_time` INT NOT NULL; ?

In your database.

 

[row900]

Warning: syntax error, unexpected '(' in C:/Users/****/Desktop/****/config.lua on line 17 in C:\xampp\htdocs\install.php on line 177
Database error. Unknown database type in C:/Users/****/Desktop/****/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

HOW FIXED ??

I Want Fast Answer

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "****"
sqlDatabase = "****"
sqlFile = "lol.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"