Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2006
Posts: 23
K
newbie
newbie
K Offline
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)

Joined: Jun 2006
Posts: 346
R
enthusiast
enthusiast
R Offline
Joined: Jun 2006
Posts: 346
Can you specify if you are using Classic or Threads?

Joined: Oct 2006
Posts: 23
K
newbie
newbie
K Offline
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.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I'm updating the importer scripts today so I'll put a check in to fix this.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (1 invisible), 875 guests, and 141 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)