Well, I just moved my first application from localhost to an actual server and it was a big flop. The submit button that worked fine on localhost and live preview gives a database error on the server and I have no idea why. The error it gives me doesn't even make sense:
Error executing SQL Insert
INSERT INTO tocas_dba.TOCAS_SAVED_QUERYS (QUERY_DATE, QUERY_NAME, QUERY_DESCRIPTION, BREAK_1, BREAK_2, BREAK_3, BREAK_4, BREAK_5, BREAK_6, BREAK_7, BREAK_8, TOTALS, SHOW, TRIBAL_ONLY_CRITERIA, CHECKBOX_VALUES, EFFORT, UNITS, POUNDS, LANDINGS, LANDINGS2, AVG_PRICE, SPECIES_CRITERIA, TRIBES_CRITERIA, GEAR_CRITERIA, CATCH_AREA_CRITERIA, DISPOSITION_CRITERIA, DEALERS_CRITERIA, YEARS_CRITERIA, MONTH_CRITERIA, BEGIN_WEEK, END_WEEK, BEGIN_DATE, END_DATE, QUERY_TEXT, GENERATING_REPORT, QUERY_OWNER) VALUES (:saved_querys_QUERY_DATE, :saved_querys_QUERY_NAME, :saved_querys_QUERY_DESCRIPTION, :saved_querys_BREAK_1, :saved_querys_BREAK_2, :saved_querys_BREAK_3, :saved_querys_BREAK_4, :saved_querys_BREAK_5, :saved_querys_BREAK_6, :saved_querys_BREAK_7, :saved_querys_BREAK_8, :saved_querys_TOTALS, :saved_querys_SHOW, :saved_querys_TRIBAL_ONLY_CRITERIA, :saved_querys_CHECKBOX_VALUES, :saved_querys_EFFORT, :saved_querys_UNITS, :saved_querys_POUNDS, :saved_querys_LANDINGS, :saved_querys_LANDINGS2, :saved_querys_AVG_PRICE, :saved_querys_SPECIES_CRITERIA, :saved_querys_TRIBES_CRITERIA, :saved_querys_GEAR_CRITERIA, :saved_querys_CATCH_AREA_CRITERIA, :saved_querys_DISPOSITION_CRITERIA, :saved_querys_DEALERS_CRITERIA, :saved_querys_YEARS_CRITERIA, :saved_querys_MONTH_CRITERIA, :saved_querys_BEGIN_WEEK, :saved_querys_END_WEEK, :saved_querys_BEGIN_DATE, :saved_querys_END_DATE, :saved_querys_QUERY_TEXT, :saved_querys_GENERATING_REPORT, :saved_querys_QUERY_OWNER)
Function requested is not supported
This is from a UX dialog tied to an SQL database table
I know the application is talking to the database because another page, a grid, submits just fine.
Error executing SQL Insert
INSERT INTO tocas_dba.TOCAS_SAVED_QUERYS (QUERY_DATE, QUERY_NAME, QUERY_DESCRIPTION, BREAK_1, BREAK_2, BREAK_3, BREAK_4, BREAK_5, BREAK_6, BREAK_7, BREAK_8, TOTALS, SHOW, TRIBAL_ONLY_CRITERIA, CHECKBOX_VALUES, EFFORT, UNITS, POUNDS, LANDINGS, LANDINGS2, AVG_PRICE, SPECIES_CRITERIA, TRIBES_CRITERIA, GEAR_CRITERIA, CATCH_AREA_CRITERIA, DISPOSITION_CRITERIA, DEALERS_CRITERIA, YEARS_CRITERIA, MONTH_CRITERIA, BEGIN_WEEK, END_WEEK, BEGIN_DATE, END_DATE, QUERY_TEXT, GENERATING_REPORT, QUERY_OWNER) VALUES (:saved_querys_QUERY_DATE, :saved_querys_QUERY_NAME, :saved_querys_QUERY_DESCRIPTION, :saved_querys_BREAK_1, :saved_querys_BREAK_2, :saved_querys_BREAK_3, :saved_querys_BREAK_4, :saved_querys_BREAK_5, :saved_querys_BREAK_6, :saved_querys_BREAK_7, :saved_querys_BREAK_8, :saved_querys_TOTALS, :saved_querys_SHOW, :saved_querys_TRIBAL_ONLY_CRITERIA, :saved_querys_CHECKBOX_VALUES, :saved_querys_EFFORT, :saved_querys_UNITS, :saved_querys_POUNDS, :saved_querys_LANDINGS, :saved_querys_LANDINGS2, :saved_querys_AVG_PRICE, :saved_querys_SPECIES_CRITERIA, :saved_querys_TRIBES_CRITERIA, :saved_querys_GEAR_CRITERIA, :saved_querys_CATCH_AREA_CRITERIA, :saved_querys_DISPOSITION_CRITERIA, :saved_querys_DEALERS_CRITERIA, :saved_querys_YEARS_CRITERIA, :saved_querys_MONTH_CRITERIA, :saved_querys_BEGIN_WEEK, :saved_querys_END_WEEK, :saved_querys_BEGIN_DATE, :saved_querys_END_DATE, :saved_querys_QUERY_TEXT, :saved_querys_GENERATING_REPORT, :saved_querys_QUERY_OWNER)
Function requested is not supported
This is from a UX dialog tied to an SQL database table
I know the application is talking to the database because another page, a grid, submits just fine.
Comment