• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Can't Connect to my website

RunarM

RunarM

Finally back
Joined
Jul 17, 2008
Messages
1,636
Reaction score
34
Location
Norway/Tromsø
when i try to connect to my website this comes up:

Code: 
Database error - can't connect to MySQL database. Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:\Documents and Settings\Rm\Skrivebord\Server/config.lua .
3. MySQL user, password, database or host is wrong.

How can i fix that :/?
Please help!

-Runarm
 
Sort by date Sort by votes
Are you trying to connect to phpmyadmin or something similar?

First I would check and see if your ip address is correct along with your username and password. Most likely you forgot to change the information.

Hope it helped.
 
Upvote 0 Downvote
What type of website are you trying to run that requires MySql right off the bat? Are you trying to access PHPmyadmin or something? or like a high score page?
 
Upvote 0 Downvote
127001.jpg
 
Upvote 0 Downvote
Paxton said:
What website is that? Is this Gesior ACC?
Click to expand...

The one i got from you :p

Code: 
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "*******"
	sqlDatabase = "florensia"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTImeout = 10
	passwordType = "plain"
 
Upvote 0 Downvote
My system is different man xD

Go to config-and-functions.php and look at line 46, this system doesn't take passes from config.lua

Also in main folder change pass in config.php for another functions of website.
 
Upvote 0 Downvote
Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comment' in 'field list'' in C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php:112 Stack trace: #0 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php(112): PDO->query('SELECT `id`, `n...') #1 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php(140): OTS_Player->load('1') #2 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\latestnews.php(46): OTS_Player->find('Account Manager') #3 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\index.php(70): include('C:\Documents an...') #4 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\index.php(1): include('C:\Documents an...') #5 {main} thrown in C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php on line 112

i edited this:
Code: 
		$ots->connect(POT::DB_MYSQL, array('host' => "localhost", 'user' => "root", 'password' => "*******", 'database' => "florensia") );



Norix said:
Or maybe try to change the "\" in the configuration to "/"
Click to expand...

Didn't work :/
777 post!
 
Upvote 0 Downvote
RunarM said:
Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comment' in 'field list'' in C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php:112 Stack trace: #0 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php(112): PDO->query('SELECT `id`, `n...') #1 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php(140): OTS_Player->load('1') #2 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\latestnews.php(46): OTS_Player->find('Account Manager') #3 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\index.php(70): include('C:\Documents an...') #4 C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\index.php(1): include('C:\Documents an...') #5 {main} thrown in C:\Documents and Settings\Rm\Skrivebord\Florensia\htdocs\includes\pot\OTS_Player.php on line 112

i edited this:
Code: 
		$ots->connect(POT::DB_MYSQL, array('host' => "localhost", 'user' => "root", 'password' => "*******", 'database' => "florensia") );





Didn't work :/
777 post!
Click to expand...

Export database from Florensiaots.com You got wrong database version.
 
Upvote 0 Downvote
Back
Top