Just installed the Forum. Just wonder where can I find wwwthreads conversion tools in the Admin Panel

You have to run the import scripts from shell (ie. you need telnet/ssh access).


Adrian

Download the Tar file but does not seem to be able to find import script.

The import script (import.pl) is located in the admin/tools directory.


Adrian

Thanks for your reply.

Run import.pl at Telnet Prompt and encounter the following error

locate GForum/Import.pm in @INC (@INC contains: /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) at import.pl line 19.

hmm... can you check if you have the files:
admin/GForum/Import/WWWThreads.pm
admin/GForum/Import/Generic.pm
admin/GForum/Import.pm
admin/tools/import.pl


Adrian

Yes, all the files are there.

I ran import.pl by using the following command at telnet

Perl import.pl

Is that the correct way ?

Full Error Message

Can't locate GForum/Import.pm in @INC (@INC contains: /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) at import.pl line 19.
BEGIN failed--compilation aborted at import.pl line 19.

Not sure what is the problem.

Can the following files

admin/GForum/Import/WWWThreads-PHP.pm
admin/GForum/Import/Generic.pm
admin/GForum/Import.pm

be moved to

admin/tools

and change the import.pl scripts slightly to run import.pl with those file in the same directory ?

At the top of import.pl make sure you have:

use lib '/usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin';

It looks like it is already there due to the content of @INC but check anyway.

The top of import.pl is as follow :-

use strict;
use lib '/usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin';
use Getopt::Long;
use GForum::Import;

Any suggestion from GT staff to help me to solve the problem ?

Hi,

From shell, can you type

pwd

from your admin directory and tell me what it says? I suspect you are running in one of these "Virtual" servers where they chroot you from the web. It makes it a pain to run any sort of shell scripts.

If I'm right, you can try typing:

perl -I/full/path/to/admin import.pl

where the path is what you got from pwd, however I suspect you may run into other problems. Try also:

virtual perl /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin/tools/import.pl

and see if it works.

Cheers,

Alex
--
Gossamer Threads Inc.

Thanks Alex.

The virtual perl method works but I encouter another problem.

perl /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin/tools/import.pl --type=WWWThreads-PHP --source=/usr/local/etc/httpd/vhosts/puppy/php --clear-database
Reading import configuration... error!
The WWWThreads version you are currently using (v) is not supported.
Import unsuccessful.

I am running only WWWThreads PHP Version 5.3

Version problem solved.

Still there are error. Message as follow :-

Reading import configuration... (1.00s) done!
Clearing Gossamer Forum database... Can't call method "fetchall_arrayref" on an undefined value at /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin/GForum/Table/Group.pm line 66.

Hi,

I'll have to get Adrian to answer this, but can you turn on debug (Setup->Misc) and re run and tell me what GT::SQL::error says?

Also, how did you fix the version problem?

Cheers,

Alex
--
Gossamer Threads Inc.

Error message in debug mode

virtual perl /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin/tools/import.pl --type=WWWThreads-PHP --source=/usr/local/etc/httpd/vhosts/puppy/php --clear-database --debug
Reading import configuration... Reading WWWThreads configuration from: /usr/local/etc/httpd/vhosts/puppy/php/config.inc.php
db config:
driver: mysql
db name: *******
db host: localhost
db user: *******
db pass: ******
Reading WWWThreads version from: /usr/local/etc/httpd/vhosts/puppy/php/main.inc.php
WWWThreads version: 5.3
Reading WWWThreads User Titles from: /usr/local/etc/httpd/vhosts/puppy/php/filters/usertitles
(1.00s) done!
Clearing Gossamer Forum database... Can't call method "fetchall_arrayref" on an undefined value at /usr/local/etc/httpd/vhosts/puppy/cgi-bin/forum/admin/GForum/Table/Group.pm line 66.

Hi,

Can you run that with --debug --debug --debug --debug? It hopefully should print out the actual SQL queries (you may have to manually turn on debugging in the admin to make it work).
We only really need everything past where it says:
"Clearing Gossamer Forum database..."


Adrian

Alex and Adrian, both of you have done excellent job I definitely did it very badly

All thing finally sorted out at our end.

Thank you very much for your guidance.

By the way, I am also thinking of getting another license to replace my another UBB. Is the conversion for UBB5.45C supported ?

What turned out to be the problem?

Unfortunately, the current UBB import being written only supports version 6. I don't believe we have a copy of version 5.x anywhere. I'll have to look and see if it's a big difference from the version 6. If it isn't, it will probably be released shortly after the version 6 import is completed.


Adrian

Made some very silly mistake. Forgot to grant privileges for forum to connect to database