Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Duplicate column name error

Questions related to installing, updating, setting up and configuring
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Duplicate column name error

Unread post by treed »

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:

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)
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.
Post Reply