Do not remember me!
/ / / Need help with sql code

Need help with sql code

Well I have this problem, I am not sure but is there an sql code I can use to switch the database URL ? They have a perfect one for wp but I see nothing for DLE
my images are to the new address but the images are not showing,,
WP Code
UPDATE wp_posts SET post_content=(REPLACE (post_content, '<old url>','<new url>'));
Added by: in MySQL Questions on
This question is marked as answered. Answered by: dlefaq


0

Comments 9

  1. yorismith
    0
    yorismith Currently Offline → 12 June 2015 18:29

    you don't need manually query to database...what you need is change url in config.php and run "Rebuild Articles" everything is done automatically not just dle_post but also in comments, pm etc...
     N/A |  45
  2. Kathryn
    0
    Kathryn Currently Offline → 12 June 2015 19:27

    Something is wrong .. after I preformed the rebuild article, nothing has changed I am still going to have to do all the images manually.
     14 |  46
  3. Kathryn
    0
    Kathryn Currently Offline → 12 June 2015 19:28

    Quote: Kathryn
    Something is wrong .. after I preformed the rebuild article, nothing has changed I am still going to have to do all the images manually.

    Also here is the address:

    
    http://ebook-mecca.com
     14 |  46
  4. dlefaq
    0
    dlefaq Currently Offline → 12 June 2015 19:57

    everything working fine to me, only "related articles" has not changed all you need is "Rebuild Cache For Related News" from the same section in rebuild articles in admin cp everything else is fine
     2 |  102
  5. Kathryn
    0
    Kathryn Currently Offline → 12 June 2015 20:10

    Honestly I did that too but I am still changing links in the categories . I am half done already and fixed all my buttons too...

    Now... the only thing I would like is the .htaccess settings for Bullet Energy ? Everything else is there it is just not showing and I know it is the code for .htaccess since I have access im my cpanel... it uploaded blank and I had to copy onto it the one for DLE now I just need that one code and all is good
     14 |  46
  6. dlefaq
    0
    dlefaq Currently Offline → 12 June 2015 21:27

    do you add links and URL in xfields? if the answer is "Yes" then export and find and replace then import back...10 minutes should be done if your database smaller than 100mb
     2 |  102
  7. Kathryn
    0
    Kathryn Currently Offline → 13 June 2015 11:09

    No I was fixing the image links and they are all done ... seems the only thing I am missing is the code to go on the .htaccess for bullet energy, since I do not think anyone has it or whatever I will reinstall and write over with the previous version to save myself re-posting for the 3rd time lol
     14 |  46
  8. yorismith
    0
    yorismith Currently Offline → 13 June 2015 13:34

    anyone will have it...and you can find the code in different ways
    - grab it from your old .htaccess which you have backup from your old host
    - http://www.dleguide.com/bullet-energy/125-install-bullet-energy.html
    - login to bullet energy forum admin and generate the code in forum settings
     N/A |  45
  9. Kathryn
    0
    Kathryn Currently Offline → 13 June 2015 14:04

    Thank you and I reinstalled it... it was not large or anything so it is not a problem to do it.

    I wish I could get a hold of my dang provider so he could take of the output buffering and downgrade my php No one has seen him anywhere,,,and quite frankly I am freaking out. LOL I just wish I could have taken an un-managed VPS and next year will try and find a good one.
     14 |  46

Information

Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.