- Posts: 91
- Karma: 1
- Thank you received: 0
- Community Forum
- Appointment Booking Pro - Retired, no longer for sale or supported.
- ABPro 4.0.x
- Export/CSV option throws error Unknown column
Export/CSV option throws error Unknown column
- Patrick Gay
- Topic Author
- Offline
- Expert Boarder
Less
More
4 years 5 months ago #26098
by Patrick Gay
Export/CSV option throws error Unknown column was created by Patrick Gay
In the Admin screen on the front end, in the requests tab, enter the name of the person and click the search icon. Select all the data and click the Export/CSV link at the top of the screen.
The scree will then say:
ABPro WARNING! A database error was encountered, see error log for details. Unknown column 'ResourceName' in 'order clause'.
When checking the ABPro Error Log, it says:
Object: fe_functions2
Description: Unknown column 'ResourceName' in 'order clause'.
Turning on debug on the Joomla site and I captured this SQL:
Any ideas what might be causing this and how to get around it?
Congratulations on retirement.
The scree will then say:
ABPro WARNING! A database error was encountered, see error log for details. Unknown column 'ResourceName' in 'order clause'.
When checking the ABPro Error Log, it says:
Object: fe_functions2
Description: Unknown column 'ResourceName' in 'order clause'.
Turning on debug on the Joomla site and I captured this SQL:
SELECT j3_sv_apptpro3_requests.*, j3_sv_apptpro3_resources.name AS ResourceName, j3_sv_apptpro3_services.name AS ServiceName, j3_sv_apptpro3_categories.name AS CategoryName, CONCAT(j3_sv_apptpro3_requests.startdate,j3_sv_apptpro3_requests.starttime) as startdatetime, DATE_FORMAT(j3_sv_apptpro3_requests.startdate, '%a %b %e ') as display_startdate, DATE_FORMAT(j3_sv_apptpro3_requests.starttime, ' %H:%i') as display_starttime, j3_sv_apptpro3_paypal_transactions.id_paypal_transactions AS id_transaction
FROM (j3_sv_apptpro3_requests
LEFT JOIN j3_sv_apptpro3_resources
ON j3_sv_apptpro3_requests.resource = j3_sv_apptpro3_resources.id_resources
LEFT JOIN j3_sv_apptpro3_services
ON j3_sv_apptpro3_requests.service = j3_sv_apptpro3_services.id_services
LEFT JOIN j3_sv_apptpro3_categories
ON j3_sv_apptpro3_resources.category_id = j3_sv_apptpro3_categories.id_categories
LEFT JOIN j3_sv_apptpro3_paypal_transactions
ON j3_sv_apptpro3_paypal_transactions.custom = j3_sv_apptpro3_requests.id_requests)
WHERE j3_sv_apptpro3_resources.resource_admins LIKE '%|552|%'
AND LCASE(j3_sv_apptpro3_requests.name) LIKE '%mark%'
AND startdate >= '2018-01-01'
ORDER BY ResourceName asc, startdatetime
Any ideas what might be causing this and how to get around it?
Congratulations on retirement.
Please Log in to join the conversation.
- Rob
- Offline
- Administrator
Less
More
- Posts: 4785
- Karma: 103
- Thank you received: 673
4 years 5 months ago #26103
by Rob
Replied by Rob on topic Export/CSV option throws error Unknown column
I am guessing, when you set up your export, you have excluded the resource name and the export is not happy about it.
I cannot reproduce the behavior here.
I cannot reproduce the behavior here.
Please Log in to join the conversation.
- Patrick Gay
- Topic Author
- Offline
- Expert Boarder
Less
More
- Posts: 91
- Karma: 1
- Thank you received: 0
4 years 5 months ago #26104
by Patrick Gay
Replied by Patrick Gay on topic Export/CSV option throws error Unknown column
I ended up going to the config and choosing export. The resource name was there, but it wasn't working for some reason. I removed the ResourceName field and added it back and saved and now it's working.
Thanks for the suggestion. Problem is resolved.
Thanks for the suggestion. Problem is resolved.
Please Log in to join the conversation.
- Rob
- Offline
- Administrator
Less
More
- Posts: 4785
- Karma: 103
- Thank you received: 673
4 years 5 months ago #26105
by Rob
Replied by Rob on topic Export/CSV option throws error Unknown column
Glad you got it working.
Please Log in to join the conversation.
- Community Forum
- Appointment Booking Pro - Retired, no longer for sale or supported.
- ABPro 4.0.x
- Export/CSV option throws error Unknown column
Time to create page: 0.187 seconds