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

    • Error 127 Table Handler - [MYSQL][ODBC 3.51 Driver ]mysqld -4.0.13

      If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the error 127. Solution: Please follow the below troubleshoot (on server system of ...

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