TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 28, 2024, 08:10:26 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,104
  • Total Topics: 21,212
  • Online today: 143
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 1
  • Guests: 133
  • Total: 134
  • tino

Mysql to change article ID

Started by wildenborch, September 12, 2019, 06:51:45 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

wildenborch

Hi,

Can someone post the correct Mysql update code?

I want to update the category ID into another category ID for all articles with an ID less than ID 3000.

Thanks in advance,

Fred

tino

[codeUPDATE tp_articles SET category_id = '#' WHERE id < '3000';

Or similar to that, I'll post the correct one when I'm home this evening.

wildenborch

Thanks Tino,

I tried and changed some things and for me this code worked:

UPDATE smf_tp_articles SET category = "459" WHERE id < "3088"

Fred

tino

Glad you worked it out.

Hope you're well.

wildenborch

Yes I'm well! Thank you very much.

I recently received a letter from a lawyer informing me that on one of my sites a copyright picture was used and I had to pay a compensation fee of € 280.
First I thought it was fake / fraud but it turned out to be true.
Together with a trademark / copyright lawyer from work we looked into it but the conclusion was that I had to pay!

"fortunately" I managed to reduce the compensation fee with € 90,00

The picture on my site was a thumbnail of 150 * 90
it was a picture of a well known dutch football stadion called "de kuip"

I have now removed all pictures from that site.