SQL Error: 1064

[mreal]

Hi,
I just joined this forum because I encountered an error with MySQL. I hope someone can help me out this. this had to be the worst week ever to have this problem...any tips would be appreciated!

Could not obtain acp index modules

DEBUG MODE

SQL Error : 1064 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 3

SELECT * FROM cgs_acp_section_modules WHERE section_id =

Line : 88
File : pagestart.php

what would be the cause of this error as my cms worked perfectly before?

[NogDog]

From the code/text provided, it appears you have no value being compared to section_id, therefore the SQL parse error. If you need help determining why there is no value, you'll need to show us the code that builds your query.

[mreal]

that was from line 83 to the end of the coding...i don't understand what would be wrong in this?!😕

$sql = "SELECT *
	FROM " . ACP_SECTION_MODULES_TABLE . "
	WHERE section_id = $section_id";
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not obtain acp index modules', '', __LINE__, __FILE__, $sql);
}

while( $row = $db->sql_fetchrow($result) )
{
	$catrow_temp = $row['catrow'];
	$modulerow_temp = $row['modulerow'];
}
$db->sql_freeresult($result);

$catrow_temp = eval("\$catrow = " . $catrow_temp);
$modulerow_temp = eval("\$modulerow = " . $modulerow_temp);

for( $i = 0; $i < count($catrow); $i++ )
{
	$cat_name = $catrow[$i];
	$template->assign_block_vars('catrow', array(
		'ADMIN_CATEGORY' => $cat_name)
	);

for( $j = 0; $j < count($modulerow[$i]); $j++ )
{
	$module_name = $modulerow[$i][$j][0];
	$module_link = $modulerow[$i][$j][1];

	$template->assign_block_vars('catrow.modulerow', array(
		'ADMIN_MODULE' => $module_name,
		'U_ADMIN_MODULE' => append_sid($module_link.'.'.$phpEx))
	);
}
}

?>

[mreal]

$sql = "SELECT *
	FROM " . ACP_SECTION_MODULES_TABLE . "
	[COLOR="Red"]WHERE section_id = $section_id";[/COLOR]
if( !($result = $db->sql_query($sql)) )
{
	message_die([COLOR="red"]GENERAL_ERROR, 'Could not obtain acp index modules'[/COLOR], '', __LINE__, __FILE__, $sql);
}

$section_id is actually value..

[mwasif]

Make sure the variable $section_id has some value.

[mreal]

mwasif wrote:

Make sure the variable $section_id has some value.

do i have to check this in MySQL or in a PHP page?? sorry I am null in PHP 😕

[mreal]

ok, in mySQL this is what I got..here's a screenshot

http://www.montrealhiphop.net/extras/mysql_screenshot.jpg

[mwasif]

Use this code and tell me what query you see. And run the same query in phpmyadmin.

$sql = "SELECT *
	FROM " . ACP_SECTION_MODULES_TABLE . "
	WHERE section_id = '$section_id'";
echo $sql;
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not obtain acp index modules', '', __LINE__, __FILE__, $sql);
}

[mreal]

I put

$sql = "SELECT * 
    FROM " . ACP_SECTION_MODULES_TABLE . " 
    WHERE section_id = '$section_id'"; 
echo $sql; 
if( !($result = $db->sql_query($sql)) ) 
{ 
    message_die(GENERAL_ERROR, 'Could not obtain acp index modules', '', __LINE__, __FILE__, $sql); 
} 

and got this from PhPmyadmin:

 Server: db1214.perfora.net   Database: db223422739   Table: cgs_acp_section_modules 
Error 
SQL query: 

$sql = "SELECT * FROM ".ACP_SECTION_MODULES_TABLE. " WHERE section_id = '$section_id'" 
MySQL said:  

[mwasif]

I meant to say use my PHP code instead yours. I only added echo $sql; in the code.