FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » Sporum v. 1.8b1 -> fud
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Sporum v. 1.8b1 -> fud [message #16543] Wed, 04 February 2004 20:57 Go to next message
azathosk is currently offline  azathosk   Norway
Messages: 2
Registered: February 2004
Karma: 0
Junior Member
Hi,

I was wondering if it was possible to convert a sporum-forum, over to fudforum.

Afaik sporum (a apt-get debian package) use a mysql-dbase... So is it possible? To convert sporum -> fudforum, that is.

- Azathosk
Re: Sporum v. 1.8b1 -> fud [message #16584 is a reply to message #16543] Mon, 09 February 2004 19:00 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
It would be possible if I had access to a datadump of sporum, allowing me to write a conversion script.

FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #16758 is a reply to message #16543] Tue, 17 February 2004 13:39 Go to previous messageGo to next message
azathosk is currently offline  azathosk   Norway
Messages: 2
Registered: February 2004
Karma: 0
Junior Member
Aye, thanks. I'm getting a dump as soon as the person in charge of the forum gets some spare-time Wink
Re: Sporum v. 1.8b1 -> fud [message #18665 is a reply to message #16758] Wed, 02 June 2004 18:36 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
Would you be interested in writing it for Sporum 1.5.1 as well? I can give you a database dump of the VintageKustom.com forum.

[Updated on: Wed, 02 June 2004 18:37]

Report message to a moderator

Re: Sporum v. 1.8b1 -> fud [message #18666 is a reply to message #18665] Wed, 02 June 2004 18:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Sure.

FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #18667 is a reply to message #18666] Wed, 02 June 2004 19:52 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
Ok, where do you want it sent to?
Re: Sporum v. 1.8b1 -> fud [message #18668 is a reply to message #18667] Wed, 02 June 2004 19:55 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Depends on how big it is, if it's under 2 megs you can e-mail it to me directly to ilia(at)prohost(dot)org. Otherwise put it online somewhere and give me a URL to the archive.

FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #18669 is a reply to message #18668] Wed, 02 June 2004 20:04 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
1.1MB, it's in your email.
Re: Sporum v. 1.8b1 -> fud [message #18701 is a reply to message #16543] Thu, 03 June 2004 18:30 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The converter has been written.
  • Attachment: sporum.php
    (Size: 11.63KB, Downloaded 1187 times)


FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #18703 is a reply to message #18701] Thu, 03 June 2004 19:30 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
Glancing through the file I don't see prompts for the sporum dbase name or anything. Do I install FUDforum telling it to use the Sporum settings or do I install Sporum as a separate entity and it pulls all of the dbase info from SmallPigVars.pm?
Re: Sporum v. 1.8b1 -> fud [message #18705 is a reply to message #18703] Thu, 03 June 2004 19:37 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You simply need to install FUDforum, unlock it via an admin control panel, put the spforum.php inside the forum's main directory and change the path to the SmallPigVars.pm in it.

FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #18706 is a reply to message #18705] Thu, 03 June 2004 20:22 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
Ok, I installed FUDforum and set all the settings, then ran the Sporum converter. It replaced my admin account on the new board (hayfever) with my old admin account from Sporum (Hayfever) and reset the password. Just thought you'd like to know, don't know if it was intended or not.
Re: Sporum v. 1.8b1 -> fud [message #18707 is a reply to message #18706] Thu, 03 June 2004 20:23 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This is intended behaviour.

FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #18708 is a reply to message #18707] Thu, 03 June 2004 20:27 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
Ok then, works great. Board is up and running at http://www.vintagekustom.com/FUDforum2/.
Re: Sporum v. 1.8b1 -> fud [message #18713 is a reply to message #18708] Fri, 04 June 2004 03:50 Go to previous messageGo to next message
hayfever   United States
Messages: 7
Registered: June 2004
Location: West Lafayette, IN
Karma: 0
Junior Member
I have found one possible problem with the converter, maybe nothing can be done about it. All of the posts have lost their formatting (ie paragraphs defined by spacing using enter key are all run in as one long paragraph). If I click edit it shows it as it should be formatted, then if I apply the "edit" (read: no change) the post displays properly.
Re: Sporum v. 1.8b1 -> fud [message #18725 is a reply to message #18713] Fri, 04 June 2004 13:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Try the attached conversion script and let me know if it works any better.
  • Attachment: sporum.php
    (Size: 11.66KB, Downloaded 983 times)


FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #19525 is a reply to message #18725] Fri, 30 July 2004 19:39 Go to previous messageGo to next message
sonar is currently offline  sonar   Netherlands
Messages: 3
Registered: July 2004
Karma: 0
Junior Member
I get a problem with converting from sporum 1.5.x
Some messages are imported but most aren't.
All attachements fail to be imported also.

I also get a lot of failures like this:

At the importing forums part:
Notice: Undefined index: filesize in www/test.jcwodan.nl/sporum.php on line 220

and at importing messages:
Importing Topics and Messages
WARNING: file attachment /bewaar/sporum/uploaded/D:\van compu Rob\deskjpg\0072.jpg doesn't exist
WARNING: file attachment /bewaar/sporum/uploaded/D:\mp3\Cumbat.mpeg doesn't exist
WARNING: file attachment /bewaar/sporum/uploaded/D:\mp3\Smile.gif doesn't exist
WARNING: file attachment /bewaar/sporum/uploaded/C:\Program Files\napster\Music\Onderweg - Abel .mp3 doesn't exist
WARNING: file attachment /bewaar/sporum/uploaded/C:\temp\courant-3.jpg doesn't exist
(/storage/fudforum/include/theme/default/db.inc:113
/www/test.jcwodan.nl/sporum.php:289
) 1062: Duplicate entry '16' for key 1
Query: INSERT INTO fud26_msg (id, thread_id, poster_id, post_stamp, subject, ip_addr, foff, length, file_id, apr, reply_to ) VALUES ( 16, 37, 21, 949425803, 'gala2000:diner', '192.168.1.21', 19930, 2547, 1, 1, 0)
Server Version: 4.0.18-log


These files that give an error do exist but are stored without the slashes.
for example:
/bewaar/sporum/uploaded/D:\van compu Rob\deskjpg\0072.jpg
is really:
/bewaar/sporum/uploaded/D:-van compu Rob-deskjpg-0072.jpg
Re: Sporum v. 1.8b1 -> fud [message #19536 is a reply to message #19525] Mon, 02 August 2004 13:34 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Here is a version with further fixes.
  • Attachment: sporum.php
    (Size: 11.66KB, Downloaded 1004 times)


FUDforum Core Developer
Re: Sporum v. 1.8b1 -> fud [message #19539 is a reply to message #16543] Mon, 02 August 2004 14:15 Go to previous messageGo to next message
sonar is currently offline  sonar   Netherlands
Messages: 3
Registered: July 2004
Karma: 0
Junior Member
Nope... still the same problems.
icon5.gif  Re: Sporum v. 1.8b1 -> fud [message #19582 is a reply to message #16543] Fri, 06 August 2004 20:41 Go to previous messageGo to next message
sonar is currently offline  sonar   Netherlands
Messages: 3
Registered: July 2004
Karma: 0
Junior Member
I cheked some things out ...

The first errors are because a wrong value is used..
In the sporum.php "filesize" was used but in my smallpigvars.pm it was "file_size".

And the script chooses wrong filenames..

On my computer the uploaded files are constrcuted as follows:
filename:
D:-mp3-Smile.gif
while the script searches for D:\mp3\Smile.gif

so it gives file not found.

This is the output of my sporum.php:

Finished Importing Moderators
Importing Topics and Messages
WARNING: file attachment /bewaar/sporum/uploaded/D:\mp3\Smile.gif doesn't exist
(/storage/FUDforum/include/theme/default/db.inc:113
/www/test.jcwodan.nl/sporum.php:289
) 1062: Duplicate entry '16' for key 1
Query: INSERT INTO fud26_msg (id, thread_id, poster_id, post_stamp, subject, ip_addr, foff, length, file_id, apr, reply_to ) VALUES ( 16, 96, 61, 949425803, 'gala2000:diner', '192.168.1.21', 57381, 2547, 1, 1, 0)
Server Version: 4.0.18-log
Re: Sporum v. 1.8b1 -> fud [message #19599 is a reply to message #19582] Mon, 09 August 2004 11:14 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Try the one attached.

The other two errors you showed clearly indicate that you were still using the old conversion script. The new script checks the path of the file to determine it's location. Had that failed the error would've been D:\mp3\Smile.gif and not /bewaar/sporum/uploaded/D:\mp3\Smile.gif.
The path of the file is retrieved from a database, not made by the conversion script.

Unless the file paths are 'fudged' so that \ are converted to - on the file system there shouldn't be a problem unless a file is missing. The query failure, also should've been fixed by the earlier fix as it was caused by messages with multiple attachments.
  • Attachment: sporum.php
    (Size: 11.66KB, Downloaded 1016 times)


FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Convert Font from ISO-8859-1 to Unicode-8
Next Topic: xmb 1.8 SP1 -> Fud 2.6
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 19:07:49 GMT 2024

Total time taken to generate the page: 0.03675 seconds