Print Page - Mysql to change article ID

Title: Mysql to change article ID
Post by: wildenborch on September 12, 2019, 06:51:45 AM

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

Title: Re: Mysql to change article ID
Post by: tino on September 12, 2019, 12:16:30 PM

Code Select

[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.

Title: Re: Mysql to change article ID
Post by: wildenborch on September 12, 2019, 07:05:00 PM

Thanks Tino,

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

Code Select

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

Fred

Title: Re: Mysql to change article ID
Post by: tino on September 12, 2019, 07:29:43 PM

Glad you worked it out.

Hope you're well.

Title: Re: Mysql to change article ID
Post by: wildenborch on September 14, 2019, 10:52:48 PM

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.

TinyPortal

Development => Support => Topic started by: wildenborch on September 12, 2019, 06:51:45 AM