[ phpopencounter-Bugs-863822 ] POT wants to access pot_accesslog_200401 in mysql_merge mode

Bugs item #863822, was opened at 2003-12-21 09:30
Message generated for change (Settings changed) made by nicknol
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101716&aid=863822&group_id=1716

Category: Analysis Module
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nick Nolte (nicknol)
Assigned to: Nobody/Anonymous (nobody)
>Summary: POT wants to access pot_accesslog_200401 in mysql_merge mode

Initial Comment:
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


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101716&aid=863822&group_id=1716


-------------------------------------------------------
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