Home N-13 News Forums Help Search
RegisterForgot password?
How to add image to post necklacesdiscou
Known bugs - 4.0.3 necklacesdiscou

Latest N-13 News 4.0.3

What is N-13 News?
Where can I get help?
Known bugs

Forums Help & Support 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:

:grin:!

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
Network-13.com © 2013