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/.
Zainstalowałem ostatnio z repozytorium grę Warzone 2100, lecz nie mogę jej uruchomić. Zaraz po wywołaniu gry i pokazaniu się ekranu ładowania gra się automatycznie zamyka. Mój system to 64 bitowy Linux Mint na Debianie testing.
Komunikat z terminala:
No function contains program counter for selected frame. Saved dump file to '/tmp/warzone2100.gdmp-MQAAP7' If you create a bugreport regarding this crash, please include this file. Naruszenie ochrony pamięci
Zawartość pliku dump:
Program: /usr/games/warzone2100(warzone2100) Command line: "warzone2100" Version: Version 2.3.8 Distributor: Debian Compiled on: May 21 2011 09:07:10 Compiled by: GCC 4.6.1 20110507 (prerelease) Compiled mode: Release build Executed on: Sat Jul 2 09:44:09 2011 Operating system: Linux Node name: tesla Release: 2.6.38-2-amd64 Version: #1 SMP Sun May 8 13:51:57 UTC 2011 Machine: x86_64 Pointers: 64bit Compiled against PhysicsFS version: 2.0.2 Running with PhysicsFS version: 2.0.2 Misc Data: [09:44:09]OpenGL Vendor : ATI Technologies Inc. [09:44:09]OpenGL Renderer : ATI Mobility Radeon HD 4500 Series [09:44:09]OpenGL Version : 3.3.10666 Compatibility Profile Context [09:44:09]OpenGL GLSL Version : 3.30 [09:44:09]Video Mode 1366 x 768 (32 bpp) (fullscreen) [09:44:09]OpenAL Vendor: OpenAL Community [09:44:09]OpenAL Version: 1.1 ALSOFT 1.13 [09:44:09]OpenAL Renderer: OpenAL Soft [09:44:09]OpenAL Extensions: AL_EXT_DOUBLE AL_EXT_EXPONENT_DISTANCE AL_EXT_FLOAT32 AL_EXT_IMA4 AL_EXT_LINEAR_DISTANCE AL_EXT_MCFORMATS AL_EXT_MULAW AL_EXT_MULAW_MCFORMATS AL_EXT_OFFSET AL_EXT_source_distance_model AL_LOKI_quadriphonic AL_SOFT_buffer_sub_data AL_SOF [09:44:09]Using language: Język systemu Dump caused by signal: SIGSEGV: Invalid memory reference: Address not mapped to object GLIBC raw backtrace: warzone2100[0x5a61fd] /lib/x86_64-linux-gnu/libc.so.6(+0x32480)[0x7fd71e012480] /usr/lib/libGLC.so.0(__glcRenderCharTexture+0xa80)[0x7fd71f9973f0] /usr/lib/libGLC.so.0(+0x13c2e)[0x7fd71f994c2e] /usr/lib/libGLC.so.0(__glcProcessChar+0xaf)[0x7fd71f98e72f] /usr/lib/libGLC.so.0(+0x1347a)[0x7fd71f99447a] /usr/lib/libGLC.so.0(glcRenderString+0x55)[0x7fd71f994635] warzone2100(iV_DrawTextRotated+0xfc)[0x58e35c] warzone2100[0x48d33b] warzone2100[0x5596ec] warzone2100[0x55974c] warzone2100(widgDisplayScreen+0x10)[0x55b760] warzone2100(runTitleMenu+0x44)[0x490714] warzone2100(titleLoop+0x235)[0x552105] warzone2100(main+0xcd0)[0x4439c0] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7fd71dffeead] warzone2100[0x443e95] GDB extended backtrace: GNU gdb (GDB) 7.2-debian Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /usr/games/warzone2100...(no debugging symbols found)...done. Attaching to program: /usr/games/warzone2100, process 16580 Reading symbols from /usr/lib/libSDL-1.2.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libSDL-1.2.so.0 Reading symbols from /usr/lib/libphysfs.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libphysfs.so.1 Reading symbols from /lib/libpng12.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libpng12.so.0 Reading symbols from /usr/lib/libvorbisfile.so.3...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libvorbisfile.so.3 Reading symbols from /usr/lib/libvorbis.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libvorbis.so.0 Reading symbols from /usr/lib/libogg.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libogg.so.0 Reading symbols from /usr/lib/libtheora.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libtheora.so.0 Reading symbols from /usr/lib/libopenal.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libopenal.so.1 Reading symbols from /usr/lib/libGLC.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libGLC.so.0 Reading symbols from /usr/lib/libGL.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libGL.so.1 Reading symbols from /usr/lib/x86_64-linux-gnu/libGLU.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libGLU.so.1 Reading symbols from /lib/libpopt.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libpopt.so.0 Reading symbols from /usr/lib/x86_64-linux-gnu/libX11.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libX11.so.6 Reading symbols from /usr/lib/libglee.so.0d1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libglee.so.0d1 Reading symbols from /usr/lib/libminiupnpc.so.5...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libminiupnpc.so.5 Reading symbols from /usr/lib/libstdc++.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libstdc++.so.6 Reading symbols from /lib/x86_64-linux-gnu/libm.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/libm.so.6 Reading symbols from /lib/libgcc_s.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/libgcc_s.so.1 Reading symbols from /lib/x86_64-linux-gnu/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/libc.so.6 Reading symbols from /lib/x86_64-linux-gnu/libpthread.so.0...(no debugging symbols found)...done. [Thread debugging using libthread_db enabled] [New Thread 0x7fd70efae700 (LWP 16591)] [New Thread 0x7fd70f7af700 (LWP 16590)] [New Thread 0x7fd713fb1700 (LWP 16589)] [New Thread 0x7fd7179c3700 (LWP 16587)] Loaded symbols for /lib/x86_64-linux-gnu/libpthread.so.0 Reading symbols from /usr/lib/libasound.so.2...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libasound.so.2 Reading symbols from /lib/x86_64-linux-gnu/librt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/librt.so.1 Reading symbols from /lib/x86_64-linux-gnu/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/libdl.so.2 Reading symbols from /usr/lib/libpulse-simple.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libpulse-simple.so.0 Reading symbols from /usr/lib/libpulse.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libpulse.so.0 Reading symbols from /usr/lib/x86_64-linux-gnu/libXext.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXext.so.6 Reading symbols from /usr/lib/libdirectfb-1.2.so.9...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libdirectfb-1.2.so.9 Reading symbols from /usr/lib/libfusion-1.2.so.9...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libfusion-1.2.so.9 Reading symbols from /usr/lib/libdirect-1.2.so.9...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libdirect-1.2.so.9 Reading symbols from /usr/lib/libcaca.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libcaca.so.0 Reading symbols from /usr/lib/libz.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/lib/x86_64-linux-gnu/libfontconfig.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libfontconfig.so.1 Reading symbols from /usr/lib/libfreetype.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libfreetype.so.6 Reading symbols from /usr/lib/libfribidi.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libfribidi.so.0 Reading symbols from /usr/lib/libGLEWmx.so.1.5...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libGLEWmx.so.1.5 Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /usr/lib/x86_64-linux-gnu/libxcb.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libxcb.so.1 Reading symbols from /usr/lib/libpulsecommon-0.9.21.so...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libpulsecommon-0.9.21.so Reading symbols from /usr/lib/libgdbm.so.3...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libgdbm.so.3 Reading symbols from /lib/libcap.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libcap.so.2 Reading symbols from /usr/lib/x86_64-linux-gnu/libICE.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libICE.so.6 Reading symbols from /usr/lib/x86_64-linux-gnu/libSM.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libSM.so.6 Reading symbols from /usr/lib/libXtst.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libXtst.so.6 Reading symbols from /lib/libslang.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libslang.so.2 Reading symbols from /lib/libncursesw.so.5...(no debugging symbols found)...done. Loaded symbols for /lib/libncursesw.so.5 Reading symbols from /usr/lib/libexpat.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libexpat.so.1 Reading symbols from /usr/lib/libXmu.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libXmu.so.6 Reading symbols from /usr/lib/x86_64-linux-gnu/libXi.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXi.so.6 Reading symbols from /usr/lib/x86_64-linux-gnu/libXau.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXau.so.6 Reading symbols from /usr/lib/x86_64-linux-gnu/libXdmcp.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 Reading symbols from /lib/x86_64-linux-gnu/libwrap.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/libwrap.so.0 Reading symbols from /usr/lib/libsndfile.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libsndfile.so.1 Reading symbols from /usr/lib/libasyncns.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libasyncns.so.0 Reading symbols from /lib/libdbus-1.so.3...(no debugging symbols found)...done. Loaded symbols for /lib/libdbus-1.so.3 Reading symbols from /lib/libattr.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/libattr.so.1 Reading symbols from /lib/libuuid.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/libuuid.so.1 Reading symbols from /usr/lib/x86_64-linux-gnu/libXt.so.6...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXt.so.6 Reading symbols from /lib/x86_64-linux-gnu/libnsl.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/libnsl.so.1 Reading symbols from /usr/lib/libFLAC.so.8...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libFLAC.so.8 Reading symbols from /usr/lib/libvorbisenc.so.2...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libvorbisenc.so.2 Reading symbols from /lib/x86_64-linux-gnu/libresolv.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/x86_64-linux-gnu/libresolv.so.2 Reading symbols from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-2.so...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/gconv/ISO8859-2.so Reading symbols from /usr/lib/x86_64-linux-gnu/libXcursor.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXcursor.so.1 Reading symbols from /usr/lib/x86_64-linux-gnu/libXrender.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXrender.so.1 Reading symbols from /usr/lib/x86_64-linux-gnu/libXfixes.so.3...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXfixes.so.3 Reading symbols from /usr/lib/dri/fglrx_dri.so...(no debugging symbols found)...done. Loaded symbols for /usr/lib/dri/fglrx_dri.so Reading symbols from /usr/lib/libatiuki.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libatiuki.so.1 Reading symbols from /usr/lib/libatiadlxx.so...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libatiadlxx.so Reading symbols from /usr/lib/x86_64-linux-gnu/libXinerama.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/x86_64-linux-gnu/libXinerama.so.1 0x00007fd71e085ded in waitpid () from /lib/x86_64-linux-gnu/libc.so.6 (gdb) #0 0x00007fd71e085ded in waitpid () from /lib/x86_64-linux-gnu/libc.so.6 No symbol table info available. #1 0x00000000005a6768 in ?? () No symbol table info available. #2 <signal handler called> No symbol table info available. #3 0x00007fd71f9973f0 in __glcRenderCharTexture () from /usr/lib/libGLC.so.0 No symbol table info available. #4 0x00007fd71f994c2e in ?? () from /usr/lib/libGLC.so.0 No symbol table info available. #5 0x00007fd71f98e72f in __glcProcessChar () from /usr/lib/libGLC.so.0 No symbol table info available. #6 0x00007fd71f99447a in ?? () from /usr/lib/libGLC.so.0 No symbol table info available. #7 0x00007fd71f994635 in glcRenderString () from /usr/lib/libGLC.so.0 No symbol table info available. #8 0x000000000058e35c in iV_DrawTextRotated () No symbol table info available. #9 0x000000000048d33b in ?? () No symbol table info available. #10 0x00000000005596ec in ?? () No symbol table info available. #11 0x000000000055974c in ?? () No symbol table info available. #12 0x000000000055b760 in widgDisplayScreen () No symbol table info available. #13 0x0000000000490714 in runTitleMenu () No symbol table info available. #14 0x0000000000552105 in titleLoop () No symbol table info available. #15 0x00000000004439c0 in main () No symbol table info available. (gdb) #4 0x00007fd71f994c2e in ?? () from /usr/lib/libGLC.so.0 (gdb) (gdb) rax 0x0 0 rbx 0x30a1d30 50994480 rcx 0x0 0 rdx 0xffffffffffffffd8 -40 rsi 0x30a1d30 50994480 rdi 0x30b8e80 51089024 rbp 0x30b8e80 0x30b8e80 rsp 0x7fff717168d0 0x7fff717168d0 r8 0x800000 8388608 r9 0x0 0 r10 0x0 0 r11 0x7fd71f996970 140561924843888 r12 0x7fff717168e0 140735096645856 r13 0x3943d00 60046592 r14 0x0 0 r15 0x0 0 rip 0x7fd71f994c2e 0x7fd71f994c2e eflags 0x246 [ PF ZF IF ] cs 0x33 51 ss 0x2b 43 ds 0x0 0 es 0x0 0 fs 0x0 0 gs 0x0 0 (gdb) A debugging session is active. Inferior 1 [process 16580] will be detached. Quit anyway? (y or n) [answered Y; input not from terminal] Detaching from program: /usr/games/warzone2100, process 16580
Offline
Ciężko rzec, bo nie jestem specjalistą - zainstaluj Warzone z PlayDeb, myślę, że będzie lepiej
Możesz też spróbować uruchomić jako administrator (sudo), czasem aplikacje działają z sudo, nie wiem jaka jest zależność
PS. Czy ta gra jest ulepszana/rozwijana?
Fervi
Offline
Ja właśnie zainstalowalem Warzone2100 na Gentoo, i wstaje bardzo grzecznie.
Także może dpkg-buildpackage i kompilacja ze źródełka?
Offline
Instalowałem grę z playdeb, kompilowałem ze źródeł i w każdym przypadku mam takie same błędy. Podejrzewam, że może być to problem kompatybilności z jedną z systemowych bibliotek.
Offline
no jedyna biblioteka przy ktorej wywalia stacktrace to jest
/usr/lib/libGLC.so.0
czyli tam jest błąd.
to jest sam link symboliczny zobacz czy nie masz innej wersji biblioteki w systemie i podmien linki symboliczne moze pomoze.
ps.
biblioteka to jest cos od openGL
Zwykle jak sie wywala naruszenie ochrony pamięci to ma to związek z wyjściem poza zakres zdefiniowanej tablicy.
ale tak szczerze mówiąc
patrząc na twoja karte graficzna wcinam sie o browar że problemy są przez nią powodowane :].
Offline
Swoją drogą, Warzone 2100 to gra sprzed 12 lat, powinna ruszyć na telefonie komórkowym ze średniej półki ;) .
Offline
nie wiem czy pomogą jakieś pyki myki typu ls -l /usr/lib/libGL* obstawiamy tu karte graficzną openGL
Lub sadystycznie http://yourubuntulinux.blogspot.com/2007/05/how-to-install-warzone-2100-game-on.html
Ostatnio edytowany przez Ryszard (2011-07-03 17:07:13)
Offline
Pobrałem starszą wersję paczek z grą z repozytorium dla debiana squeeze, lecz nadal występuje ten sam błąd. Sprawdziłem dowiązanie symboliczne do biblioteki i wszystko wydaje się być w porządku. Co do karty graficznej to korzystam ze sterownika fglrx i mam zainstalowane wiele natywnych gier 3d (m. in. Shadowgrounds, Prey, Enemy Territory, Sauerbraten). Wszystkie te gry poza Warzone 2100 działają bez zarzutu.
Offline
1) Masz paczki mesy zainstalowane?
2) Przypuszczam, że raczej w tym momencie powinieneś walnąć FacePalm'a, ale czy system startuje ze sterowników ATI (A nie żadnej Vesa'y)
3) Spróbuj uruchomić wersję 32-bitową (masz teraz 64, ta?)
Fervi
Offline
I poza tym nie kompilowałbym kodu z przed kilku lat kompilatorem
Compiled by: GCC 4.6.1 20110507 (prerelease)
Między werxsjami gcc-4.3, 4.4, 4.5 i 4.6 jest trochę różnic, dlatego dalej jest [url=http://gcc.gnu.org/]rozwijane[/url] gcc-4.3.* i 4.4.
Poza tym, jak pisali tą grę, to jeszcze nie było 64 bitowych systemów.......
U mnie ruszyła na x86 kompilowana gcc-4.4.5.
To by było na tyle
Ostatnio edytowany przez Jacekalex (2011-07-04 17:33:28)
Offline
Wersja z repo Wheezy amd64 działa normalnie, także teorie o kompilatorach i bitach możecie sobie odpuścić. ;) Tu coś jest z systemem autora, a nie samą grą czy jej wersją dostępną w repo Debiana. Co — niestety nie wiem. :|
Offline
[quote=ArnVaker]Wersja z repo Wheezy amd64 działa normalnie, także teorie o kompilatorach i bitach możecie sobie odpuścić. ;) Tu coś jest z systemem autora, a nie samą grą czy jej wersją dostępną w repo Debiana. Co — niestety nie wiem. :|[/quote]
Jeśli u Arniego na Amd64 chodzi, i nie wiadomo, co jest grane u @pribina, to może potraktować program debugerrem?
gdb `which program` set args "argumenty programu" run
pisane z pamięci, więcej: http://www.gentoo.org/doc/pl/bugzilla-howto.xml
Ewentualnie można pobawić się [b]strace[/b], ale wypluje kilka kilometrów logu (NIE WKLEJAĆ NA FORUM TAKICH TASIEMCÓW)
Przykład:
strace -o /tmp/program-log -f `which program --arg --arg2`
Uwaga, - lepiej żeby /tmp miało kilkadziesiąt mega wolnego miejsca :D
To by było na tyle
;-)
Offline
Widziałem gdzieś na launchpadzie podobne zgłoszenie o błędzie i prawdopodobnie jest to błąd w sterowniku od ATI. W tej chwili mam sterownik w wersji 11.4. Na stronie ATI oraz w repozytorium sida jest już wersja 11.6. Poczekam aż nowsza wersja trafi do testinga i może wtedy uda się rozwiązać ten problem.
edit: Po ostatniej aktualizacji sterowników mesy pojawił się konflikt ze sterownikiem fglrx co zmusiło mnie do jego usunięcia. Po uruchomieniu kompa na otwartym sterowniku Radeon warzone2100 uruchamiał się i działał poprawnie. Niestety otwarty sterownik oferuje o wiele gorszą wydajność niż ten od ATI co uniemozliwia uruchomienie bardziej wymagajacych gier typu Doom 3.
edit2: Przez ostatnie 3 miesiące nie interesowałem się tematem, lecz wczoraj z ciekawości zainstalowałem warzone 2100 i o dziwo uruchomił się już za pierwszym razem. Najwidoczniej aktualizacje sterownika lub gry naprawiły błąd, który uniemozliwiał uruchomienie gry.
Ostatnio edytowany przez pribina (2011-10-30 13:43:50)
Offline
Time (s) | Query |
---|---|
0.00013 | SET CHARSET latin2 |
0.00006 | SET NAMES latin2 |
0.00100 | 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='18.218.95.236' WHERE u.id=1 |
0.00066 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '18.218.95.236', 1732225648) |
0.00048 | SELECT * FROM punbb_online WHERE logged<1732225348 |
0.00064 | DELETE FROM punbb_online WHERE ident='18.225.149.158' |
0.00073 | SELECT topic_id FROM punbb_posts WHERE id=176976 |
0.00227 | SELECT id FROM punbb_posts WHERE topic_id=19288 ORDER BY posted |
0.00061 | 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=19288 AND t.moved_to IS NULL |
0.00005 | SELECT search_for, replace_with FROM punbb_censoring |
0.00147 | 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=19288 ORDER BY p.id LIMIT 0,25 |
0.00077 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=19288 |
Total query time: 0.00887 s |