[phpOpenTracker-User] problem/error: phpopentracker wants to access pot_accesslog_200401 in mysql_merge mode

I try to run version 1.3.2 in mysql_merge mode

I've deleted all tables. Then I created all tables except pot_accesslog and
pot_visitors.
After calling phpopentracker for the first time, the not existing tables
were created as merge tables:
pot_accesslog, pot_accesslog _200312
pot_visitors, pot_visitors_200312

As it ist december only one table is created ,obviously.

Now I called the simple_report to test my installation and when trying to
get the details for month december I got an error, because phpopentracker
wants to access pot_accesslog_200401 which does not exit yet.


page requested:
simple_report.php?page=month&client_id=1&month=12&year=2003

debug output:
CREATE TEMPORARY TABLE  pot_accesslog_temporary (
accesslog_id      INT(11)                NOT NULL,
timestamp         INT(10)    UNSIGNED    NOT NULL,
weekday           TINYINT(1) UNSIGNED    NOT NULL,
hour              TINYINT(2) UNSIGNED    NOT NULL,
document_id       INT(11)                NOT NULL,
exit_target_id    INT(11)    DEFAULT '0' NOT NULL,
entry_document    TINYINT(1) UNSIGNED    NOT NULL,

KEY accesslog_id   (accesslog_id),
KEY timestamp      (timestamp),
KEY document_id    (document_id),
KEY exit_target_id (exit_target_id)
) TYPE=MRG_MyISAM UNION=(pot_accesslog_200312,pot_accesslog_200401)

phpOpenTracker Error: Can't find file: '#sql584_5b_8.MRG' (errno: 2


Hope for hints and thank you for phpopentracker
Nick





-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click