- #2
Check with your host, it’s likely a security issue with mod_sec or something similar.
- #3
Check with your host, it’s likely a security issue with mod_sec or something similar.
Thanks just read the sticky too and sent a ticket vĩ đại host...
PS: I had two sites on this host and recently moved Xenforo vĩ đại the other site on same host. (Combined two sites into one). Everything was working great after the move for weeks. Today they deleted old site which xenforo was at and this is when new site which was working for weeks triggered the error. Just some more history that may help track down what happened.
Last edited:
- #4
Having issues with database! I have another host migrating my site vĩ đại their server and Forum is still having same issue. Is it even possible when I transferred diễn đàn vĩ đại new tên miền it was using database from another cpanel? Therefore when old host deleted the site i didnt need anymore the database was also gone. Is that even possible. Would the database move into cpanel when i moved the diễn đàn thư mục weeks ago?
- #5
If it was a cPanel vĩ đại cPanel transfer on a new host, everything should have migrated.
Who are you hosting with? Have you looked at the page source vĩ đại see what (if anything) it says?
- #6
If it was a cPanel vĩ đại cPanel transfer on a new host, everything should have migrated.
Who are you hosting with? Have you looked at the page source vĩ đại see what (if anything) it says?
All I did was tải về the subdiretcory thư mục and uploaded it and it was working for weeks. When they deleted old site I got this error. Now new migrating host says he cant find the database and gettimg same error.
view source:
An unexpected database error occurred. Please try again later.
PS this error was before migration! I started migration because many said it was a server issue blocking etc MOD_sec or some security
- #7
I replied vĩ đại your ticket this morning.
The error in the first post is due vĩ đại the mysql database details on the server no longer matching what is in the src/config.php
tệp tin.
- #8
I replied vĩ đại your ticket this morning.
The error in the first post is due vĩ đại the mysql database details on the server no longer matching what is in the
src/config.php
tệp tin.
I'm guessing somehow XEnforo was using database from another cpanel :/ I didnt even think that was possible...Hence when second site was deleted so sánh was databases
- #9
XF can't connect vĩ đại a database on a different host/server unless there is some very specific configuration phối up (which is very unlikely).
You or your host have made changes vĩ đại the database log in credentials on the server where XF is installed.
- #10
XF can't connect vĩ đại a database on a different host/server unless there is some very specific configuration phối up (which is very unlikely).
You or your host have made changes vĩ đại the database log in credentials on the server where XF is installed.
I kinda figured that cant be possible when I moved Xen it was working for weeks. What I dont understand is why cant new host doing the migration find the database :/ very frustrating..
- #11
Think if I roll it back vĩ đại when it was working it will resolve itself
Also where is database stored in the directory?
Last edited:
- #12
The DB is NOT stored in your XF directory... it's in a totally separate location on a server that odds are you CANNOT gain access vĩ đại if you are on shared hosting. If you are on a VPS or dedicated server you can. So the XF files that were copied over had nothing (other kêu ca contents of one file) vĩ đại vì thế with it.
What happened in that a new mySQL trương mục was created for the DB that was pulled from the old site... you simply copied your XF directory over, and did NOT update the mySQL credentials in your config.php vĩ đại reflect the new server/hosting instance of mySQL. And honestly, a cPanel->cPanel transfer should have done that.
Once more, what "new" hosting provider are you using?
- #13
The DB is NOT stored in your XF directory... it's in a totally separate location on a server that odds are you CANNOT gain access vĩ đại if you are on shared hosting. If you are on a VPS or dedicated server you can. So the XF files that were copied over had nothing (other kêu ca contents of one file) vĩ đại vì thế with it.
What happened in that a new mySQL trương mục was created for the DB that was pulled from the old site... you simply copied your XF directory over, and did NOT update the mySQL credentials in your config.php vĩ đại reflect the new server/hosting instance of mySQL. And honestly, a cPanel->cPanel transfer should have done that.
Once more, what "new" hosting provider are you using?
Knownhost is new host but I’m confused on why it was working for weeks…
- #14
All I need is data base referenced vĩ đại Xen correct. Host activated it for bầm vĩ đại pull database.
-
3868EF66-1D6A-435E-BC3D-0763A8EBDDE4.webp
167.4 KB · Views: 27
- #15
If that is the database for XF, yes.
Confirm in the config tệp tin - the DB name will be listed there.
- #16
Thanks new host for it sorted out! Thank you everyone….
- #17
Just for my own knowledge if I wanted vĩ đại get the old site vĩ đại work before the move so sánh we can delete the old site (three) vì thế I upload the database and overwrite? Still very confused how the two sites are working off same database
- #18
Mayhap I've imbibed in vĩ đại much holiday cheer... but I really now don't quite understand what's going on.
I thought you had ALREADY moved vĩ đại the new site and migrated over? Is the old host still running the old site? It should have really been brought offline right prior vĩ đại the move so sánh no new nội dung could be added vĩ đại it which would be lost if the same data is going vĩ đại the new site... because if you have the old site running and then the new site phối up with the old sites DB... there's no "easy" merge. One or the other.
Now, if you phối the new site up as a totally NEW site with NO users nor nội dung, you might be able vĩ đại merge the old site (and all it's content) into it... but I have a feeling from the questions you've had that is not exactly what was going on, as it's rather detailed in what needs vĩ đại be done.
You can have 15 thousand sites running off the "same database" if each database is hosted with a different provider and the tệp tin contents for the site(s) are present, or you can even have multiple sites reading/writing vĩ đại the SAME database, and those sites CAN be in remote locations... but again, that takes a little more work that most think.
I think you STILL think that the DB is a "physical file" that gets copied with your XF tệp tin structure... it's not. It IS a physical tệp tin on the server... but generally it's in /var/lib/mysql
, a location that on a shared hosting you will have NO access vĩ đại.
You simply vì thế a DB dump of the data into a different physical tệp tin, then you can take that DB dump and import it into another instance of mySQL on another server.
- #19
Mayhap I've imbibed in vĩ đại much holiday cheer... but I really now don't quite understand what's going on.
I thought you had ALREADY moved vĩ đại the new site and migrated over? Is the old host still running the old site? It should have really been brought offline right prior vĩ đại the move so sánh no new nội dung could be added vĩ đại it which would be lost if the same data is going vĩ đại the new site... because if you have the old site running and then the new site phối up with the old sites DB... there's no "easy" merge. One or the other.
Now, if you phối the new site up as a totally NEW site with NO users nor nội dung, you might be able vĩ đại merge the old site (and all it's content) into it... but I have a feeling from the questions you've had that is not exactly what was going on, as it's rather detailed in what needs vĩ đại be done.
You can have 15 thousand sites running off the "same database" if each database is hosted with a different provider and the tệp tin contents for the site(s) are present, or you can even have multiple sites reading/writing vĩ đại the SAME database, and those sites CAN be in remote locations... but again, that takes a little more work that most think.
I think you STILL think that the DB is a "physical file" that gets copied with your XF tệp tin structure... it's not. It IS a physical tệp tin on the server... but generally it's in/var/lib/mysql
, a location that on a shared hosting you will have NO access vĩ đại.
You simply vì thế a DB dump of the data into a different physical tệp tin, then you can take that DB dump and import it into another instance of mySQL on another server.
I’ll admit I’m a bit confused but sorting it out slowly.
I am in the process of moving and actually stuck because I can’t get my host tệp tin vĩ đại solve IP vĩ đại my tên miền vĩ đại test it out vĩ đại move along.
So I figure why not repair old site so sánh old host can take down site number three that was merged into one main site (the one being moved) . This way old site will be intact until move is complete. I understand easy merge but fortunately my diễn đàn is super slow so sánh I don’t have vĩ đại worry about losing any post on switch.
I just put a lot of time into this site and don’t want vĩ đại lose anything and hate vĩ đại see it broken
Thanks for your input…
Now back vĩ đại this host tệp tin nonsense…
- #20
Ok now testing on new host and when I lập cập a tệp tin kiểm tra I get this about vĩ đại throw in the towel on this…..
-
AE2CCF60-ACA6-4910-91C9-61591E245273.webp
251 KB · Views: 22