Skocz do zawartości
Hosting webh.pl - 20%

ROZWIĄZANY: Drive error w komunikatorze

boguch

Przez boguch
w Ogólny support IPB

 Udostępnij

Rekomendowane odpowiedzi

boguch Nowicjusz

boguch

Opublikowano
Opublikowano

Mam taki sam problem jak w temacie : 5607-driver-error-po-uruchomieniu-wbudowanego-komunikatora

Rozwiazanie tam widnieje jednak nie potrafie go rozgryzc, wszedlem w baze danych ale tam taka tabela jak message_topic_user_map istnieje.

Prosze o szybka pomoc

boguch Nowicjusz

boguch

Opublikowano
  • Autor
Opublikowano

===================================================

Date: Mon, 16 Nov 2009 16:45:33 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address:xxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=4 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

===================================================

Date: Mon, 16 Nov 2009 16:52:18 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address:xxxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=4 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

===================================================

Date: Mon, 16 Nov 2009 16:53:21 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address: xxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=4 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

===================================================

Date: Mon, 16 Nov 2009 16:53:31 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address: xxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=1 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

===================================================

Date: Mon, 16 Nov 2009 16:53:35 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address: xxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=1 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

===================================================

Date: Mon, 16 Nov 2009 16:53:57 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address: xxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=1 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

===================================================

Date: Mon, 16 Nov 2009 17:06:19 +0000

Error Number: 1054

Error: Nieznana kolumna 'mm.map_last_topic_reply' w order clause

IP Address: xxxx

Page: /index.php?app=members&module=messaging

Debug: array (

1 =>

array (

'file' => '/xxx/public_html/ips_kernel/classDb.php',

'line' => 1010,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 762,

'function' => 'getPersonalTopicsList',

'class' => 'messengerFunctions',

),

4 =>

array (

'file' => '/xxx/public_html/admin/applications/members/modules_public/messaging/view.php',

'line' => 143,

'function' => '_showFolder',

'class' => 'public_members_messaging_view',

),

5 =>

array (

'file' => '/xxx/public_html/admin/sources/base/ipsController.php',

'line' => 291,

'function' => 'doExecute',

'class' => 'public_members_messaging_view',

),

)

mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id )

LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )

LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=1 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

boguch Nowicjusz

boguch

Opublikowano
  • Autor
Opublikowano (edytowane)

Dodać w kolumnie map_last_topic_reply tabele message_topic_user_map

cieszyl bym sie jak pomogl bys mnie przeprowadzic przez proces naprawy tego poniewaz nie moge takiej kolumny znalezc... - szukajac, tez nie znalazlo takiej kolumny/tabeli

Edytowane przez boguch
matma4u Mentor

matma4u

Opublikowano
Opublikowano

Wykonaj te komendy a PHPAdminie

ALTER TABLE message_topic_user_map ADD map_last_topic_reply INT(10) NOT NULL default '0';
UPDATE message_topic_user_map m, message_topics t SET m.map_last_topic_reply=t.mt_last_post_time WHERE m.map_topic_id=t.mt_id;

Pamiętaj o podaniu prefiksów właściwych dla twojej bazy

  • Lubię to 1

46279b204b.png

Rozwiążemy dla Ciebie każde zadanie z matematyki: http://matma4u.pl

boguch Nowicjusz

boguch

Opublikowano
  • Autor
Opublikowano (edytowane)

Wykonaj te komendy a PHPAdminie

ALTER TABLE message_topic_user_map ADD map_last_topic_reply INT(10) NOT NULL default '0';
UPDATE message_topic_user_map m, message_topics t SET m.map_last_topic_reply=t.mt_last_post_time WHERE m.map_topic_id=t.mt_id;

Pamiętaj o podaniu prefiksów właściwych dla twojej bazy

ok, tylko gdzie te prefiksy sa okreslone ( wybacz niestety jestem zielony ).

(ALTER TABLE message_topic_user_map ADD map_last_topic_reply INT( 10 ) NOT NULL default '0';# MySQL zwrócił pusty wynik (zero rekordów).

UPDATE message_topic_user_map m,

message_topics t SET m.map_last_topic_reply = t.mt_last_post_time WHERE m.map_topic_id = t.mt_id;# MySQL zwrócił pusty wynik (zero rekordów).)

I juz wszytsko dziala. serdeczne dzieki za pomoc !

Edytowane przez boguch
matma4u Mentor

matma4u

Opublikowano
Opublikowano

Jak jesteś w phpadminie to po lewej stronie masz kolumne z wszystkimi tabelami w bazie, podaj jakie pierwsze są litery przy nzawach.

Np. ipb_nazwa_coś_tam_dalej

Po prostu wszystkie tabele będo miały na początku ten sam "wyraz" i to będzie właśnie prefix

Super, cieszę się że mogłem pomóc

  • Lubię to 1

46279b204b.png

Rozwiążemy dla Ciebie każde zadanie z matematyki: http://matma4u.pl

  • Manager
DawPi Arcymistrz

DawPi

Opublikowano
  • Manager
Opublikowano

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.

intermedia - profesjonalne rozwiązania Invision Power Board

---

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

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ę.