Is there a SQL query I can run on the shouts table to delete all but the most recent 100 or so shouts? Um, wait, is there a shouts table? Where are the shouts stored?
Thanks,
jb
TinyPortal admin>Manage Blocks>Shoutbox
Thanks, but I don't want to delete all the shouts, nor do I want to do it one page at a time, since I have 896 pages of them. :o I was looking for a query I could run as a shortcut.
jb
They are stored in Table: smf_tp_variables, but I am not sure how to query the database its not one of my strong Points, hopefully someone will come along with a better idea :)
Found it.
Here's my query: DELETE * FROM `smf_tp_variables` WHERE `id` < "8861"
I'm not a query expert, and the error message I keep getting is
Quote#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `smf_tp_variables` WHERE `id` < "8861"' at line 1
I've tried the 8861 with and without quotes. Any ideas?
Thanks,
jb
Quote from: Jerri Blank on February 02, 2007, 12:32:39 AM
Found it.
Here's my query: DELETE * FROM `smf_tp_variables` WHERE `id` < "8861"
I'm not a query expert, and the error message I keep getting is
Quote#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `smf_tp_variables` WHERE `id` < "8861"' at line 1
I've tried the 8861 with and without quotes. Any ideas?
Thanks,
jb
Have you tried without the ` marks?
Quote from: brianjw on February 02, 2007, 12:55:57 AM
Have you tried without the ` marks?
phpmyadmin plugs them in automatically, so I'm afraid to remove them. Plus, a SELECT query with exactly the same syntax works fine.
jb
Okay, the problem was the "*". Question answered - issue resolved. Thanks!
jb