Couldnt establish to database

[LoLaye]

"Couldnt establish to database"

Thats what i get when i try to run my server, i already got a database and here is what i've writen in config.lua

	-- Database
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "*******"
	sqlDatabase = "******"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"

Cud anyone help please?

 

[Djivar]

besure that you are running xampp and apache. and nothing that blocks port 80

 

[Anillka]

windows ?

 

[LoLaye]

besure that you are running xampp and apache. and nothing that blocks port 80

Im running xampp and apache , and i have opened port 80

windows ?

vista

 

[Anillka]

change
sqlHost = "localhost"

TO

sqlHost = "127.0.0.1"

if u complie as 64 bits !

 

[LoLaye]

change
sqlHost = "localhost"

TO

sqlHost = "127.0.0.1"

if u complie as 64 bits !

Really thanks, rep++

EDIT:

Could anyone tell me what this is and how i do solve it?

mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'mojje.z_ots_comunication' doesn't exist (1146)

 

[devianceone]

You're using a item shop script without the tables in your database.. disabled the shop in global events.

 

[Anillka]

Really thanks, rep++

EDIT:

Could anyone tell me what this is and how i do solve it?

go to ut phpmyadmin and excute this command in Sql

CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

 

[LoLaye]

go to ut phpmyadmin and excute this command in Sql

CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Thanks again