Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Witam,
Po instalacji debiana i próbie
apt-get update występuje bląd
Pob: 1 http://ftp.pl.debian.org stable Release.gpg [1672 B] 99% [1 Release.gpg 1672 B/1672 B 100%] [Logowanie siÄ] [PodĹÄ 99% [Logowanie siÄ] [PodĹÄ Ign http://ftp.pl.debian.org/debian/ stable/main Translation-en 99% [Logowanie siÄ] [PodĹÄ Pob: 2 http://ftp.pl.debian.org/debian/ stable/main Translation-pl [375 kB] 99% [2 Translation-pl 375 kB/375 kB 99%] [Logowanie siÄ] [PodĹÄ 99% [Logowanie siÄ] [PodĹÄ Pob: 3 http://ftp.pl.debian.org stable Release [111 kB] Ign http://ftp.pl.debian.org stable Release Pob: 4 http://ftp.pl.debian.org stable/main i386 Packages [6568 kB] Ign http://security.debian.org stable Release.gpg Ign http://security.debian.org/ stable/main Translation-en Ign http://security.debian.org/ stable/main Translation-pl Ign ftp://ftp.pl.debian.org stable Release Ign http://security.debian.org stable Release 9% [2 Translation-pl bzip2 895 kB] [4 Packages 95,3 kB/6568 kB 1%] [Info] bzip2: Data integrity error when decompressing. Input file = (stdin), output file = (stdout) It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files. You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files. Ign http://ftp.pl.debian.org/debian/ stable/main Translation-pl Pob: 5 ftp://ftp.pl.debian.org stable/main Sources [4541 kB] Ign http://security.debian.org stable/main Sources Ign http://security.debian.org stable/main i386 Packages BĹÄ d http://security.debian.org stable/main Sources 404 Not Found [IP: 128.31.0.36 80] BĹÄ d http://security.debian.org stable/main i386 Packages 404 Not Found [IP: 128.31.0.36 80] 89% [5 Sources bzip2 1860 kB] [4 Packages 5715 kB/6568 kB 87%] 1685 kB/s 0s bzip2: Data integrity error when decompressing. Input file = (stdin), output file = (stdout) It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files. You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files. BĹÄ d ftp://ftp.pl.debian.org stable/main Sources Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2) 96% [4 Packages bzip2 1800 kB] 1685 kB/s 0s bzip2: Data integrity error when decompressing. Input file = (stdin), output file = (stdout) It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files. You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files. BĹÄ d http://ftp.pl.debian.org stable/main i386 Packages Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2) Pobrano 11,1 MB w 7s (1507 kB/s) W: GPG error: http://ftp.pl.debian.org stable Release: NastÄpujÄ ce podpisy byĹy bĹÄdne: BADSIG AED4B06F473041FA Debian Archive Automatic Signing Key (6.0/squeeze) <ftpmaster@debian.org> W: GPG error: ftp://ftp.pl.debian.org stable Release: NastÄpujÄ ce podpisy byĹy bĹÄdne: BADSIG AED4B06F473041FA Debian Archive Automatic Signing Key (6.0/squeeze) <ftpmaster@debian.org> W: Nie udaĹo siÄ pobraÄ http://ftp.pl.debian.org/debian/dist...6/Packages.bz2 Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2) W: Nie udaĹo siÄ pobraÄ ftp://ftp.pl.debian.org/debian/dists...ce/Sources.bz2 Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2) W: Nie udaĹo siÄ pobraÄ http://security.debian.org/dists/sta...rce/Sources.gz 404 Not Found [IP: 128.31.0.36 80] W: Nie udaĹo siÄ pobraÄ http://security.debian.org/dists/sta...86/Packages.gz 404 Not Found [IP: 128.31.0.36 80] E: Nie udaĹo siÄ pobraÄ niektĂłrych plikĂłw indeksu, zostaĹy one zignorowane lub zostaĹa uĹźyta ich starsza wersja. aptitude update Pobieranie:1 http://ftp.pl.debian.org stable Release.gpg [1672 B] 99% [1 Release.gpg 1672/1672 B 100%] [Logowanie siÄ] [PodĹÄ 99% [Logowanie siÄ] [PodĹÄ Ignorowane http://ftp.pl.debian.org/debian/ stable/main Translation-en 99% [Oczekiwanie na nagĹĂłwki] [Logowanie siÄ] [PodĹÄ Pobieranie:2 http://ftp.pl.debian.org/debian/ stable/main Translation-pl [375 kB] 99% [2 Translation-pl 374958/375 kB 100%] [Logowanie siÄ] [PodĹÄ 99% [Oczekiwanie na nagĹĂłwki] [Logowanie siÄ] [PodĹÄ Pobieranie:3 http://ftp.pl.debian.org stable Release [111 kB] Ignorowane http://ftp.pl.debian.org stable Release Pobieranie:4 http://ftp.pl.debian.org stable/main i386 Packages [6568 kB] Ignorowane http://security.debian.org stable Release.gpg Ignorowane http://security.debian.org/ stable/main Translation-en Ignorowane http://security.debian.org/ stable/main Translation-pl Ignorowane ftp://ftp.pl.debian.org stable Release Ignorowane http://security.debian.org stable Release 9% [2 Translation-pl bzip2 895000] [4 Packages 86570/6568 kB 1%] [Info] bzip2: Data integrity error when decompressing. Input file = (stdin), output file = (stdout) It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files. You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files. Ignorowane http://ftp.pl.debian.org/debian/ stable/main Translation-pl Pobieranie:5 ftp://ftp.pl.debian.org stable/main Sources [4541 kB] Ignorowane http://security.debian.org stable/main Sources Ignorowane http://security.debian.org stable/main i386 Packages BĹÄ d http://security.debian.org stable/main Sources 404 Not Found [IP: 128.31.0.36 80] BĹÄ d http://security.debian.org stable/main i386 Packages 404 Not Found [IP: 128.31.0.36 80] 75% [5 Sources bzip2 900000] [4 Packages 4113458/6568 kB 62%] bzip2: Data integrity error when decompressing. Input file = (stdin), output file = (stdout) It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files. You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files. BĹÄ d ftp://ftp.pl.debian.org stable/main Sources Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2) 96% [4 Packages bzip2 1020000] 1697 kB/s 0s bzip2: Data integrity error when decompressing. Input file = (stdin), output file = (stdout) It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files. You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files. BĹÄ d http://ftp.pl.debian.org stable/main i386 Packages Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2) Pobrano 11,1 MB w 7s (1552 kB/s) W: GPG error: http://ftp.pl.debian.org stable Release: NastÄpujÄ ce podpisy byĹy bĹÄdne: BADSIG AED4B06F473041FA Debian Archive Automatic Signing Key (6.0/squeeze) <ftpmaster@debian.org> W: GPG error: ftp://ftp.pl.debian.org stable Release: NastÄpujÄ ce podpisy byĹy bĹÄdne: BADSIG AED4B06F473041FA Debian Archive Automatic Signing Key (6.0/squeeze) <ftpmaster@debian.org>
sources.list
#
# deb cdrom:[Debian GNU/Linux 4.0 r1 _Etch_ - Official i386 CD Binary-1 20070819-11:52]/ etch contrib main
deb http://ftp.pl.debian.org/debian/ stable main
deb-src ftp://ftp.pl.debian.org/debian/ stable main
deb http://security.debian.org stable main
deb-src http://security.debian.org stable main
jeśli ktoś spotkał się proszę o podpowiedź
Ostatnio edytowany przez przemo_pp (2012-08-18 11:26:17)
Offline
Po instalacji debiana
(…)
# deb cdrom:[Debian GNU/Linux 4.0 r1 _Etch_ - Official i386 CD Binary-1 20070819-11:52]/ etch contrib main[/quote]
Zainstaluj aktualną wersję, a nie zabytek.
PS Ten „PROBLEM” w tytule wątku tylko zniechęca do odpowiedzi.
[img]http://svn.debianart.org/themes/generic/spinner/spinner48px-moreblue.png[/img]
Offline
debian.org wersja 6.0.5 jest najbardziej aktualna czy sie myle?
Offline
6.0.5 to aktualna stabilna, ale w sources.list masz wpis sugerujący, że instalowałeś z obrazu 4.0 r1:
# deb cdrom:[Debian GNU/Linux 4.0 r1 _Etch_ - Official i386 CD Binary-1 20070819-11:52]/ etch contrib main
Pokaż:
cat /proc/version cat /etc/debian_version dpkg -l |grep apt dpkg -l |grep libc6
Offline
root@lms:~# cat /proc/version
Linux version 2.6.32-5-686 (Debian 2.6.32-41) (ben@decadent.org.uk) (gcc version 4.3.5 (Debian 4.3.5-4) ) #1 SMP Mon Jan 16 16:04:25 UTC 2012
root@lms:~# cat /etc/debian_version
6.0.5
root@lms:~# dpkg -l |grep apt
ii apt 0.8.10.3+squeeze1 Advanced front-end for dpkg
ii apt-listchanges 2.85.7+squeeze1 package change history notification tool
ii apt-utils 0.8.10.3+squeeze1 APT utility programs
ii aptitude 0.6.3-3.2+squeeze1 terminal-based package manager (terminal interface only)
ii laptop-detect 0.13.7 attempt to detect a laptop
ii python-apt 0.7.100.1+squeeze1 Python interface to libapt-pkg
ii python-apt-common 0.7.100.1+squeeze1 Python interface to libapt-pkg (locales)
ii xserver-xorg-input-synaptics 1.2.2-2 Synaptics TouchPad driver for X.Org server
root@lms:~# dpkg -l |grep libc6
ii libc6 2.11.3-2 Embedded GNU C Library: Shared libraries
rc libc6-i686 2.11.3-2 Embedded GNU C Library: Shared libraries [i686 optimized]
Offline
Wygląda na Squeeze. Skąd w takim razie ten Etch w sources.list? Sam dodałeś?
Anyway, zmień sources.list żeby był jedynie wpis:
deb http://ftp.pl.debian.org/debian/ stable main
Potem daj:
rm -r /var/lib/apt/lists/* apt-get update
Offline
nie nie dodałem było już
raczej nic z tego :(
root@lms:~# nano /etc/apt/sources.list root@lms:~# rm -r /var/lib/apt/lists/* root@lms:~# apt-get update
Pob: 1 http://ftp.pl.debian.org stable Release.gpg [1672 B]
Ign http://ftp.pl.debian.org/debian/ stable/main Translation-en
Pob: 2 http://ftp.pl.debian.org/debian/ stable/main Translation-pl [375 kB]
Pob: 3 http://ftp.pl.debian.org stable Release [111 kB]
Pob: 4 http://ftp.pl.debian.org stable/main i386 Packages [6568 kB]
6% [2 Translation-pl bzip2 0 B] [4 Packages 4034 B/6568 kB 0%]
bzip2: Data integrity error when decompressing.
Input file = (stdin), output file = (stdout)
It is possible that the compressed file(s) have become corrupted.
You can use the -tvv option to test integrity of such files.
You can use the `bzip2recover' program to attempt to recover
data from undamaged sections of corrupted files.
Ign http://ftp.pl.debian.org/debian/ stable/main Translation-pl
94% [4 Packages bzip2 0 B] 1033 kB/s 0s
bzip2: Data integrity error when decompressing.
Input file = (stdin), output file = (stdout)
It is possible that the compressed file(s) have become corrupted.
You can use the -tvv option to test integrity of such files.
You can use the `bzip2recover' program to attempt to recover
data from undamaged sections of corrupted files.
BĹÄ
d http://ftp.pl.debian.org stable/main i386 Packages
Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2)
Pobrano 7056 kB w 6s (1100 kB/s)
W: Nie udaĹo siÄ pobraÄ http://ftp.pl.debian.org/debian/dists/stable/main/binary-i386/Packages.bz2 Podproces /bin/bzip2 zwrĂłciĹ kod bĹÄdu (2)
E: Nie udaĹo siÄ pobraÄ niektĂłrych plikĂłw indeksu, zostaĹy one zignorowane lub zostaĹa uĹźyta ich starsza wersja.
root@lms:~#
Offline
źródło
http://cdimage.debian.org/debian-cd/6.0.5/i386/iso-cd/
Offline
Nic z tego nie rozumiem… Skoro instalowałeś z obrazu 6.0.5 i nie dodałeś do sources.list tej linijki dotyczącej obrazu instalacyjnego 4.0 r1, to jakim cudem ona się tam znalazła? Jakby mnie ktoś spytał, to bym powiedział, że to niemożliwe. ;)
Zobacz tak:
rm -r /var/lib/apt/lists/* apt-get clean LANG=C apt-get update
Jeśli będzie to samo, to zobacz czy ręcznie działa:
cd /tmp wget http://ftp.pl.debian.org/debian/dists/stable/main/binary-i386/Packages.bz2 bunzip2 Packages.bz2 wget http://ftp.pl.debian.org/debian/dists/stable/main/i18n/Translation-pl.bz2 bunzip2 Translation-pl.bz2
[b]EDIT:[/b] Możesz jeszcze spróbować inny mirror w sources.list.
Offline
a jednak :P eh instalowałem już go kilka razy i nadal to samo nie jestem w tanie tego ogarnąć:(
root@lms:~# rm -r /var/lib/apt/lists/*
root@lms:~# apt-get clean
root@lms:~# LANG=C apt-get update
Get:1 http://ftp.pl.debian.org stable Release.gpg [1672 B]
Ign http://ftp.pl.debian.org/debian/ stable/main Translation-en
Get:2 http://ftp.pl.debian.org stable Release [111 kB]
Ign http://ftp.pl.debian.org stable Release
Get:3 http://ftp.pl.debian.org stable/main i386 Packages [6568 kB]
99% [3 Packages bzip2 0 B]
bzip2: Data integrity error when decompressing.
Input file = (stdin), output file = (stdout)
It is possible that the compressed file(s) have become corrupted.
You can use the -tvv option to test integrity of such files.
You can use the `bzip2recover' program to attempt to recover
data from undamaged sections of corrupted files.
Err http://ftp.pl.debian.org stable/main i386 Packages
Sub-process /bin/bzip2 returned an error code (2)
Fetched 6681 kB in 4s (1563 kB/s)
W: GPG error: http://ftp.pl.debian.org stable Release: The following signatures were invalid: BADSIG AED4B06F473041FA Debian Archive Automatic Signing Key (6.0/ squeeze) <ftpmaster@debian.org>
W: Failed to fetch http://ftp.pl.debian.org/debian/dists/stable/main/binary-i386 /Packages.bz2 Sub-process /bin/bzip2 returned an error code (2)
E: Some index files failed to download, they have been ignored, or old ones used instead.
Offline
root@lms:/tmp# wget http://ftp.pl.debian.org/debian/dists/stable/main/binary-i38 6/Packages.bz2
--2012-08-18 00:09:25-- http://ftp.pl.debian.org/debian/dists/stable/main/binar y-i386/Packages.bz2
Translacja ftp.pl.debian.org... 153.19.251.221, 2001:4070:1::fafb
ĹÄ
czenie siÄ z ftp.pl.debian.org|153.19.251.221|:80... poĹÄ
czono.
ĹťÄ
danie HTTP wysĹano, oczekiwanie na odpowiedĹş... 200 OK
DĹugoĹ: 6568500 (6,3M) [application/x-bzip2]
Zapis do: `Packages.bz2.1'
100%[======================================>] 6.568.500 1,81M/s w 3,6s
2012-08-18 00:09:29 (1,74 MB/s) - zapisano `Packages.bz2.1' [6568500/6568500]
root@lms:/tmp# bunzip2 Packages.bz2
bunzip2: Data integrity error when decompressing.
Input file = Packages.bz2, output file = Packages
It is possible that the compressed file(s) have become corrupted.
You can use the -tvv option to test integrity of such files.
You can use the `bzip2recover' program to attempt to recover
data from undamaged sections of corrupted files.
bunzip2: Deleting output file Packages, if it exists.
root@lms:/tmp# wget http://ftp.pl.debian.org/debian/dists/stable/main/i18n/Trans lation-pl.bz2
--2012-08-18 00:09:49-- http://ftp.pl.debian.org/debian/dists/stable/main/i18n/ Translation-pl.bz2
Translacja ftp.pl.debian.org... 153.19.251.221, 2001:4070:1::fafb
ĹÄ
czenie siÄ z ftp.pl.debian.org|153.19.251.221|:80... poĹÄ
czono.
ĹťÄ
danie HTTP wysĹano, oczekiwanie na odpowiedĹş... 200 OK
DĹugoĹ: 374958 (366K) [application/x-bzip2]
Zapis do: `Translation-pl.bz2.1'
100%[======================================>] 374.958 1,01M/s w 0,4s
2012-08-18 00:09:49 (1,01 MB/s) - zapisano `Translation-pl.bz2.1' [374958/374958 ]
root@lms:/tmp# bunzip2 Translation-pl.bz2
bunzip2: Data integrity error when decompressing.
Input file = Translation-pl.bz2, output file = Translation-pl
It is possible that the compressed file(s) have become corrupted.
You can use the -tvv option to test integrity of such files.
You can use the `bzip2recover' program to attempt to recover
data from undamaged sections of corrupted files.
bunzip2: Deleting output file Translation-pl, if it exists.
Offline
Formatujesz partycję przy instalacji? Jakie masz locale?
locale locale -a
Offline
tak
root@lms:/tmp# locale
LANG=pl_PL.UTF-8
LANGUAGE=
LC_CTYPE="pl_PL.UTF-8"
LC_NUMERIC="pl_PL.UTF-8"
LC_TIME="pl_PL.UTF-8"
LC_COLLATE="pl_PL.UTF-8"
LC_MONETARY="pl_PL.UTF-8"
LC_MESSAGES="pl_PL.UTF-8"
LC_PAPER="pl_PL.UTF-8"
LC_NAME="pl_PL.UTF-8"
LC_ADDRESS="pl_PL.UTF-8"
LC_TELEPHONE="pl_PL.UTF-8"
LC_MEASUREMENT="pl_PL.UTF-8"
LC_IDENTIFICATION="pl_PL.UTF-8"
LC_ALL=
root@lms:/tmp# locale -a
C
pl_PL.utf8
POSIX
Offline
A na jakichś innych archiwach bzip2 działa? Daje radę utworzyć archiwum i je potem rozpakować?
touch test bzip2 test bunzip2 test.bz2
Offline
root@lms:/tmp# touch test
root@lms:/tmp# bzip2 test
root@lms:/tmp# bunzip2 test.bz2
root@lms:/tmp#
Offline
Niby działa, ale na tych co trzeba nie chce. Zobacz może jeszcze jakiś inny zewnętrzny plik, np.:
wget http://www.kernel.org/pub/linux/kernel/v3.0/testing/patch-3.6-rc2.bz2 bunzip2 patch-3.6-rc2.bz2
Próbowałeś pobrać pliki z innego mirrora Debiana?
Offline
root@lms:/tmp# wget http://www.kernel.org/pub/linux/kernel/v3.0/testing/patch-3. 6-rc2.bz2
--2012-08-18 00:30:47-- http://www.kernel.org/pub/linux/kernel/v3.0/testing/pat ch-3.6-rc2.bz2
Translacja www.kernel.org... 149.20.4.69, 149.20.20.133
ĹÄ
czenie siÄ z www.kernel.org|149.20.4.69|:80... poĹÄ
czono.
ĹťÄ
danie HTTP wysĹano, oczekiwanie na odpowiedĹş... 200 OK
DĹugoĹ: 5967996 (5,7M) [application/x-bzip2]
Zapis do: `patch-3.6-rc2.bz2'
100%[======================================>] 5.967.996 325K/s w 21s
2012-08-18 00:31:08 (275 KB/s) - zapisano `patch-3.6-rc2.bz2' [5967996/5967996]
root@lms:/tmp# bunzip2 patch-3.6-rc2.bz2
bunzip2: Data integrity error when decompressing.
Input file = patch-3.6-rc2.bz2, output file = patch-3.6-rc2
It is possible that the compressed file(s) have become corrupted.
You can use the -tvv option to test integrity of such files.
You can use the `bzip2recover' program to attempt to recover
data from undamaged sections of corrupted files.
bunzip2: Deleting output file patch-3.6-rc2, if it exists.
Offline
Nie wiem co powoduje ten problem. Albo źle pobiera Ci każdy plik z sieci (co byłoby dziwne) albo bzip2 jest uwalony (co też byłoby dziwne). bzip2 nie potrafi rozpakować pliku pobranego z sieci. Jeszcze możesz wypróbować coś większego lokalnie, np.:
cd /tmp/ cp /var/log/messages . bzip2 messages bunzip2 messages.bz2
Jednak niezależnie od wyniku i tak żadne rozwiązanie nie przychodzi mi na myśl. Możesz sprawdzić czy ten sam problem wystąpi na testingu…
Offline
root@lms:/tmp# cp /var/log/messages
cp: brakujÄ
cy plik docelowy po `/var/log/messages'
SprĂłbuj `cp --help' dla uzyskania informacji.
root@lms:/tmp# bzip2 messages
bzip2: Can't open input file messages: No such file or directory.
root@lms:/tmp# bunzip2 messages.bz2
bunzip2: Can't open input file messages.bz2: No such file or directory.
Offline
Jeszcze kropka na końcu polecenia:
cp /var/log/messages .
Offline
jutro postawie wersje testową :( ehhh uparty jest :(
Offline
Ale przeszło to z kropką czy nie? BTW, skąd krzaki w komunikatach w ogóle?
Offline
root@lms:/tmp# cp /var/log/messages .
root@lms:/tmp# bzip2 messages
root@lms:/tmp# bunzip2 messages.bz2
magia :(
Offline
tak przeszło z kropką
Offline
Time (s) | Query |
---|---|
0.00010 | SET CHARSET latin2 |
0.00004 | SET NAMES latin2 |
0.00087 | SELECT u.*, g.*, o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='3.21.46.24' WHERE u.id=1 |
0.00056 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.21.46.24', 1732594883) |
0.00039 | SELECT * FROM punbb_online WHERE logged<1732594583 |
0.00038 | SELECT topic_id FROM punbb_posts WHERE id=209117 |
0.00006 | SELECT id FROM punbb_posts WHERE topic_id=21816 ORDER BY posted |
0.00049 | SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=21816 AND t.moved_to IS NULL |
0.00005 | SELECT search_for, replace_with FROM punbb_censoring |
0.00120 | SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=21816 ORDER BY p.id LIMIT 0,25 |
0.00077 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=21816 |
Total query time: 0.00491 s |