vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB5 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=262)
-   -   Change domain via phpmyadmin (https://vborg.vbsupport.ru/showthread.php?t=323346)

chikuru 08-26-2016 01:25 PM

Change domain via phpmyadmin
 
What are the steps needed to change the domain via phpmyadmin? I already changed the URL in bburl but its still redirecting to old site when trying to login via admincp

Dave 08-26-2016 01:58 PM

You're still being redirected to the old site because it's cached in the datastore. You have to clear the datastore.

chikuru 08-26-2016 02:10 PM

Quote:

Originally Posted by Dave (Post 2575270)
You're still being redirected to the old site because it's cached in the datastore. You have to clear the datastore.

Can you tell me how to clear it from pypmyadmin?

Replicant 08-26-2016 03:41 PM

Copy the install directory from your upload folder to the core directory, then copy the tools.php file from the do_not_upload folder. Navigate to the example.com/your_forum/core/install/tools.php and set the directory in Other Tools > Location of Website. Trying to do it in the database is just asking for all kinds of problems and isn't recommended.

chikuru 08-26-2016 04:26 PM

Quote:

Originally Posted by Replicant (Post 2575274)
Copy the install directory from your upload folder to the core directory, then copy the tools.php file from the do_not_upload folder. Navigate to the example.com/your_forum/core/install/tools.php and set the directory in Other Tools > Location of Website. Trying to do it in the database is just asking for all kinds of problems and isn't recommended.

This is already pointing to newer domain. However its still redirecting me to old domain whenever I try logging in only..

Replicant 08-26-2016 04:31 PM

I recently had an issue like this one and it was a 301 redirect in the cpanel that was causing the issue. After deleting the 301, the site came up and worked within 20 minutes.

chikuru 08-26-2016 04:35 PM

Quote:

Originally Posted by Replicant (Post 2575277)
I recently had an issue like this one and it was a 301 redirect in the cpanel that was causing the issue. After deleting the 301, the site came up and worked within 20 minutes.

There is no redirect in place. Maybe its datastore cache as what Dave is referring? Do you know how to clear it?

noypiscripter 08-26-2016 04:49 PM

I assumed you already executed these SQL queries.

Code:

update setting set value = 'http://mynewdomain.com' where varname='frontendurl';
update setting set value = 'http://mynewdomain.com' where varname='frontendurl_login';
update setting set value = 'http://mynewdomain.com/core' where varname='bburl';

You have to run this one to delete the options in datastore.
Code:

delete from datastore where title in ('options', 'publicoptions', 'miscoptions');
Add the table prefix if any.

NOTE: Do this at your own risk. It is recommended to back up the database before doing this.

shimei 08-26-2016 04:50 PM

Quote:

Originally Posted by chikuru (Post 2575278)
There is no redirect in place. Maybe its datastore cache as what Dave is referring? Do you know how to clear it?

I ran into this problem but with templates stored as files, maybe this will solve your issue, running the sql query or get you on the right track.

https://www.christforums.org/forum/e...heets-as-files

If you have memcached you may need to remember to clear it, and cloudflare, you may want to pause your website while working on htaccess. At least with mine redirects ect sometimes don't show up immediately.

chikuru 08-26-2016 04:57 PM

Thanks for your input guys!

I already did those noypiscripter except for the last code you. Salamat ;)

I reupload files and re run upgrade and its all working now. Not sure which one exactly fixed it but thanks for all the replies!


All times are GMT. The time now is 05:26 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01078 seconds
  • Memory Usage 1,738KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete