Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

WWWTheards import problems

Quote Reply
WWWTheards import problems
Hello!

using the import.pl with the command

--type=WWWTheards --....

it does not import.

It says that the data could not be imported as the version (v1) is not supported!

Is this true?

Thanks


Quote Reply
Re: [rajani] WWWTheards import problems In reply to
What version of WWWThreads are you running? Hopefully you aren't running version 1 since that must be pretty darn old!


Adrian
Quote Reply
Re: [brewt] WWWTheards import problems In reply to
Hello Adrian!

Oh, thanks for your reply.

I use 5.x.x version and so I was surprised that it said that it did NOT support.

It is a version that I got before half a year. So either it is 5.1.x or 5.2.x!

I could however check it out. But, I mean it should work in both as there were no table field changes, you know.

Last edited by:

rajani: Nov 23, 2001, 5:35 AM
Quote Reply
Re: [rajani] WWWTheards import problems In reply to
Can you post or send me what $w3t::VERSION is in modules/w3t.pm?
eg:
$w3t::VERSION = "5.3<i>perl</i>";

Thanks.


Adrian
Quote Reply
Re: [brewt] WWWTheards import problems In reply to
Hello!

Funny!

Here it says the following:

$w3t::VERSION = "1";

This is a surprise indeed.

I will check in the original file and figure out why it should say this.

But it is really 5.x.x, because I have downloaded and installed. This could be a bug from the original.

If this is the only problem, then it should be no problem to write manually the real version number.

I will try this too and report further..

However, it was clever of you indeed, I must say, I would have never come to the idea to check here.
Quote Reply
Re: [rajani] WWWTheards import problems In reply to
Yeah, if you know for sure it's version 5.x then you should be able to change it without any problems. Just make sure you change it to the version number that it actually is.


Adrian
Quote Reply
Re: [brewt] WWWTheards import problems In reply to
Hello Adrian!

Thanks! That was the problem. I simply changed the version number in there and it went further. Thats was clever of you.

However now it gives some more problems. They are as follows:

Importing Forum table data... DBD::mysql::st execute failed: Unknown column 'Cat
_Keyword' in 'where clause' at XXX/cgi-bin/GForum/Import/WWWThreads.pm line 550.

DBD::mysql::st fetchrow failed: fetch() without execute() at /cgi-bin/forum/admin/GForum/Import/WWWThreads.pm line 551.
error!

Fatal Error: (ILLEGALVAL) Category can not contain the value '[undefined]'
Import unsuccessful.

Any ideas as to what could be the problem?

Shall I just create a field that it needs or?

Quote Reply
Re: [rajani] WWWTheards import problems In reply to
You must not have version 5.1 of WWWThreads since the column Cat_Keyword was removed from v5.1 and later. Make sure you have the right version number set in the w3t.pm file. You probably have a newer version than 5.1.


Adrian
Quote Reply
Re: [brewt] WWWTheards import problems In reply to
Hello!

Thanks for your reply.

I substituted the right version number i.e. 5.1.5 and it gives following error:

Importing User table data... done!
Importing Category table data... done!
Importing Forum table data... done!
Importing UserNew table data... done!
Importing ForumModerator table data... done!
Importing Post table data... done!
Updating depth on posts... done!
Importing PostAttachment table data... done!
Importing ForumSubscriber table data... done!
Importing Message table data... done!
Importing MessageAttachment table data... done!
Importing Grouping table data... done!
Importing ForumGroup table data... error!
Fatal Error: group_id_fk can not contain the value '[undefined]'
Import unsuccessful.

Clear and append switches works the same. Debug options did not show anything more.

Any idea?

Thanks
Quote Reply
Re: [rajani] WWWTheards import problems In reply to
Can you run it with --debug --debug --logfile import.log
and send me the file?


Adrian
Quote Reply
Re: [brewt] WWWTheards import problems In reply to
Hello there!

In Reply To:
Can you run it with --debug --debug --logfile import.log

After having understood your hint of:

--debug --debug

I ran

--debug --debug --debug --debug

and found out that it had a group less then it needed to be. This may have got currupted or do not know where this came from. But I simply traced the mappings the import.pl was creating. Found out the followng


Imported ForumGroup data:
$VAR = {
'forum_perms' => '5',
'forum_id_fk' => '10',
'group_id_fk' => undef
};

Fatal Error: group_id_fk can not contain the value '[undefined]'
Import unsuccessful.

And came to a conclusion that one group was needed for the import as it dies saying "undefined = missing!!!"

By creating one, the import went smooth and flawless.

In between I also did an update from 5.1.x to 5.4 the actual one, just in case to reduce compatibility problems during the imports.

I am really thankful to you for the hints. This did help me to the final catchup. The problem was not in the programming but in the missing fields of the database due to the earlier versions.

Thanks anyway. (I hate not only computers, but also trouble shooting)