vb.org Archive - Is there a way to edit something in the SQL database?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Is there a way to edit something in the SQL database? (https://vborg.vbsupport.ru/showthread.php?t=319389)

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!

To edit the database go into phpadmin.

It would help us help you though if you posted your site link, etc.

I need clear instructions of how to edit the db from phpmyadmin, please.

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.

Quote:

Originally Posted by kh99 (Post 2549643)

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.

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.

Quote:

Originally Posted by ECZ (Post 2549644)

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.

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 ..

Quote:

Originally Posted by kh99 (Post 2549649)

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 (Post 2549651)

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>

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.

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.

X vBulletin 3.8.12 by vBS Debug 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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01335 seconds Memory Usage 1,752KB 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
Messages: