phpBB2 by Przemo
Support forów phpBB2 modified by Przemo

FAQFAQ - PIERWSZA POMOC!!  regulaminREGULAMIN  SzukajSZUKAJ  UżytkownicyUżytkownicy  GrupyGrupy  StatystykiStatystyki
RejestracjaRejestracja  ZalogujZaloguj  DownloadDownload  katalog Forów DyskusyjnychKatalog Forów   FAQ Video tutoriale

Poprzedni temat «» Następny temat
Before you ask question
Autor Wiadomość
Matteo



Pomógł: 1932 razy
Posty: 5715
Wysłany: 01-09-2010, 19:50   Before you ask question

Before you ask us about help with forum, you can alone have a try combine something…

I give here few examples, what you can try to do…

Contents list:
1) Repair tables,
2) Table doesn't exist,
3) Synchronize forums/topics/posts/users,
4) Cache,

Ad 1)
Probably happened to you, that displays you error type:
Kod:
Could not query last visit posts

DEBUG MODE

SQL Error : 145 Table 'phpbb_read_history' is marked as crashed and should be repaired

SELECT post_id, topic_id, forum_id FROM phpbb_read_history WHERE user_id = 2

Line : 41
File : read_history.php


Or:
Kod:
Couldn't access list of Categories

DEBUG MODE

SQL Error : 145 Table 'phpbb_categories' is marked as crashed and should be repaired

SELECT * FROM phpbb_categories ORDER BY cat_order, cat_id

Line : 195
File : functions.php


Let's try to read this error…
Example 1:
Kod:
SQL Error : 145 Table 'phpbb_read_history' is marked as crashed and should be repaired


In this case, try to repair it sending query by example phpMyAdmin:
Kod:
REPAIR TABLE `phpbb_read_history`;


Example 2:
Kod:
SQL Error : 145 Table 'phpbb_categories' is marked as crashed and should be repaired


So, we use earlier query, only changing in it name of tablei:
Kod:
REPAIR TABLE `phpbb_categories`;




Ad 2)
Sometimes (usually with forum moving) show up errors type:
Kod:
phpBB by Przemo : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'xxx.phpbb_users' doesn't exist

SELECT * FROM phpbb_users WHERE user_id = -1

Line : 420
File : sessions.php

This means, that table phpbb_users is missing. This error display usually, when we give wrong prefix in config.php file.
Therefore, let's check it…
Go to the phpMyAdmin and we should see tables, usually name of tables begins just prefix phpbb_, but if there are another prefix we must go to file config.php and change prefix, example:
If in phpMyAdmin we have prefix xxx_ that change:
Kod:
$table_prefix = 'phpbb_';

To:
Kod:
$table_prefix = 'xxx_';


If proved that is not in this issue, check, whether certainly we have this table. If not – probably we delete it in case or database was hacked. In this case contact with your hosting provider and please of last database backup.



Ad 3)
Maybe you happened, that, when you make a post on your forum display blank page, or you see that in x forum is visible, that someone written x post yesterday, but really today someone other written another post there.

In this case you should look to:
http://www.forumadress.com/check_files.php?mode=sql&type=all
If in database are some errors, then go to Administration Panel and in order we doing synchronize:
Users,
Forums (and in this: number of topics in the forum, number of posts in the forum, latest post in the forum, number of replies to topics, the latest post on topics).



Ad 4)
If after any changes in template files etc don't see changes on forum, that remember to clean cache on forum! Administration Panel => Admin Index => Under of the users online list „Clear Cache: SQL & templates”.

I hope, that small FAQ little help you.

If after all of this you can't cope with error on forum, calmly you can write new topic :)

(original content)
_________________
Fora, strony, sklepy internetowe i wiele więcej...
matteo.fcb(at)gmail.com
 
     
Gadatliwa Kasia 

   
Wyświetl posty z ostatnich:   
Odpowiedz do tematu
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
Nie możesz załączać plików na tym forum
Możesz ściągać załączniki na tym forum
Dodaj temat do Ulubionych
Wersja do druku

Skocz do:  

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,06 sekundy. Zapytań do SQL: 11
Polecane serwisy

Najlepsze oprogramowanie do prowadzenia sklepu internetowegoNajlepszy program do sklepu firmowany przez Przem'a

Sklep z gadżetami

mediaclick.pl

serwis laptopów

phpbb

Polisy Ubezpieczeniowe TU Europa

Design Cart - Tworzenie sklepu internetowego

dnirozwoju.pl

Ranking Hostingów HostingOnline.pl

• Zamów reklamę