Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (JAISP), 68 guests, and 247 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,935
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 15
Ruben 11
Morgan 6
Abbott 2
BB 2
Latest Photos
Previous Thread
Next Thread
Print Thread
Ban List #257381
10/15/15 01:41 PM
10/15/15 01:41 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
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?

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Ban List [Re: sundance] #257382
10/15/15 02:45 PM
10/15/15 02:45 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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
Re: Ban List [Re: sundance] #257383
10/15/15 03:06 PM
10/15/15 03:06 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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
Re: Ban List [Re: Ruben] #257384
10/15/15 03:38 PM
10/15/15 03:38 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
Ok, I changed Ruben to admin, should be able to take a look, let me know thx!

Re: Ban List [Re: sundance] #257385
10/15/15 03:46 PM
10/15/15 03:46 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
Give me a moment.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Ban List [Re: sundance] #257386
10/15/15 03:49 PM
10/15/15 03:49 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
I just took a peak in the database and only see the one new entry, all others are gone.

Re: Ban List [Re: sundance] #257387
10/15/15 04:20 PM
10/15/15 04:20 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
Check your pm here.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Ban List [Re: Ruben] #257388
10/15/15 05:17 PM
10/15/15 05:17 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
Got it, thank you!

Re: Ban List [Re: sundance] #257389
10/15/15 05:26 PM
10/15/15 05:26 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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
Re: Ban List [Re: sundance] #257390
10/15/15 05:35 PM
10/15/15 05:35 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
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.

Re: Ban List [Re: sundance] #257391
10/15/15 05:43 PM
10/15/15 05:43 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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
Re: Ban List [Re: sundance] #257392
10/15/15 05:47 PM
10/15/15 05:47 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
I can not find any table backups while using FTP.

I tried changing the permission and still no go.

Re: Ban List [Re: sundance] #257393
10/15/15 05:49 PM
10/15/15 05:49 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
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/15 05:49 PM.
Re: Ban List [Re: sundance] #257394
10/15/15 05:52 PM
10/15/15 05:52 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
Never mind I now have the folder working. Doesn't help with the lose of yesterday but never the less.

Re: Ban List [Re: sundance] #257395
10/15/15 05:53 PM
10/15/15 05:53 PM
Joined: Jun 2006
Posts: 16,935
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,935
Portland, OR; USA
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.
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!
Re: Ban List [Re: sundance] #257396
10/15/15 05:56 PM
10/15/15 05:56 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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
Re: Ban List [Re: sundance] #257397
10/15/15 06:05 PM
10/15/15 06:05 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
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.

Re: Ban List [Re: sundance] #257398
10/15/15 06:12 PM
10/15/15 06:12 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
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.

Re: Ban List [Re: sundance] #257399
10/15/15 06:14 PM
10/15/15 06:14 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
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?

Re: Ban List [Re: sundance] #257400
10/15/15 06:15 PM
10/15/15 06:15 PM
Joined: Jun 2006
Posts: 16,935
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,935
Portland, OR; USA
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.
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!
Re: Ban List [Re: sundance] #257401
10/15/15 06:17 PM
10/15/15 06:17 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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
Re: Ban List [Re: Gizmo] #257402
10/15/15 06:19 PM
10/15/15 06:19 PM
Joined: Aug 2012
Posts: 115
S
sundance Offline OP
member
sundance  Offline OP
member
S
Joined: Aug 2012
Posts: 115
The file is,
ubbt_BANNED_HOSTS.sql

I cant seem to open this with notepad?

Re: Ban List [Re: sundance] #257403
10/15/15 06:29 PM
10/15/15 06:29 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
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

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Control Panel / Transactions Username
by Morgan. 06/20/18 05:38 AM
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
New Image capabilities ver 7.6.1
by Abbott. 06/14/18 02:28 PM
Thread deleted?
by Lisanne. 06/05/18 11:13 AM
Forum Statistics
Forums36
Topics35,123
Posts191,338
Members12,088
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)