176 Support questions or comments

• 
  Sep 20, 2022
  josepham Purchased

  How can i rename sitemap link from sitemap.xml to somethingelse.xml
• 
  Sep 20, 2022
  MirazMacStudios Author

  src/routes/base.routes.php
  
  $app->get('/sitemap.xml', CONTROLLER_NAMESPACE . 'Site\SitemapController:sitemapIndex'
  ->name('sitemap.index';
  
  
  Change '/sitemap.xml' to whatever you wish, for example: '/mysitemap.xml'

• 
  Sep 19, 2022
  josepham Purchased

  What hosting do you use for this script
• 
  Sep 19, 2022
  MirazMacStudios Author

  For the demo I use a simple shared hosting. Not a known brand.

• 
  Sep 18, 2022
  josepham Purchased

  How can i host it to sub directory of subdomain like this "subdomain.example.com/search" because this show 404 when i search something.
• View 5 more replies
• 
  Sep 18, 2022
  MirazMacStudios Author

  Yes you can. It's showing 404 because the .htaccess file is missing. Make sure the .htaccess is there with the index.php.
• 
  Sep 18, 2022
  josepham Purchased

  The file is there but i think the rule is not supported
• 
  Sep 18, 2022
  MirazMacStudios Author

  If it's working for the main domain, then it would work for the subdomain as well. Possibly the .htaccess isn't the one of the script. Delete it and reupload the one from the script. Otherwise contact your hosting provider regarding this.
  
  The demo is hosted on a subdomain itself: https://based.mirazmac.com/
  
  
• 
  Sep 18, 2022
  josepham Purchased

  I mean "subdomain.example.com/search" the "search" folder is where it's hosted not subdomain
• 
  Sep 18, 2022
  MirazMacStudios Author

  Still. It works under a subdirectory in localhost. Should work fine within the subdomain as well. Although I wouldn't recommend running it within a subdirectory.
• 
  Sep 18, 2022
  josepham Purchased

  What is the rule to host it in this way please i want to use it in subdomain folder
• 
  Sep 18, 2022
  MirazMacStudios Author

  Sorry but there is no extra rule for that. You just need to make sure the script's htaccess file of the script is present within the subdirectory.
  
  I'm not a sysadmin so this is all I can say. Anything else you better off contacting a sysadmin.
  Thanks
• 
  Sep 18, 2022
  josepham Purchased

  I figure it out for anyone need this
  
  RewriteEngine On
  
  RewriteCond %{HTTP_HOST} ^example.example.com$ [NC]
  RewriteCond %{REQUEST_URI} !^/folderhosted/
  RewriteRule (.*) /folderhosted/$1

• 
  Sep 17, 2022
  josepham Purchased

  How to add icon on Menu i see icon ID but when i add link to icon is not display
• View 6 more replies
• 
  Sep 17, 2022
  MirazMacStudios Author

  The icons must be added to this file:
  site/themes/default/views/shared/sprites.svg
  
  As SVG symbols. Open that file and you should have an idea.
• 
  Sep 17, 2022
  josepham Purchased

  How can i change it to add direct link of svg
• 
  Sep 17, 2022
  MirazMacStudios Author

  Use this tool:
  https://svg-to-symbol.herokuapp.com/
  
  Then copy only the <symbo id="bla">....</symbol> tag. And add to the sprites.svg tag like any other symbols that's present in the file.
• 
  Sep 17, 2022
  josepham Purchased

  ok now there is a issue to ajax when you add external link to menu it does open it just load with ajax no page open
• 
  Sep 17, 2022
  MirazMacStudios Author

  Sorry but I can't recreate the issue. The external links work just fine. ( https://drive.google.com/file/d/1wnDsFIyuvglRk6pyDapsrwkJJBP3gYDo/view )
  And it should work fine unless you have modified the templates/javascript manually. Can you please provide your site URL so I can see what's causing the issue?
• 
  Sep 17, 2022
  josepham Purchased

  Oh the issue is the link is part of the site but its main domain and different site, its like this i have two site one is main site on example.com and the other is the search with this script hosted like this "example.com/search". So the link i add to menu is like this "example.com/category/name" not the main domain is the same as the site hosted like this "example.com/search" so the script treat it as a page so it not open the link change on address bar but the main page dont change
• 
  Sep 17, 2022
  MirazMacStudios Author

  Oh I see. The script's ajax system treats same domain URLs as their own. I'd recommend you to add the link manually to the site with an target="_blank" attribute. As currently for the menu there is no such option present.
  
  Or you can use a shortlink generator like bit.ly to generate a shortlink to that URL and use it like that.
• 
  Sep 17, 2022
  josepham Purchased

  What if i want to open it on the same page
• 
  Sep 17, 2022
  MirazMacStudios Author

  Then you can omit the target="_blank" attribute and it should work fine if you add it externally in the templates or use a shortlink.

• 
  Sep 2, 2022
  josepham Purchased

  Hi again this is not an issue or support this is just to ask if this is possible, can you add a form on back end where admin can manually add keywords to show up on search. This can be a search form or input field. Or add permission to disable log to normal user except for admin how can i do this am sure it is not hard.
• View 4 more replies
• 
  Sep 2, 2022
  josepham Purchased

  I just want some keywords to showup on sitemap its hard to add them using database so can i disable log from normal user and allow for admin
• 
  Sep 2, 2022
  MirazMacStudios Author

  Hello. I'm currently in between a lot of things right now. I will keep your request in mind. But however, you're free to modify or hire a developer to do this for you.
  
  Or for now you can just use phpmyadmin to insert them.
• 
  Sep 2, 2022
  josepham Purchased

  Is it possible to install another script (same based) and allow to log search in the same database without allow main script to log search.
• 
  Sep 2, 2022
  MirazMacStudios Author

  No sorry, that would require heavy modifications. But you're free to hire a developer and see if that can be done.
• 
  Sep 2, 2022
  josepham Purchased

  If possible can you point out which file to edit to achieve permission or where its says if log is turn on then keep the search on database
• 
  Sep 2, 2022
  MirazMacStudios Author

  File: src/controllers/Site/SiteController.php
  
  
  
  This is the code that does this:
  
  
  
  $logSearches = (int) get_option('search_log';
  
  if ($logSearches) {
  $queryModel = new QueryModel;
  $db = $queryModel->db();
  $time = time();
  
  $stmt = $db->prepare("INSERT INTO {$queryModel->getTable()} ( query_term, created_at, updated_at ) VALUES ( :term, :ctime, :utime ) ON DUPLICATE KEY UPDATE query_count = query_count + 1, updated_at = {$time};";
  
  $stmt->bindValue(':term', limit_string(sp_strip_tags($query), 250), PDO::PARAM_STR);
  $stmt->bindValue(':ctime', $time, PDO::PARAM_INT);
  $stmt->bindValue(':utime', $time, PDO::PARAM_INT);
  
  $stmt->execute();
  }
  
  
  
  I'm sorry but I can't provide any much more guidance than this you or a developer have to figure out the rest. Thanks
• 
  Sep 2, 2022
  josepham Purchased

  Ok. Thanks

• 
  Aug 26, 2022
  josepham Purchased

  I have come back to point out some things - For the past few weeks i have try to find the issue that cause sleeping process to remain open on MySQL but i never found it, have come to two conclusion either this script was not built to handle too much traffic or their is an extension used that keep the mysql processes open because even if you try to kill the process from the database the process remain active and you get an error. I think even the session saved on var folder can cause this too as imagine you have 2000 people at the same time searching and all the 2000 session saved at the same time and not cleared after user left. I have a script that delete the session after some time but i think this should not be done on search script anyway i dont know much about session but if the is a way to disable session it will be good. Another issue i think can be cause by googlebot, the sitemap on the script is telling google to recrawl the page daily and if you have more than 10,000 search a day this mean googlebot will hit your site 10,000 times a day my site have more than 100,000 search a day and sitemap tell google to recrawl the typed keyword everyday.. You can see the logic. I have 103 split sitemap that is 1000 for each sitemap. I try to disable the log search function but this will not help as google already have the pages on search result . Log story short am trying to find the way to kill sleeping mysql process that remain open if anyone have an idea just post it
• View 3 more replies
• 
  Aug 26, 2022
  josepham Purchased

  THIS WILL NEVER HAPPEN TO ANYONE IF YOUR SITE IS NOT HIGH TRAFFIC IF YOUR SITE IS HIGH TRAFFIC THIS WILL HAPPEN TO YOU UNLESS YOUR SERVER IS NOT LIMIT HOW MANY PROCESS YOUR SCRIPT OPEN AT THE SAME TIME..
• 
  Aug 26, 2022
  josepham Purchased

  You can see the process list here my server allow only 60 process at same time https://prnt.sc/8_Yn5Mwk2ZyT
• 
  Aug 26, 2022
  josepham Purchased

  Maybe this will help too - https://prnt.sc/Hz0-bxMyk4pF
• 
  Aug 28, 2022
  josepham Purchased

  There is more issue like this - https://programmierfrage.com/items/1040-too-many-connection-in-php-pdo-exception
• 
  Aug 28, 2022
  MirazMacStudios Author

  The script doesn't limit or use this. The script can't do anything to prevent this. The simple concept is, the more your visitor is the more MySQL connections there will be. Your linked article literally says it's determined by the:
  set global max_connection=2000;
  
  Flag on server side. Meaning you need to optimize MySQL on the server side.
• 
  Aug 28, 2022
  josepham Purchased

  I dont have a permission to change this but i try to add mysqli_close(); in the end of the file i dont think is going to solve this but i will keep looking for solution.

• 
  Aug 16, 2022
  josepham Purchased

  This use to work oky but now it open a lot of database mysql process untile i exceeded the limit of the server, i try to disable the log but it doesn't work i try everything but its seem the script start these process without any use please can you point out where in the script php start database mysql process or did you close the process on that file on not active or not used.
• View 16 more replies
• 
  Aug 16, 2022
  josepham Purchased

  or did you close the process on that file when is not active or not used.
• 
  Aug 16, 2022
  josepham Purchased

  It worth noting that i have cloud hosting
• 
  Aug 16, 2022
  MirazMacStudios Author

  Sorry but I don't understand your issue. This script has a very minimal use of MySQL. It basically uses it for the admin panel and to store the search queries if enabled. Your issue is broader than the coverage of the script. The script by itself can't modify or access a system process like that. The script uses standard PHP PDO's MySQL driver to communicate with the database and that's it. As you can see no one in the comment section is facing this issue.
  
  I'd recommend you to re-install your server's OS if possible. Or just try a different web hosting.
• 
  Aug 16, 2022
  MirazMacStudios Author

  Also it could be a configuration issue on how your web server is configured as well. By design, PHP starts everything in a request, then when the request is finished everything is teared down. That's how PHP works. A PHP script doesn't have that level of system access to still keep running.
  For your issue, it's strictly core server side specific, I'd recommend you to re-install the server OS, and reconfigure the server using an expert sysadmin. Or for a clarification, you can use a cheap shared server and you'd see the script is running smoothly.
• 
  Aug 16, 2022
  josepham Purchased

  PHP PDO's MySQL is a command to establish a database connection and it is up to a PHP code to stop the connection after the query has been executed, which you seem not to agree with. It is common practice and it is a well-known fact. That's why is recommend adding code lines to stop the connection as soon as it is over.
  
  Additionally, am using Cloud plan managed by hostinger, meaning it would not be possible to restart the OS from scratch as it would affect a whole server.
  
  Note that the code itself is working perfectly fine. The main issue is once those connections pile up, they are not being stopped and in turn, limits are exceeded.
  
• 
  Aug 16, 2022
  josepham Purchased

  I would suggest optimizing the script and make sure that all of the connections are closed immediately once they are finished. For that we can add mysql_close() to end of the scripts but the issue is i dont know where to add this
• 
  Aug 16, 2022
  MirazMacStudios Author

  The modern PHP PDO libraries doesn't need to be explicitly. PHP automatically does this for you. If you don't believe me here's the link to the official documentation.
  https://www.php.net/manual/en/pdo.connections.php
  "If you don't do this explicitly, PHP will automatically close the connection when your script ends."
  
  And on the other end, if the issue was script specific, everyone else would face the issue. If you just browse through the comments no one else is facing the issue.
  
  Also you seem to have mistaken connections with MySQL packets, your MySQL server is at fault here, this is not something I can fix from the script.
• 
  Aug 16, 2022
  MirazMacStudios Author

  The script doesn't use the mysql_* functions. They are deprecated since PHP 7. The script uses the standard PHP PDO. Which closes the connection automatically when the script ends. Even if you do this manually it won't fix your issue. Because the issue lies within your MySQL server or web server configuration.
  
  Trust me, if this was a script specific issue, I'd try my best to help you. But it's not. As a developer, I know this.
• 
  Aug 16, 2022
  josepham Purchased

  What about on php 8.0
• 
  Aug 16, 2022
  MirazMacStudios Author

  What about it? The script is written for PHP 7.x. This is mentioned in the the requirements. The mysql_* functions were entirely removed since PHP 7.
  
  This is not something you should be concerned about. If the script didn't close the connections as you say, the comments would be piling about their site having the same issue.
  
  This is not a script issue. If It was I'd be the first to spot it. Please, just switch to another hosting.
  
  
• 
  Aug 16, 2022
  josepham Purchased

  Just show me how to add this even if the server do this automatic just show my how to close it manually from the script
• 
  Aug 16, 2022
  josepham Purchased

  How to add this mysql_close() to end of the scripts
• 
  Aug 16, 2022
  MirazMacStudios Author

  You just don't even try to understand don't you. I'm trying my best to make you understand, PHP automatically closes the connection. PDO is object oriented, the script holds no reference to it. The core PHP PDO extension does. The script simply extends it, and it's garbage collected when the script ends.
  
  This is the file:
  src/framework/PDO/Database.php
  
  If you understand PHP, and see the constructor:
  https://pastebin.com/Yu1DVyws
  
  It's simply creating a PDO instance, not holding it in any variable. Because it extends the base PDO class. PHP will automatically close the connection when the script finishes running. But despite my telling, you want me to hold in in a variable, and then destruct it manually which is done by setting the variable to NULL. But it's not storing the instance in a variable.
  
  You don't need to do this. But still for your satisfaction, I've done this. Replace the contents of this paste ( https://pastebin.com/YAqmPf0T ) , in the file:
  src/framework/PDO/Database.php
  
  
  
• 
  Aug 16, 2022
  josepham Purchased

  You know i appreciate what you done here but i dont know a lot about Mysql and php. I upgrade the script to old library that use 7.4 php to 8.0 maybe this is the cause. And my site have more than 2 Millions page view a month and i log the search
• 
  Aug 16, 2022
  MirazMacStudios Author

  I don't think the PHP version has anything to do with PDO connections. However, you shouldn't run this script on PHP 8.0. It's written for PHP 7.x only. Use PHP 7.x only.
  
  I suffer from severe ADHD and depression. It's very hard for me to focus. I didn't even do paid work for the last two years due to this. This is perhaps the most time I've spent resolving an issue in the past 6 months, it's very hard for me to focus.
  
  I mean it when I say it, it's not a script specific issue.
  Anyway, my last bit of advice would be, to switch to PHP 7.x and see if that helps the issue. If not, ask your hosting provider about it to see if they can help.
  
  Thanks.
  
• 
  Aug 16, 2022
  MirazMacStudios Author

  Also as you log the search that could be the reason to the slowdown. Perhaps your MySQL server is unable to handle that many records. Try deleting the search logs entirely if that helps.
• 
  Aug 16, 2022
  josepham Purchased

  I try it few weeks ago and now its at 179,390
• 
  Aug 16, 2022
  josepham Purchased

  it use to be 2 millions queres
• 
  Aug 16, 2022
  MirazMacStudios Author

  I bet that has something to do with it. Your MySQL server is simply struggling to manage that much of data. My suggestion would be to clear the entire table. And stop logging the searches.
  

• 
  Aug 16, 2022
  josepham Purchased

  This use to work oky but now it open a lot of database mysql process untile i exceeded the limit of the server, i try to disable the log but it doesn't work i try everything but its seem the script start these process without any use please can you point out where in the script php start database mysql process or did you close the process on that file on not active or not used.

• 
  Aug 14, 2022
  rufatkiu Purchased

  How can I custom results page design?
• View 1 more reply
• 
  Aug 14, 2022
  MirazMacStudios Author

  There isn't really much to customize apart from CSS. As Google themselves render the results, so you can't really modify much of it.
  
  The search results page template is: site/themes/default/views/search/search.php
  
  And the location to the CSS is: site/themes/default/assets/css/styles.css
• 
  Aug 14, 2022
  rufatkiu Purchased

  I want to design the UI like ,is it possible?https://github.com/Ashwin-op/Google-Clone
• 
  Aug 14, 2022
  MirazMacStudios Author

  Sorry but I'm not a designer and the linked item is a different ecosystem entirely. Any customizations must be made by you or a developer that you hired.
• 
  Aug 14, 2022
  rufatkiu Purchased

  Ok, thanks

• 
  Aug 12, 2022
  Beandi Purchased

  Hello,
  An error occurred while loading the administration interface.
  Apache error log: "malformed header from script 'thumb.php': Bad header: Cache-Control, referer: https://seen.hu/dashboard/gallery"
  
  And I want to ask:
  The information cards are always displayed in English (wikipedia). I want to rewrite the wikipedia link, where can I do it? (I want to use this: https://hu.wikipedia.org/)
  
  THX for support!
  Bea
  
• View 3 more replies
• 
  Aug 12, 2022
  MirazMacStudios Author

  For the first question, can you please let me know your PHP version, and is this happening with all the images or just some formats?
  
  Secondly, that's not possible. As the script doesn't use Wikipedia for data. It uses DuckDuckGo Instant Answer API. https://duckduckgo.com/api
  Which doesn't support localization at the moment.
• 
  Aug 12, 2022
  Beandi Purchased

  PHP: Modules for PHP 7.4.29 fscgid (debian/apache)
  
  
• 
  Aug 12, 2022
  Beandi Purchased

  Sorry,
  the error is only here: "dashboard - gallery"
• 
  Aug 12, 2022
  MirazMacStudios Author

  Strange. I'm using the same PHP version on Apache server, but I can't recreate your issue.
  
  Please download this thumb.php file: https://drive.google.com/file/d/1qmo4eskuiBfgKD2TOb2Ve3Z4uz6bKiJw/view?usp=sharing
  
  And replace the current thumb.php with it.
  
  And then go to: Dashboard > Settings > Debugging
  
  and enable "Flush Cache" then click Run Actions.
  
  
  And see if the issue is still present or not.
  
  
• 
  Aug 12, 2022
  Beandi Purchased

  Ok. THX for the support!
  Nice, it works.
  Haven nice day
  
• 
  Aug 12, 2022
  MirazMacStudios Author

  Glad it solved your issue. Stay safe.