Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×
Hosting webh.pl - 20%

ROZWIĄZANY: Pisanie tematu

dudeka

Przez dudeka
w Ogólny support IPB

 Udostępnij

Rekomendowane odpowiedzi

dudeka Współpracownik

dudeka

Opublikowano
Opublikowano

Witam. Problem jest strasznie denerwujący. Otóż gdy chcemy na forum napisać jakiś temat, edytor tekstu nie odświeża się i nie widać napisanego tematu. Aby go zobaczyć trzeba cofnąć stronę i dany dział odświeżyć i wtedy napisany przez nas temat się pokazuje. Jaka może być tego przyczyna i jak to naprawić ?

Reaver Wschodząca gwiazda

Reaver

Opublikowano
Opublikowano

Wyczyść cache przeglądarki. Z jakiego korzystasz hostingu, może nie nadąża? Poza tym w 3.3.3 masz sporo ajaxa, dlatego ta wersja potrzebuje więcej przestrzeni niż poprzednie.

CR.

Macsch15 Arcymistrz

Macsch15

Opublikowano
Opublikowano

O taki problem chodzi

http://forum.invisio...ezeniem-strony/ ,

http://forum.invisio...edzi-do-tematu/ ?

Z jakiego korzystasz hostingu, może nie nadąża?

Też mi się tak wydaje, że hosting jest za słaby.

A co jeśli JS wykonuje się od strony użytkownika a nie serwera? :blink:

Poza tym w 3.3.3 masz sporo ajaxa, dlatego ta wersja potrzebuje więcej przestrzeni niż poprzednie.

Podobne ilości były w... 3.2... 3.1...

Nawet jeśli teraz jest trochę więcej kodu JS, to na pewno nie na tyle żeby kupować dyski po kilka TB.

dudeka Współpracownik

dudeka

Opublikowano
  • Autor
Opublikowano

Teraz to mam inny problem :/

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here

dudeka Współpracownik

dudeka

Opublikowano
  • Autor
