Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-02-05 17:48:59

egid
Member
Registered: 2005-11-30
Posts: 10
Website

Table 'txp_log' doesn't exist

I recently had to restore my txp install from a backup database on a new server, and this has been popping up if I go to my ‘logs’ page:

Warning: Table ‘aeronaut.txp_log’ doesn’t exist delete from txp_log where time < date_sub(now(), interval 7 day) in /home/.levi/ericg/aeronaut/textpattern/lib/txplib_db.php on line 84

Warning: Table ‘aeronaut.txp_log’ doesn’t exist select count(*) from txp_log where 1 in /home/.levi/ericg/aeronaut/textpattern/lib/txplib_db.php on line 84

No referrers recorded.

What’s the table structure for txp_log so that I can recreate it? Much appreciated!

Last edited by egid (2007-02-05 17:49:34)

Offline

#2 2007-02-05 20:19:44

hcgtv
Archived Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: Table 'txp_log' doesn't exist

Here you go, the txp_log table structure

Offline

#3 2007-02-05 20:30:42

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: Table 'txp_log' doesn't exist

That’s a nice list, Bert, I’ll bookmark it!

Offline

#4 2007-02-05 22:20:37

egid
Member
Registered: 2005-11-30
Posts: 10
Website

Re: Table 'txp_log' doesn't exist

Thanks! :D

Offline

#5 2007-02-05 22:51:15

hcgtv
Archived Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: Table 'txp_log' doesn't exist

egid, I added the auto_increment description for tables that use it, like txp_log.

Els, when I get a chance, I’ll add descriptions to all the fields. I’ll look at a brand new install’s database and comb through the code to come up with what certain fields are and what they could contain.

Offline

Board footer

Powered by FluxBB