Skip to main content
Home
  • About
  • Services
    • Digital Experience
    • Digital Business Consulting
    • User Experience Design Services
    • Website Analytics and Consulting
    • Website Personalization
    • Website Personalization Demo
    • Platform Engineering
    • AI Enablement Services
    • Drupal Development Services
    • Drupal Support Services
    • Marketing Technology
    • Quality Assurance Services
    • Impact Services
    • CTO as a Service
    • Conversion Optimization
    • Talent Services
  • Pricing
  • Resources
    • Website Personalization
    • Drupal Blog
    • Articles
    • Case Studies
    • Developers Corner
  • Careers
    • Culture
    • Job Openings
    • Growing@Zyxware
Contact Us
Contact Us
Profile picture for user Anoop John

Anoop John

Founder | CTO
Anoop John, Founder and CTO of Zyxware Technologies, helps organizations navigate the challenges of digital transformation initiatives and is a dedicated Free Software Evangelist and active Drupal community contributor. Based in Austin, Texas, he is passionate about leveraging technology to create a just and compassionate society.

Drupal Performance Tips: Avoid DISTINCT in Drupal Views and SQL queries to speed up query execution and improve page load times

Zyxware default image2
Drupal Technical | 2 min read
On one of the maintenance projects we got we came across a page that used to take around 11 seconds to load. The page was a views listing for users. We were able to speed up the page load times from around 11 seconds to under 3 seconds by taking out just the distinct option used in the view. The following was the select query that was originally generated from the view with the time logged by views in the preview panel.
Read more

Find and delete files greater than a given size from the Linux command line

Zyxware default image2
Technical Solution | 5 min read
The find command available in GNU/Linux shells is a versatile tool for finding files matching the given conditions in a folder and performing a specific action on the files found. The following command will find all files greater than 1M size in your current folder and ask you if you would like to delete the file find . -size +1M -exec rm -i {} \;
Read more

Simple script to pre-warm boost cache on a small site

Zyxware default image2
Technical Solution | 2 min read
Boost is a module that allows for static caching on a Drupal site for improving performance for anonymous users. You can read more about how to install and configure boost here. Boost comes with a boost crawler that can crawl your site and refresh the boost cache. Here is a simple script that can be used to refresh the boost cache without enabling the boost crawler.
Read more

Solution for warning in Drupal - call_user_func_array() expects parameter 2 to be array, string given in sites/all/modules/contrib/views/views.module

Zyxware default image4
Drupal Technical | 3 min read
We recently saw this error on a Drupal 6 site that had not been updated for quite a while."warning: call_user_func_array() expects parameter 2 to be array, string given in sites/all/modules/contrib/views/views.module" means what it says. call_user_func_array expects the second parameter to be an array whereas a string was given instead. You can troubleshoot problems like this by writing a bit of debug code before the line where the error is reported.
Read more

How to exclude a given file or directory from httpd password protection in apache

Zyxware default image4
Technical Solution | 2 min read
Apache allows you to protect contents of specific directories in your website or the whole website from unauthorized access using a mechanism called httpd password protection. During development of new sites the partially built sites are protected from unauthorized access using httpd authentication. This could sometimes interfere with testing of integration with third party services that might expect some of your URLs to be accessible without authentication. Here is how you can exclude a given file or directory from httpd authentication
Read more

How to log in programmatically as user 1 in Drupal 7

Zyxware default image1
Drupal Technical | 2 min read
Once in a while you will come across a Drupal site where you have to login to the site without having access to the credentials of user 1. You can easily reset the password of user 1 directly in the database or you can create a small work around to login to the site. Here is how you can login to the Drupal 7 site programmatically as user 1 without knowing user 1 credentials.
Read more

How to login programmatically as user 1 in Drupal 6

Zyxware default image2
Drupal Technical | 2 min read
If you have a Drupal 6 site where you have access to the ftp account but not to the user 1 credentials here is how you can login programmatially to the site as user 1 without resetting the user 1 password. Now that you know that this is possible, remember to not give ftp access to users who do not have access to user 1 credentials as well.
Read more

Recovering / Resetting the password of user 1 in Drupal 6 or Drupal 7

Zyxware default image2
Drupal Technical | 2 min read
Frequently we come across Drupal sites (live or testing) where the user 1 passwords are not known to the owner of the site. You can retrieve the password by changing the email address of user 1 to your email address and then use the forgot password option to reset your password. But if you don't want to change the user 1 email address but instead just want to change the password of user 1 there is an easier alternative via the database.
Read more

Find all active IPs your local network using nmap

Zyxware default image2
Technical Solution | 2 min read
Nmap is a Free Software tool that can be used for a variety of network network exploration tasks and security auditing. Nmap ("Network Mapper") scans IP packets to determine a lot of different aspects about hosts available on the network and also about services these hosts are offering. It can help you find a lot of information about these hosts including reverse DNS names, operating system guesses, device types, and MAC addresses.
Read more

Understanding db_rewrite_sql, node level access permissions and generation of primary links in Drupal

Zyxware default image4
Drupal Technical | 3 min read
On a Drupal site that came up for some minor alterations recently we came across an issue where some menu links disappeared for anonymous users while they appeared normally for the administrative users. On digging further we came across an issue with an implementation of hook_db_rewrite_sql in a contributed module. But along the way we had to debug the full process of generation of primary links and how node level access permissions are checked during this process.
Read more
  • Load More
Footer Logo
  • United States
  • Australia
  • India
Virginia Office - 457B Carlisle Dr Suite 205, Herndon, VA 20170
Phone: +1 201 355 2515
Business Inquiry? Contact Us
Looking to join our team? Check our careers page
8 Excelsa Way, Hillside, Melbourne, VIC 3037, Australia
Phone: +61 450 405 000
Business Inquiry? Contact Us
Looking to join our team? Check our careers page
SBC 2205, II Floor, Yamuna Building, Technopark Phase III campus, Trivandrum - 695581
Phone: +91 8157 99 5558
Business Inquiry? Contact Us
Looking to join our team? Check our careers page
Footer main menu
  • Home
  • Articles
  • About
  • Investor Centre
  • Contact
  • Careers
  • Learn Drupal

Footer Secondary menu

  • Verticals
    • Retail
    • Education
    • Public Services
    • Media
  • Drupal Services
    • Drupal Development
    • Drupal Migration
    • Drupal Support
    • Hire a Drupal Developer
  • Digital Services
    • Universal Analytics Backup
    • Website Analytics and Consulting
    • Website Personalization
    • CTO as a Service
    • Marketing Technology
ZYXWARE

Privacy. T & C . © 2025 Zyxware Technologies Pvt. Ltd