Re: Merge table weirdness

On Fri, 7 May 2004, Mika Tuupola wrote:

> 	Running 1.4.1 and after converting to mysql merge tables
> 	things stopped working. Loogin at the debug output

	To continue on this one. Logging the actual page requests
	fail too because of the missing weekday (and hour) columns.

-cut-
2	 	

INSERT
INTO pot_accesslog_200405
(accesslog_id,
timestamp, weekday, hour,
document_id, entry_document)
VALUES ('961387649', '1083932766', '5', '15', '1249675767', '0')

phpOpenTracker Error: Unknown column 'weekday' in 'field list'
-cut-

-cut-
mysql> describe pot_accesslog_200405;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| accesslog_id   | int(11)          |      | MUL | 0       |       |
| client_id      | int(10) unsigned |      |     | 0       |       |
| timestamp      | int(10) unsigned |      | MUL | 0       |       |
| document_id    | int(11)          |      | MUL | 0       |       |
| exit_target_id | int(11)          |      | MUL | 0       |       |
| entry_document | set('0','1')     |      |     |         |       |
+----------------+------------------+------+-----+---------+-------+
-cut-


-- 
Mika Tuupola                      http://www.appelsiini.net/~tuupola/




-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver
higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3