[2.0.21] Rebuild Search

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
58
81%
Very Good
10
14%
Good
3
4%
Fair
0
No votes
Poor
1
1%
 
Total votes: 72

ricola
Registered User
Posts: 1
Joined: Wed Mar 15, 2006 10:53 am

Post by ricola »

Excellent, thanks a lot!
Pirpa
Registered User
Posts: 1
Joined: Mon Mar 20, 2006 7:39 pm

Post by Pirpa »

Hi!

I think this MOD is very useful for all phpbb users. Ovever, phpbb has a lot of different implementations. One of the most spreaded is in the php-nuke portal.

I use the 7.6 php-nuke release. I tried to install the latest release of Rebuild Search Mod (2.2.), following the installation instruction provided with the mod, and the hints I found in this topic. Unfortunately, the mod still doesn't works. I always have a blank page on the right side of the administration panel.

Maybe because I'm working in local, using EasyPHP 1.8?

I hope to solve as soon as possible my trouble with it, I really need to rebuild my search.

If someone will help me, I will try to create a release specifically for php-nuke, if the author will give me his ok.

Thanks in advance!
cobrador
Registered User
Posts: 18
Joined: Wed Mar 22, 2006 4:58 pm

No errors, no nothing

Post by cobrador »

Nice mod btw, like the idea at least - i have moved my board from one host to another both running 2.0.17

when i installed at first it gave me an error but that was because my database was not 'phpbb' in name but phpbbxx so just changed that variable and it loaded with no sql errors

but when i run it no matter what settings i use it just does it instantly and doesnt actually update anything:

Code: Select all

Rebuild Search Progress 
Processed post ids : 3956 - 3956

Cleared search tables. 3916 post(s) were deleted by your users during processing. All posts were processed successfully.
All search tables were optimized successfully.
  
Processing post details 
   Processed Posts  Percent  
Current Session  from 1 to 1 (out of total 3917)  0.03 % completed

Total  from 3917 to 3917 (out of total 3917)  100 % completed

Processing time details 
  Processing time 
Last 1 post(s) of current session 00 days, 00 hours, 00 minutes, 01 seconds 
From the beginning of current session 00 days, 00 hours, 00 minutes, 01 seconds 
Average per cycle of current session 00 days, 00 hours, 00 minutes, 01 seconds 
Estimated until finish of current session 00 days, 01 hours, 05 minutes, 16 seconds 
 
Database size details 
  Current Estimated after finish 
Search Tables size 6.14 KB 15.83 MB 
Database size 813.29 KB 16.61 MB 


judging by the progress bars it seems to have finished at that and the button at the bottom says finished.

I checked by searching and it only brings results from a test post i created after the move

am i doing something wrong?
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

Please try to start from the begining and choose to clear the search tables.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
cobrador
Registered User
Posts: 18
Joined: Wed Mar 22, 2006 4:58 pm

Post by cobrador »

chatasos wrote: Please try to start from the begining and choose to clear the search tables.


starting id = 0
clear search tables = delete
number of posts = 3918 (max)
post per cycle = 50
time limit = 300
refresh rate = 3
disable board = no

hit rebuild

output:

Code: Select all

Rebuild Search Progress 
Processed post ids : 3956 - 3957

3916 post(s) were deleted by your users during processing. All posts were processed successfully.
All search tables were optimized successfully.
  
Processing post details 
   Processed Posts  Percent  
Current Session  from 1 to 2 (out of total 3918)  0.05 % completed

Total  from 3917 to 3918 (out of total 3918)  100 % completed

Processing time details 
  Processing time 
Last 2 post(s) of current session 00 days, 00 hours, 00 minutes, 01 seconds 
From the beginning of current session 00 days, 00 hours, 00 minutes, 01 seconds 
Average per cycle of current session 00 days, 00 hours, 00 minutes, 01 seconds 
Estimated until finish of current session 00 days, 00 hours, 32 minutes, 38 seconds 
 
Database size details 
  Current Estimated after finish 
Search Tables size 6.20 KB 6.20 KB 
Database size 813.51 KB 813.51 KB 
 
Active parameters 
Starting post_id 3956 
Processed post(s) on last cycle 2 
Time limit 300 
Board status Enabled 

am i entering wrong values?

it says 30 odd minutes but doesnt seem to do anything else and progress bars again go straight to full, and the database size doesnt change, on old forum was in region of 10MB when backed up from ACP
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

What kind of db (+version) are you using?
Also have a look here and try running those sql queries...
http://www.phpbb.com/phpBB/viewtopic.ph ... 99#1752399

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
cobrador
Registered User
Posts: 18
Joined: Wed Mar 22, 2006 4:58 pm

Post by cobrador »

running MySQL 4.0 database
100MB database with plenty of space left according to 1and1 control panel

that enough info?

Code: Select all

SQL query
SQL query: 
SELECT COUNT( post_id ) AS total_posts
FROM phpbb99_posts
WHERE post_id >=0
[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]



total_posts
3918