Opublikowano (edytowane) 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:00 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYD' (Errcode: 28)
IP Address: 82.146.224.12 - /uploads/profile/photo-19547.jpg?_r=0
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(4,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:03 +0000
Error: 1060 - Powtórzona nazwa kolumny 'field_3'
IP Address: 82.146.224.12 - /admin/index.php?adsess=54a7db712078063bf3c20508634cb39d&app=members&&module=members&section=members&do=member_edit&member_id=19547&secure_key=08366b07b4bd966d5585e4c2bf2bf9b1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: ALTER TABLE pfields_content ADD field_3 text NULL
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/customfields/profileFields.php					 | [db_main_mysql].addField													 | 393			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_admin/members/members.php			 | [customProfileFields].parseToSave											 | 1949			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_admin/members/members.php			 | [admin_members_members_members]._memberDoEdit								 | 84			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_members_members_members].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:09 +0000
Error: 1060 - Powtórzona nazwa kolumny 'field_3'
IP Address: 82.146.224.12 - /admin/index.php?adsess=54a7db712078063bf3c20508634cb39d&app=members&&module=members&section=members&do=member_edit&member_id=19547&secure_key=08366b07b4bd966d5585e4c2bf2bf9b1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: ALTER TABLE pfields_content ADD field_3 text NULL
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/customfields/profileFields.php					 | [db_main_mysql].addField													 | 393			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_admin/members/members.php			 | [customProfileFields].parseToSave											 | 1949			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_admin/members/members.php			 | [admin_members_members_members]._memberDoEdit								 | 84			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_members_members_members].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:21 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 82.146.224.12 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(4,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:53 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 82.146.224.12 - /index.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(4,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:55 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 212.160.171.210 - /uploads/profile/photo-thumb-19547.jpg?_r=0
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:43:56 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 195.54.187.110 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:44:06 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 87.199.21.21 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:44:18 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 123.125.71.51 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:44:18 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 89.229.138.161 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:44:27 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 89.229.138.161 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:44:27 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_1.MYI' (Errcode: 28)
IP Address: 82.146.224.12 - /index.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(4,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 10 Jul 2012 09:44:29 +0000
Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)
IP Address: 89.229.138.161 - /index.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
 FROM core_tags t WHERE 1=1
 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE
 ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/sources/classes/hooks/gateway.php			 | [classes_tags_cloud].getCloudData											 | 78			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/boardIndexTags_39522151142c91c41c55deef4888ea57.php				 | [forums_hookGateway].tags													 | 17			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [boardIndexTags].getOutput												 | 3462			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							 | [output].templateHooks													 | 2724			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [output].sendOutput														 | 124			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [public_forums_forums_boards].doExecute									 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
-------------------------------------------------------------------------------------------------------

wklejam kawałek kodu bo cały post z całym kodem się coś długo ładował :D

Edytowane przez dudeka
Macsch15 Arcymistrz

Macsch15

Opublikowano
Opublikowano (edytowane)

Ouch. Strzelam że tu akurat może być wina hostingu.

Sprawdź najpierw bazę.

Zaawansowane :a: Diagnostyka :a: Baza danych

+

Zaawansowane :a: Diagnostyka :a: Indeksy bazy danych

Jeśli są jakieś błędy, kliknij na "System ma spróbować naprawić to za ciebie?"

Jeśli się nie naprawią, pod każdym błędem masz zapytanie które powinieneś uruchomić w PMA.

Edytowane przez Macsch15
  • Manager
DawPi Arcymistrz

DawPi

Opublikowano
  • Manager
Opublikowano

Ustawiłeś pełne prawa użytkownika SQL dla danej bazy danych? Bo ten błąd sugeruje coś innego.

Error: 1 - Can't create/write to file '/tmp/#sql_4172_0.MYI' (Errcode: 28)

Tak czy inaczej powinienieś napisać zgłoszenie do admina serwera z tym błędem i niech on go jeszcze zweryfikuje pod kątem błędów na Twoim serwerze.

intermedia - profesjonalne rozwiązania Invision Power Board

---

Chcesz uzyskać szybko i sprawnie pomoc? Uzupełnij wersję i adres w profilu.

dudeka Współpracownik

dudeka

Opublikowano
  • Autor
Opublikowano

DawPi, odpisano mi w unixstorm że wszystkie problemy z forum wynikają z braku miejasca na dysku nie praw zapisu. Jest też inny problem. w bazie znajduje się tabela mail, która zajmuje 3 GB, dodatkowo ostatnio gracze zaczęli się skarżyć na spamowanie ich skrzynek mail, właśnie dziś się okazało, że niby my wysłaliśmy do nich 150 tyś. maili. Co z tym zrobić ? Właśnie w ACP pokazuje mi, że jest problem z tą bazą , po wykonaniu zapytania wyskakuje "Powtórzona nazwa kolumny 'm_id' " co zrobić ? Czy to tutaj leży cały problem z pisanie postów ? Bez tego forum nie działa tak jak powinno

dudeka Współpracownik

dudeka

Opublikowano
  • Autor
Opublikowano

Mam taką tabelę : mail_queue.

Do niej komentarz :

Kliknij tutaj by naprawić tę tabelę, lub możesz uruchomić ręcznie następujące zapytanie:

ALTER TABLE mail_queue ADD mail_id int(10) NOT NULL auto_increment, ADD PRIMARY KEY( mail_id);

ALTER TABLE mail_queue ADD mail_date int(10) NOT NULL default 0;

ALTER TABLE mail_queue ADD mail_to varchar(255) NOT NULL default '';

ALTER TABLE mail_queue ADD mail_from varchar(255) NOT NULL default '';

ALTER TABLE mail_queue ADD mail_subject text;

ALTER TABLE mail_queue ADD mail_content text;

ALTER TABLE mail_queue ADD mail_html_on int(1) NOT NULL default 0;

ALTER TABLE mail_queue ADD mail_cc TEXT NULL DEFAULT NULL;

dudeka Współpracownik

dudeka

Opublikowano
  • Autor
Opublikowano

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

Table './pawlo123_forumipb/mail_queue' is marked as crashed and last (automatic?) repair failed

To się pojawia. Poza tym wchodząc przez Zaawansowane -> Zarządzanie SQL -> Przegląd bazy ->mail_queue wyświetla się na górze strony

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/pawlo123/domains/cs-soplica.com/public_html/ips_kernel/classDbMysqliClient.php on line 471

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/pawlo123/domains/cs-soplica.com/public_html/ips_kernel/classDbMysqliClient.php on line 471

Warning: Invalid argument supplied for foreach() in /home/pawlo123/domains/cs-soplica.com/public_html/admin/applications/core/skin_cp/cp_skin_sql.php on line 497

Warning: Invalid argument supplied for foreach() in /home/pawlo123/domains/cs-soplica.com/public_html/admin/applications/core/skin_cp/cp_skin_sql.php on line 508

  • 2 tygodnie później...
PawloG Entuzjasta

PawloG

Opublikowano
Opublikowano

Dobra, tabela jest naprawiona, błędów podczas pisania tematów nie ma, jednak problemem jest zasypywanie znowu mailami uzytkowników. Wczoraj wysłało 230 tysięcy maili. Co może być przyczyna?

Zauważyłem w tabeli w mail_queqe ze do wielu userów jest wysyłana wiadomość: User

dodał nowy temat ....

  • Manager
DawPi Arcymistrz

DawPi

Opublikowano
  • Manager
Opublikowano

No właśnie, może ludzie mają włączoną obserwację danej pozycji i im te maile przychodzą.

Sprawdź czy nie masz włączonej w ACP opcji o nazwie Automatically follow every forum i dla których grup.

  • Lubię to 1

intermedia - profesjonalne rozwiązania Invision Power Board

---

Chcesz uzyskać szybko i sprawnie pomoc? Uzupełnij wersję i adres w profilu.

PawloG Entuzjasta

PawloG

Opublikowano
Opublikowano

Tak, opcja była włączona i to dla prawie wszystkich grup. Dziwne, bo wątpie czy ktoś ją ustawiał, chyba że po aktualizacja sama się ustawiła. Dziwi mnie też, że ja nie otrzymywałem żadnych maili. Support IPB polecił także wyczyszczenie tabeli mail_queue, ponieważ zalegało tam około 250 tysięcy maili. Zrobiłem to wcześniej i nie pojawiły się żadne wpisy o powiadomieniach o nowych tematach.

Dzięki za pomoc, myślę że będzie normalnie już działać wszystko, ale dam znać jutro czy była jakaś fala maili ;)

Gość
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
 Udostępnij
Tematy

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.