How to Fix Joomla Database Issues

“White Backend” Joomla Error: Unknown column ‘a.client_id’ in ‘where clause’:

After updating Joomla 3.8 this error “Unknown column ‘a.client_id’ in ‘where clause'” appears when you login into back-end, and there is nothing, it means White Back-end.

There is no Menu, but if you try to select menu (click and drag) then you will see the selected text where it describes its error. It is a database not updated error, but in this situation, you can't go to Extensions and manage the database.

How to Fix Joomla Database Issues:

Login to the Joomla Website Backend.

Copy the below link, replace your domain name with and load.

If you are in Localhost then change it like that localhost/YourWebsite/administrator/index.php?option=com_installer&task=database.fix

That's all.

How To Fix Error loading component: com fields Component not found in Joomla

1. Warning Error loading component: com_fields, Component not found

When updating Joomla 3.6.5 site to 3.7, many users have seen the warning error:

“Warning: Error loading component: com_fields, Component not found”


How to fix

Step 1: Go to Extensions/Manage/Discover
Step 2: Click on "Discover" button, enter "fields" in search edit and select all extensions it shows
Step 3: Click on "Install" button and reload the page


2. No access to menu manager after updating to J3.7

Immediately after updating from Joomla 3.6.5 to 3.7, you have no way to access the backend menu manager. The following message appears when you try to go to Menu → Manage

And if you click on your Main menu, the below error will appear 

How to fix

Step 1: Go to Extensions → Manage → Database. In this step, you will see a warning “Database is not up to date” and a list of database problems as below:

Step 2: Click the Fix button on the upper left. If the database issues are resolved, you will see the notice “Database table structure is up to date”.
You can now go back to your menu manager as previously.

How to use Recaptcha in Joomla

