|
|
phpBB2 by Przemo
Support forów phpBB2 modified by Przemo
|
|
DEBUG MODE |
Autor |
Wiadomość |
Miniman
Posty: 22
|
Wysłany: 04-05-2007, 23:43 DEBUG MODE
|
|
|
Hello. I have recently installed your PhpBB modification on my website(http://miniman.110mb.com/forums/index.php). But I keep getting "DEBUG MODE" errors. They are coming up all over the place. One of them is this:
Cytat: | Could not obtain post/user information.
DEBUG MODE
SQL Error : 1030 Got error 28 from storage engine
SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_parent, p.post_icon, p.user_agent, p.post_attachment, p.post_expire, u.user_sig_image, u.user_birthday, u.user_from, u.user_icq, u.user_msnm, u.user_yim, u.user_avatar_width, u.user_avatar_height, u.user_field_1, u.user_allow_field_1, u.user_field_2, u.user_allow_field_2, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb1_posts p LEFT JOIN phpbb1_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb1_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb1_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 45 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15
Line : 843
File : viewtopic.php
|
This appears sometimes when you click on a topic. I did edit the viewtopic.php one time to add a mod. I am thinking that might be the reason. If you think this could be it then I can show you my viewtopic.php file.
Any help is appreciated. |
|
|
|
 |
Gadatliwa Kasia
|
|
|
|
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 04-05-2007, 23:51
|
|
|
U must realize query:
Kod: | REPAIR TABLE phpbb1_posts |
|
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 00:00
|
|
|
Thanks! I think it worked!
EDIT: Im wrong. It is still there. |
|
|
|
 |
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 05-05-2007, 00:11
|
|
|
Try:
Kod: | optimize table phpbb1_posts |
|
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 00:14
|
|
|
Nope. The message is coming up every time I open a thread now. |
|
|
|
 |
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 05-05-2007, 00:19
|
|
|
Try:
Kod: | REPAIR TABLE phpbb1_advertisement
OPTIMIZE TABLE phpbb1_advertisement |
If this won't help, try to synchronize forums, users, posts, etc. |
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 00:27
|
|
|
That didn't work either. This is annoying. And I don't want to synchronize forums. |
|
|
|
 |
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 05-05-2007, 00:34
|
|
|
Miniman napisał/a: | And I don't want to synchronize forums. |
U need to do that |
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 00:40
|
|
|
My host isn't even letting me upload. So I don't know. Thanks for the help anyway |
|
|
|
 |
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 05-05-2007, 00:45
|
|
|
Miniman, but U can't even use ACP option?
ACP => Forum Admin => Synchronize |
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 00:56
|
|
|
lord_nicon napisał/a: | Miniman, but U can't even use ACP option?
ACP => Forum Admin => Synchronize |
I would but I messed something else up when trying to fix it. I needed to upload a file so I could replace my current viewtopic.php but my host wouldn't let me. So I replaced the code myself but it went weird and I still can't upload so I can't fix it and right now when you try to view a topic you just get a bunch of code. |
|
|
|
 |
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 05-05-2007, 01:02
|
|
|
Miniman napisał/a: | bunch of code. |
Show me this code.
WTF is it a hosting that U cant upload files? O_o
When U try to upload any file U c any error? Anything? |
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 01:06
|
|
|
It says "Error uploading file "viewtopic.php"" And the code is just the viewtopic.php code. It doesn't seem to work when I click edit through the file manager. |
|
|
|
 |
nicon

Pomógł: 359 razy Posty: 2151
|
Wysłany: 05-05-2007, 01:09
|
|
|
It's rly weird, try to contact with hosting admins, bcs it is php code, it can't just show a code of this file. O_o Unlock forum, I need to look @ that. |
_________________ Pozdrawiam, Piotr `nicon` Kowalczyk.
Pomoc poza forum tylko odpłatna.
DBA - jak sama nazwa wskazuje - jest to osoba, która dba o bazy danych. |
|
|
|
 |
Gadatliwa Kasia
|
|
|
|
Miniman
Posty: 22
|
Wysłany: 05-05-2007, 01:09
|
|
|
I just found out that on the server my site is on no one can upload files. So I guess I will have to wait.
Unlocked forum, take a look. |
Ostatnio zmieniony przez Miniman 05-05-2007, 01:13, w całości zmieniany 1 raz |
|
|
|
 |
|
Nie możesz pisać nowych tematów Nie możesz odpowiadać w tematach Nie możesz zmieniać swoich postów Nie możesz usuwać swoich postów Nie możesz głosować w ankietach Możesz załączać pliki na tym forum Możesz ściągać załączniki na tym forum
|
Dodaj temat do Ulubionych Wersja do druku
|
Kopiowanie wszelkich treści zawartych na forum, modyfikacji oraz instrukcji bez zgody administracji i autorów tematów/postów zabronione!
Powered by phpBB modified by Przemo © 2003 phpBB
| Strona wygenerowana w 0,1 sekundy. Zapytań do SQL: 11 | |
 |
|