Your Time:

Our Time:

← Back to discussions

✓ Update problem in MySQL

Need help with a different issue? Search the forums or open a new ticket.

Open a support ticket

Resolved

Posted in: MusicPlay

This topic has 4 replies, 2 voices, and was last updated 10 years, 1 month ago by Fem.

2016-10-06 at 5:19 am
Support Expired

#16887
cameleweb
Participant
Topics: 14
Replies: 59
Total posts: 73
Post count: 61
Hi!

I made a mistake when adding some buttons on an album, for my links to iTunes. I ran this query to correct the error in one shot :

UPDATE wp8s_postmeta SET meta_value=REPLACE(meta_value, '&mt=1&app=music', '&app=itunes')

The value was updated in te database, but when I edit the album, I dont see the info anymore.
What’s wrong?

Reply
2016-10-06 at 1:17 pm

#16908
Fem
Keymaster
Topics: 2
Replies: 8473
Total posts: 8475
Post count: 6003
That’s a custom work what you have did and we are not sure what you are trying to do.

Reply
2016-10-06 at 5:03 pm
Support Expired

#16910
cameleweb
Participant
Topics: 14
Replies: 59
Total posts: 73
Post count: 61
I tried to correct the URL for all my buttons. See the attachement I forgot at first.

Reply
2016-10-08 at 3:47 am
Support Expired

#16941
cameleweb
Participant
Topics: 14
Replies: 59
Total posts: 73
Post count: 61
Sorry, i’ve just found the solution.
Changing the URL changed also the lengh of this metadata (the s:NN in the string before the URL). I have to change also this value.
It’s working now!
Sorry for the disturbance!

Reply
2016-10-13 at 10:49 am

#17020
Fem
Keymaster
Topics: 2
Replies: 8473
Total posts: 8475
Post count: 6003
Topic is set to be resolved. If you wish to update this topic please reply here instead of creating another topic.

Reply

You must be logged in to reply to this topic.