Previous Thread
Next Thread
Print Thread
Hop To
Importer fails at "Importing Banned Host"
#165038 10/06/2006 8:31 AM
Joined: Oct 2006
Posts: 23
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"
kieyeoci #165040 10/06/2006 8:40 AM
Joined: Jun 2006
Posts: 346
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"
Ron M #165042 10/06/2006 8:48 AM
Joined: Oct 2006
Posts: 23
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"
kieyeoci #165068 10/06/2006 11:30 AM
Joined: Jun 2006
Posts: 9,243
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.


Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Disaster!!! Files became empty.. Please advise.
by Morgan - 07/27/2020 2:38 PM
Unable to Update Censor List
by BOTCuser - 07/22/2020 9:15 AM
7.7.4 error on rebuilders
by Ruben - 07/21/2020 3:06 PM
[STOCK] UBB.threads Group Image Pack
by isaac - 07/19/2020 9:03 PM
Who's Online Now
1 members (1 invisible), 67 guests, and 63 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 7.7.5
(Snapshot build 20200807)