Match finder SQL error

Forum dedicato allo script per i tornei e ladder di videogames PHP Rivals mod.
Form about phpRivals Mod script.

Match finder SQL error

Messaggioda nenuc0 » 21/10/2013, 14:24

Hi!

When I try to submit a match finder on a 1on1 ladder I have this error.

Codice: Seleziona tutto
General Error
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 'OR match_groupid = 2) LIMIT 1' at line 1 [1064]

SQL

SELECT * FROM phpbb_rivals_matchfinder WHERE match_ladder = 2 AND (match_groupid = OR match_groupid = 2) LIMIT 1

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 193
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 240
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: [ROOT]/includes/ucp/rivals/ucp_rivals_match_finder.php
LINE: 527
CALL: dbal->sql_query_limit()

FILE: [ROOT]/includes/ucp/ucp_rivals.php
LINE: 721
CALL: ucp_rivals_match_finder()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: ucp_rivals->main()

FILE: [ROOT]/ucp.php
LINE: 327
CALL: p_master->load_active()


I downloaded the match finder fixes I saw in other topics but I have always the same error.

Thanks and hugs

nenuc0
Sconosciuto
 
Messaggi: 23
Iscritto il: 12/02/2012, 19:12
Nazionalità: Portugal (pt)
Numero MVP totali: Nessuno

Re: Match finder SQL error

Messaggioda Soshen » 21/10/2013, 15:26

let me check
Vedi le mie collezioni
Avatar utente
Soshen
Site Admin
 
Messaggi: 1357
Iscritto il: 09/07/2010, 23:54
Nazionalità: Italy (it)
Numero MVP totali: 4
Gamername: Soshen


Torna a phpRivals Mod

Chi c’è in linea

Visitano il forum: Nessuno e 1 ospite

cron