Unknown column '****' in field list

Income Tax || Unknown column '****' in field list

      
      

Solution:
Please follow the troubleshooting steps below (on the server system of the software):
  1. Create a Backup of the Data:
    1. Navigate to C:\mysql.
    2. Copy the “Data” folder and paste it to a safe location.
  2. After the backup is complete, open the Income Tax software.
  3. Go to Tools and click on "Reset Database Version".
      
  1. A message will appear: "Database Version Reset Successfully. Please restart the application."
      
  1. Click OK and restart the software.
  2. Execute the software to verify if the issue is resolved.
I hope this information proves helpful.

    • Related Articles

    • Income Tax || Custom Backup

      To take backup of any particular clients please open the spectrum module like Income Tax, TDS and then go to its Tools Menu >> Database Utility >> Custom backup. Now, Select the check box in front of the client for whom you wish to take backup then ...

    • ExpressITR || Process to Update PAN, Name, DOB as Per PAN Database

      Process to Update PAN, Name, DOB as Per PAN Database If you encounter errors while filing returns due to mismatched PAN, Name, or DOB with the PAN database, follow these steps to resolve the issue: Step 1: Update Details on the Income Tax Portal Log ...

    • Income Tax || "PAN or Name does not match as per PAN database" during ITR Upload

      Issue: Getting error as “PAN mentioned in the return in verification part does not match with PAN of authorised person” Issue: Getting error as “Name does not match with the "Name" as per PAN database and the same is required to be replaced with the ...

    • Zen IT || Tax Audit → Invalid Property Array Index

      Follow the steps outlined below to address the issue on the server system of the software: Create a Backup of Your Data Navigate to the directory: C:\mysql Locate the Data folder, copy it and paste it to a secure location (e.g., external storage or ...

    • Spectrum || Schedule Backup

      Here are clearer step-by-step instructions for setting up daily backups for Spectrum and its modules, excluding TDS, along with configuring backup reminders for TDS: Daily Backup for Spectrum (Excluding TDS): Launch the Spectrum software. Click on ...