Roxor site much errors

[Amiroslo]

im using this [8.54] RoXoR Server v8.54 (1337ms)

and im getting this errors
but i get this error

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

and this

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

this 2

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 499

and this

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 499

 

[Zysen]

This is messed config.lua but try this:

mysqlHost = "localhost"

 

[Piltrafa]

Change This:

mysqlHost = "192.168.0.102"
mysqlUser = "root"
mysqlPass = "MYPASS"
mysqlDatabase = "YOUR DATABASE NAME (NOT SQLITE DATABASE)"
mysqlPort = 3306

 

[Amiroslo]

didnt work i tried

mysqlHost = "localhost"
mysqlHost = "my ip"

and i tried

mysqlDatabase = "YOUR DATABASE NAME (NOT SQLITE DATABASE)"

im using mysql by the way

 

[Radium]

	mysqlHost = "192.168.0.102"
	mysqlUser = "root"
	mysqlPass = "MYPASS"
	mysqlDatabase = "Roxor.s3db"
	mysqlPort = 3306

It would usually be localhost for the host.

As for the mysqlDatabase, In phpmyadmin, have you created a new database? the name of the database in there should be the name instead of "Roxor.s3db"

 

[Amiroslo]

ohh lol it says in the server i though in the httdocs now it fixed ty guys my baddddd

but i get this error

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

 

[Amiroslo]

and this

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

this 2

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 499

and this

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 499

 

[Amiroslo]

i rly need this buuump

 

[Zysen]

Open your install.php and find line 499
Open your account.php and find line 228


Copyit;and paste it here!

 

[Amiroslo]

line 499

$check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch();

acc line 228

$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ', ' . $this->db->fieldName('blocked') . ', ' . $this->db->fieldName('rlname') . ', ' . $this->db->fieldName('location') . ', ' . $this->db->fieldName('key') . ', ' . $this->db->fieldName('premium_points') . ', ' . $this->db->fieldName('page_access') . ', ' . $this->db->fieldName('premdays') . ', ' . $this->db->fieldName('lastday') . ', ' . $this->db->fieldName('created') . ' FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . (int) $id)->fetch();

 

[Zysen]

Your using Gesior AAC 0.3.6 or what?

 

[Amiroslo]

yes

 

[Amiroslo]

bump

 

[samiii]

im bumping to got the install.php error on line 499, here is the line

$check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch();

 

[lollimpo]

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

help please!

 

[Korrex]

Try activating pdo_mysql in php.ini

 

[xeexii]

STEP 4
Add samples to DB:
Added first news ticker.

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

HELP PLS?

 

[enany]

C:\xampp\htdocs\install.php on line 509



help me please

 

[Cronox]

@up
Not understand -.^ ,what your say?

 

[Loney]

C:\xampp\htdocs\install.php on line 509



help me please

Disable error reporting or switch to XAMPP 1.7.3 (if you're going to use UniServer, better).