Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2015, 06:54 PM
XYZ500 XYZ500 is offline
 
Join Date: Aug 2014
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Is there a way to edit something in the SQL database?

This is in reference to this thread: https://vborg.vbsupport.ru/showthread.php?t=319295

I think there is an image link in the SQL database that is preventing the site to display the green SSL in the URL bar.

I need to edit that link from http to https.

Is there a way to find that link in the SQL database and then edit it? Maybe in the phpmyadmin? If anyone knows a way of doing this, please instruct me.

Thank you!
Reply With Quote
  #2  
Old 07-07-2015, 07:39 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To edit the database go into phpadmin.

It would help us help you though if you posted your site link, etc.
Reply With Quote
  #3  
Old 07-08-2015, 08:24 AM
XYZ500 XYZ500 is offline
 
Join Date: Aug 2014
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I need clear instructions of how to edit the db from phpmyadmin, please.
Reply With Quote
  #4  
Old 07-08-2015, 09:44 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, if you use a query or a search to find the row, you can just click on the field with the data you want to change and change it right there. But I don't know how to tell you to find what you want. To be honest, I can't think of why any image path couldn't be changed somewhere in the admincp.
Reply With Quote
  #5  
Old 07-08-2015, 10:13 AM
XYZ500 XYZ500 is offline
 
Join Date: Aug 2014
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kh99 View Post
Well, if you use a query or a search to find the row, you can just click on the field with the data you want to change and change it right there. But I don't know how to tell you to find what you want. To be honest, I can't think of why any image path couldn't be changed somewhere in the admincp.
I had a few months old SQL database backup on my PC. I opened it on Wordpad and searched for the link and found it there.
Reply With Quote
  #6  
Old 07-08-2015, 10:37 AM
Skyrider Skyrider is offline
 
Join Date: Feb 2006
Location: Netherlands
Posts: 1,392
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Course:

http://support.hostgator.com/article...-in-phpmyadmin

Just search for the word/line you are looking for, and edit the value. The option you are looking for is most likely within the 'setting' table which will show up as results in your search query.

It's advised though to make a database backup before messing with it.
Reply With Quote
2 благодарности(ей) от:
kh99, RichieBoy67
  #7  
Old 07-08-2015, 10:42 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ECZ View Post
I had a few months old SQL database backup on my PC. I opened it on Wordpad and searched for the link and found it there. Now I'm thinking, I can take a latest db backup, download it, open it on wordpad, edit the link and make it https, upload it and restore it. But this entire process will take TOO MUCH time (especially the downloading and uploading) as the db size is 1.5GB. Is there any way to find this link in the phpmyadmin like I did on wordpad and edit and save it?
If you found the link in a backup file, then you should be able to figure out what table and column it's in. If you tell us that, we should be able to tell you where you can change it in the admincp. Or at least it would be easier to find where to edit it in phpMyAdmin.

Be careful of what you edit directly in the database. If you edit a text field which is in serialized format you can make it invalid. If at all possible you should have a current backup before making changes.
Reply With Quote
  #8  
Old 07-08-2015, 11:47 AM
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Location: Riverside, California USA
Posts: 1,080
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ECZ ... you can get to that http link directly from your admin panel ... go to your templates and just type in the any of the following and do a search:

Code:
<script type="text/rocketscript">
			var pkBaseURL = (("https:" == document.location.protocol) ? "https://yourdomain.com/analytics/piwik/piwik/" : "http://yourdomain.com/analytics/piwik/piwik/");
			document.write(unescape("%3Cscript src='" + pkBaseURL + "piwik.js' type='text/javascript'%3E%3C/script%3E"));
			</script><script type="text/rocketscript">
			try {
				var piwikTracker = Piwik.getTracker(pkBaseURL + "piwik.php", 1);
				piwikTracker.trackPageView();
				piwikTracker.enableLinkTracking();
			} catch( err ) {}
			</script><noscript><p><img src="http://yourdomain.com/analytics/piwik/piwik/piwik.php?idsite=1" style="border:0" alt=""/></p></noscript>
Just type in anything from that script and you should find it in one of the templates my Man ... no need to go into your database at all ...

--------------- Added [DATE]1436363339[/DATE] at [TIME]1436363339[/TIME] ---------------

I would do a search for this:

analytics/piwik/piwik/piwik

and you should have no problem finding it ..
Reply With Quote
Благодарность от:
RichieBoy67
  #9  
Old 07-08-2015, 05:53 PM
XYZ500 XYZ500 is offline
 
Join Date: Aug 2014
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kh99 View Post
If you found the link in a backup file, then you should be able to figure out what table and column it's in. If you tell us that, we should be able to tell you where you can change it in the admincp. Or at least it would be easier to find where to edit it in phpMyAdmin.

Be careful of what you edit directly in the database. If you edit a text field which is in serialized format you can make it invalid. If at all possible you should have a current backup before making changes.
I'm not sure how to tell you which table or column it is in. I just opened the sql file on wordpad and used the search option to find the link. Sending you a screenshot in the PM showing you what I found in the wordpad.

Quote:
Originally Posted by CAG CheechDogg View Post
ECZ ... you can get to that http link directly from your admin panel ... go to your templates and just type in the any of the following and do a search:

Code:
<script type="text/rocketscript">
			var pkBaseURL = (("https:" == document.location.protocol) ? "https://yourdomain.com/analytics/piwik/piwik/" : "http://yourdomain.com/analytics/piwik/piwik/");
			document.write(unescape("%3Cscript src='" + pkBaseURL + "piwik.js' type='text/javascript'%3E%3C/script%3E"));
			</script><script type="text/rocketscript">
			try {
				var piwikTracker = Piwik.getTracker(pkBaseURL + "piwik.php", 1);
				piwikTracker.trackPageView();
				piwikTracker.enableLinkTracking();
			} catch( err ) {}
			</script><noscript><p><img src="http://yourdomain.com/analytics/piwik/piwik/piwik.php?idsite=1" style="border:0" alt=""/></p></noscript>
Just type in anything from that script and you should find it in one of the templates my Man ... no need to go into your database at all ...

--------------- Added [DATE]1436363339[/DATE] at [TIME]1436363339[/TIME] ---------------

I would do a search for this:

analytics/piwik/piwik/piwik

and you should have no problem finding it ..
I tried searching like this. Didn't find anything. I didn't know Piwik was causing trouble too for SSL. I thought it was just that one image being loaded as http.
Reply With Quote
  #10  
Old 07-08-2015, 06:36 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I looked at the image you sent me. That's the "Show Default Post Icon" setting, it's under the "Thread Display Options (showthread)" section, so you should be able to edit it there instead of needing to use phpMyAdmin.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11937 seconds
  • Memory Usage 2,264KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (3)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete