Anyone have any ideas..

[NoKSouLz]

Anyone have any ideas what this error message means:

Im puzzled

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 '' at line 1

Comes up when clicking a team in the tournament and ladder script..

Only does it on that page, but its not giving me an actual error just says that

What could it mean?

[Lynne]

Something is wrong on that page near the first line. What does the page look like? And does it say the page name? Are you getting the errors sent to you via email?

[NoKSouLz]

If i copied and pasted the code would any of you be able to pick out whats wrong?

I tried to look myself but failed miserably lmao

--------------- Added 08 Sep 2009 at 23:06 ---------------

First section of the code which is the file that used when it errors:

<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # Copyright ? BananaLive Scripts. All Rights Reserved. ############# ||
|| ################################################## ################## ||
\*================================================ ======================*/

error_reporting(E_ALL & ~E_NOTICE);
define('THIS_SCRIPT', 'competitions');
if ($_REQUEST['do'] && in_array($_REQUEST['do'], array('addannouncement', 'editannouncement', 'editrules', 'addteam', 'editteam')))
{
define('GET_EDIT_TEMPLATES', true);
}
$phrasegroups = array('posting', 'postbit', 'user', 'timezone', 'global', 'pm', 'reputationlevel', 'search');
$specialtemplates = array(
'bbcodecache',
'smiliecache',
);
$globaltemplates = array(
'editor_clientscript',
'editor_css',
'editor_jsoptions_font',
'editor_jsoptions_size',
'editor_smilie',
'editor_smiliebox',
'tmnt_editrules',
'editor_smiliebox_row',
'editor_smiliebox_straggler',
'editor_toolbar_off',
'editor_toolbar_on',
'memberinfo_block_visitormessaging',
'memberinfo_css',
'memberinfo_usercss',
'newpost_disablesmiliesoption',
'showthread_quickreply',
'tmnt_addcomment',
'tmnt_cmpt',
'tmnt_bracket',
'tmnt_cmptlms',
'tmnt_cmptlms',
'tmnt_cmptlms',
'tmnt_index',
'tmnt_teamlist',
'tmnt_teamlist_bot',
'tmnt_teamlist_top',
'tmnt_team_won',
'tmnt_ladder_edit',
'tmnt_index_lbit',
'tmnt_index_tbit',
'tmnt_ladder_list',
'tmnt_ladder_list_bot',
'tmnt_ladder_list_top',
'tmnt_ladder_cmpt_ddms',
'tmnt_ladder_new',
'tmnt_newteam',
'tmnt_cmptlms_top',
'tmnt_cmptlms_bot',
'tmnt_comment',
'tmnt_createteam',
'tmnt_display',
'tmnt_displayannouncement',
'tmnt_displayrules',
'tmnt_displayteam',
'tmnt_edit',
'tmnt_team_join',
'tmnt_editann',
'tmnt_editcomment',
'tmnt_editplayer',
'tmnt_editteam',
'tmnt_hof',
'tmnt_hof_bot',
'tmnt_hof_top',
'tmnt_join',
'tmnt_ladder_chll',
'tmnt_ladder_allchll',
'tmnt_ladder_allchll_rm',
'tmnt_ladder_allchll_bot',
'tmnt_ladder_allchll_none',
'tmnt_ladder_allchll_top',
'tmnt_ladder_tlchll',
'tmnt_ladder_tlchll_bot',
'tmnt_ladder_tlchll_none',
'tmnt_ladder_tlchll_top',
'tmnt_ladder_chllpm',
'tmnt_ladder_chll_bot',
'tmnt_ladder_chll_top',
'tmnt_ladder_cmpt',
'tmnt_ladder_cmpt_bot',
'tmnt_ladder_cmpt_none',
'tmnt_ladder_cmpt_top',
'tmnt_ladder_display',
'tmnt_ladder_elorating',
'tmnt_ladder_join',
'tmnt_ladder_insertmatch',
'tmnt_ladder_repmatch',
'tmnt_ladder_repmatch_top',
'tmnt_ladder_repmatch_bot',
'tmnt_ladder_submitscore',
'tmnt_letter',
'tmnt_list',
'tmnt_listann',
'tmnt_listann_bot',
'tmnt_listann_top',
'tmnt_list_bot',
'tmnt_list_top',
'tmnt_new',
'tmnt_newannouncement',
'tmnt_editcat',
'tmnt_newplayer',
'tmnt_noannouncements',
'tmnt_nocomments',
'tmnt_notmnts',
'tmnt_playerstats',
'tmnt_rules',
'tmnt_shell',
'tmnt_swapplayer',
'tmnt_teammember',
'tmnt_teammember_ddm',
'tmnt_threadtemplate',
'tmnt_ladder_teamchal',
'tmnt_ladder_yourteams',
'tmnt_nocategories',
'tmnt_listcat_con',
'tmnt_listcat',
'tmnt_newcategory',
'pm_newpm'
&nbsp;);
$actiontemplates = array(
);

require_once('./global.php');
require_once(DIR . '/includes/functions.php');
require_once(DIR . '/includes/functions_tal.php');

$navbits = construct_navbits(array(
'competitions.php' . $vbulletin->session->vars['sessionurl_q'] => $modname,
'' => construct_phrase('Error')
&nbsp;));
eval('$navbar = "' . fetch_template('navbar') . '";');

// ################################################## ###########################

[Marco van Herwaarden]

Posting the script will not help. You will need to post the details of the error message. You can find these details either in your email or by right clicking on the error page and selecting Show Source.

[NoKSouLz]

The thing is..

you dont receieve any email from the error as its not a database error.

And clicking view source on the page reveals nothing, all it says in the source is what i pasted in the first post :\

[Lynne]

If it is saying it's a MySQL error on the first line of that code, then I would guess there is something weird about how the page is being called. MySQL shouldn't be involved in that part of the page at all. Take a look at the code that calls that page.

(Also, typically any 'code' (like your 'do' comparisons that you have at the top of that page) should go after all the array definitions and includes.)