General Error (SQL Error)
-
- New to forums
- Posts: 7
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sun May 22, 2016 6:52 pm
General Error (SQL Error)
Hey, I recently changed the name of my package, I have a website, game server and teamspeak. I could access my phpbb forums before I changed the name. I sent a support ticket but there was not much that could be done. The guy(s) that helped me said it was all they could do and they could not offer full web support. They said I should come here and ask.
This is the error that I get when I try to access my site. ([name].site.nfoservers.com)
General Error
SQL ERROR [ mysqli ]
Access denied for user '[name]'@'localhost' (using password: YES) [1045]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I can login to the phpmyadmin at [name].site.nfoservers.com/phpmyadmin
This is the error that I get when I try to access my site. ([name].site.nfoservers.com)
General Error
SQL ERROR [ mysqli ]
Access denied for user '[name]'@'localhost' (using password: YES) [1045]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I can login to the phpmyadmin at [name].site.nfoservers.com/phpmyadmin
-
- New to forums
- Posts: 7
- Joined: Sun May 22, 2016 6:52 pm
Re: General Error (SQL Error)
In my config.php file, I have filled in exactly what is on my databases tab
This is my config.php file:
<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = '[name]_forum';
$dbuser = '[name]';
$dbpasswd = 'XXXXXXXX';
$table_prefix = 'phpbb_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';
@define('PHPBB_INSTALLED', true);
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
// @define('DEBUG', true);
// @define('DEBUG_CONTAINER', true);
This is my config.php file:
<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = '[name]_forum';
$dbuser = '[name]';
$dbpasswd = 'XXXXXXXX';
$table_prefix = 'phpbb_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';
@define('PHPBB_INSTALLED', true);
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
// @define('DEBUG', true);
// @define('DEBUG_CONTAINER', true);
Re: General Error (SQL Error)
Did you also update the user? When you change your identifier your MySQL username also changes with it.
@Kraze^NFo> Juski has a very valid point
@Juski> Got my new signature, thanks!
@Kraze^NFo> Out of context!
@Juski> Doesn't matter!
@Juski> You said I had a valid point! You can't take it back now! It's out there!
@Juski> Got my new signature, thanks!
@Kraze^NFo> Out of context!
@Juski> Doesn't matter!
@Juski> You said I had a valid point! You can't take it back now! It's out there!
-
- New to forums
- Posts: 7
- Joined: Sun May 22, 2016 6:52 pm
Re: General Error (SQL Error)
Yes, the dbuser is the same as the user on my databases tab.
Edit: for some reason the [name]@localhost has a different name to what I changed in the config tab.
The [name]@localhost has the name of my first identifier, but in the config.php file I have the name of my new identifier, not sure what is going on there.
Edit: for some reason the [name]@localhost has a different name to what I changed in the config tab.
The [name]@localhost has the name of my first identifier, but in the config.php file I have the name of my new identifier, not sure what is going on there.
Re: General Error (SQL Error)
Can you post a link to your site?
@Kraze^NFo> Juski has a very valid point
@Juski> Got my new signature, thanks!
@Kraze^NFo> Out of context!
@Juski> Doesn't matter!
@Juski> You said I had a valid point! You can't take it back now! It's out there!
@Juski> Got my new signature, thanks!
@Kraze^NFo> Out of context!
@Juski> Doesn't matter!
@Juski> You said I had a valid point! You can't take it back now! It's out there!
-
- New to forums
- Posts: 7
- Joined: Sun May 22, 2016 6:52 pm
Re: General Error (SQL Error)
celestial.site.nfoservers.com
But in my config.php, dbuser is celestial
But in my config.php, dbuser is celestial
Re: General Error (SQL Error)
Try downloading an update package from phpBB and uploading the "/install" folder. Once uploaded go to yourdomain.com/install/database_update.php and see if that will cause it to reread the config.
@Kraze^NFo> Juski has a very valid point
@Juski> Got my new signature, thanks!
@Kraze^NFo> Out of context!
@Juski> Doesn't matter!
@Juski> You said I had a valid point! You can't take it back now! It's out there!
@Juski> Got my new signature, thanks!
@Kraze^NFo> Out of context!
@Juski> Doesn't matter!
@Juski> You said I had a valid point! You can't take it back now! It's out there!
Re: General Error (SQL Error)
Just a thought - make sure you don't have two config files with different user data.
-
- New to forums
- Posts: 7
- Joined: Sun May 22, 2016 6:52 pm
Re: General Error (SQL Error)
Ok, I will try that when I get home, thanks for your help so far!kraze wrote:Try downloading an update package from phpBB and uploading the "/install" folder. Once uploaded go to yourdomain.com/install/database_update.php and see if that will cause it to reread the config.
-
- New to forums
- Posts: 7
- Joined: Sun May 22, 2016 6:52 pm
Re: General Error (SQL Error)
There is only 1 config that I know of, unless there are different configs in different locations with the same data.doulos9 wrote:Just a thought - make sure you don't have two config files with different user data.
-
- New to forums
- Posts: 7
- Joined: Sun May 22, 2016 6:52 pm
Re: General Error (SQL Error)
It worked! Thanks for the help guyskraze wrote:Try downloading an update package from phpBB and uploading the "/install" folder. Once uploaded go to yourdomain.com/install/database_update.php and see if that will cause it to reread the config.