Re: [phpOpenTracker-general] more split_tables.php problems

Hello--

When I last wrote to the list a month ago today, I was having 
problems with the split tables script. I have rewritten the 
script and now have it working, in that it properly moves the 
data into the new monthly tables. But I've run into another 
problem...

Now my reports don't work. I am using the default report file 
include included with v1.5. When I try to view the report, I get 
the error:

phpOpenTracker Error: Table 'phpopentracker.pot_visitors' doesn't 
exist

That's right, it doesn't exist because it was replaced by

'phpopentracker.pot_visitors_200512'

What appears to be happening is that the report is pulling up the 
the value for visitors_table as defined in the Config file, when 
it should be accessing the class in mysql_merge.php to generate 
the proper name for the table to access (visitors_table_yearmonth).

Does Config.php need an edit? Is there a problem with the 
mysql_merge.php file? How can I get the report file to recognize 
the new monthly tables created by the split_tables.php script?

If anyone can offer some insight, I would be most appreciative! I 
had to disable phpOpenTracker last month due to the slow 
performance without mysql_merge, and I'm eager to get this back 
online.

cheers
SAM :)

ps. If you're interested in the revised split_tables.php script, 
it's here:
http://www.solutionsphp.com/contribute/phpopentracker/split_tables.txt
NOTE: No guarantees, use at your own risk!!

solutions_PHP wrote:
> Hello--
> 
> I have been having trouble with the split_tables.php tool and my web 
> research about the issue has led me to subscribe to this list where I 
> hope I can find some help.
> 
> I ran the script on my 1.5 installation of phpOpenTracker. I first set 
> db_type to MySQL_merge. When I executed the script, I received an error 
> about an undefined function, createMergeTable.
> 
> In looking at the database, I can see that the new monthly tables were 
> indeed created, but the data was not moved into them, and the front end 
> of the app now generates errors about tables not being found.
> 
> I found another post in the mailing list archives from just yesterday 
> recounting a similar issue with split_tables:
> http://article.gmane.org/gmane.comp.web.phpopentracker.general/766
> 
> I also found a post from May where a user attached his modified version 
> of the script, which apparently works well. Unfortunately, the download 
> appears to be corrupt:
> http://article.gmane.org/gmane.comp.web.phpopentracker.general/726
> 
> In addition, there's a note in Google's cache about how the 
> split_tables.php script was removed from the package back in 2003 
> because it "never really worked". The version of the script I downloaded 
> just last week is 1.4 2003/12/05, so I'm wondering if this is that same 
> script has just never really worked (and if so, why it would still be 
> offered as a download...)
> 
> Any ideas, suggestions, or a link to download that "working" version of 
> the script?
> 
> Thank you in advance!
> SAM :)



-- 
Sam Stevens, solutions_PHP
http://www.solutionsphp.com/
Open source? Of course!

**************************************************
Tired of sifting through all that SPAM? We recommend using
MailWasher, an excellent tool for socking it to spammers.
Download a free trial:
http://fta.firetrust.com/index.cgi?id=5966&page=1
**************************************************

IMPORTANT - CONFIDENTIAL INFORMATION
Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message (or
responsible for delivery of the message to such person), you may not
copy or deliver this message to anyone. In such case, you should
destroy this message and kindly notify the sender by reply email.