ERROR: Import `create_view.sql` failed [check import file]

  • Resolved rc169

    (@rc169)


    3 years, 3 months ago

    Hello Peter,

    I am trying to create an SQL view, but get the error shown in the heading. I have wrapped the field names, etc in backticks, as suggested in another question on this forum, but still get the error. Is there any way that I can see (or generate) a log file that shows whet the actual problem is, or at least gives a hint?

    I have placed a semicolon at the end of the SQL command, and a Line Feed, as stated in the documentation, but without success.

    Thanks in advance for your help.

    Nigel

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    3 years, 3 months ago

    Hi @rc169,

    Sorry to hear you’re encountering an issue.

    Are you importing this view to your local WordPress database?

    If you’re importing to a remote database, we have a doc page dedicated to troubleshooting error messages here: Errors and Messages | Remote Database

    Would it be alright for us to see this file so we can check?

    You can send us a new message here Contact | WP Data Access.

    We’ll wait for your message!

    Thread Starter rc169

    (@rc169)

    3 years, 3 months ago

    Hi Kim,

    Thanks for your message. I am importing to the local WordPress database, and I had also reported the issue to my hosting supplier. The hosting company adjusted a setting, and advised me that the import procedure should now work – which it did, ultimately. However, I did find that I had configured the name of the view wrongly, and it included a period. After removing the period, so that the name of the view has only letters, then the import worked correctly. Maybe it would also have functioned if I had wrapped the name of the view in quotation marks.

    Now that the SQL view has been created, another issue has arisen with the use of the view on a WordPress page. In WP Data Access, I have setup Data Tables, and in the data tables, I have some columns which are URLs of files located on the website. In “Table Builder” – “Data Tables”, “Publication type”, I have set these up with the following settings:-

    Type = Modal

    Hyperlinks on modal = Always

    Show icons = Yes

    However, with these settings on the SQL View, the URLs are shown as plain text, and do not open the corresponding page. In “Data Explorer”, I have set the columns as Column Type “Hyperlink”, and the save of the settings functions correctly. However, the setting seems to become “lost” subsequently, so that the hyperlinks do not work in the browser. This problem does not arise with the actual data tables, only with the views.

    Can you help with this issue? Let me know if I need to setup a separate entry on the forum.

    Thanks in advance for your help.

    Nigel (rc169)

    Plugin Contributor Kim L

    (@kimmyx)

    3 years, 3 months ago

    Hi Nigel,

    Thanks for the response and for updating us about the upload issue.

    We’re now looking into the hyperlink issue and yes, please create a new thread so that others who may come across a similar issue will find your thread easier. 🙏

    For now, I will mark this thread as resolved and will respond on the new thread you create.

    Thank you!

    Thread Starter rc169

    (@rc169)

    3 years, 3 months ago

    Thanks Kim.

    I have created the new thread:-

    https://ww.wp.xz.cn/support/topic/cannot-create-url-link-in-sql-view/

    Thanks in advance for your help.

    Nigel (rc169)

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

The topic ‘ERROR: Import `create_view.sql` failed [check import file]’ is closed to new replies.