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
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 (Ruben), 476 guests, and 111 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)