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 error on search.php version 3.6 upgrade
Alankeys
Posted on 07 Jun 2010, 09:11:01

Access: Member
Total Posts: 107
Joined: 2009-11-28


Getting the following error on calling search.php



Error: 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 'WHERE timestamp >= '1275346801' AND timestamp <= '1275433201'' at line 1
Statement: SELECT COUNT(id) AS hasnews FROM WHERE timestamp >= ? AND timestamp <= ?
Arguments: 1275346801,1275433201
#2398
Chris
Posted on 07 Jun 2010, 16:40:17

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

There is no search.php in 3.6

See here

http://code.google.com/p/n-13news/wiki/Integration
#2402
Alankeys
Posted on 07 Jun 2010, 17:47:32

Access: Member
Total Posts: 107
Joined: 2009-11-28

Tried all the path configs including full path.
It wont run. Just a blank screen.
#2405
Chris
Posted on 07 Jun 2010, 17:55:27

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

Show me the code you're using.
#2406
Alankeys
Posted on 07 Jun 2010, 18:09:24

Access: Member
Total Posts: 107
Joined: 2009-11-28


<?php
$search = true;
include ../news/index.php';
?>

<?php
$search = true;
include 'news/index.php';
?>

<?php
$search = true;
include '/home/sites/domian.com/public_html/news/index.php';
?>




etc
#2408
Chris
Posted on 08 Jun 2010, 01:44:12

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

Hint: the search form has been moved into the templates.

If you're using an older template, like 3.2, it won't have the search form. Use Ajax 3.6 template as the default and it should work, compare the differences between it and the one you're currently using.
#2410
Alankeys
Posted on 08 Jun 2010, 10:41:52

Access: Member
Total Posts: 107
Joined: 2009-11-28

Thank you Chris

Ive got it....
By the way, it implements a nice list.....


Just a further question, what is the best way to get the search box directly under the article ? I tried a few ideas. Obviously it could be added in an i frame but I was hoping to put the box under article so that search stayed within same frame [no new window].

edit : sort of expected the search to added in 'news structure' ?
#2411
Last edited by Alankeys at 2010-06-08 11:40:34 Reason:
Chris
Posted on 08 Jun 2010, 12:17:54

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

Currently you can't. What you can do though is add another include with $search = true specified so that the search form always shows.
#2414
Network-13.com © 2013