Previous Thread
Next Thread
Print Thread
Hop To
#257381 10/15/2015 1:41 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Help please, we lost our ban list in the console for some reason. Can someone tell me where to look for it in a txt file or whatever file through FTP?

sundance #257382 10/15/2015 2:45 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Well the ban list is stored in tables in the database.
There is a separate one for email,host(ip) and users.
They all begin with banned.
So the only way to restore what you had is to login to your cpanel and use something like phpmyadmin and take a peek.

Possibly they need a repair or if you have a db backup you can restore just those three tables.

FYI,
If they got wiped I would suspect the whole database need to be checked.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
sundance #257383 10/15/2015 3:06 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
BTW,
I took a peek and I don't have admin access anymore so I can't check for errors.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Ruben #257384 10/15/2015 3:38 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Ok, I changed Ruben to admin, should be able to take a look, let me know thx!

sundance #257385 10/15/2015 3:46 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Give me a moment.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
sundance #257386 10/15/2015 3:49 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I just took a peak in the database and only see the one new entry, all others are gone.

sundance #257387 10/15/2015 4:20 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Check your pm here.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Ruben #257388 10/15/2015 5:17 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Got it, thank you!

sundance #257389 10/15/2015 5:26 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Okay,
I don't think your other admin did anything wrong it is just a simple matter that the data table got hosed.
I also replied with more details at your site on that same topic.
In the admin forum.
I just got bumped off as admin but it should be there.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
sundance #257390 10/15/2015 5:35 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I cant find any backed up data tables. And I just checked the backup storage directory and ran a test and it is telling me that the test for backups is failing. So at this point I don't believe that there are any table backups.

sundance #257391 10/15/2015 5:43 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Well the last backup attempt was
06/12/15 07:19 PM
By you.
If the test fails then you need to ftp to the folder and see if it exists and then set permissions to like 755 or 777.
Same goes for server logs.
If you want I can copy paste what somebody had posted for now.
Do you have a current database backup from cpanel?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
sundance #257392 10/15/2015 5:47 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I can not find any table backups while using FTP.

I tried changing the permission and still no go.

sundance #257393 10/15/2015 5:49 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I made a new folder outside of the root called Newbackup and gave it 777. The Cpannel is still saying it is a bad dir.

Last edited by sundance; 10/15/2015 5:49 PM.
sundance #257394 10/15/2015 5:52 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Never mind I now have the folder working. Doesn't help with the lose of yesterday but never the less.

sundance #257395 10/15/2015 5:53 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Are you using the full server path to the directory, versus the virtual path your FTP client displays?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
sundance #257396 10/15/2015 5:56 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Your path was incorrect. I fixed it and it is running a backup now.
You need to do the same for mysql error logs.
It is going to take a while to complete.
I also added your old ip ban list to the database.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
sundance #257397 10/15/2015 6:05 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Yes it is working now, so any of the previous attempts must have flailed. I do have server backups every day. But I don't have the tables which now I will get pronto.

sundance #257398 10/15/2015 6:12 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Ok I just did a backup of the tables and the ubbt_BANNED_HOSTS.sql is showing something here but now I need to find a way to open this file.

sundance #257399 10/15/2015 6:14 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I have SQL Server software should I install it?

Or is this the wrong format of the table being backed up?

On table backups what is the normal file extension?

sundance #257400 10/15/2015 6:15 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I generally open any files with coding in them with notepad, edit plus plus, or edit plus; you do not want to open them with utilities that'll add additional characters, such as Word or Wordpad.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
sundance #257401 10/15/2015 6:17 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Yes the ubb cp works for table backups and will be slow.
In fact it is still running but you really should use the cpanel for database backups.
Due to if you need to restore a table or database the ubb method will make you restore one table at a time which is like 64 tables and you still need to use cpanel.
Where cpanel can let you backup the whole database and restore the whole database with one step.
Till your database gets very large.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Gizmo #257402 10/15/2015 6:19 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
The file is,
ubbt_BANNED_HOSTS.sql

I cant seem to open this with notepad?

sundance #257403 10/15/2015 6:29 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Your new backup
ubbt_BANNED_HOSTS.sql
Is only going to have what i added a few moments ago from the txt file .

And by the way I am still running a ubb cp backup.
Your import map table is huge for some reason.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 458 guests, and 91 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)