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

This topic has 4 replies, 2 voices, and was last updated 9 years, 11 months ago by Anonymous.

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
Anonymous
Inactive
Topics: 0
Replies: 3227
Total posts: 3227
Post count: 0
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
Anonymous
Inactive
Topics: 0
Replies: 3227
Total posts: 3227
Post count: 0
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.