Search Module don't work..

xantique · Posted: Sat May 22, 2004 5:30 pm

Hi,
My search module is stopped to work..
when I do a search It's show only the last news page resaults.. Question

My last interventions are :

1-Changing the path of my site from Admin Panel
from mysite.com/html/ to mysite.com/html

2-Changing My_Accont index file from Raven's Autoactivation hacked index file to the standart index file (with activation)

Thanks for any advise..

Usişng : 6.0 ----> 7.0 patched (4 sites running on same db if help )

sixonetonoffun · Posted: Sat May 22, 2004 5:54 pm

Are you using Fortress by chance? I've seen it reported to cause wierd errors with certain languages?

If not try using the old 7.0 search as a test to see we can narrow down to a time where it did work. You could even try the file from the 7.3 version of the patched Series.

But if we can get to a version that works it would help to locate what has changed. If you've tried some of those already with no results we'll have to dig deeper. But all the new filtering I could see where the language could be raising a hidden issue.

When I tried it I was able to get other then the first news story but never more then one result.

sixonetonoffun · Posted: Sat May 22, 2004 6:03 pm

Actually I tried again searching
"et" and it returns 4 results from News so its working to search news somewhat. Though I'd have thought it would return a huge number of results for such a common string. (and 3 results for weblinks)

xantique · Posted: Sat May 22, 2004 6:45 pm

Thanks sixonetonoffun,

Quote:

Are you using Fortress by chance? I've seen it reported to cause wierd errors with certain languages?

No, I don't use Fortess..
I tryed two differend index.php (booth 7.0) No result..
7.3 not yet tryed..

Quote:

When I tried it I was able to get other then the first news story but never more then one result.

That's true ..
I get only one result and only from the last new page..

xantique · Posted: Sat May 22, 2004 7:12 pm

1-I tryed 7.1, no effect.
2-I just figured out that It can't find even in the last news page..
3-I changed back my sites' path : no resault..
(In this case ,nothing to do with the path modification...)
4- I changed back Raven's Autoactivation hacked index.php in Your_account Module index.php) : no resault ..
In this case ,nothing to do with with Your_Account index.php change
Rolling Eyes

It's strange.. Confused

sixonetonoffun · Posted: Sat May 22, 2004 7:43 pm

Yes its strange and no I don't think the settings or account files should have any effect on the Search module. I'm at a little bit of a loss here assuming that all the tables are ok because your sites active and you'd notice if the authors table or stories table was corrupt and not responding and the search would throw some error message.

I don't think the Patch files have anything in them that would cause this behavior I did a quick compare and see nothing that stands out and they work on the test site.

Which leads back to whats being truncated here the query or the result? I'm guessing the query. Lets try taking mainfile.php and removing all the new filtering from it once just to verify there isn't any issues there.

Try commenting out this Union Tap in your mainfile.php its about the only recent addition there. If there is no improvement let us know maybe we can get some more input from someone else. Be sure to put them back if there is no improvement.

Code:

//Union Tap
//Copyright Zhen-Xjell 2004 http://nukecops.com
//Beta 3 Code to prevent UNION SQL Injections
unset($matches);
unset($loc);
if (preg_match("/([OdWo5NIbpuU4V2iJT0n]{5}) /", rawurldecode($loc=$_SERVER["QUERY_STRING"]), $matches)) {
die("YOU ARE SLAPPED BY <a href=\"http://nukecops.com\">NUKECOPS</a> BY USING '$matches[1]' INSIDE '$loc'.");
}

xantique · Posted: Sun May 23, 2004 7:19 pm

Thanks for your advices sixonetonoffun..
Sorry been late but I was working on patching latest Chatserv fixes and applying Raven's Hackalert and Http Athentication scriptes .. Shocked

All are done and working now Very Happy

I installed Union Top script above just under Hackalert in my mainfile
I tryed also 7.2 and 7.3 searh modules..
But there is no improvment , my search problem issue is still continue.. Neutral

xantique · Posted: Mon May 24, 2004 6:46 pm

1-Tryed old mainfile (backup) ,no effect;

