solved - Renamed a column and now when I save the form down I get invalid column name - Bad Trigger

D

New member

I misspelled vector as vecter when I built my data table. I renamed the field and tested the form. Got the error below. Then I deleted the field from the form and still got the error below. I then logged out of dadabik, and logged back in, and got the same error. How do I get passed this issue?​


Image Library​

[08] Error: during query execution. UPDATE "Image_Library" SET "Stores" = '3', "Organization_id" = 'AWS-OFFLOAD', "Custnum" = NULL, "Manual_Overide" = '0', "StitchCount" = NULL, "No_Longer_used" = NULL, "File_Location" = '\\AWS-OFFLOAD\DesignLibrary\C00002212\Embroidery\Master Files', "File_Name" = '#2 Running Bear.jpg', "File_type" = '3', "Item_location" = '1', "Production_Ready_Image_Height" = '2483', "Production_Ready_Image_Width" = '2550', "Native_Image_Link" = NULL, "Production_Ready_Template_ID" = NULL, "Production_Ready_Template_Image" = NULL, "School_Name_Character_Count" = NULL, "School_Mascot_Character_Count" = NULL, "Inserted" = '2023-06-28 16:04:29', "Modified_By" = NULL, "LastModifiedDate" = '2017-08-01 15:12:49', "tags" = NULL, "Order" = NULL, "Organization_Name" = NULL, "Image_Name" = NULL where "id" = '855200'
The DBMS server said: SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'isvecter'.

About/upgrade​

DaDaBIK™ is a product conceived and developed by Eugenio Tacchini
Copyright © 2001-2023 Eugenio Tacchini
Proudly ❤️ made in Emilia
dadabik.com

Your current DaDaBIK version​

You are using DaDaBIK version 11.9-Elba enterprise, installed on 06-16-2023 (installation code: 18930648ca84cc7de1), the latest version of DaDaBIK is 11.9-Elba released on 03-23-2023

You are running the latest release of DaDaBIK

In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.

System info​

PHP Version: 8.1.20

sqlserver version: 15.00.2000

Web server: Microsoft-IIS/10.0

Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36

URL installation: https://idahomenow.com/program_files/
 

deep64blue

DaDaBIK Guru
This has been flagged as solved without any details but for the record if you make any changes outside Dadabik you need to run DB Synchro:-

1688153880966.png
 
Top