Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
txp_log table doesn't exist (Visitor Logs)
Hi,
I have had this problem for a few months actually, but only now bothering to try and fix it. When I go to textpattern/index.php?event=log I get
Warning: Table '(db).txp_log' doesn't exist delete from txp_log where time < date_sub(now(), interval 28 day) in
(...)textpattern/lib/txplib_db.php on line 81
Warning: Table '(db).txp_log' doesn't exist select count(*) from txp_log where 1 in (...)textpattern/lib/txplib_db.php
on line 81
No referrers recorded.I really liked looking at my visitor logs, actually, so I’d kind of like them back. :)
I did have rss_admin_db_manager extension installed. When I click on the “Extensions” tab it creates, I get a message “Restricted Area”. Now that is quite weird: I’m sure that tab used to work in the past.
Upgrading to 4.06 might have caused something to break…
High diagnostics: http://pastebin.com/f348f972d
Should I just recreate the table and see what happens? If so, what do I need to tell MySQL?
thanks…
Brianna
Last edited by pfctdayelise (2008-07-23 11:44:13)
Offline
#2 2008-07-23 13:01:18
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: txp_log table doesn't exist (Visitor Logs)
pfctdayelise wrote:
I did have rss_admin_db_manager extension installed. When I click on the “Extensions” tab it creates, I get a message “Restricted Area”. Now that is quite weird: I’m sure that tab used to work in the past.
Upgrading to 4.06 might have caused something to break…
See this post.
Offline
Re: txp_log table doesn't exist (Visitor Logs)
OK, thanks, that extension is fixed. I can’t imagine that would have delete the log table from my database though… would it?
Brianna
Offline
#4 2008-07-24 03:20:39
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: txp_log table doesn't exist (Visitor Logs)
No it wouldn’t, but you could very easily have dropped the table using that plugin, without intending to.
Yes, just re-create the table and you’ll be fine.
Offline
Re: txp_log table doesn't exist (Visitor Logs)
OK, I created the table using phpMyAdmin and trying to copy the description from another Textpattern install – and now I have my Visitor Logs back. Wooo… I can hardly believe that worked. :)
Offline
#6 2008-07-24 15:26:16
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: txp_log table doesn't exist (Visitor Logs)
Brianna
Glad you got that working — I have a question about how you initially setup the site though…
Did you originally setup this site by using rss_admin_db_manager to import a full backup from somewhere else? Or possibly to restore a backup you had previously made?
— Steve
Offline
Re: txp_log table doesn't exist (Visitor Logs)
Steve,
No, I just initially set it up in the normal “untar – follow install instructions” manner. I installed rss_admin_db_manager later. I had previously used it to make one backup file. But I never used that backup for anything.
Offline
#8 2008-07-24 15:46:22
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: txp_log table doesn't exist (Visitor Logs)
Ok, thanks.
— Steve
Offline