[SOLVED] Â After modifying linked view on MySQL server fields does |
6/29/2011 7:35:20 AM |
PHPRunner General questions | |
J
jevobz author
There's a problem with PhpRunner v. 5.3 build 7474: |
|
![]() |
Sergey Kornilov admin 6/29/2011 |
Make sure you synchronized your project after modifying MySQL database. This can be done on 'Datasource tables' screen in PHPRunner. |
J
|
jevobz author 6/29/2011 |
Make sure you synchronized your project after modifying MySQL database. This can be done on 'Datasource tables' screen in PHPRunner.
|
![]() |
Sergey Kornilov admin 6/30/2011 |
If you use a custom SQL Query - you need to modify it manually after synchronization. If this doesn't help contact support directly sending your project file and database for investigation. |
J
|
jevobz author 6/30/2011 |
No, I haven't made any customizations in PHPRunner. It simply ignores any subsequent (after first link) change of linked server-side MySQL view - that's what I wanted to say, and synchronization does not help. In case of contact with support, what should be sent - database dump, alter view SQL file and phpr file? |
J
|
jevobz author 7/1/2011 |
Well, I've just found a solution - if somebody will face the same problem, it is possible to manually edit phpr project file, which is in fact XML file. We need to search there for SQL definitions and fix them (there are 2 inside tags <m_strSQL> and <m_sqlHead>), then for label (inside tag <m_arrFieldLabels>) and add it (by copying and changing other label) and finally for big <m_arrFieldObj> section where Runner's fields definitions are located. I've just copied definition of the same type, placed it in query's order and renamed it. I found these tags by searching for view's name. At the first sight, it works. |
![]() |
Sergey Kornilov admin 7/1/2011 |
Cannot comment on this. Need to see project and database in order to provide a meaningful response. |
J
|
jevobz author 7/8/2011 |
Well, I finally figured out root cause of the problem. My MySQL user had no "SHOW VIEW" privilege (another clients like Access don't require that privilege, they simply use view as table). After adding it, query parser started to work. |