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

Home » FUDforum Development » Bug Reports » Compact Messages bug in rc3
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Compact Messages bug in rc3 [message #5192] Fri, 23 August 2002 00:49 Go to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

Disabling the forum for the duration of maintenance run

Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
100% Done
Compacting private messages...
Query Failed: SELECT distinct(foff),length FROM fud21_pmsg
Reason: Table 'fud21_pmsg' was not locked with LOCK TABLES
From: c:/php4/php.exe
Server Version: 3.23.46-nt
Re: Compact Messages bug in rc3 [message #5193 is a reply to message #5192] Fri, 23 August 2002 00:58 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
Cannot replicate the problem here...

Did message compacting work before for you? If so what was the last version when it did, I'll compare the code between the 2 versions maybe I'll be able to spot something.


FUDforum Core Developer
Re: Compact Messages bug in rc3 [message #5233 is a reply to message #5193] Sat, 24 August 2002 03:45 Go to previous messageGo to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

in rc4

Disabling the forum for the duration of maintenance run

Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
10% done
20% done
30% done
40% done
50% done
60% done
70% done
100% Done
Compacting private messages...
Query Failed: SELECT distinct(foff),length FROM fud21_pmsg
Reason: Table 'fud21_pmsg' was not locked with LOCK TABLES
From: c:/php4/php.exe
Server Version: 3.23.46-nt
Re: Compact Messages bug in rc3 [message #5277 is a reply to message #5233] Mon, 26 August 2002 12: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
Send me a copy of your compact.php script found in the adm/ directory. I've tried, but I just cannot replicate the bug you are seeing.

FUDforum Core Developer
Re: Compact Messages bug in rc3 [message #5309 is a reply to message #5277] Tue, 27 August 2002 04:41 Go to previous messageGo to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

prottoss wrote on Mon, 26 August 2002 20:38

Send me a copy of your compact.php script found in the adm/ directory. I've tried, but I just cannot replicate the bug you are seeing.

in 2.3.0
================================
Disabling the forum for the duration of maintenance run

Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
100% Done
Compacting private messages...
Query Failed: SELECT distinct(foff),length FROM k12_pmsg
Reason: Table 'k12_pmsg' was not locked with LOCK TABLES
From: c:/php4/php.exe
Server Version: 3.23.46-nt
================================
  • Attachment: compact.php
    (Size: 7.25KB, Downloaded 684 times)
Re: Compact Messages bug in rc3 [message #5316 is a reply to message #5309] Tue, 27 August 2002 13: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
Please try the attached compact script (replace your existing one with this one and then run it).
  • Attachment: compact.php
    (Size: 7.26KB, Downloaded 676 times)


FUDforum Core Developer
Re: Compact Messages bug in rc3 [message #5326 is a reply to message #5316] Wed, 28 August 2002 00:51 Go to previous messageGo to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

Disabling the forum for the duration of maintenance run

Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
10% done
20% done
30% done
40% done
50% done
60% done
70% done
100% Done
Compacting private messages...

Warning: Division by zero in e:\htdocs\ok\adm\compact.php on line 203
0% done

Warning: Division by zero in e:\htdocs\ok\adm\compact.php on line 203
0% done

Warning: Division by zero in e:\htdocs\ok\adm\compact.php on line 203
0% done
100% Done

Warning: rename() failed (File exists) in e:\htdocs\ok\adm\compact.php on line 218
Done (in 0 min)

Re-enabling the forum.
Re: Compact Messages bug in rc3 [message #5328 is a reply to message #5326] Wed, 28 August 2002 01:11 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 division by 0 errors are solved in latest CVS, however the rename error is quite puzzling. Which operating system are you using?

FUDforum Core Developer
Re: Compact Messages bug in rc3 [message #5331 is a reply to message #5328] Wed, 28 August 2002 01:31 Go to previous messageGo to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

win2000 prof

i'm going to test it on red hat linux

[Updated on: Wed, 28 August 2002 01:33]

Report message to a moderator

Re: Compact Messages bug in rc3 [message #5332 is a reply to message #5331] Wed, 28 August 2002 01:43 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
I found the problem, apparently on Windows, PHP's rename() command does not work if the destination file already exists. I'm going to add a handler for this in the CVS.

FUDforum Core Developer
Re: Compact Messages bug in rc3 [message #5333 is a reply to message #5332] Wed, 28 August 2002 01:47 Go to previous messageGo to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

Cool Cool Cool
thanks

result of linux
====================
Disabling the forum for the duration of maintenance run

Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
10% done
20% done
30% done
40% done
50% done
60% done
70% done
100% Done
Compacting private messages...

Warning: Division by zero in /home/httpd/ok/adm/compact.php on line 203
0% done

Warning: Division by zero in /home/httpd/ok/adm/compact.php on line 203
0% done

Warning: Division by zero in /home/httpd/ok/adm/compact.php on line 203
0% done
100% Done
Done (in 0.016666666666667 min)

Re-enabling the forum.
Re: Compact Messages bug in rc3 [message #5334 is a reply to message #5333] Wed, 28 August 2002 02:08 Go to previous messageGo to next message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

i use the last cvs:(
if other people have the same error!



Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
10% done
20% done
30% done
40% done
50% done
60% done
70% done
100% Done
Compacting private messages...
Query Failed: SELECT distinct(foff),length FROM k12_pmsg
Reason: Table 'k12_pmsg' was not locked with LOCK TABLES
From: c:/php4/php.exe
Server Version: 3.23.46-nt


Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
10% done
20% done
30% done
40% done
50% done
60% done
70% done
100% Done
Compacting private messages...
Query Failed: SELECT distinct(foff),length FROM k12_pmsg
Reason: Table 'k12_pmsg' was not locked with LOCK TABLES
From: /home/httpd/ok/adm/compact.php
Server Version: 3.23.46-nt
Re: Compact Messages bug in rc3 [message #5335 is a reply to message #5334] Wed, 28 August 2002 02:24 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
I know, I had not commited that changed the query order just yet.

Update:
The change was just now commited.


FUDforum Core Developer

[Updated on: Wed, 28 August 2002 02:25]

Report message to a moderator

Re: Compact Messages bug in rc3 [message #5337 is a reply to message #5335] Wed, 28 August 2002 03:23 Go to previous message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma: 0
Senior Member

prottoss wrote on Wed, 28 August 2002 10:24

I know, I had not commited that changed the query order just yet.

Update:
The change was just now commited.

hahaha~~~~~~~~~~~
Laughing
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: emailed links not working?
Next Topic: forum lockups using 1.2.8
Goto Forum:
  

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

Current Time: Fri Nov 22 23:14:32 GMT 2024

Total time taken to generate the page: 0.02385 seconds