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

Home » FUDforum » FUDforum Installation Issues » phpBB import failed with FUDforum 2.7.3RC1
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
phpBB import failed with FUDforum 2.7.3RC1 [message #27830] Tue, 27 September 2005 21:18 Go to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
Hi,

As I'm tired of phpBB, I'm thinking in moving my foruns to FUD Forum.
To test it, I've created an experimental FUD forum and I've imported the phpBB 2 data, but it didn't work correctly. It imported everything but the message's text.
The original forum: http://www.fnei.net/forum/
The test forum: http://www.fnei.net/fudforum/

FUDforum: 2.7.3RC1

Is anyone experiencing the same? Do you want any debug info?

Regards,
Nuno

P.S.: yes, Ilia, I'm Nuno from PHP.net Wink
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27831 is a reply to message #27830] Tue, 27 September 2005 21:21 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
Did you run the conversion script on the command line or via the browser? I suspect the script didn't have permissions to write to the messages/ directory where the message bodies are being stored.

FUDforum Core Developer
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27832 is a reply to message #27831] Tue, 27 September 2005 21:29 Go to previous messageGo to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
Ilia wrote on Tue, 27 September 2005 22:21

Did you run the conversion script on the command line or via the browser? I suspect the script didn't have permissions to write to the messages/ directory where the message bodies are being stored.


yayck, what a fast answer.. Smile

Yep, I have run it from the browser.
The initial directory (public_html/fudforum) had permitions set to 777. I've checked now and the messages's dir permissions are 711. Well, this is not good, but maybe the installer could have take care of it (safe mode is disabled).

I'll run the converter script again after changing the dir permissions.

Nuno

P.S.: BTW, the forum only become usable after running the consistency test.
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27834 is a reply to message #27830] Tue, 27 September 2005 21:42 Go to previous messageGo to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
Ahah.
Update: the script works fine after I run the 'Forum Consistency' test.
It only breaks the forum after I run the 'Compact Messages' script. Anyway the messages folder is always empty.

Nuno
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27835 is a reply to message #27832] Tue, 27 September 2005 21: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
The consistency checker run is mandatory after running conversion script, iirc the conversion script mentions that at the end of its run.

As far as the compactor goes, are the message bodies visible prior to its execution?


FUDforum Core Developer
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27836 is a reply to message #27835] Tue, 27 September 2005 22:00 Go to previous messageGo to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
Ilia wrote on Tue, 27 September 2005 22:55


As far as the compactor goes, are the message bodies visible prior to its execution?


Yep!
After running it, they disappear.
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27837 is a reply to message #27836] Tue, 27 September 2005 22:15 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
Ok, bug in the compactor then, need to trace that problem, I've had people report it earlier and 2.7.3RC1 should've fixed it. At least I could not longer replicate the problem.

Anyhow there is just one place in compact.php where files are being removed. Block under the "/* remove old message files */" comment. If you are willing, try to add a debug line there to see what it is trying to remove.


FUDforum Core Developer
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27838 is a reply to message #27837] Tue, 27 September 2005 22:36 Go to previous messageGo to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
OK, so here it goes:
* it first deletes all msg_* files (line 145).

* Then it was supposed to move all tmp_* to msg_*. The problem is that there are no tmp_* file there. So I end up with no files in the messages's folder.

* In addition, after running this script, error_log gets filled with:
[27-Set-2005 18:40:47] PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/fneinet/public_html/fudforum/include/theme/default/db.inc on line 128

So the error may be a non-validated sql result. I don't know..

Any more hints to help in the debugging?

[Updated on: Tue, 27 September 2005 22:44]

Report message to a moderator

Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27841 is a reply to message #27830] Wed, 28 September 2005 08:53 Go to previous messageGo to next message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
OK, after a quick sleep, I've found the cause:
$r = q('SELECT m.id, m.foff, (..)');

while ($r = db_rowarr($c)) {
	if ($r[4] && $r[2] > $r[4]) {


the problem is that you are passing the $c var to db_rowarr() which isn't defined at all, instead of passing the $r result.


Nuno

[Updated on: Wed, 28 September 2005 08:54]

Report message to a moderator

Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27844 is a reply to message #27841] Wed, 28 September 2005 13:54 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
Yup that was it, silly typo.
The fixed version of the compactor can be found here:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/www_root/adm/co mpact.php?v=1.59


FUDforum Core Developer
Re: phpBB import failed with FUDforum 2.7.3RC1 [message #27883 is a reply to message #27830] Thu, 29 September 2005 09:58 Go to previous message
nuno is currently offline  nuno   Portugal
Messages: 11
Registered: September 2005
Location: Portugal
Karma: 0
Junior Member
OK. I think it is now working correctly.
Next week I'll give you some feedback about what I and our users think about the forum.

Nuno

[Updated on: Thu, 29 September 2005 09:58]

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Feeds fail after moving servers
Next Topic: The Post flood error ?!?! I have it set to 60 seconds
Goto Forum:
  

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

Current Time: Sun Nov 10 02:12:39 GMT 2024

Total time taken to generate the page: 0.01896 seconds