Previous Thread
Next Thread
Print Thread
Hop To
Importer fails at "Importing Banned Host" #165038 10/06/2006 7:31 AM
Joined: Oct 2006
Posts: 23
kieyeoci Offline OP
newbie
OP Offline
newbie
Joined: Oct 2006
Posts: 23
After doing a clean install of 7.0 and running the importer script against an existing 6.5.1.1 database everything works up until this point:

Code
Importing Banned Host: NULL
Script: 
Line#: 
SQL Error: 
SQL Error #: 0
Query: insert into ubbt_BANNED_HOSTS values ( NULL )


What can I do to recover?

This is with:
  • Red Hat Enterprise Linux ES 3
  • MySQL 4.1.21-standard (installed using RPMs from MySQL website)
  • PHP 4.3.2 (latest patched version as provided by Red Hat)

Re: Importer fails at "Importing Banned Host" [Re: kieyeoci] #165040 10/06/2006 7:40 AM
Joined: Jun 2006
Posts: 346
Ron M Offline
enthusiast
Offline
enthusiast
Joined: Jun 2006
Posts: 346
Can you specify if you are using Classic or Threads?

Re: Importer fails at "Importing Banned Host" [Re: Ron M] #165042 10/06/2006 7:48 AM
Joined: Oct 2006
Posts: 23
kieyeoci Offline OP
newbie
OP Offline
newbie
Joined: Oct 2006
Posts: 23
Threads. I inspected the importer script to see what it was doing and then did some investigation with MySQL:

Code
mysql> USE old_database_name;
mysql> SELECT * FROM w3t_Banned;
+------------+
| B_Hostname |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)


I deleted that row and then resumed the import by going to http://example.com/path_to_forums/importers/threads_import.php?ubb=extras

The import then completed. I have no idea how/why that NULL value got into the table.

Re: Importer fails at "Importing Banned Host" [Re: kieyeoci] #165068 10/06/2006 10:30 AM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
I'm updating the importer scripts today so I'll put a check in to fix this.


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Who's Online Now
1 registered members (isaac), 90 guests, and 311 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)