Title: Parse Error on line 1 Last modified: April 19, 2020 --- # Parse Error on line 1 * Resolved [larryhines](https://wordpress.org/support/users/larryhines/) * (@larryhines) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/) * I am new to WP. I am it running currently as a local host on a Mac, with the intent to migrate after I make sure all of our requirements can be met. So far so mgood. * I installed the Data Access Plug in and it is great. Successfully used to add tables, data, etc. * I made several tables visible, but when I want to publish, I get an error: * Parse error on line 1: Expected ‘string’, ‘number’. ‘Null’, ‘True’, ‘False’,‘{‘,‘[‘, got ‘EOF’ * The error is displayed in the Table Options section whether I have selected a table or not. I also uninstalled and reinstalled Data Access Plug-in, but that did not work. * How do I fix this error so I can publish? * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fparse-error-on-line-1%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 9 replies - 1 through 9 (of 9 total) * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12699546) * Hi Larry, * Are you seeing this error in the Data Publisher table options section or in Data Projects manage table options section? Can you add a screenshot? * Since you are working a Mac, I presume you are using Safari? Can you use another browser to see if you are getting the same results? * Best regards, Peter * Thread Starter [larryhines](https://wordpress.org/support/users/larryhines/) * (@larryhines) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12703132) * I tried Chrome and got the same result. * Per your email * $return = do_shortcode (‘[wpdataaccess pub_id=”4″ sql_where=”S_P_R=\’20210101\'”‘); * I am new to WP. Can you direct me to where to place this code? * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12703484) * Sorry Larry! I see now this is not gonna work… 🙈 * You cannot combine pub_id and sql_where. If you want to add a where clause to a publication, you need to enter it in the Data Publisher. Unfortunately the where clause supports hard coded values, but no variables. * You might have an alternative. Please checkout the search option (see link below). Option search allows you to add an initial search value to your table. Hope this helps… * [https://datatables.net/reference/option/search](https://datatables.net/reference/option/search) * Sorry, Peter * Thread Starter [larryhines](https://wordpress.org/support/users/larryhines/) * (@larryhines) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12721494) * Sorry, but I am completely confused. I am not trying to add a “where” clause. I just want to publish a simple 3 column table. The error shows in the Data Publisher even before I have selected a table or entered any info into the Data Publisher. * I attached screenshot when I replied to the email. I do not think I can add a screen shot tom this forum reply. * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12721631) * Sorry, looks like I mixed two posts topics. * I checked your mail, but there is no attachment. It might have been rejected for security reasons. Can you put it online and send me the url? * Thanks, Peter * Thread Starter [larryhines](https://wordpress.org/support/users/larryhines/) * (@larryhines) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12721700) * As requested here is a link to a screenshot. It is a google doc * [https://docs.google.com/document/d/11t-NUL1gWwGo4uGAi43EfzADa-FM86ky88nExdoHGME/edit?usp=sharing](https://docs.google.com/document/d/11t-NUL1gWwGo4uGAi43EfzADa-FM86ky88nExdoHGME/edit?usp=sharing) * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12722055) * Thank you for the screenshot! * It looks like your browser doesn’t like the JSON editor. Can you please disable the editor and try again? This how you disable the JSON editor: – Go to Settings menu – Click on WP Data Access – Click on tab Data Publisher – Scroll down to JSON editing – Select “Use textarea without JSON validation” – Save your settings * The Data Publisher will work without the JSON editor as well, but the plugin will not be able to validate if your column table options (advanced) contains valid JSON. Please be aware that the table options (advanced) column still needs to be valid JSON. * Let me know if this solve your problem… * Best regards, Peter * Thread Starter [larryhines](https://wordpress.org/support/users/larryhines/) * (@larryhines) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12722547) * Thanks you. Yes, this resolved the problem, * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12722730) * Great! 🙂 Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Parse Error on line 1’ is closed to new replies. * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063) * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/) * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/) * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/) ## Tags * [parse-error](https://wordpress.org/support/topic-tag/parse-error/) * 9 replies * 2 participants * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/parse-error-on-line-1/#post-12722730) * Status: resolved