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

I just made it one step further... I found that in the 
conf/phpOpenTracker.php file, I had to uncomment line 96:

$PHPOPENTRACKER_CONFIGURATION['merge_tables_mode'] = 'month';

(in addition to the edit for 
$PHPOPENTRACKER_CONFIGURATION['db_type']).

I am no longer getting the table doesn't exist error... now I 
just get a blank page that loads and loads and loads, but never 
displays any data! After about 3 minutes, the status bar in the 
browser reports "Done", but the page remains blank.

Is there anyone who has mysql_merge working that can offer any ideas?

thanks!
SAM :)



solutions_PHP wrote:
> 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.