Native reCAPTCHA was added into Joomla in version 2.5. Using reCAPTCHA is a great way of preventing bots from making fake accounts and content on your site. There are four steps to setting up reCAPTCHA:

  1. Log in to your administrator back-end,
  2. Go to your Plugin Manager. You can find this under the Extensions drop-down menu in the top menu or in the Control Pannel page.
  3. Edit the Plugin Captcha - ReCaptcha
    • Set Status to Enabled
    • Copy and paste the Public and Private keys in their appropriate fields.
      • You will get the Public and Private keys by signing in with your Google account (create it if you don't have one) here: Create a reCAPTCHA key
      • Once you have registered your website domain, Google will provide your ReCAPTCHA keys.
    • Click Save & Close
  4. To enable reCAPTCHA
    • For Contact forms and the Registration form
      • Go to Global Configuration, and select the Site tab.
      • Choose Captcha - ReCaptcha in the Default Captcha field.
      • Click Save & Close.
    • For the Registration form only
      • Go to the User Manager. You can find it under the Users top menu or in the Control Pannel page.
      • In the Component tab in the Options chooses one of the following for the Captcha:
        • Use Default - that is the default setting and follows the Default Captcha field setting in your Global Configuration.
        • None Selected - that setting ignores the Default Captcha setting in Global Configuration. Use it when you want ReCAPTCHA in the Contact forms but not in the Registration form.
        • Captcha - ReCaptcha - Only needed if the Default Captcha in the Global Configuration is set to None Selected but you want the ReCAPTCHA not in Contact forms but in the Registration form.
      • Click Save & Close.

That's it! You're done!

How to Setup SMS Mobile App

Step 1

Download the ZIP file here: 

Extract the downloaded file on your computer.

Edit the config.xml and js/main.js files and change every instance of [appname] to the name of your app, change [description] to the description of your site and change [domain] to your domain in the format without http:// or slashes at the end of your domain.

Please note: Files to edit are config.xml and js/main.js

You can use search and replace to edit the files.

Once you are done, zip the folder again.


Step 2

See list of phonegap supported mobile platforms here:

Login to You may need to register for a free account if you don't already have an account.

Click on New App at the top right hand corner.


Click on "Private" to create a private App and click on "Upload a .zip file".



Once your upload is complete, click on "Ready to Build".



Now click on the name of the App.



Select your IOS key, Android key and Windows publisher ID. If you have not obtained these keys, instructions are available on phonegap for obtaining keys for supported platforms. IOS,



You can now download your Apps and make them available to your customers.


For phonegap support, please visit


Bulk SMS Portal Creator V4 Complete Manual

SMS Portal Creator is the world's most powerful Bulk SMS Portal Solution for Bulk SMS Business. You don't need to understand any programming  languages, the portal is user-friendly.

Save time and energy today and start making money in no time. SMS Portal supports every major HTTP SMS Gateway in the world.


SMS Client Management

Message Management

Phonebook Management

Detailed Billing

Credit Management

Mobile Apps

Online Payment Integration

SMS routing and much more.


The SMS Portal Component has two Major Menus: Administrator Menu and Members Menu

Both Menu has several icons performing different functions.

The Admin Menu: This menu is strictly for the administrator/owner of the SMS Portal Website

This menu is used in the frontend of the sms portal website to manage members, credit members, manage phonebooks etc.

Admin Menu

Admin Control Panel: It has all the Icons of the admin menu in it.

Settings: This is where you configure your website time, date, Database Auto-Backup, Messaging, SPC Registration Settings, SPC Notification Settings, SPC Gateway/API Settings, SPC Filtering, Prices, Payment Gateways and Numbers, and SPC Additional Settings

SPC News: You will be getting latest news of bug fix to update your SPC

Admin Roles: Use this to set roles of admins if you have more than one administrator managing the website.

API Manager: This is where you will be able to create new API in case you want to use multiple sms providers

Manage Members: You can manage your customer accounts, view/edit their details here.

Credit Members: You can credit members/customers here, you can as well approve credit that was previously ordered by your customer, customers can pay online and get sms credit automatically if the payment gateway is configured and added in the settings of the sms portal creator. You will need a VOGUEPAY MACHERNT ID to be able to accept online payment.

Transaction History: Transaction records are kept here, you can view records of day to day transactions done by admins, and customers.

Draft Messages: Use this to manage Drafted SMS messages

Vouchers: Use this to create or Manage SMS vouchers, you can create voucher codes in series and sell to your customers.

Phonebook: Use this to manage all phonebooks that are created in the SPC

Message History: Use this to view all Messages that were sent from the sms portal, view delivery status of the messages.

Debt Profile: Use this to manage debtors, it is possible to credit customers on debt and you may likely forget you did so, but with this in place, you can view those who are owing or remove them from debtors list.

Price Models: This is used to create/edit SMS Price Globally on your sms platform, you can set a special price for SMS credit or default sms price.

Phone Number Sales: Selling Phone numbers from your Database is one of the things that boost your sales especially when you have much phone numbers in your database, you can set numbers base on location and sell them to your customers who need them for promotional purpose.

Member Statistics: Use the form to generate member statistics to view credit analysis

Messages Summary: Use this to manage SMS Usage Summary by Days and Sales Transaction Summary by Days

Bonus for Members: Give out SMS units to members, you can decide to give to all registered members or all active members or all members with approved transactions.

Periodic Bonuses: Use this to give periodic sms credit bonus to all registered costumers, costumers can use the sms credit to send sms free of charge, but the sms delivers with your signature inclusive inform of promoting your website.

VoguePay Merchant IDs: This is where you add your merchant ID after getting it from VOGUEPAY.

System Tools: These tools are used to create new alert for members, clear pending msgs, clear all special costs, clear all special API, delete all pending transactions, delete draft msgs, delete all pending alerts, and delete all used vouchers. 



Online Payment:

We have Added a new Payment Method, you can now pay for SMS on

Click to Buy SMS


DND Issue Resolved:

The default sender ID are now rUPDATE to MTN.  Whatever sender ID you use to send SMS will automatically be  replaced by the new default sender ID. Please, endeavour to add your sender name in the message to indicate it is from you.

With Our corporate route, your messages will enjoy real-time magic delivery to all Nigerian numbers regardless of the DND status. We shall keep you posted on the progress we are making. Thank you for your perfect understanding.

Please note: SMS Charges to MTN is now 2 units/SMS.