2-Installed Chatserv's Search Content Hack,
(You can download it here:

Only registered users can see links on this board!
Get registered or login to the forums!

)

It works ,Thanks to Chatserv but didn't resolved "narrowed query" problem..

3- Discovered 2 brandnew Smile

Sql "286" error :

A- Stories Archive's Sql don't work

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in.... /local/home.../includes/sql_layer.php on line 286

B- FAQ Administration Sql don't work

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
in ...../local/home/.../includes/sql_layer.php on line 286

Quote:

Which leads back to whats being truncated here the query or the result? I'm guessing the query.

May be "A" is the answer.. Question

Raven · Posted: Mon May 24, 2004 8:30 pm

Have you tried running a REPAIR on your database using phpmyadmin? Also, I assume that everything was working? If so, what changes were made that stopped it all that you can rememeber?

xantique · Posted: Tue May 25, 2004 5:05 am

Thanks Raven...

Quote:

Also, I assume that everything was working?

Right .. (Except Faq Admin )

Quote:

Have you tried running a REPAIR on your database using phpmyadmin?

No I couldn't ..Since 4 days my hosting company has tons of problems, so I can't acces to my DB Sad

Last modification that I did :

Quote:

1-Changing the path of my site from Admin Panel from mysite.com/html/ to mysite.com/html

2-Changing My_Accont index file from Raven's Autoactivation hacked index file to the standart index file (with activation)

(I restored them back but no improvment)
In addition to those, if I remember well, I was tryed to resolve 2.06 BB2 Avatar issue changing site paths at Admin cp and following the instructions on this Forum , but I couldn't repair it and restored back .. Confused

Right now I am going to try one more time to acces to my db..
Mad

Raven · Posted: Tue May 25, 2004 5:33 am

You know, I offer quality hosting with great support Smile

blith · Client Joined: Jul 18, 2003 Posts: 977

Raven wrote:

You know, I offer quality hosting with great support Smile

I'll second that emotion!! Go with RavenWebHosting!!

xantique · Posted: Tue May 25, 2004 7:23 pm

Thanks Raven four your kind invitation..

Very Happy

Yes, I know that I have to change immediatly my host..
But unfortunatly, before joining RavenHosting and "triple the emotion" together with blith Laughing

I have to wait several mounths.. (because of prepaid amount ) Mad

At the end, reached my db today Exclamation

After digging and changing some tables, I have some improvment..

Here are the results :

1-Stories Archive's : repaired , working
2-Faq Admin Sql repaired but I can't add new categories..
3-Search problem continue , is still "narrowed" Crying or Very sad

Raven · Posted: Tue May 25, 2004 7:42 pm

Tell you what. Let me know your disk space and bandwidth requirements and how many months you have prepaid and I may just host you for free until then. Man, I am in a fine mood tonight Laughing

xantique · Posted: Tue May 25, 2004 8:46 pm

so, I am lucky tonight..
(here, It's 5 35 in the morning, I didn't sleep yet! )

Concerning prepaid months, I don't remember all the details ..
I have to check this through my hosting's cp ,
a task which is not always evident !

Depanding on my hosting cp availability Confused

, tomorrow
I'll try to send your pm a message
with my account / need details..

Thanks again Raven..

xantique · Posted: Fri Aug 26, 2005 7:13 am

Problem with my search Module which doesn't search before 16th May 2004 is Resolved..

Hi,

Yes my search module problem is resolved:

In those days (16 th. May), after an hack attempt (author injection, before installing Sentinelle ), for security reasons, after creating a new one, I was deleted my hacked Admin ID which was created during the install of new phpbb2.0.6 to Nuke...*

This was the reason of such bizarre behavior...

After recreating my old deleted Admin ID, averything working fine now.. Laughing

Thanks a lot four your valuable time and support

Raven and Sixonetonoffun

--------------------------------------
*Nuke Version 7.0 (upgraded from 6.5 ) + phpbb2.0.6 to Nuke..

In those times BB Forums wasn't included yet to the official Nuke 6.5 package...
So, manual install of BB was needed and during this install, "dublicate" Admin ID was necessary...
(dublicate : First one for "normal" PhpNuke Admin, second one - same - for BB2 first admin login..)