Deleting all but most recent shouts

[Jerri Blank]

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

[Lesmond]

TinyPortal admin>Manage Blocks>Shoutbox

[Jerri Blank]

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.    I was looking for a query I could run as a shortcut.



jb

[Lesmond]

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

[Jerri Blank]

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

#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

[brianjw]

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

#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?

[Jerri Blank]

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

[Jerri Blank]

Okay, the problem was the "*".  Question answered - issue resolved. Thanks!



jb