To post a new support question, click the Post New Topic button below. 
Current Version: 5.5.2 | Sytist Manual | Common  Issues | Feature Requests
				Please log in or Create an account to post or reply to topics.
				
		You will still receive notifications of replies to topics you are part of even  if you do not subscribe to new topic emails.
			
		Adding Additional Fields From The Order Data For Order Export
					L
			 
			
			
			
				
			
			
			 
				Lori Chaudoir
				53 posts  
						
			Wed Jun 29, 22 10:35 AM CST
				After seeing someone else's post about reports and workflow, I decided to see what I could do with them to enhance my workflow.
But when I attempt to add additional fields from the order data, specifically order_notes, and I click add, I get the following
MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function='fieldname', status='1' , display_order='16'' at line 1
I have no experience in MySQL so I am not sure what it is I am supposed to do. Can anyone help?
					
	
				
								But when I attempt to add additional fields from the order data, specifically order_notes, and I click add, I get the following
MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function='fieldname', status='1' , display_order='16'' at line 1
I have no experience in MySQL so I am not sure what it is I am supposed to do. Can anyone help?
Attached Photos
				Tim - PicturesPro.com
				17,471 posts  
			 (admin)			
			Thu Jun 30, 22 6:47 AM CST
				Makes no sense you would be getting that error. 
You can email me the following for me to look into it:
1) Link to your Sytist admin.
2) The admin username and password (or create me an admin account by clicking Admins in the upper right corner of the admin pages).
3) Hosting information (link, username and password).
					
	
				
				
								
					You can email me the following for me to look into it:
1) Link to your Sytist admin.
2) The admin username and password (or create me an admin account by clicking Admins in the upper right corner of the admin pages).
3) Hosting information (link, username and password).
		Tim Grissett, DIA - PicturesPro.com 
My Email Address: info@picturespro.com
 				My Email Address: info@picturespro.com
Please log in or Create an account to post or reply to topics.
	
		
	
		

Loading more pages
