At the moment only allow to search thru posts since 5 weeks.
It will start from now on and every topic made will now be indexed.

I will continue improving it, but you can now use it as it is.

Watched topics and WAP pf are also on their way, i will soon have finished them

 

that may stop a few of the wingers......................



















not for long though

 

 

I don't know if i worded it correctly but i meant that every topic made since 5 weeks is present in it, and all the ones made from now on will be too.

HTH

The rest is as i said

 

now can we have the "view your posts" option back please

 

erm, it's there and has never left, Andy...

 

Top man Pet

I really have missed it

 

thanks

 

pity its not working

 

sorry but it is.

 

I know that mate but it doesnt work all i get is....

continued with a billion 6 digit numbers for ages!

 

It`s not woking for me this came up
real

Could not obtain topic ids

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 'GROUP BY p.topic_id' at line 5

SELECT p.topic_id FROM phpbb_posts p WHERE p.post_id IN (1853909, 1853987, 1854002, 1854039, 1854118, 1854141, 1854198, 1854565, 1854883, 1854893, 1855276, 1855280, 1855287, 1855296, 1855596, 1855805, 1848473, 1855922, 1856047, 1856094, 1820191, 1857731, 1858226, 1858837, 1859019, 1853429, 1860128, 1860352, 1861112, 1861287, 1861564, 1861582, 1861668, 1861692, 1861725, 1861787, 1862192, 1862206, 1862223, 1862315, 1862326, 1862387, 1862397, 1862473, 1862485, 1862509, 1862777, 1862801, 1862889, 1863184, 1863657, 1863818, 1863837, 1863867, 1864635, 1864664, 1864699, 1865136, 1865138, 1865153, 1865411, 1865534, 1865603, 1866066, 1867488, 1867600, 1867815, 1868021, 1868089, 1868323, 1868473, 1868503, 1868508, 1868521, 1868555, 1868637, 1868690, 1869476, 1869607, 1869928, 1870226, 1870279, 1870316, 1870362, 1870390, 1870584, 1870612, 1870652, 1871210, 1871234, 1871461, 1871475, 1871507, 1871626, 1871815, 1871821, 1871835, 1872101, 1872107, 1872220, 1872275, 1872456, 1872877, 1873026, 1873042, 1873094, 1873112, 1873156, 1873252, 1873262, 1873266, 1873476, 1873490, 1873534, 1873565, 1873619, 1873837, 1873972, 1874152, 1874343, 1874416, 1874472, 1874589, 1874675, 1874744, 1874786, 1874826, 1874870, 1875000, 1875006, 1875026, 1875060, 1875074, 1875079, 1875080, 1875149, 1875165, 1875219, 1875310, 1875405, 1875601, 1875747, 1876021, 1876066, 1876128, 1876297, 1876449, 1876533, 1876546, 1876653, 1876739, 1876767, 1876785, 1876898, 1877019, 1877095, 1877113, 1877324, 1877744, 1877772, 1877776, 1878011, 1878101, 1878139, 1878207, 1878253, 1878298, 1878313, 1878441, 1878497, 1878897, 1879241, 1879307, 1879343, 1879371, 1879421, 1879464, 1879520, 1879537, 1879587, 1879615, 1879659, 1879743, 1879760, 1879847, 1879912, 1879917, 1879921, 1879960, 1879999, 1880035, 1880040, 1880083, 1880120, 1880295, 1880323, 1880529, 1880930, 1880918, 1880942, 1880957, 1880987, 1881129, 1881486, 1881527, 1881602, 1882000, 1882064, 1882152, 1882157, 1882212, 1882696, 1882748, 1878280, 1883258, 1883278, 1883526, 1883622, 1883745, 1883882, 1884117, 1884128) AND p.forum_id NOT IN (37, 45, 55, 60, 66) GROUP BY p.topic_id GROUP BY p.topic_id

Line : 443
File : /home/passionf/www/forum/search.php

 

Well done Pet, top work mate! Welcome back Searchy!

 

Doo, can you tell me what exact search you did please, so i check? mine worked ...

 

same here, Its not working

 

"it's not working" does not help, do you know ?

please tell me what did you search and what is the error !

 

Could not obtain topic ids

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 'GROUP BY p.topic_id' at line 5

SELECT p.topic_id FROM phpbb_posts p WHERE p.post_id IN (1854277) AND p.forum_id NOT IN (37, 45, 55, 60, 66) GROUP BY p.topic_id GROUP BY p.topic_id

Line : 443
File : /home/passionf/www/forum/search.php

 

Pet:

Just tried a normal search for the word "blah"

Could not obtain topic ids

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 'GROUP BY p.topic_id' at line 5

SELECT p.topic_id FROM phpbb_posts p WHERE p.post_id IN (1854240, 1857685, 1858473, 1863669, 1867224, 1875193, 1875704, 1882599, 1884189) AND p.forum_id NOT IN (37, 45, 55, 60, 66) GROUP BY p.topic_id GROUP BY p.topic_id

Line : 443
File : /home/passionf/www/forum/search.php

Too many GROUP BY's

 

Pet, I get debug thingy if I use

VIEW MY POSTS thingy
Search for a keyword (example I used "turbo")
and SEARCH FOR AUTHOR

everytime I got the DEBUG message, could not obtain ID blah blah blah

VIEW YOUR POSTS has not worked for me in many months

 

thanks frog, will look

 

My pleasure

 

ok, can someone please test again, as i don't have those probs here...

i changed something in the code.

 

This is the error I got doing a search for "RS1800"
Might help.


Could not obtain topic ids

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 'GROUP BY p.topic_id' at line 5

SELECT p.topic_id FROM phpbb_posts p WHERE p.post_id IN (1855320, 1855478, 1855490, 1855498, 1855505, 1855521, 1855919, 1851544, 1858448, 1859418, 1865269, 1870305, 1332836, 1878538, 1879551) AND p.forum_id NOT IN (56, 37, 45, 51, 55, 54, 60, 66, 68) GROUP BY p.topic_id GROUP BY p.topic_id

Line : 443
File : /home/passionf/www/forum/search.php

 

Works for me, and it's QUICK

 

Always still been accessible from people's profiles.....

e.g.
https://passionford.com/forum/search...=Mr.Manchester

 

ok i found the glitch
everything should be ok now regarding searching. Cheers all for your help...

 

All ok now
Thanks again pet

 

np Doo, my pleasure.

Andy, you can confirm that it's working for you too, as well as "view your topics" ?

 

 

Its all good here Pet !!

Rapide comme l'eclair.....

 

Merci Natalie

 

Pet, was the PM I sent you any use ?

 

that's clever, testing code on a live server

 

 

De rien ..... errr.... ben je sais pas ton vrai nom!!!

 

frog, yes, sort of

 

Nath -> "Julien"

 

Do you permanently live your life in a black box with no windows and no light or what?

 

Julien.... oh c'est trop chou....

 

As long as the wap is back, will be.



Dave.