2. PHPRunner General questions
  3. [SOLVED]  Error when exporting project
This topic is locked
[SOLVED]

 Error when exporting project

 		10/14/2019 1:03:13 AM
PHPRunner General questions
rdsanford author

I get this error during project export. The export completes.
An error occurred while exporting table

Testtable





Error executing query

Table 'test.Testtable doesn't exist





SHOW full columns from'Testtable'
The custom view was deleted previously. It does not display on the datasource tables page, yet export apparently thinks it is still there. Can I manually remove the reference to this non-existent export table? Sync database doesn't resolve issue.
Thanks
Sergey Kornilov admin 10/14/2019

A couple of things I can suggest.

  1. Make sure you run the latest build of PHPRunner
  2. Also, you can proceed to 'Deleted tables' on 'Datasource tables' screen and choose to 'Remove from project permanently'.
rdsanford author 10/15/2019



A couple of things I can suggest.

  1. Make sure you run the latest build of PHPRunner
  2. Also, you can proceed to 'Deleted tables' on 'Datasource tables' screen and choose to 'Remove from project permanently'.


I did both things you suggested, still had this issue.
lefty 10/15/2019



I did both things you suggested, still had this issue.


I have heard this issue in the forum before. Delete the output file in your folder and server if your already uploaded to . Then re-build with newest version (build #33876) . As always Backup any output. Then don't forget to change the new output to any folders or plugins that need write permissions. I have no issues with export pages in newest version. As admin says before build delete any tables not used! This should ensure you have 1. a clean build and 2. the correct synced tables to export.
One of the fixes was Quote " (build #33876)

[color="#1C2837"]
[color="#1C2837"][font="arial, verdana, tahoma, sans-serif"]
Sergey Kornilov admin 10/16/2019

This is not about export pages, this is about project export (Project->Export project).
It appears that 'Testtable' is stuck somewhere in project, maybe you have used it as a Lookup table somewhere. If you do not remember where to check you can open your project file (.phpr) in any text editor, search for 'Testtable' there and it can point you in the right direction.
rdsanford author 10/16/2019



This is not about export pages, this is about project export (Project->Export project).
It appears that 'Testtable' is stuck somewhere in project, maybe you have used it as a Lookup table somewhere. If you do not remember where to check you can open your project file (.phpr) in any text editor, search for 'Testtable' there and it can point you in the right direction.


This was my issue. I deleted the actual lookup table but did not remove the reference from the field on the parent table. Apparently the build process does not report an issue if this should happen. I discovered this while testing the parent table and got a php exception. Solved and thank you all for your help.