Duplicate column name error
Posted: Wed Apr 26, 2023 8:53 pm
After the update for Version V.4.5-2023.04.11.01 I now get debug errors on a whole series of reports that have been fine for a long time. The error is:
I notice that the DB version is V.4.5-2023.04.10.00 which is not in sync with the files version. Looking for some way to get to the bottom of what's going on here.
Code: Select all
[0] : ===PDO MESSAGE===
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'OrdDate'
===SQL===========
ALTER TABLE ___nu16449707647418___ ADD `USER_ID` VARCHAR(5) DEFAULT 'admin' , ADD `HOME_ID` VARCHAR(6) DEFAULT 'nuhome' , ADD `GLOBAL_ACCESS` VARCHAR(1) DEFAULT '1' , ADD `LOGIN_NAME` VARCHAR(5) DEFAULT 'admin' , ADD `nuDevMode` VARCHAR(1) DEFAULT '0' , ADD `form_id` VARCHAR(15) DEFAULT '5fa330f01be70b5' , ADD `redirect_form_id` VARCHAR(15) DEFAULT '5fa330f01be70b5' , ADD `record_id` VARCHAR(3) DEFAULT '103' , ADD `title` VARCHAR(16) DEFAULT 'Wholesale Orders' , ADD `call_type` VARCHAR(11) DEFAULT 'getlookupid' , ADD `column_widths` VARCHAR(1) DEFAULT '0' , ADD `iframe` VARCHAR(1) DEFAULT '0' , ADD `object_id` VARCHAR(15) DEFAULT '5fa347d0b0131c4' , ADD `page_number` VARCHAR(1) DEFAULT '0' , ADD `rows` VARCHAR(2) DEFAULT '20' , ADD `row_height` VARCHAR(2) DEFAULT '18' , ADD `session_id` VARCHAR(15) DEFAULT 's16825279776862' , ADD `sort` VARCHAR(2) DEFAULT '-1' , ADD `sort_direction` VARCHAR(4) DEFAULT 'desc' , ADD `subforms` VARCHAR(1) DEFAULT '0' , ADD `refreshed` VARCHAR(1) DEFAULT '3' , ADD `CLONED_RECORD` VARCHAR(1) DEFAULT '0' , ADD `NEW_RECORD` VARCHAR(1) DEFAULT '0' , ADD `browse_sql` VARCHAR(1) DEFAULT '0' , ADD `browse_rows` VARCHAR(1) DEFAULT '0' , ADD `browse_table_id` VARCHAR(22) DEFAULT '___nu1644964613682e___' , ADD `browse_filtered_rows` VARCHAR(1) DEFAULT '0' , ADD `browse_title_multiline` VARCHAR(1) DEFAULT '1' , ADD `form_code` VARCHAR(6) DEFAULT 'Orders' , ADD `form_description` VARCHAR(16) DEFAULT 'Wholesale Orders' , ADD `form_type` VARCHAR(10) DEFAULT 'browseedit' , ADD `NUSETHASHCOOKIE_NAME` VARCHAR(9) DEFAULT 'nuDevMode' , ADD `NUSETHASHCOOKIE_VALUE` VARCHAR(1) DEFAULT '0' , ADD `primary_key` VARCHAR(3) DEFAULT '259' , ADD `OrdBillViaEmail` VARCHAR(1) DEFAULT '1' , ADD `OrdDate` VARCHAR(10) DEFAULT '2023-04-26' , ADD `OrdPO` VARCHAR(8) DEFAULT 'W1049891' , ADD `OrdInvNo` VARCHAR(4) DEFAULT '1094' , ADD `OrdOrgID` VARCHAR(3) DEFAULT '259' , ADD `OrdTerms` VARCHAR(5) DEFAULT 'Net30' , ADD `OrdBillToAttn` VARCHAR(9) DEFAULT 'Jeff Ward' , ADD `OrdBillToCompany` VARCHAR(10) DEFAULT 'Mendo MIll' , ADD `OrdBillToAddr1` VARCHAR(17) DEFAULT '1870 N. State St.' , ADD `OrdBillToCity` VARCHAR(5) DEFAULT 'Ukiah' , ADD `OrdBillToState` VARCHAR(2) DEFAULT 'CA' , ADD `OrdBillToZip` VARCHAR(5) DEFAULT '95449' , ADD `OrdBillToPhone` VARCHAR(12) DEFAULT '707-472-3314' , ADD `OrdBillToEmail` VARCHAR(16) DEFAULT 'AP@mendomill.com' , ADD `OrdShipToCompany` VARCHAR(10) DEFAULT 'Mendo MIll' , ADD `OrdShipToAttn` VARCHAR(8) DEFAULT 'Bob Doty' , ADD `OrdShipToAddr1` VARCHAR(20) DEFAULT '305 E Commercial St.' , ADD `OrdShipToCity` VARCHAR(7) DEFAULT 'Willits' , ADD `OrdShipToState` VARCHAR(2) DEFAULT 'CA' , ADD `OrdShipToZip` VARCHAR(5) DEFAULT '95490' , ADD `OrdShipToPhone` VARCHAR(14) DEFAULT '(707) 459-4631' , ADD `OrdShipToEmail` VARCHAR(21) DEFAULT 'tom@programmertom.com' , ADD `OrdTotal` VARCHAR(7) DEFAULT '1000.00' , ADD `OrdShipCost` VARCHAR(4) DEFAULT '0.00' , ADD `OrdSched` VARCHAR(10) DEFAULT '2023-04-27' , ADD `OrdProductTotal` VARCHAR(7) DEFAULT '1000.00' , ADD `ID` VARCHAR(3) DEFAULT '259' , ADD `nuDelete` VARCHAR(1) DEFAULT '0' , ADD `PREVIOUS_RECORD_ID` VARCHAR(3) DEFAULT '103' , ADD `SUBFORM_ID` VARCHAR(15) DEFAULT '5fa347d0b0131c4' , ADD `TABLE_ID` VARCHAR(22) DEFAULT '___nu16449707647418___' , ADD `description` VARCHAR(11) DEFAULT 'Sales Order' , ADD `parentID` VARCHAR(19) DEFAULT 'SQL:5fdd24f01088703' , ADD `nuInstall` VARCHAR(1) DEFAULT '0' , ADD `nu_date_time` VARCHAR(19) DEFAULT '2023-04-26 11:41:58' , ADD `nu_date` VARCHAR(10) DEFAULT '2023-04-26' , ADD `nu_time` VARCHAR(8) DEFAULT '11:41:58' , ADD `nu_year` VARCHAR(4) DEFAULT '2023' , ADD `nu_month` VARCHAR(2) DEFAULT '04' , ADD `nu_day` VARCHAR(2) DEFAULT '26' , ADD `nu_hour` VARCHAR(2) DEFAULT '11' , ADD `nu_minute` VARCHAR(2) DEFAULT '41' , ADD `sre_layout` VARCHAR(198) DEFAULT '{\"top\":30,\"left\":30,\"bottom\":260,\"right\":30,\"width\":215.9,\"height\":279.4,\"paper\":\"Letter\",\"orientation\":\"P\",\"groups\":[{\"sortField\":\"Detail\",\"sortBy\":\"a\",\"sections\":[{'
===BACK TRACE====
/var/www/html/db/core/nurunpdf.php - line 1128 (nuRunQuery)
/var/www/html/db/core/nurunpdf.php - line 64 (nuAddCriteriaValues)
/var/www/html/db/core/nurunpdf.php - line 23 (nuRunReportId)