Parse Error on line 1

  • Resolved larryhines

    (@larryhines)


    6 years, 1 month ago

    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 to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    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

    (@larryhines)

    6 years, 1 month ago

    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

    (@peterschulznl)

    6 years, 1 month ago

    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

    Sorry,
    Peter

    Thread Starter larryhines

    (@larryhines)

    6 years, 1 month ago

    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

    (@peterschulznl)

    6 years, 1 month ago

    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

    (@larryhines)

    6 years, 1 month ago

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    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

    (@larryhines)

    6 years, 1 month ago

    Thanks you. Yes, this resolved the problem,

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Great! 🙂

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Parse Error on line 1’ is closed to new replies.