Programming Questions? Ask a Programmer for Answers ASAP
Hello and thank you for contacting us, a paid expert support site. My name is XXXXX XXXXX I'd be glad to assist you with your issue.
Sorry that link is protected as I would need an admin login to view. Is the difference between the two just a change in short code?
oh, sorry i sent you a link from the admin window
No worries. I am using Safari on a Mac and only see one player there
It's black in color
(I assume the Quicktime player)
i just took out the old player
that new player is the native media player
Ok, so yes, I see the native player.
So, if it is just a change in short code, it might be an easy fix directly through the database
i believe it is just a change in short code, but across the entire site
Can you paste me a sample of both codes for the same file?
from the "text"/code perspective it looks like
the first being the native
the second referencing the file as a link
Ok, so we are going from the second code to the first, correct?
And I assume they are all MP3s?
every single one
Great. Let me see what I can come up with - and do you have access to the database through your web panel or PHPMyAdmin?
yep, cpanel to phpmyadmin
i'm shocked there isn't a plugin to do this already
There might be but I am used to doing things directly. Programmer's mind, I guess... Haha
cool, let me know
Ugh, can't use regex in MySQL Replace()
Would you be willing to give me a dump of your database or at least the table of posts and I can replace the strings using an external program?
gimme a minute
Great. Once you have it, please upload it to Wikisend: http://www.wikisend.com/ or your preferred file sharing site.
If you use wikisend, please provide the File ID so that I can download it.
i might need a little help in this- I've never done it
No worries - go to the posts table under the database on the left and use the Export tab on the right-side. You can then export the table - it will either give you a .sql file or a .gz file.
i'm in finally
looking at php my admin
showing me three databases
Might be the second one, wrd1
Under it, do you have something like wp_posts listed?
i think our primary databse is the first
but i'll look
i don't know why the f**k that wp_1 is there
they both have posts options
but wp_3 has all my plugins
_dialectsarchive has everything you need I think
Ok, whichever you think is the right one - depends on your setup, really.
so quick export JUST the posts?
If you are entirely unsure, check your website via FTP or file manager from cpanel and look in the wp_config.php file
just export wp_posts?
It will tell you what database it is using.
Yes, just wp_posts is fine
sorry, it's doing the entire thing
Its ok if you do the entire thing, I can just pull out wp_posts.
If you go to the wp_posts table first, you can export just that table
getting wp_posts.sql now
is that what you want?
i was going to use we transfer
do you have an email
or tell me how you'd like to upload
i'm doing wikisend like you asked
ummm too big i guess?
email so i can use wetransfer?
I don't have a public email address, sorry.
Wikisend supports up to 100 MB.
well the file won't upload there
How big is the file?
one sec i'll check
i'll try a couple more times
We are sorry, but an error has occured while uploading.
You can return to the start page and try again.
throw me an alternate place to do this please
zippy share it is
there we go :)
Ok, give me a little bit to do the replacements.
Ok, sorry that took so long.
Here is the updated file. 6207 replacements! https://www.dropbox.com/s/muchv0e93rqhib8/wp_posts-updated.sql
What you'll want to do is go into the wp-posts table in phpmyadmin, in the import tab, you can upload the file back in. (hopefully your host allows large files to be uploaded!)
It will drop the old table and replace it with the updated table.
ummm, let me put up some notice and do that
so, this won't mess up anything else, yeah?
Nope and if it does, you have the backup of the old posts table.
Sorry for the delay, I didn't see your reply.
so i think this is working
i'm taking off our site warning and letting a few people test it
and then i'll be paying you in a hot second
Okies, take your time
Just checking in - I'm going to need to step out soon. Just wanted to see how things were going. Not trying to rush or anything.
I will be back in a little bit.
New is in. Working. Thanks! I'll pay now.