SQL syntax erorr [HELP]
Asked Modified Viewed 2,602 times
asked
hello,
I've erorr in my web at downloads categorys cat, this is it:
I was searching how to fix this problem, but nowhere found the answer.
I hope you can help me.
Thank's Tom,
I've erorr in my web at downloads categorys cat, this is it:
Code Download source
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 'LIMIT 0,15' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1I was searching how to fix this problem, but nowhere found the answer.
I hope you can help me.
Thank's Tom,
answered
if u want to know the sql statement that caused this error open your maincore.php (make copy before) look for function dbquery and modify it like this:
your output should look like this:
#SELECT * FROM .........." then the sql error msg.
post it here.
Code Download source
function dbquery($query) {
$result = @mysql_query($query);
if (!$result) {
[color=blue]echo "#$query<br/>";[/color]
echo mysql_error();
return false;
} else {
return $result;
}
}
your output should look like this:
#SELECT * FROM .........." then the sql error msg.
post it here.
Edited by wibix on 12-01-2006 23:43,
answered
Code Download source
#SELECT * FROM fusion_downloads WHERE download_cat='2' ORDER BY LIMIT 0,1000so, how fix it? :]
answered
before you read below... did you do any modifications yourself? does this problem occur everything, in each category or in one specific? check your sorting settings for cats - this is the problem here.
missing ORDER statement. order by what? e.g.
missing ORDER statement. order by what? e.g.
Code Download source
SELECT * FROM fusion_downloads WHERE download_cat='2' ORDER BY [color=blue]download_datestamp DESC[/color] LIMIT 0,1000
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
- Views 0 views
- Posts 3 posts
- Votes 0 votes
- Topic users 2 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions