Support Forums: Recent Posts

Support Forums: Recent Posts http://www.synapp2.org/forum/ synapp2.org en Fri, 30 Jul 2010 08:52:53 +0000 richard on "Version 1.8.0 (beta 1)" http://www.synapp2.org/forum/topic.php?id=35#post-84 Tue, 20 Jul 2010 08:27:03 +0000 richard 84@http://www.synapp2.org/forum/ Release Notes - SynApp2 1.8.0 (beta 1) //// Installation Instructions ./_config_/synapp2.install.MySQL.txt ./_config_/synapp2.install.Oracle.txt review the update notes below Program and Usage Information ./synapp2/synapp2.txt Issues ./synapp2/synapp2.todo.htm //// New things for version 1.8.0 include: 1. new Options GUI makes many more items available for interactive customization 2. EXTRA columns are now available for inclusion on all forms in the generated application except for Input (IFORM) 3. column display names are visible on the Options Form - Column Display Attributes, along with the raw (and expanded) names 4. improved automatic column and nav/report tab display name formatting //// Bugs fixed with version 1.8.0 (beta 1): 1. XML parse errors, while processing [extraneous data in] AJAX server responses, are handled and displayed by the SynApp2 message window (or in the Report display IFRAME) 2. table alias values are correctly mapped into generated SQL statement terms and clauses when there are multiple joins involving any table that supplies records for different levels of hierarchy during a select query 3. the causes for all known PHP WARNING, NOTICE and STRICT messages have been addressed - although it is possible to run SynApp2 with PHP (5.3.0 at least) display_errors TRUE and error_reporting level set to E_ALL | STRICT, it is a generally accepted practice to keep PHP display_errors FALSE on production servers - if display_errors is FALSE and a PHP error does occur, the server may return an http 500 status without much, if any, useful information 4. the date picker control exhibits much better overall behavior and displays [contrasting fg/bg colors] correctly on the Mac version of Safari4+ //// Looking forward: a) examples b) production release status c) GUI to manage users and authorization settings d) installation wizard/configuration checker e) support for mass edit/add of records f) alternative page flow strategies for generated applications g) fully managed concurrent database access (table record locking) h) support for database engines: MS SQL Server, SQLite, PostgreSQL i) formal bug and change log databases richard on "Please Login appears at the bottom of the page" http://www.synapp2.org/forum/topic.php?id=29#post-83 Tue, 20 Jul 2010 08:21:13 +0000 richard 83@http://www.synapp2.org/forum/ SynApp2 version 1.8.0 (beta 1) has improved error handling and reporting. You should update to the latest version. richard on "Forum Registration" http://www.synapp2.org/forum/topic.php?id=16#post-82 Tue, 20 Jul 2010 08:10:28 +0000 richard 82@http://www.synapp2.org/forum/ Moved topic to from General Discussion to Announcements richard on "Documentation - SynApp2 Walk through No. 1" http://www.synapp2.org/forum/topic.php?id=17#post-81 Tue, 20 Jul 2010 08:09:13 +0000 richard 81@http://www.synapp2.org/forum/ Moved topic from General Discussion to Announcements richard on "SynApp2 0.1.8 Preview Available" http://www.synapp2.org/forum/topic.php?id=32#post-80 Tue, 20 Jul 2010 08:08:18 +0000 richard 80@http://www.synapp2.org/forum/ Moved topic from General Discussion to Announcements richard on "Documentation - SynApp2 Customization" http://www.synapp2.org/forum/topic.php?id=9#post-79 Tue, 20 Jul 2010 08:06:15 +0000 richard 79@http://www.synapp2.org/forum/ Moved topic from General Discussion to Announcements richard on "Oracle 11g does not work" http://www.synapp2.org/forum/topic.php?id=21#post-78 Tue, 20 Jul 2010 08:04:24 +0000 richard 78@http://www.synapp2.org/forum/ Moved post from General Discussion to Issues. richard on "File organiazation of disributions has changed" http://www.synapp2.org/forum/topic.php?id=34#post-77 Tue, 20 Jul 2010 07:47:47 +0000 richard 77@http://www.synapp2.org/forum/ As of 1.8.0 beta 1, all of the files and folders in the distribution archives have moved up 1 level (previously, there had been a top level folder named synapp2). Take a peek into the archive, before you expand it, to see what's going on. As always, the meat and potatoes is in 3 folders: { _config_, _shared_, synapp2 } If you're installing for the first time, you'll need all 3 folders. If you're updating, don't do anything with _config_, that is, if you already have it on your server. See the release notes. The synapp2 folder is only needed if you want the GUI for the web app generator on the server. On servers that are just hosting SynApp2 generated applications, you can skip it. In most cases, update your SynApp2 installation(s) by just dropping in new _shared_ and synapp2 folders and you're done. That was easy! richard on "Calendar / Date Pick control" http://www.synapp2.org/forum/topic.php?id=25#post-76 Mon, 19 Jul 2010 14:44:03 +0000 richard 76@http://www.synapp2.org/forum/ The calendar date picker has been significantly improved as of SynApp2 version 1.8.0 (beta 1) richard on "About Alpha Release Status" http://www.synapp2.org/forum/topic.php?id=27#post-75 Mon, 19 Jul 2010 14:31:52 +0000 richard 75@http://www.synapp2.org/forum/ SynApp2 has been elevated to a release status of beta, as of version 1.8.0 (beta 1), on 19 July 2010 richard on "SynApp2 - Version 1.8.0 (Beta 1) Released!" http://www.synapp2.org/forum/topic.php?id=33#post-74 Mon, 19 Jul 2010 14:28:53 +0000 richard 74@http://www.synapp2.org/forum/ Take the convention over configuration design paradigm to a whole new level with SynApp2. Genuinely complete web applications will simply fall out of your relational database designs. Instantly cut to the chase. Let SynApp2 handle numerous up-front development decisions and details - so you don’t have to. Point SynApp2 to an instance of your sensibly normalized MySQL database or Oracle schema and - click - you have a web application. Use the new customization GUI to extend and enhance your apps, taking advantage of the powerful MVC framework. Leverage sophisticated features to manage data within an orchestrated process flow. SynApp2 has what you need to create custom tailored applications with search, browse, read, edit, add, and delete capabilities. Plus, you’ll have automatic data validation, tabular PDF reports and data export - all on your first turn. With your applications up and running - create custom handlers for batch processing, two-phase data validation, dynamic GUI and anything else you may need. The SynApp2 authentication and authorization facilities make quick work of mapping user access to all areas of your applications, with a very flexible, yet practical degree of granularity. Like modern composite materials, SynApp2 is both ultra-lightweight and very strong. Use SynApp2 by itself or alongside whatever tools and technology you rely on. SynApp2 is free and open source software. Contact us at <a href="http://www.synapp2.org" rel="nofollow">http://www.synapp2.org</a> richard on "SynApp2 0.1.8 Preview Available" http://www.synapp2.org/forum/topic.php?id=32#post-73 Mon, 19 Jul 2010 14:25:07 +0000 richard 73@http://www.synapp2.org/forum/ SynApp2 version 1.8.0 (beta 1) has shipped. richard on "SynApp2 0.1.8 Preview Available" http://www.synapp2.org/forum/topic.php?id=32#post-72 Wed, 14 Jul 2010 07:38:12 +0000 richard 72@http://www.synapp2.org/forum/ SynApp2 RC 0.1.8n preview is now available. richard on "SynApp2 0.1.8 Preview Available" http://www.synapp2.org/forum/topic.php?id=32#post-71 Wed, 07 Jul 2010 13:11:23 +0000 richard 71@http://www.synapp2.org/forum/ SynApp2 RC 0.1.8k is feature-complete, stable and fully functional. Let me know if you want a preview, I'll send you a link to the distro. richard on "What language does the SynApp2 code-generation produce?" http://www.synapp2.org/forum/topic.php?id=31#post-70 Tue, 29 Jun 2010 10:01:05 +0000 richard 70@http://www.synapp2.org/forum/ SynApp2 generates static w3c compliant HTML 4.01 and a few lines of JavaScript into each page of an application. The application and report navigation tabs are dynamically generated HTML. Appearance is managed exclusively with CSS. In practice, SynApp2 and the generated applications will run on, and with, just about any combination of browser, web server, PHP and MySQL version produced over the last 5 or 6 years. The following excerpt is from the synapp2.txt document: <blockquote> W3C standards compliant browser (FF 1.5+, IE 6+, Safari ?+, others) JavaScript/DOM (as supported by browser) AJAX data exchange layer Apache, Microsoft IIS MySQL 4+, Oracle 10g (Express Edition) PHP 4+ Windows/Vista/Linux/Unix/Mac/iPhone/iPod Touch/Sun/LAMP </blockquote> The following excerpt is from page 9 of the SynApp2 Concepts document: <blockquote> While the framework supports dynamic GUI generation, all of the GUI forms that SynApp2 generates are static HTML. This means that you can use readily available markup editing tools to stylize them. Do this as a final step, after the design of your database and application has been proven. Almost all of what SynApp2 generates is view related – GUI. Very little executable code is emitted. SynApp2 generated executable code is limited to a few, simple, name vs. value mapping statements. It is the generalized, application-independent executable code of the underlying SynApp2 MVC framework that is reused, or shared, by every SynApp2 powered application. There will be more on this later, but for those who are leery of code generators, take comfort. Amazing things can be done with the SynApp2 MVC framework, beyond just supporting automatically generated applications. </blockquote> Here is a sample of the city.htm page generated for the Census application, described in the SynApp2 Walk through No. 1 document: ' <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">  <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta http-equiv="Pragma" content="no-cache"> <meta name="generator" content="SynApp2">     <title> City </title>   <link rel="stylesheet" type="text/css" href="../_shared_/standard.css">  <link rel="stylesheet" type="text/css" href="../_shared_/3rdparty/date/datepickercontrol.css">  <script type="text/javascript" src="../_shared_/synapp2.js"></script> <script type="text/javascript" src="../_shared_/3rdparty/webtoolkit.drag.js"></script> <script type="text/javascript" src="../_shared_/3rdparty/date/datepickercontrol.js"></script>  <script type="text/javascript"> // set_appid('census'); set_pid('city'); // // //reg_lookup('id__iform__00__city', {qid:'country', basis_id:'id__iform__00__city__id_country'}); //reg_lookup('id__iform__00__city', {qid:'timezones', basis_id:'id__iform__00__city__timezone'}); reg_flow('id__tform__00__city', {_qid_:'city'}); // // reg_overlay("id__tform__00__city", "id__sform__00__city", "search"); reg_overlay("id__tform__00__city", "id__iform__00__city", "input"); reg_overlay("id__tform__00__city", "id__tform__00__city", "select", 5); reg_overlay("id__tform__00__city", "id__aform__00__city", "stat"); // function page_init() { do_init(); do_app_nav('id_app_nav'); } </script>    </head> <body id="id_body" onload="page_init();"> <div id="id_app_nav" class="class_app_nav"></div> <div id="id_page_content" class="class_page_content"> <div id="id__iform__screen"></div> <div></div>  <div class="class_nav_col">  <div id="id__sform__00__city" class="class_layout_group_std"> <div id="id__sform__00__city__caption" class="class_layout_group_caption_std">Search Form - City</div> <div class="class_form_std"> <label for="id__sform__00__city__id_country">Country:</label> <input id="id__sform__00__city__id_country" type="text" name="city_id_country" size="40"> <label for="id__sform__00__city__city_name">City Name:</label> <input id="id__sform__00__city__city_name" type="text" name="city_name" size="40"> <label for="id__sform__00__city__timezone">Timezone:</label> <input id="id__sform__00__city__timezone" type="text" name="city_timezone" size="40"> </div> <div class="class_vsep_std"></div> <div class="class_control_bar"> <div class="class_control_bar_caption">City</div> <div class="class_control_bar_controls"> <button type="button" name="do_search" title="Search"><img src="../_shared_/img/action_search.gif" alt="Search"></button> <button type="button" name="do_reset" title="Reset"><img src="../_shared_/img/action_reset.gif" alt="Reset"></button> <button type="button" name="do_add" title="Add"><img src="../_shared_/img/action_add.gif" alt="Add"></button> </div> <div class="class_control_bar_prompt">Fill in values and then click Search</div> </div> </div> <div class="class_layout_vsep_std"></div> <div class="class_layout_hsep_std"></div> </div>  <div class="class_layout_vsep_std"></div> <div class="class_layout_hsep_std"></div> <div id="id_basis_div" class="class_nav_col"> <div id="id__tform__00__city" class="class_layout_group_std"> <div id="id__tform__00__city__caption" class="class_layout_group_caption_std">Select Form - City</div> <table id="id__tform__00__city__table" class="class_table_std" cellspacing="0"> <thead> <tr> <th><input type="checkbox"></th> <th> </th> <th>Country</th> <th>City Name</th> <th>Timezone</th> <th>Population</th> </tr> </thead> <tbody> <tr> <td axis="_row_id_"><input type="checkbox"></td> <td axis="_row_no_"> </td> <td axis="city_id_country"> </td> <td axis="city_name"> </td> <td axis="city_timezone"> </td> <td axis="population"> </td> </tr> </tbody> </table> <div class="class_vsep_std"></div> <div class="class_control_bar"> <div class="class_control_bar_caption">City</div> <div class="class_control_bar_controls"> <button type="button" name="do_nav_first" title="First"><img src="../_shared_/img/action_nav_first.gif" alt="First"></button> <button type="button" name="do_nav_up" title="PgUp"><img src="../_shared_/img/action_nav_up.gif" alt="PgUp"></button> <button type="button" name="do_nav_dn" title="PgDn"><img src="../_shared_/img/action_nav_dn.gif" alt="PgDn"></button> <button type="button" name="do_nav_last" title="Last"><img src="../_shared_/img/action_nav_last.gif" alt="Last"></button> <button type="button" name="do_nav_close" title="Close"><img src="../_shared_/img/action_close.gif" alt="Close"></button> <button type="button" name="do_add" title="Add"><img src="../_shared_/img/action_add.gif" alt="Add"></button> <button type="button" name="do_edit" title="Edit"><img src="../_shared_/img/action_edit.gif" alt="Edit"></button> <button type="button" name="do_delete" title="Delete"><img src="../_shared_/img/action_remove.gif" alt="Delete"></button> </div> <div class="class_control_bar_prompt">Navigate records, select a record and then click Edit (or click Add to create a new record)</div> </div> </div> <div class="class_layout_vsep_std"></div> <div class="class_layout_hsep_std"></div> </div>    <div id="id__iform__00__city" class="class_layout_group_iform"> <div id="id__iform__00__city__caption" class="class_layout_group_caption_std">Input Form - City</div> <div id="id__iform__00__city_feedback" class="class_form_std_feedback"> <label for="id__iform__00__city__id_country"></label> <label for="id__iform__00__city__city_name"></label> <label for="id__iform__00__city__timezone"></label> <label for="id__iform__00__city__population"></label> </div> <div class="class_form_std"> <label for="id__iform__00__city__id_country">Country:</label> <select id="id__iform__00__city__id_country" name="id_country" onchange="process_change(this);"><option value=""></select> <label for="id__iform__00__city__city_name">City Name:</label> <input id="id__iform__00__city__city_name" type="text" name="city_name" maxlength="40" size="40"> <label for="id__iform__00__city__timezone">Timezone:</label> <select id="id__iform__00__city__timezone" name="timezone" onchange="process_change(this);"><option value=""></select> <label for="id__iform__00__city__population">Population:</label> <input id="id__iform__00__city__population" type="text" name="population" maxlength="10" size="10"> </div> <div class="class_vsep_std"></div> <button type="button" name="do_exchange" title="Ok">Ok</button> <button type="button" name="do_cancel" title="Cancel">Cancel</button> </div>  <div id="id_page_msg" class="class_msg_std"></div> </div>  </body> </html> ' richard on "Please Login appears at the bottom of the page" http://www.synapp2.org/forum/topic.php?id=29#post-69 Tue, 20 Apr 2010 15:37:45 +0000 richard 69@http://www.synapp2.org/forum/ A review of the recommendations for PHP configuration confirms that <code>display_errors</code> should be off <code>{false, '0'}</code> on any production server. The default error level of PHP is (or should be) <code>E_ALL & ~E_NOTICE</code>, according to the PHP Manual. But, since PHP 5.3 there are now DEPRECATED messages. This has led to a few tweaks that will help SynApp2 run more quietly, in versions beyond 0.1.7. Here's a firm recommendation to adjust your PHP configuration to turn off <code>display_errors</code> altogether. It’s easy to look in the PHP log file to see what’s going on. You may have to enable that with log_errors={true,1}. Having error display turned on, for anything other than serious debug sessions, is likely to cause trouble. There's almost always a chance that some code, somewhere, is going to trip a message, especially over time and with different (newer) versions of PHP. richard on "Changes affecting Walk through No 1." http://www.synapp2.org/forum/topic.php?id=30#post-68 Tue, 13 Apr 2010 13:43:23 +0000 richard 68@http://www.synapp2.org/forum/ The GUI for v 0.1.7 has changed slightly since the Walk through document was last updated. Since then, a multi-select checkbox column has be added to Select Forms. Checking a box is equivalent to clicking on a row (cell) in older versions of SynApp2. Clicking on a row, now does two things at once - 1) highlight, 2) select (and move on). There's a new set of keyboard shortcuts. A reference guide for those is pending. But, the walk through should work nicely, if you check (exactly one) row, and the click the green checkmark (select) button, to move on. The multi-select capability is only for Delete operations. Mass Add and Edit is coming. richard on "Please Login appears at the bottom of the page" http://www.synapp2.org/forum/topic.php?id=29#post-67 Tue, 13 Apr 2010 09:06:16 +0000 richard 67@http://www.synapp2.org/forum/ If PHP error/notice messages get into the (XML) response stream headed back to the browser, the XMLHttpRequest object can throw a parse exception. This looks (to synapp2.js) like an authentication failure and the login message appears. With version 0.1.7, there is at least one place in action.php that throws a warning (notice) under some conditions (line 90 if you must know). It didn't get caught because a developer, who wasn't getting enough sleep, left the HTML display_errors messages turned off in his PHP configuration while he was testing. (He as been severely disciplined and will have time to think about this while he heals and learns to type with nine fingers.) In the mean time, if you see this problem, try turning off display_errors or setting the error_reporting level to E_ALL & ~E_NOTICE richard on "SynApp2 Concepts" http://www.synapp2.org/forum/topic.php?id=28#post-66 Sat, 10 Apr 2010 14:39:33 +0000 richard 66@http://www.synapp2.org/forum/ The SynApp2 Concepts document has been released. There's 53 pages of in-depth information and illustrations. The document is current with the SynApp2 0.1.7 release. richard on "About Alpha Release Status" http://www.synapp2.org/forum/topic.php?id=27#post-65 Wed, 24 Mar 2010 11:53:47 +0000 richard 65@http://www.synapp2.org/forum/ Don't let the alpha release status frighten you away. SynApp2 is solid, useful software. The alpha status provides some elbow room to make needed changes, even if it happens to impact backward compatibility to some degree. If a change is necessary, to sensibly move forward, it's going to get done. Things are happening quickly, and it isn't reasonable to deprecate functions over one or more releases before they're removed. Eventually, there will be some warning, but not in the near term. Don't worry. Every effort is being made to minimize impacts. Much care and thought goes into how things get done in the first place, so a lot of track doesn't have to get ripped up as we go along. So far, we've done really well. Have faith. Jump in. The water's fine! richard on "Run PageGen always prompts "Please Login"" http://www.synapp2.org/forum/topic.php?id=26#post-64 Sat, 13 Mar 2010 14:12:01 +0000 richard 64@http://www.synapp2.org/forum/ Stephen, I'm glad you were able to figure it out. The file permissions, as you found, are critical. I'm working on a release candidate for version 0.1.7. I'd like to send you that. I've refactored and reorganized the JavaScript code. There is now keyboard event management and some nifty shortcuts. My email address/link is on the SynApp2.org home page. You can email me anytime, I'll be glad to hear from you. Richard stephen on "Run PageGen always prompts "Please Login"" http://www.synapp2.org/forum/topic.php?id=26#post-63 Thu, 11 Mar 2010 16:20:15 +0000 stephen 63@http://www.synapp2.org/forum/ G'day again, I'm an idiot. I installed the synapp2 directory structure onto my web server as root and forgot to change the file owner and group to the webserver user apache. My webserver could only read the files and not write or modify any of them. chown and chgrp everything in synapp2 to apache and now it works correctly. stephen on "Run PageGen always prompts "Please Login"" http://www.synapp2.org/forum/topic.php?id=26#post-62 Thu, 11 Mar 2010 16:08:37 +0000 stephen 62@http://www.synapp2.org/forum/ Hi there, I installed without problem and can login to the initial login page. Successfully select my database and table then move to the PageGen page but every time I press the PageGen button it simply prompts me to "Please Login" at the very bottom of the page. Something must be wrong with my setup but I don't know what. Cheers Steve richard on "Calendar / Date Pick control" http://www.synapp2.org/forum/topic.php?id=25#post-61 Tue, 26 Jan 2010 17:55:11 +0000 richard 61@http://www.synapp2.org/forum/ The calendar control seems to be inconsistent, in that it doesn't always register the clicked on date. Workaround: use the keyboard cursor keys to highlight a date and hit enter. It's probably been this way since day one - just didn't catch it. Expect it to be fixed in releases after 0.1.6. richard on "Documentation - SynApp2 Customization" http://www.synapp2.org/forum/topic.php?id=9#post-60 Mon, 18 Jan 2010 11:28:22 +0000 richard 60@http://www.synapp2.org/forum/ The SynApp2 Customization document is now current through version 0.1.6. There's lots of detailed information about creating custom functions for validation and specialized processing. richard on "Version 0.1.6" http://www.synapp2.org/forum/topic.php?id=24#post-59 Mon, 18 Jan 2010 10:22:16 +0000 richard 59@http://www.synapp2.org/forum/ Release Notes - SynApp2 0.1.6 alpha //// Installation Instructions ./_config_/synapp2.install.MySQL.txt ./_config_/synapp2.install.Oracle.txt review the update notes below Program and Usage Information ./synapp2/synapp2.txt Issues ./synapp2/synapp2.todo.htm //// If you're updating from version 0.1.3 or earlier: 1. Make sure you preserve a copy of your customized version of _shared_/access.php 2. Make sure you preserve copies of customized versions of _shared_/custom.inc.php and/or synapp2/custom.inc.php, if any 3. Replace all of the SynApp2 files with ones from the new .tar.gz or .zip distribution 4. Merge customizations into _shared_/custom.inc.php and/or synapp2/custom.inc.php, as needed 5. Update _config_/access.inc.php with your customizations for site prefix, usernames, passwords, etc., from your preserved copy of _shared_/access.php If you're performing a fresh install, you can disregard the notes above. //// If you're updating from 0.1.4 or earlier and have defined EXTRA columns for your app(s), most EXTRA columns will shift position (to the left), after you regenerate affected pages. You can change the EXTRA <key_column> sub-expression to be the column immediately to the left of where the EXTRA column should appear. //// New things for version 0.1.6 include: 1. support for custom column validation functions 2. support for customizable, event-driven drag 'n drop //// Bugs fixed with version 0.1.6: 1. PHP 5.3 compatibility - failure to initialize parent class by parent name - use base class/constructor name instead, report.php fixed (2009-12-01) 2. PHP 5.3 compatibility - convert regular expression functions from deprecated POSIX ereg to Perl preg, all but 1 case fixed (2010-01-08) 3. resize_container() - no action when [response payload is empty] row_size = 0 (2009-12-19), fixed (2009-12-22) clip row_size to 1 - synapp2.js 4. custom::get_nav_incl_tabs() - does not handle space(s) between CSV elements, (2010-01-02), fixed (2010-01-02) trim() the CSV elements 5. Safari drag handler breaks select options, disabled idd mechanism for Safari only, HACK: (2009-01-02), fixed (2010-01-07) 6. Report filter form (FFORM) submit not triggered by enter key, fixed (2010-01-14) //// Looking forward: a) more items available for interactive customization b) alternative page flow strategies for generated applications c) overhaul keyboard event handling d) fully managed concurrent database access (table record locking) //// Copyright (c) 2007 - 2010 Richard Howell. All rights reserved. <a href="http://www.synapp2.org" rel="nofollow">http://www.synapp2.org</a> $Id: synapp2.release_notes.txt,v 1.4 2010/01/16 01:38:25 richard Exp $ mico on "Version 0.1.5" http://www.synapp2.org/forum/topic.php?id=22#post-58 Tue, 29 Sep 2009 02:58:25 +0000 mico 58@http://www.synapp2.org/forum/ Great work Richard .... way to go. Mico richard on "SynApp2 Installation - MySQL" http://www.synapp2.org/forum/topic.php?id=23#post-57 Fri, 25 Sep 2009 11:04:51 +0000 richard 57@http://www.synapp2.org/forum/ SynApp2 should work with most or all recent releases of MySQL. There are both short and detailed versions of installation instructions for MySQL. See <a href="http://www.synapp2.org/documentation/_release_/synapp2.install.MySQL.txt" rel="nofollow">http://www.synapp2.org/documentation/_release_/synapp2.install.MySQL.txt</a> - Richard richard on "Version 0.1.5" http://www.synapp2.org/forum/topic.php?id=22#post-56 Fri, 25 Sep 2009 10:53:51 +0000 richard 56@http://www.synapp2.org/forum/ Release Notes - SynApp2 0.1.5 alpha //// Installation Instructions ./_config_/synapp2.install.MySQL.txt ./_config_/synapp2.install.Oracle.txt review the update notes below Program and Usage Information ./synapp2/synapp2.txt Issues ./synapp2/synapp2.todo.htm //// If you're updating to version 0.1.5 from version 0.1.3 or earlier: 1. Make sure you preserve a copy of your customized version of _shared_/access.php 2. Make sure you preserve copies of customized versions of _shared_/custom.inc.php and/or synapp2/custom.inc.php, if any 3. Replace all of the SynApp2 files with ones from the new .tar.gz or .zip distribution 4. Merge customizations into _shared_/custom.inc.php and/or synapp2/custom.inc.php, as needed 5. Update _config_/access.inc.php with your customizations for site prefix, usernames, passwords, etc., from your preserved copy of _shared_/access.php If you're performing a fresh install, you can disregard the notes above. //// If you're updating from 0.1.4 or earlier and have defined EXTRA columns for your app(s), most EXTRA columns will shift position (to the left), after you regenerate affected pages. You can change the EXTRA <key_column> sub-expression to be the column immediately to the left of where the EXTRA column should appear. //// New things for version 0.1.5 include: 1. all reports have option to export tab-delimited text 2. customizable EXTRA columns can generate/supply (X)HTML for hypertext links, images, etc. 3. customizable for Select Form: COL_ORDER 3. customizable report items: RPT_PAGE_SIZE, RPT_PAGE_ORENTATION, RPT_FONT_FAMILY, RPT_FONT_SIZE 4. customizable Select Form rows: LIMIT_ROWS 5. customizable NAV and RPT tab order: TAB_ORDER 6. <key_column> for EXTRA can now refer to any column in/from the qid/basis table //// Bugs fixed with version 0.1.5: 1. invalid (size) markup generated for Report Form date range_elements (2009-09-09), fixed (2009-09-09) 2. like named column didn't fetch/copy from parent to child when parent record is_constraint (2008-09-25), fixed (2008-09-25) 3. PDF Reports - report.php, report::auto_widths() was broken from 0.1.4 development, fixed (2009-09-16) 4. reg_lookup() not enabled for FETCH customization where parent/child column names do not match (2009-09-23), fixed (2009-09-24) //// Looking forward: a) more items available for interactive customization b) alternative page flow strategies for generated applications //// Copyright (c) 2007 - 2009 Richard Howell. All rights reserved. <a href="http://www.synapp2.org" rel="nofollow">http://www.synapp2.org</a> $Id: synapp2.release_notes.txt,v 1.2 2009/09/24 15:57:38 richard Exp $ richard on "Oracle 11g does not work" http://www.synapp2.org/forum/topic.php?id=21#post-55 Tue, 22 Sep 2009 13:54:30 +0000 richard 55@http://www.synapp2.org/forum/ Login to the schema/database you want to generate an application for. The system user is a special case user and is not normally used as a login to SynApp2. richard on "Oracle 11g does not work" http://www.synapp2.org/forum/topic.php?id=21#post-54 Tue, 22 Sep 2009 09:33:07 +0000 richard 54@http://www.synapp2.org/forum/ The service name should also appear in the listener.ora file. Locate listener.ora and look for the line: DEFAULT_SERVICE_LISTENER = (XX) Use the XX value in place of XE in the oci_connect() statement. richard on "Oracle 11g does not work" http://www.synapp2.org/forum/topic.php?id=21#post-53 Tue, 22 Sep 2009 07:29:10 +0000 richard 53@http://www.synapp2.org/forum/ olá É agradável encontrar a ti. Your English is a lot better than my Portuguese. I hope I said - Hello. It is nice to meet you. I think we need to discover the SERVICE_NAME for the instance of Oracle that you're running. Here's a link that discusses naming methods: <a href="http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/naming.htm" rel="nofollow">http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/naming.htm</a> Assuming you're on a Linux system, use the locate or find command to find the file: tnsnames.ora. Try the command: locate tnsnames.ora That should show you where the file is. If you would, please post the file to the forum for reference. The service name should be listed. Use the service name in place of "dbname", in the oci_connect statement. Here is what my file looks like. <pre><code># tnsnames.ora Network Configuration File: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )</code></pre> gpolillo on "Oracle 11g does not work" http://www.synapp2.org/forum/topic.php?id=21#post-52 Tue, 22 Sep 2009 04:20:49 +0000 gpolillo 52@http://www.synapp2.org/forum/ I am trying to connect in oracle 11g, but I failed. it was modified @oci_connect($u, $p, "{$h}/XE") TO @oci_connect($u,$p,"{$h}/dbname"), but the result is: (xml): <?xml version="1.0" encoding="utf-8" standalone="yes" ?> <response> <version>0.1.4</version> <authentication>failed</authentication> <authorization>succeeded</authorization> <request_action>select</request_action> <request_mode>get_norm</request_mode> <qid></qid> <query></query> <target_table></target_table> <target_id>0</target_id> <affected_id>0</affected_id> <affected_rows>0</affected_rows> <found_rows>0</found_rows> <insert_id>0</insert_id> <insert_offset>0</insert_offset> <offset>0</offset> <limit>0</limit> <rows>0</rows> <cols>0</cols> <firstpage>1</firstpage> <lastpage>1</lastpage> <debug_msg> $_POST Array ( [_request_action_] => select [_request_mode_] => get_norm [_request_pid_] => login [_request_objective_] => [_request_guidance_] => [_request_limit_offset_] => 0 [_request_show_response_] => true [_login_username_] => system [_login_password_] => ******* [_request_qid_] => [_request_appid_] => synapp2 ) </debug_msg> <debug_msg>db_connect('localhost', 'system') - attempt failed</debug_msg> </response> By simple connect script, I get to access my oracle 11g and other remote oracle 11g and 10g!, but by synapp2, I dont. sorry by my english, I am Brazilian. Thanks. richard on "Opera 10 works for SynApp2" http://www.synapp2.org/forum/topic.php?id=20#post-51 Wed, 02 Sep 2009 11:54:23 +0000 richard 51@http://www.synapp2.org/forum/ Opera 10 seems to be more up to the task of running SynApp2 applications than prior versions. There are a couple of catches: 1. Opera Turbo mode seems to prevent Adobe Reader from displaying reports. 2. The Small Screen mode doesn't display all elements, notably the transparent .png overlay. That unfortunately allows access to forms across z-index layers and breaks the page flow. Other than that, things appear to work fine. richard on "Google Chrome 2.0 works well for SynApp2" http://www.synapp2.org/forum/topic.php?id=19#post-50 Wed, 02 Sep 2009 10:01:19 +0000 richard 50@http://www.synapp2.org/forum/ Version 2.0.127.43 of Google Chrome works well with SynApp2. But, this version has no way of allowing pop-up windows for specific sites. That means that you'll have to give permission for the SynApp2 message window to appear. That hampers dignostics somewhat. The beta version of Chrome reportedly does allow site-specific permissions for pop-ups.