General Error (SQL Error)

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
UnknownFusion
New to forums
New to forums
Posts: 7
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sun May 22, 2016 6:52 pm

General Error (SQL Error)

Post by UnknownFusion »

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
UnknownFusion
New to forums
New to forums
Posts: 7
Joined: Sun May 22, 2016 6:52 pm

Re: General Error (SQL Error)

Post by UnknownFusion »

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);
User avatar
kraze
Former staff
Former staff
Posts: 4362
Joined: Fri Sep 17, 2010 9:06 am
Location: California

Re: General Error (SQL Error)

Post by kraze »

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!
UnknownFusion
New to forums
New to forums
Posts: 7
Joined: Sun May 22, 2016 6:52 pm

Re: General Error (SQL Error)

Post by UnknownFusion »

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.
User avatar
kraze
Former staff
Former staff
Posts: 4362
Joined: Fri Sep 17, 2010 9:06 am
Location: California

Re: General Error (SQL Error)

Post by kraze »

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!
UnknownFusion
New to forums
New to forums
Posts: 7
Joined: Sun May 22, 2016 6:52 pm

Re: General Error (SQL Error)

Post by UnknownFusion »

celestial.site.nfoservers.com

But in my config.php, dbuser is celestial
User avatar
kraze
Former staff
Former staff
Posts: 4362
Joined: Fri Sep 17, 2010 9:06 am
Location: California

Re: General Error (SQL Error)

Post by kraze »

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!
doulos9
This is my homepage
This is my homepage
Posts: 200
Joined: Sun Sep 15, 2013 9:44 pm

Re: General Error (SQL Error)

Post by doulos9 »

Just a thought - make sure you don't have two config files with different user data.
UnknownFusion
New to forums
New to forums
Posts: 7
Joined: Sun May 22, 2016 6:52 pm

Re: General Error (SQL Error)

Post by UnknownFusion »

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.
Ok, I will try that when I get home, thanks for your help so far! :)
UnknownFusion
New to forums
New to forums
Posts: 7
Joined: Sun May 22, 2016 6:52 pm

Re: General Error (SQL Error)

Post by UnknownFusion »

doulos9 wrote:Just a thought - make sure you don't have two config files with different user data.
There is only 1 config that I know of, unless there are different configs in different locations with the same data.
UnknownFusion
New to forums
New to forums
Posts: 7
Joined: Sun May 22, 2016 6:52 pm

Re: General Error (SQL Error)

Post by UnknownFusion »

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.
It worked! Thanks for the help guys :)
Post Reply