Pagina 1 din 2

Recent messages

Scris: 15-Iun-2008, 21:17:29
de megeo
Phpbb: 3.0.1
Modul a fost instalat pe mai multe forumuri si nu am mai avut probleme la instalare. toate fisierele sunt la locul lor ok, modificarile facute, dar apare aceasta eroare
Eroare

Cod: Selectaţi tot

Eroare generală
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND p.post' at line 1 [1064]

SQL

SELECT f.forum_id, f.forum_name, LEFT(t.topic_title, 20) as topic_title, t.*, p.post_time, p.poster_id, u.username as last_username, u.username as author_username FROM (phpbb_forums f, phpbb_posts p, phpbb_topics t, phpbb_users u) WHERE f.forum_id IN (10,) AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND p.post_id = t.topic_first_post_id AND t.topic_moved_id = 0 AND p.poster_id = u.user_id AND t.topic_poster = u.user_id ORDER BY t.topic_last_post_id DESC LIMIT 3

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 159
CALL: dbal_mysql->_sql_query_limit()

FILE: recent_messages.php
LINE: 150
CALL: dbal->sql_query_limit()

FILE: index.php
LINE: 126
CALL: include('recent_messages.php')
Cine imi traduce chestia asta si eventual cum as putea rezolva?

Scris: 15-Iun-2008, 21:23:15
de pK - eXplosive
Eroare Generală
SQL ERROR [mysql4]

Aveti o eroare in sintaxa SQL; verificaţi manual care corespunde cu versiunea de pe server MySQL dvs. pentru dreptul de a utiliza aproape de sintaxa ") şi t.topic_status <> 2 AND t.forum_id = f.forum_id AND p.post 'la linia 1 [1064]

SQL

SELECT f.forum_id, f.forum_name, pe stânga (t.topic_title, 20) ca topic_title, or *, p.post_time, p.poster_id, u.username ca last_username, u.username ca author_username de la (phpbb_forums f, phpbb_posts p , Phpbb_topics t, phpbb_users u) f.forum_id ÎN CAZUL (10), şi t.topic_status <> 2 AND t.forum_id = f.forum_id AND p.post_id = t.topic_first_post_id AND t.topic_moved_id = 0 şi p.poster_id = u.user_id AND t.topic_poster = u.user_id ORDER BY t.topic_last_post_id desc LIMITÄ‚ 3

Backtrace

File: include / db / mysql.php
Line: 158
Call: dbal-> sql_error ()

File: include / db / mysql.php
Line: 205
Call: dbal_mysql-> sql_query ()

File: include / db / dbal.php
Line: 159
Call: dbal_mysql-> _sql_query_limit ()

File: recent_messages.php
Line: 150
Call: dbal-> sql_query_limit ()

File: index.php
Line: 126
Call: include ( "recent_messages.php ')
Traducere.

Scris: 15-Iun-2008, 21:24:56
de megeo
Versiune de server MySql gresita?

Alta intrebare:

Cum pot schimba versiunea? stiu ca se selecteaza la instalare.

Scris: 15-Iun-2008, 21:32:31
de pK - eXplosive
In config.php mi se pare, schimba "mysql" cu "mysqli", din cate imi amintesc asta trebuia facut, apropo sau invers.

Scris: 15-Iun-2008, 21:34:48
de megeo
ok. mersi de raspuns.

daca reusesc te anunt.

le:

am blank page acum

Scris: 15-Iun-2008, 21:39:44
de pK - eXplosive
Schimba inapoi, pare rau nu mai stiu cum se rezolva, stiam o data ca am avut si eu aceeasi eroare.

Scris: 15-Iun-2008, 21:40:32
de megeo
am schimbat inapoi.

Scris: 15-Iun-2008, 22:32:46
de dorin
megeo scrie:Versiune de server MySql gresita?
Ce server MySQL ruleaza ?

Scris: 16-Iun-2008, 12:34:56
de megeo
mysql 4

Scris: 16-Iun-2008, 13:44:14
de dorin
Un link catre mod ?