huge errors after changing domains, please help!!

zoldos · Post by **zoldos** » Thu Oct 31, 2019 1:55 am

I changed domains and changed the cookie domain, and domain name in ACP, but I get this error on the index page:

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 258: mysqli_fetch_assoc(): Couldn't fetch mysqli_result
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 320: mysqli_free_result(): Couldn't fetch mysqli_result
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 258: mysqli_fetch_assoc(): Couldn't fetch mysqli_result
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 320: mysqli_free_result(): Couldn't fetch mysqli_result
Return to index page	
General Error
NO_STYLE_DATA

Please notify the board administrator or webmaster: trifecta@trifectasyndicate.com

Help!!!

2600 · Post by **2600** » Thu Oct 31, 2019 5:32 am

It may be worthwhile to download your database file, back it up then copy it to the desktop. Now open it up with Notepad ++ and do a search and replace with your old domain to your new domain. Save and upload the new modified database file to phpMyadmin. This is what I have done when I changed domains not once but twice. Though, the real method to do this is through a series of SQL command queries.

I'm wondering if that error is in relation to the aforementioned database location located in your config.php file. Did you upload a new database for this new domain? If so, it needs to be reflected in the config.php file with the database name, user, password and other potential options.

You might also want to go into the cache folder and delete the production folder. It will rebuild.

zoldos · Post by **zoldos** » Thu Oct 31, 2019 10:31 am

Thank you so much! Cleared the "Production" folder and the site came right up.

2600 · Post by **2600** » Fri Nov 01, 2019 3:34 am

You're welcome. I thought it might have been that, wasn't entirely sure. I know that when I first started out and changed from a free domain to a paid for host I had the same issue.

It's amazing at how much the cache can do things. Since I use CloudFlare, not only do I have to put the site into Development mode in CloudFlare and clear its cache, but I also have to clear the board's cache as well. Then there's your browser. Several months back someone also had to clear out their DNS cache on their computer. So if someone else is reading this for help you might want to try that as well.

zoldos · Post by **zoldos** » Fri Nov 01, 2019 8:40 am