Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

wwwthreads import trouble

Quote Reply
wwwthreads import trouble
I runned import.pl and I get an error.

This is from the logfile:

......
Importing Grouping data...
Importing ForumGroup data...
Importing UserNew data...
Importing ForumModerator data...
Imported WWWThreads Moderators:
$VAR = {};
Importing Post data...
Fatal Error: (NOTNULL) Column Email cannot be left blank.
Import unsuccessful.



Any idea where and how to fix this ??



--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Sir Up] wwwthreads import trouble In reply to
Can you run it with the -d -d -d arguments and post the results?

Adrian
Quote Reply
Re: [brewt] wwwthreads import trouble In reply to
Here is the last part of the logfile:

Importing ForumModerator data...
Imported WWWThreads Moderators:
$VAR = {};

Importing Post data...
GT::SQL::Driver::MYSQL::sth (1297): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'gossamer_forum_import_temp_user' from GForum::Import::WWWThreads::import_posts at /home/cycle24/public_html/sql/forum/admin/GForum/Import/WWWThreads.pm line 760
GT::SQL::Driver::MYSQL::sth (1297): Query execution took: 0.000522s from GForum::Import::WWWThreads::import_posts at /home/cycle24/public_html/sql/forum/admin/GForum/Import/WWWThreads.pm line 760
GT::SQL::Driver::MYSQL::sth (1297): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'gossamer_forum_import_temp_user' from GForum::Authenticate::auth_valid_username at GForum::Authenticate::auth_valid_username line 215
GT::SQL::Driver::MYSQL::sth (1297): Query execution took: 0.000506s from GForum::Authenticate::auth_valid_username at GForum::Authenticate::auth_valid_username line 215

GT::SQL::Table (1297): Column Email cannot be left blank. at /home/cycle24/public_html/sql/forum/admin/GT/SQL/Table.pm line 1850.
GT::SQL::Driver::MYSQL::sth (1297): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'gossamer_forum_import_temp_user' from GForum::Table::User::_plg_insert at GForum::Table::User::_plg_insert line 198
GT::SQL::Driver::MYSQL::sth (1297): Query execution took: 0.000591s from GForum::Table::User::_plg_insert at GForum::Table::User::_plg_insert line 198

Fatal Error: (NOTNULL) Column Email cannot be left blank.

Import unsuccessful.

---

Thank you



--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Sir Up] wwwthreads import trouble In reply to
Can you email me telnet/ssh access information as well as the command you're using to import so I can debug this further? Thanks.

Adrian
Quote Reply
Re: [brewt] wwwthreads import trouble In reply to
I commented out the following lines at GT:SQL:table.pm around line 1850

# Check to make sure that not_null columns without defaults have been specified
# while (my ($c, $col) = each %{$self->{schema}->{cols}}) {
# my $default = $col->{default};
# if ((not defined $set->{$c} or $set->{$c} eq '') and
# ($col->{not_null}) and # Only check for not_null columns
# (not $self->{schema}->{ai} or $c ne $self->{schema}->{ai}) and # But not the auto-increment field
# (not defined $default or $default eq '')) { # And only when there isn't a default
# $self->error(NOTNULL => WARN => $col->{form_display} || $c);
#

After this the installation runs successfull. It looks that the forum is running now without any problems.

Michael

--
Michael Skaide

http://www.cycle24.de