SmartCJ Support Forum

Hi.

Imported too much videos to TCMS. Server is not responding properly. Can't delete videos from admin panel.
Can you please tell me, from which tables should I delete videos? Delete all of them is not an option, I will lose rotation results.

What I'm asking for, is sql query that is used when I'm deleting a thumb from TCMS

Thanks

Hi,

too many is how many?

sql: delete from rot_gallery_info ....

Hi. Over 800k. I mean not too much for SmartCJ, but to much for my server
Thanks!

what queries are slow?

It's not about slowness. Big amount of videos and tags is too much for my low-RAM server It says that some temporary table is full, couldn't even enter List Thumbs page in admin panel. Anyway, already deleted everything from Settings -> Special

I see , ok