Opened 9 years ago

Closed 9 years ago

#723 closed bug (fixed)

500 Error

Reported by: bbutler Owned by:
Priority: trivial Milestone:
Component: Core Version: 7.5.1
Keywords: Cc:

Description

We are currently getting a 500 Server Error when we try to create a really long folder template. We've tried as multiple users with multiple browsers.

We are a new customer and this is holding us back from starting to use the system.

This is what we're currently trying to save:

Invoice/Vendor
Invoice/Vendor/Advertising
Invoice/Vendor/Advertising/Year
Invoice/Vendor/Advertising/Year/Month
Invoice/Vendor/Advertising/Year/Month/January
Invoice/Vendor/Advertising/Year/Month/February
Invoice/Vendor/Advertising/Year/Month/March
Invoice/Vendor/Advertising/Year/Month/April
Invoice/Vendor/Advertising/Year/Month/May
Invoice/Vendor/Advertising/Year/Month/June
Invoice/Vendor/Advertising/Year/Month/July
Invoice/Vendor/Advertising/Year/Month/August
Invoice/Vendor/Advertising/Year/Month/September
Invoice/Vendor/Advertising/Year/Month/October
Invoice/Vendor/Advertising/Year/Month/November
Invoice/Vendor/Advertising/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Supplies
Invoice/Vendor/Supplies/Year
Invoice/Vendor/Supplies/Year/Month
Invoice/Vendor/Supplies/Year/Month/January
Invoice/Vendor/Supplies/Year/Month/February
Invoice/Vendor/Supplies/Year/Month/March
Invoice/Vendor/Supplies/Year/Month/April
Invoice/Vendor/Supplies/Year/Month/May
Invoice/Vendor/Supplies/Year/Month/June
Invoice/Vendor/Supplies/Year/Month/July
Invoice/Vendor/Supplies/Year/Month/August
Invoice/Vendor/Supplies/Year/Month/September
Invoice/Vendor/Supplies/Year/Month/October
Invoice/Vendor/Supplies/Year/Month/November
Invoice/Vendor/Supplies/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Insurance
Invoice/Vendor/Insurance/Year
Invoice/Vendor/Insurance/Year/Month
Invoice/Vendor/Insurance/Year/Month/January
Invoice/Vendor/Insurance/Year/Month/February
Invoice/Vendor/Insurance/Year/Month/March
Invoice/Vendor/Insurance/Year/Month/April
Invoice/Vendor/Insurance/Year/Month/May
Invoice/Vendor/Insurance/Year/Month/June
Invoice/Vendor/Insurance/Year/Month/July
Invoice/Vendor/Insurance/Year/Month/August
Invoice/Vendor/Insurance/Year/Month/September
Invoice/Vendor/Insurance/Year/Month/October
Invoice/Vendor/Insurance/Year/Month/November
Invoice/Vendor/Insurance/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Permits and Licenses
Invoice/Vendor/Permits and Licenses/Year
Invoice/Vendor/Permits and Licenses/Year/Month
Invoice/Vendor/Permits and Licenses/Year/Month/January
Invoice/Vendor/Permits and Licenses/Year/Month/February
Invoice/Vendor/Permits and Licenses/Year/Month/March
Invoice/Vendor/Permits and Licenses/Year/Month/April
Invoice/Vendor/Permits and Licenses/Year/Month/May
Invoice/Vendor/Permits and Licenses/Year/Month/June
Invoice/Vendor/Permits and Licenses/Year/Month/July
Invoice/Vendor/Permits and Licenses/Year/Month/August
Invoice/Vendor/Permits and Licenses/Year/Month/September
Invoice/Vendor/Permits and Licenses/Year/Month/October
Invoice/Vendor/Permits and Licenses/Year/Month/November
Invoice/Vendor/Permits and Licenses/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Merchant Fees
Invoice/Vendor/Merchant Fees/Year
Invoice/Vendor/Merchant Fees/Year/Month
Invoice/Vendor/Merchant Fees/Year/Month/January
Invoice/Vendor/Merchant Fees/Year/Month/February
Invoice/Vendor/Merchant Fees/Year/Month/March
Invoice/Vendor/Merchant Fees/Year/Month/April
Invoice/Vendor/Merchant Fees/Year/Month/May
Invoice/Vendor/Merchant Fees/Year/Month/June
Invoice/Vendor/Merchant Fees/Year/Month/July
Invoice/Vendor/Merchant Fees/Year/Month/August
Invoice/Vendor/Merchant Fees/Year/Month/September
Invoice/Vendor/Merchant Fees/Year/Month/October
Invoice/Vendor/Merchant Fees/Year/Month/November
Invoice/Vendor/Merchant Fees/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Uniforms
Invoice/Vendor/Uniforms/Year
Invoice/Vendor/Uniforms/Year/Month
Invoice/Vendor/Uniforms/Year/Month/January
Invoice/Vendor/Uniforms/Year/Month/February
Invoice/Vendor/Uniforms/Year/Month/March
Invoice/Vendor/Uniforms/Year/Month/April
Invoice/Vendor/Uniforms/Year/Month/May
Invoice/Vendor/Uniforms/Year/Month/June
Invoice/Vendor/Uniforms/Year/Month/July
Invoice/Vendor/Uniforms/Year/Month/August
Invoice/Vendor/Uniforms/Year/Month/September
Invoice/Vendor/Uniforms/Year/Month/October
Invoice/Vendor/Uniforms/Year/Month/November
Invoice/Vendor/Uniforms/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Miscellaneous
Invoice/Vendor/Miscellaneous/Year
Invoice/Vendor/Miscellaneous/Year/Month
Invoice/Vendor/Miscellaneous/Year/Month/January
Invoice/Vendor/Miscellaneous/Year/Month/February
Invoice/Vendor/Miscellaneous/Year/Month/March
Invoice/Vendor/Miscellaneous/Year/Month/April
Invoice/Vendor/Miscellaneous/Year/Month/May
Invoice/Vendor/Miscellaneous/Year/Month/June
Invoice/Vendor/Miscellaneous/Year/Month/July
Invoice/Vendor/Miscellaneous/Year/Month/August
Invoice/Vendor/Miscellaneous/Year/Month/September
Invoice/Vendor/Miscellaneous/Year/Month/October
Invoice/Vendor/Miscellaneous/Year/Month/November
Invoice/Vendor/Miscellaneous/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Maintenance & Repairs
Invoice/Vendor/Maintenance & Repairs/Year
Invoice/Vendor/Maintenance & Repairs/Year/Month
Invoice/Vendor/Maintenance & Repairs/Year/Month/January
Invoice/Vendor/Maintenance & Repairs/Year/Month/February
Invoice/Vendor/Maintenance & Repairs/Year/Month/March
Invoice/Vendor/Maintenance & Repairs/Year/Month/April
Invoice/Vendor/Maintenance & Repairs/Year/Month/May
Invoice/Vendor/Maintenance & Repairs/Year/Month/June
Invoice/Vendor/Maintenance & Repairs/Year/Month/July
Invoice/Vendor/Maintenance & Repairs/Year/Month/August
Invoice/Vendor/Maintenance & Repairs/Year/Month/September
Invoice/Vendor/Maintenance & Repairs/Year/Month/October
Invoice/Vendor/Maintenance & Repairs/Year/Month/November
Invoice/Vendor/Maintenance & Repairs/Year/Month/December
Invoice/Vendor
Invoice/Vendor/Equipment Rental
Invoice/Vendor/Equipment Rental/Year
Invoice/Vendor/Equipment Rental/Year/Month
Invoice/Vendor/Equipment Rental/Year/Month/January
Invoice/Vendor/Equipment Rental/Year/Month/February
Invoice/Vendor/Equipment Rental/Year/Month/March
Invoice/Vendor/Equipment Rental/Year/Month/April
Invoice/Vendor/Equipment Rental/Year/Month/May
Invoice/Vendor/Equipment Rental/Year/Month/June
Invoice/Vendor/Equipment Rental/Year/Month/July
Invoice/Vendor/Equipment Rental/Year/Month/August
Invoice/Vendor/Equipment Rental/Year/Month/September
Invoice/Vendor/Equipment Rental/Year/Month/October
Invoice/Vendor/Equipment Rental/Year/Month/November
Invoice/Vendor/Equipment Rental/Year/Month/December
Invoice/Vendor
Invoice/Vendor/IT
Invoice/Vendor/IT/Year
Invoice/Vendor/IT/Year/Month
Invoice/Vendor/IT/Year/Month/January
Invoice/Vendor/IT/Year/Month/February
Invoice/Vendor/IT/Year/Month/March
Invoice/Vendor/IT/Year/Month/April
Invoice/Vendor/IT/Year/Month/May
Invoice/Vendor/IT/Year/Month/June
Invoice/Vendor/IT/Year/Month/July
Invoice/Vendor/IT/Year/Month/August
Invoice/Vendor/IT/Year/Month/September
Invoice/Vendor/IT/Year/Month/October
Invoice/Vendor/IT/Year/Month/November
Invoice/Vendor/IT/Year/Month/December
Special Events
Special Events/Year/Event
Consultants
Consultants/Agreements/Year
Consultants/Agreements/Year/Month
Consultants/Agreements/Year/Month/January
Consultants/Agreements/Year/Month/February
Consultants/Agreements/Year/Month/March
Consultants/Agreements/Year/Month/April
Consultants/Agreements/Year/Month/May
Consultants/Agreements/Year/Month/June
Consultants/Agreements/Year/Month/July
Consultants/Agreements/Year/Month/August
Consultants/Agreements/Year/Month/September
Consultants/Agreements/Year/Month/October
Consultants/Agreements/Year/Month/November
Consultants/Agreements/Year/Month/December
Consultants/Payments/Year
Consultants/Payments/Year/Month
Consultants/Payments/Year/Month/January
Consultants/Payments/Year/Month/February
Consultants/Payments/Year/Month/March
Consultants/Payments/Year/Month/April
Consultants/Payments/Year/Month/May
Consultants/Payments/Year/Month/June
Consultants/Payments/Year/Month/July
Consultants/Payments/Year/Month/August
Consultants/Payments/Year/Month/September
Consultants/Payments/Year/Month/October
Consultants/Payments/Year/Month/November
Consultants/Payments/Year/Month/December
Receivable
Receivable/Bank Deposits
Receivable/Bank Deposits/Year
Receivable/Bank Deposits/Year/Month
Receivable/Bank Deposits/Year/Month/January
Receivable/Bank Deposits/Year/Month/February
Receivable/Bank Deposits/Year/Month/March
Receivable/Bank Deposits/Year/Month/April
Receivable/Bank Deposits/Year/Month/May
Receivable/Bank Deposits/Year/Month/June
Receivable/Bank Deposits/Year/Month/July
Receivable/Bank Deposits/Year/Month/August
Receivable/Bank Deposits/Year/Month/September
Receivable/Bank Deposits/Year/Month/October
Receivable/Bank Deposits/Year/Month/November
Receivable/Bank Deposits/Year/Month/December
Employees
Employees/Agreements
Employees/Agreements/Year
Employees/Agreements/Year/Month
Employees/Agreements/Year/Month/January
Employees/Agreements/Year/Month/February
Employees/Agreements/Year/Month/March
Employees/Agreements/Year/Month/April
Employees/Agreements/Year/Month/May
Employees/Agreements/Year/Month/June
Employees/Agreements/Year/Month/July
Employees/Agreements/Year/Month/August
Employees/Agreements/Year/Month/September
Employees/Agreements/Year/Month/October
Employees/Agreements/Year/Month/November
Employees/Agreements/Year/Month/December
Employees/Reimbursements
Employees/Reimbursements/Year
Employees/Reimbursements/Year/Month
Employees/Reimbursements/Year/Month/January
Employees/Reimbursements/Year/Month/February
Employees/Reimbursements/Year/Month/March
Employees/Reimbursements/Year/Month/April
Employees/Reimbursements/Year/Month/May
Employees/Reimbursements/Year/Month/June
Employees/Reimbursements/Year/Month/July
Employees/Reimbursements/Year/Month/August
Employees/Reimbursements/Year/Month/September
Employees/Reimbursements/Year/Month/October
Employees/Reimbursements/Year/Month/November
Employees/Reimbursements/Year/Month/December
Employees/Loans/Agreements
Employees/Loans/Agreements/Year
Employees/Loans/Agreements/Year/Month
Employees/Loans/Agreements/Year/Month/January
Employees/Loans/Agreements/Year/Month/February
Employees/Loans/Agreements/Year/Month/March
Employees/Loans/Agreements/Year/Month/April
Employees/Loans/Agreements/Year/Month/May
Employees/Loans/Agreements/Year/Month/June
Employees/Loans/Agreements/Year/Month/July
Employees/Loans/Agreements/Year/Month/August
Employees/Loans/Agreements/Year/Month/September
Employees/Loans/Agreements/Year/Month/November
Employees/Loans/Agreements/Year/Month/December
Employees/Loans/Repayments
Employees/Loans/Repayments/Year
Employees/Loans/Repayments/Year/Month
Employees/Loans/Repayments/Year/Month/January
Employees/Loans/Repayments/Year/Month/February
Employees/Loans/Repayments/Year/Month/March
Employees/Loans/Repayments/Year/Month/April
Employees/Loans/Repayments/Year/Month/May
Employees/Loans/Repayments/Year/Month/June
Employees/Loans/Repayments/Year/Month/July
Employees/Loans/Repayments/Year/Month/August
Employees/Loans/Repayments/Year/Month/September
Employees/Loans/Repayments/Year/Month/October
Employees/Loans/Repayments/Year/Month/November
Employees/Loans/Repayments/Year/Month/December
Taxes
Taxes/Income
Taxes/Miscellaneous
Taxes/Payroll
Taxes/Payroll/W2s
Taxes/Payroll/W2s/Year
Taxes/Payroll/1099s
Taxes/Payroll/1099s/Year
Taxes/Payroll/Form941
Taxes/Payroll/Form941/Year
Taxes/Payroll/Form941/Year/Q1
Taxes/Payroll/Form941/Year/Q2
Taxes/Payroll/Form941/Year/Q3
Taxes/Payroll/Form941/Year/Q4
Taxes/Property

Change History (1)

comment:1 by car031, 9 years ago

Component: SetupCore
Milestone: 7.5.3
Priority: majortrivial
Resolution: fixed
Status: newclosed

the template is too long. this scheme is saved in the database in a column of max. 4000 chars, while this template is abnormal. We suggest you to break this template is a set of smaller templates. This would be the reliable way to operate.
If you cannot do this, please execute this statement against your database:
ALTER TABLE ld_generic MODIFY ld_string1 VARCHAR(20000);

Note: See TracTickets for help on using tickets.