You have an error in your SQL syntax;

Joop

Posted on 19 Jul 2009, 19:59:55

Access: Member
Total Posts: 4
Joined: 2009-07-19

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
What does this mean?? and what can i do

#672

Chris

Posted on 20 Jul 2009, 09:09:50

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

I'll need a bit more information. Where did you see this error? what were you doing when it occurred?

#673

Joop

Posted on 20 Jul 2009, 13:28:35

Access: Member
Total Posts: 4
Joined: 2009-07-19

well i have a index.php
whith

Code:


<?php
$cat[] = 'All';
include 'Nieuws/index.php';
?>

Here i have no problem
but at the other pages

i have this

Code:


<?php
$cat[] = '[i]Category name[/i]';
include 'Nieuws/index.php';
?>

And than i get the error message

#675

Last edited by Joop at 2009-07-20 13:29:04 Reason:

Chris

Posted on 20 Jul 2009, 21:37:50

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

In 3.2 by default all categories get shown if none are specified. So try doing this

Code:


<?php
include 'Nieuws/index.php';
?>

#678

Joop

Posted on 21 Jul 2009, 08:39:43

Access: Member
Total Posts: 4
Joined: 2009-07-19

But when i have all categories it works, and when i want only 1 i get that error message

#679

Ccs9623

Posted on 12 Aug 2009, 01:21:32

Access: Member
Total Posts: 16
Joined: 2009-07-10

Any idea on this one? I'm getting the same thing.

When I add the $cat[] ='cat_name';

I get the error message. If I remove this, all works fine.

#707

Ccs9623

Posted on 12 Aug 2009, 01:37:37

Access: Member
Total Posts: 16
Joined: 2009-07-10

Ah Ha!

I figured it out (I think). The error only comes up if there are no news items with the specified catagory! As soon as you assign at least one news item to the category, it works as advertised.

If this helps, and you can fix it, I'd really appreciate it :smile2:

#706

Chris

Posted on 12 Aug 2009, 10:59:34

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Quote:

Ah Ha!

I figured it out (I think). The error only comes up if there are no news items with the specified catagory! As soon as you assign at least one news item to the category, it works as advertised.

If this helps, and you can fix it, I'd really appreciate it :smile2:

!

That's awesome, I'll fix this later today.

#723

Chris

Posted on 12 Aug 2009, 11:56:42

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

This is now fixed, if you download this file extract it, and upload to your server replacing your own copy of index.php with this new one.

#724

Ccs9623

Posted on 12 Aug 2009, 20:06:44

Access: Member
Total Posts: 16
Joined: 2009-07-10

Fantastic! Thanks for the fix.... and so fast too! :happy:

#725