[ 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 (Comment added) made by bergmann
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101716&aid=863822&group_id=1716

Category: Analysis Module
Group: None
>Status: Closed
>Resolution: Fixed
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


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

>Comment By: Sebastian Bergmann (bergmann)
Date: 2004-02-29 23:00

Message:
Logged In: YES 
user_id=7993

This should have been fixed. If not, please reopen the bug.

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

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


-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click