Code: Select all

SQL query
SQL query: 
SELECT COUNT( post_id ) AS total_posts
FROM phpbb99_posts
WHERE post_id <=4300
[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]



total_posts
3918
the two queries further down:
1st one returns 130 odd pages of stuff each one 30 odd long
the 2nd one returns: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0016 sec)
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

cobrador wrote: the two queries further down:
1st one returns 130 odd pages of stuff each one 30 odd long
the 2nd one returns: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0016 sec)


I guess you're refering to those 2:

Code: Select all

SELECT p.*
FROM phpbb_posts p
LEFT JOIN phpbb_posts_text pt ON p.post_id = pt.post_id
WHERE pt.post_id IS NULL;

Code: Select all

SELECT pt.*
FROM phpbb_posts_text pt
LEFT JOIN phpbb_posts p ON p.post_id = pt.post_id
WHERE p.post_id IS NULL; 
If one of them is returning any rows back, then i suppose you have same strange problem in your db. Does your forum work fine for all old posts?
Can you edit/delete/move them?


How many posts do you have?
How many records does each one of the above queries return?
You can run the following in order to find out the number of records of the posts tables:

Code: Select all

SELECT count(post_id)
FROM phpbb_posts;

SELECT count(post_id)
FROM phpbb_posts_text;

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
cobrador
Registered User
Posts: 18
Joined: Wed Mar 22, 2006 4:58 pm

Post by cobrador »

right it does appear that when clicking on old topics that it says 'No posts exist for this topic' - that'll probably e me messing up my database import or some other crappy issue, only removed the wordlist entries from my backup - chances are i made some ther small mistake

sorry to have wasted your time
SHH
Registered User
Posts: 52
Joined: Wed Feb 22, 2006 1:06 am
Contact:

Post by SHH »

Hi,

Sorry i'm new to phpmyadmin but how do you do this

Code: Select all

....
  KEY `end_post_id` (`end_post_id`)
);

this is what i have so far

Code: Select all

 rebuild_session_id   	mediumint(8)  	UNSIGNED  	No   	   	auto_increment   	
	 start_post_id  	mediumint(8) 	UNSIGNED 	No  	0  	  	
	 end_post_id  	mediumint(8) 	UNSIGNED 	No  	0  	  	
	 start_time  	int(11) 	  	No  	0  	  	
	 end_time  	int(11) 	  	No  	0  	  	
	 last_cycle_time  	int(11) 	  	No  	0  	  	
	 session_time  	int(11) 	  	No  	0  	  	
	 session_posts  	mediumint(8) 	UNSIGNED 	No  	0  	  	
	 session_cycles  	mediumint(8) 	UNSIGNED 	No  	0  	  	
	 search_size  	int(10) 	UNSIGNED 	No  	0  	  	
	 rebuild_session_status  	tinyint(1) 	  	No  	0 
and
 PRIMARY  	 PRIMARY  	 1   	 rebuild_session_id
I tried running this mod got no errors but search still does not work
SHH
Registered User
Posts: 52
Joined: Wed Feb 22, 2006 1:06 am
Contact:

Post by SHH »

After I run, the mod it says

"You successfully finished the processing (221 processed posts) on 24 Mar 2006 05:52 pm"

No mods installed (execpt this one), brand new installation, restored from another database that the search function didn't work. So, have phpbb 2.0.18, new clean install, but with data from another 2.0.18 installation. Both searches don't work.

This is the message when i search on both databases

Code: Select all

No topics or posts met your search criteria
TIA
SHH
Registered User
Posts: 52
Joined: Wed Feb 22, 2006 1:06 am
Contact:

Post by SHH »

After I run, the mod it says

"You successfully finished the processing (221 processed posts) on 24 Mar 2006 05:52 pm"

No mods installed (execpt this one), brand new installation, restored from another database that the search function didn't work. So, have phpbb 2.0.18, new clean install, but with data from another 2.0.18 installation. Both searches don't work.

This is the message when i search on both databases

Code: Select all

No topics or posts met your search criteria
also the search works fine for "Search for Author:"

TIA
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

Hi SHH,
Please have a look at the post i made just before...
http://www.phpbb.com/phpBB/viewtopic.ph ... 25#2055025

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
SHH
Registered User
Posts: 52
Joined: Wed Feb 22, 2006 1:06 am
Contact:

Post by SHH »

Hi thanks,

I have been trying to run these queries. I don't know that much about sql. I 'm using sql 4.0

Is there a place where i could learn to run this code

Code: Select all

SELECT count(post_id)
FROM phpbb_posts;

SELECT count(post_id)
FROM phpbb_posts_text;
I went to the place where I thought you could run a querie but it displays this "You have to choose at least one column to display"

Sorry.. new to this stuff...
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

You have to use a tool like phpmyadmin in order to run sql queries
Please have a look here:
http://www.phpbb.com/phpBB/viewtopic.php?t=74143

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
Post Reply

Return to “[2.0.x] MOD Database Releases”