PHPRunner 4.2 beta 2 (build 349)

Looks very good.
However, on every page in the project I have made, I get the folloeing errors in the top od every page generated by PHPR:
Notice: Undefined index: URL in C:\Apache\htdocs\www\_test\include\dbcommon.php on line 3
Notice: Undefined index: dirname in C:\Apache\htdocs\www\_test\include\dbcommon.php on line 4
The code in line 3 and 4 is:

$pinfo=pathinfo($_SERVER["URL"]);

session_set_cookie_params(0,$pinfo["dirname"]);
I cannot figure out the reason
Regards
Morten B Jepsen

At Edit SQL, it does not allow calculated field.

Eg.
Table1:

`rate`

`name`
it does not allow:

`rate`/2 as `new_rate`

`name`
Rgds

Dex

Dex,
I understand from the content of:
http://www.bigresource.com/Tutorial/mySQL/...alculations.htm
that your syntax used is differing from same.
HTH Hajo

Hi,
I had verified again that the calculated field is not supported for build 331.

It worked on the 4.1. When opened at 4.2 build 331, it rejects the sql.
It's a simple divide by 2 for one of the numeric field and it does not accept

on build 331.
Rgds

Dex

Dex,
thanks, I'm looking into this.

Looks pretty awesome.
I'm playing with it now and had a quick question. How do I implement auto-update features?
This would add things I've been looking to implement in the future, so if it works well that would be nice!
Thanks!

Cody

Cody,
Proceed to Visual Editor, open "Edit as" settings of any field, set Default value and check off "Apply on Edit page as well" check box.

Cody,

Ok, cool. I'll give that a try.
For some reason I couldnt add anything on the read only option? Normally I use the now() code on it....but now I cant....any idea why?
I could change it on an old project....but not on my new one.

Just been messing about with the visual mysql thingy
when I put a tick in the top to select all fields and the fields are already ticked, it duplicates the fields

Hi,
I have transferred a project from phprunner 4.1 and am having problems with the visual query designer. Example SQL Statement from 4.1
SELECT

contacts.cn_no,

contacts.cn_type,

contact_types.pc_desc,

contacts.cn_firstname,

contacts.cn_surname,

contacts.cn_jobtitle,

contacts.cn_company,

contacts.cn_address,

contacts.cn_area_no,

areas.area_desc,

contacts.cn_country_no,

countries.ctry_desc,

contacts.cn_phone,

contacts.cn_mobile,

contacts.cn_fax,

contacts.cn_email,

contacts.cn_website,

contacts.cn_team_member_no,

contacts.cn_updated_date,

contacts.cn_updated_user,

contacts.cn_notes

FROM

contacts

LEFT OUTER JOIN contact_types ON (contacts.cn_type = contact_types.pc_no)

LEFT OUTER JOIN areas ON (contacts.cn_area_no = areas.area_no)

LEFT OUTER JOIN countries ON (contacts.cn_country_no = countries.ctry_no)
The areas table is not being shown at the top of the screen and so I get the error:
Cannot retrieve columns information. Please modify SQL query and try again

Error Message: unknown table 'areas' in field list
This statement have been transformed by 4.2 and the table joins have been lost:

SELECT

`contacts`.`cn_no`,

`contacts`.`cn_type`,

`contact_types`.`pc_desc`,

`contacts`.`cn_firstname`,

`contacts`.`cn_surname`,

`contacts`.`cn_jobtitle`,

`contacts`.`cn_company`,

`contacts`.`cn_address`,

`contacts`.`cn_area_no`,

`areas`.`area_desc`,

`contacts`.`cn_country_no`,

`countries`.`ctry_desc`,

`contacts`.`cn_phone`,

`contacts`.`cn_mobile`,

`contacts`.`cn_fax`,

`contacts`.`cn_email`,

`contacts`.`cn_website`,

`contacts`.`cn_team_member_no`,

`contacts`.`cn_updated_date`,

`contacts`.`cn_updated_user`,

`contacts`.`cn_notes`

FROM `contacts`

CROSS JOIN `contact_types`

CROSS JOIN `countries`
There is no problem with the 'areas' table because this query works
select `area_no`,

`area_id`,

`area_desc`,

`area_active`

FROM `areas`
Regards
Gordon

However, on every page in the project I have made, I get the folloeing errors in the top od every page generated by PHPR:

I get exactly the same error, having looked at the previous dbcommon file these lines of code look new.
If I comment out these lines it appears to work fine

IMPORT does not work in 331
Error message: The filename C:\WINDOWS\TEMP\php\upload\phpF92.tmp is not readable
Morten

IMPORT does not work in 331

Morten,
MUST be a failure at your end as I had been extensively testing the IMPORT feature at my end and it worked like a charm.
HTH Hajo

Hajo
I tried on a pc using XP prof SP2 and it does not work. Tried to make a new application and still not work
Tried it from the server then. Server also runs XP prof SP2. Same problem.
I am running build 331 here, could this be the problem. I do not have a clue what this could be. Never have eny problems her. PHP 4.1 runs no problems.
Morten

Morten,
I am running Win XP Pro SP3 RC1 on one partition and installed XAMPP 1.6.5 on my 2 GB USB stick under portableapps.com feature for PHPR 4.2 beta testing purposes, the import feature ran fine and without any problems on several occasions, and I even discovered something interestingly, say, as long as the COLUMNS sequence is not interrupted by means of subsequent SQL field naming, it does not matter on how many fields are in front or after the COLUMN sequence, the import is just working on same.
May I suggest, you are giving a XAMPP 1.6.5 a try on it for onward follow-up at your end what might be wrong with the webserver's configuration at your end.
HTH Hajo

Morten,
I gave PHPR 4.2 beta 1 a chance for testing on a 2 GB USB stick under portableapps.com featured XAMPP 1.6.5 web server, using Win XP Pro with SP3 RC1, really NO problem on the IMPORT feature at all. Even, I discovered on the testing session of IMPORTING a .xls file, it does not really matter how many "wrong" column names are in front or at the end of a subsequent SQL column block, as long as the COLUMN block (SQL based one) is not interrupted by wrongly named IMPORT file, it's working fine.
HTH Hajo

Morten,
make sure that file uploading is set up properly in your PHP.

I.e.

C:\WINDOWS\TEMP\php\upload folder exists and IUSR_... user has read/write permissions on it.

Do you have file uploading working in your other PHP projects ?

IMPORT does not work in 331

Morten,

Alexey
I use file upload on many of my projects, no problem. But I am not uploading a file here, I attempt to load records into a database.
I tried on my own server (localhost) where the user should have full rights also on the C: drive. Same result, same error message.
A php/upload directory is created under C:\WINDOWS\TEMP, but there is no files in it.
The file I attempt to upload is EXCEL 2000. It contains exactly the same fields as the SQL database except the index key.
The funny thing is that I get the same error message on a big external web-hotel (UNIX) as I get on my little home test test server.
Morten

Morten,
I just zipped and mailed a PHPR 4.2 beta project file containing IMPORT demo along with SQL dump, the .xls file used for successful imports and two screenshots over to you. Things (import session of .xls data) had been working at my end like a charm.
HTH Hajo

HAJO
Thanks for all your efforts helping me.
Your project worked with the excel file you sent
When I make a project with my own excel 2000 I get the error message

My own project with CSV vile works
Conclusion: PHPR build 332 (and 331) is not compatible with EXCEL 2000
Which excel version did you use for the data you sent?
Thanks for your assistance

Morten B Jepsen

HAJO

Morten,
on the Excel version..., I used the SAVE AS "Excel97/2000/XP" option under OpenOffice v2.3.1 ...
HTH Hajo

Bonjour.
Phpr4.2 V332:

Exactly as Morten & Kujox, I got these "notices".
Any way to solve that without put a "comment out" on lines 3 & 4 ???
[codebox]Notice: Undefined index: URL in c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php on line 3
Notice: Undefined index: dirname in c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php on line 4
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php:3) in c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php on line 6
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php:3) in c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php on line 6
Warning: Cannot modify header information - headers already sent by (output started at c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php:3) in c:\program files\easyphp1-8\www\phpr42b_cunx\events42\output\include\dbcommon.php on line 19

[/codebox]

I am trying phprunner 4.2 dynamic permissions. But I get an error message when phprunner tries to create the security tables. It says "Failed to create permission tables". Is this something to do with the way I am connecting to the host (using phprunner.php) ? There should be no problem with my MQSQL permissions as I regularly create tables using the login I have specified. Can I create the permissions tables myself manually? Or can you solve this problem please. I will send a jpg to sergey with a screenshot of the error message. Thanks

Ben

Please bring back the Step numbers at the top of the screen. It makes it much easier to know where you are, and when you find something in the Help file, where to find that screen, etc.
Thanks,

Ken

curious about when in January 2008 will the new version be available?
Kim <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=24941&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Thank you for the picture resize function. It's GREAT and works perfect.
In South Africa we pay a lot for traffic and most users don't know how to resize photos, resulting in huge photos landing on the site. This will surely save and is a great marketing feature for our services.
PHPRunner is great!

any estimates on when it will be released?

looks very promising!

What is going wrong????
Today a became a registerd user and I thought, why nog trying v4.2 as well.

Making php filies wilt v4.2 with the same phpr file, made with v4.1, placed in the same outfup folder doens't work.
Calling the login.php, directly from IE7 doens't work. It will not run?
Remaking it with v4.1 it works again.
Am I doing something wrong?
Help me out please because ik want to use the great function to make images automaticly smaller.
Jafieb

What is going wrong????

I found the solution myself but i don't know the reason.
OnceRi read on this forum to put in the event login onload:
if ($_REQUEST["a"]=="logout"){

exit;

}else{

header("Location: something_list.php");

exit();

}
So this works fine with v4.1 but not with v4.2
Anyone an idea why?
Jafieb

Looks very good. Nice.
However, making a lookup on a edit or add page gives an error.
Looking in the ...._edit.php file (at the end) I found some code like:
@data["fieldname"] = ;
removing this it works fine again.
After this error I made a new project with the Knowledge Base (here I message error = 3 code).

creating the php-files it gives the same error as above.
Is this a known error?
Jafieb

how do you enable the following feature?
Auto-update fields. Automatically insert a value into field every time record is updated (UpdateBy, UpdateTime, IP address of user etc)
Also there seem to be issues with greek characters. Is this a known bug?
thanks in advance

well, my trial has run out, I am a registered customer, how do I extend the trial?

well, my trial has run out, I am a registered customer, how do I extend the trial?

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=25127&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' /> simple, you download and install the current beta build 334 and BINGO, you are getting another 21 days ...

Wow... after reading this thread and using the trial version for the last 5 days... I just went online and purchased my copy.
This looks really exciting!!

Is there a new build 334 ?????
According to the top of this topic, the last update was Jan 3rd when build 332 was released. Has there been anything since that.
I would like to start using 4.2 because it has some facilities that I badly beed, but the the errors in build 332 are such, that I hve chosen to wait, and I cannot see on this thread that they have been fixed.
:-)

Morten

Morten,
you may want to take a look at meanwhile 4.2 beta build 340 ???..., easy going by simply clicking the following link to download for onward installation and 21 days beta testing:
http://www.asprunner.com/files/phprunner42b-setup.zip
HTH Hajo

Looks very good. Nice.

doing some tests I saw:

1. checking out "apply on the Edit page as wel" has effect on the error
   
2. checking out "lookup wizard as EditBox with ajax popup" has effect on the error and creates an other one
   Maybe this will help solving the problem

1. checking out "apply on the Edit page as wel" has effect on the error
   
2. checking out "lookup wizard as EditBox with ajax popup" has effect on the error and creates an other one
   Maybe this will help solving the problem
   

I have seen the same problem on a new database created with 4.2 build 340

This gave an error like PHP Parse error: syntax error, unexpected ';' in _Klant_edit.php on line 546

Looking in the code this line held the following

where $data["Geslacht"] = ; was line 546. I also had the "apply on the Edit page as well" checked.

Morten,

Phprunner 4.2 Beta 340.....Looks great, great new features.
I've run into a problem with the visual editor when the page has a Master Detail relation link. If I make any changes to the list page with the visual Editor, then build the page the links to the related detail page doesn't work. Usually the hover will pop up the related detail, but clicking on the link does nothing. Have tried may things.
The problem also appeared when I simply changed the alignment of the search box to left align using the html editor. The search box showed up where I expected, but the Master/Detail links didn't work.
Thanks

Patrick

Patrick,
please publish your project on Demo Account (last tab in PHPRunner) and send a URL where I can see and troubleshoot the problem to support@xlinesoft.com.

Sorting is not working on a project created in version 4.1 that contains sorting info.
I have a project created in 4.1 that contains multiple tables. I opened it in 4.2 beta and re-configured the Sort Type on the Edit SQL Query page. But after Build, I got errors like:
Error type 256

Error descriptionYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `Field1` ASC, `Field2` ASC, `Field3` ASC limit 0,15' at line 1

URL localhost/project01/Tablename_list.php?

Error file ......\output\include\dbconnection.php

Error line 26
To solve the problem, I have to remove all sorting info from within version 4.1 and rebuild it in version 4.2.
Does anybody else have the same experience?

curious about when in January 2008 will the new version be available?

Okay how about Feb 2008? I have some new projects to start on and I like to have an idea if I should go ahead and use the 4.2 for it. How long are you all thinking before the new version is released? Is the beta 340 the latest revision out?
Oh and one more silly question. Are all the features in 4.2 beta the last of the features being added for this version?
Kim

Sorting is not working on a project created in version 4.1 that contains sorting info.

When I use search function on a list page I get this error. It happens whenever I use any sort for that page in Edit SQL Query. If I remove the sort everything is fine. I built this on 4.2 build 340. Adding the sort back in creates the problem again.
Technical information

Error type 256
Error description You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 1 LIMIT 10' at line 1
URL localhost/Project5/Get_Ready_searchsuggest.php?searchFor=x1&searchField=&rndVal=1202053428671&start=0
Error file C:\xampp\htdocs\Project5\include\dbconnection.php
Error line 26
SQL query SELECT DISTINCT Order1 FROM newinitial WHERE (`Is it shipped` =0 AND `Get-ready issued` !=0000-00-00 ) and ( Order1 like '%x1%')ORDER BY `Target delivery` ORDER BY 1 LIMIT 10

Patrick

I've run into a problem with the visual editor when the page has a Master Detail relation link. If I make any changes to the list page with the visual Editor, then build the page the links to the related detail page doesn't work. Usually the hover will pop up the related detail, but clicking on the link does nothing. Have tried may things.

This seems to be a bug in the system. I've had something similar and Jane supplied the cure. Hopefully it will be sorted in the next build.
Read this thread to solve the problem:
http://www.asprunner.com/forums/index.php?showtopic=7357

I can't find the feature to "Import data from CSV and Excel files". Is it me? I am using build 340. Thanks for any help. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=25539&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />

Any ideas when 4.2 will be released proper? I thought it was going to be January as was stated the price was going to rise?
Thanks,
Graham

Bug in Dynamic security settings
I have tested 4.2b for a while and I have been unable to get dynamic security to work until yesterday when I found the "workaround". I understood that others get it to work so I suspected that it was something I did or something special about my tables. Indeed it was.
In all my databases I use e-mail as login name. It works perfectly, never had any problem and people do not have to remember yet another stupid login name. And your e-mail you don't forget.
Sstup of dynamic permissions went ok, and it allowed me to select an administrator. And dhe admin user could log in to the database and work as usual. But the admin could not change any security settings. Admin area worked ok, but when i changed something and clicked "save" the table just went back to original, no changes recorded and no error messages.
I then tried to make login names without "@" in any of the names, and voila, everything works.
I would however, still like to use e.mail as login name. Is that something which can be fixed?
Best regards

Morten Jepsen

can I suggest this change in the new version, cause now i'm doing it by modifying the code internally. Here's a picture of what i'd like to suggest:

the thing is to have the master-client detail popup in the table value insted of creating a new column with the table name repeatedly fopr every value.
thanks a lo t for this excellent software.

Bug in show as image

PHPR 4.1 b340
I have an application storing links to photos on the server.
Display on new page or in ibox works perfectly. However, display on new page or in ibox does not work on _view page unless one of the photos are displayed in the _list page.
Once there is no image in the _list, the images on the _view just opens as normal jpg image in same window and ibox does not work. Rather invonvenient as i do not want the images on the _list, only in the _view.
Best regards

Morten B Jepsen

Hi,
I'm using PHPRunner 4.2 beta 2 build 347
I am running XP SP2 and I have created a new project and connected to a mysql 4.1.16 database. I have selected a table and then gone into query designer. When I try to add another table I get the error:
PHPRunner has encountered a problem and needs to close....Please tell Microsoft about this problem....
I'm not sure if the rest is useful:

<?xml version="1.0" encoding="UTF-16"?>

<DATABASE>

<EXE NAME="PHPRunner.exe" FILTER="GRABMI_FILTER_PRIVACY">

<MATCHING_FILE NAME="cacl.exe" SIZE="126976" CHECKSUM="0x4C6F05AE" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="05/03/2004 19:38:25" UPTO_LINK_DATE="05/03/2004 19:38:25" />

<MATCHING_FILE NAME="checkadsi.exe" SIZE="28672" CHECKSUM="0x83D4CAA3" BIN_FILE_VERSION="1.0.0.1" BIN_PRODUCT_VERSION="1.0.0.1" PRODUCT_VERSION="1, 0, 0, 1" FILE_DESCRIPTION="CheckASDI MFC Application" COMPANY_NAME="" PRODUCT_NAME="CheckASDI Application" FILE_VERSION="1, 0, 0, 1" ORIGINAL_FILENAME="CheckASDI.EXE" INTERNAL_NAME="CheckASDI" LEGAL_COPYRIGHT="Copyright © 2003" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="1.0.0.1" UPTO_BIN_PRODUCT_VERSION="1.0.0.1" LINK_DATE="02/19/2003 04:00:54" UPTO_LINK_DATE="02/19/2003 04:00:54" VER_LANGUAGE="English (United States) [0x409]" />

<MATCHING_FILE NAME="eectrl.dll" SIZE="106496" CHECKSUM="0x3B49F8C9" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1CDEF" LINKER_VERSION="0x0" LINK_DATE="12/26/2007 05:56:02" UPTO_LINK_DATE="12/26/2007 05:56:02" />

<MATCHING_FILE NAME="libmySQL.dll" SIZE="1069056" CHECKSUM="0x161BE11B" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x60000" LINK_DATE="02/14/2005 12:54:58" UPTO_LINK_DATE="02/14/2005 12:54:58" />

<MATCHING_FILE NAME="libpq.dll" SIZE="90112" CHECKSUM="0x86E6433E" BIN_FILE_VERSION="7.4.1.0" BIN_PRODUCT_VERSION="7.4.1.0" PRODUCT_VERSION="7, 4, 1, 0" FILE_DESCRIPTION="PostgreSQL Access Library" COMPANY_NAME="" PRODUCT_NAME="PostgreSQL" FILE_VERSION="7, 4, 1, 0" ORIGINAL_FILENAME="libpq.dll" INTERNAL_NAME="libpq" LEGAL_COPYRIGHT="Copyright © 2003" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="7.4.1.0" UPTO_BIN_PRODUCT_VERSION="7.4.1.0" LINK_DATE="12/30/2003 15:49:16" UPTO_LINK_DATE="12/30/2003 15:49:16" VER_LANGUAGE="English (United States) [0x409]" />

<MATCHING_FILE NAME="PHPRunner.exe" SIZE="2744320" CHECKSUM="0x4892E8AF" BIN_FILE_VERSION="4.1.0.347" BIN_PRODUCT_VERSION="4.1.0.347" PRODUCT_VERSION="4, 1, 0, 347" FILE_DESCRIPTION="PHPRunner" COMPANY_NAME="Universal Data Solutions, Inc." PRODUCT_NAME="Universal Data Solutions PHPRunner" FILE_VERSION="4, 1, 0, 347" ORIGINAL_FILENAME="PHPRunner.exe" INTERNAL_NAME="PHPRunner" LEGAL_COPYRIGHT="Copyright c 2004-2007" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x2A6474" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="4.1.0.347" UPTO_BIN_PRODUCT_VERSION="4.1.0.347" LINK_DATE="02/14/2008 17:59:43" UPTO_LINK_DATE="02/14/2008 17:59:43" VER_LANGUAGE="English (United States) [0x409]" />

<MATCHING_FILE NAME="SciLexer.dll" SIZE="329728" CHECKSUM="0xFA438799" BIN_FILE_VERSION="1.6.8.0" BIN_PRODUCT_VERSION="1.6.8.0" PRODUCT_VERSION="1.68" FILE_DESCRIPTION="Scintilla.DLL - a Source Editing Component" COMPANY_NAME="Neil Hodgson neilh@scintilla.org" PRODUCT_NAME="Scintilla" FILE_VERSION="1.68" ORIGINAL_FILENAME="Scintilla.DLL" INTERNAL_NAME="Scintilla" LEGAL_COPYRIGHT="Copyright 1998-2006 by Neil Hodgson" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="1.6.8.0" UPTO_BIN_PRODUCT_VERSION="1.6.8.0" LINK_DATE="01/06/2007 05:05:20" UPTO_LINK_DATE="01/06/2007 05:05:20" VER_LANGUAGE="English (United States) [0x409]" />

<MATCHING_FILE NAME="unins000.exe" SIZE="685402" CHECKSUM="0x50387C18" BIN_FILE_VERSION="51.45.0.0" BIN_PRODUCT_VERSION="51.45.0.0" PRODUCT_VERSION="0.0.0.0" FILE_DESCRIPTION="Setup/Uninstall" COMPANY_NAME="" PRODUCT_NAME="Inno Setup" FILE_VERSION="51.45.0.0" ORIGINAL_FILENAME="" INTERNAL_NAME="" LEGAL_COPYRIGHT="Copyright © 1997-2007 Jordan Russell. Portions Copyright © 2000-2007 Martijn Laan." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="51.45.0.0" UPTO_BIN_PRODUCT_VERSION="51.45.0.0" LINK_DATE="06/19/1992 22:22:17" UPTO_LINK_DATE="06/19/1992 22:22:17" VER_LANGUAGE="English (United States) [0x409]" />

</EXE>

<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">

<MATCHING_FILE NAME="kernel32.dll" SIZE="984576" CHECKSUM="0xF0B331F6" BIN_FILE_VERSION="5.1.2600.3119" BIN_PRODUCT_VERSION="5.1.2600.3119" PRODUCT_VERSION="5.1.2600.3119" FILE_DESCRIPTION="Windows NT BASE API Client DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft® Windows® Operating System" FILE_VERSION="5.1.2600.3119 (xpsp_sp2_gdr.070416-1301)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="© Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xF9293" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.3119" UPTO_BIN_PRODUCT_VERSION="5.1.2600.3119" LINK_DATE="04/16/2007 15:52:53" UPTO_LINK_DATE="04/16/2007 15:52:53" VER_LANGUAGE="English (United States) [0x409]" />

</EXE>

</DATABASE>
Regards
Gordon

Gordon,
could you send me your project, database dump and instruction on reproducing this?

Hi,

Same problem with MySQL 5.0.37 on my engine!
Rgds

Uwe Loyal

Hi,
I get a message about and unexpected $end in ..\include\commonfunctions.php. It would appear the the file is not generated properly by 4.2 build 347 under certain conditions. I believe it has something to do with security settings (i.e. having PHPRunner create a login page). A message appears when pressing the build button - the message reads:
C:\Program Files\PHPRunner4.2\source\include\commonfunctions.php(121) - Couldn't find element StrTableName
I see from another post that this problem was supposed to have been sorted in a previous release.
Here are the last few lines of commonfunctions.php - maybe that will give you some clue as to where the problem is....
function ShowThumbnail($field,$table="")

{

return GetFieldData($table,$field,"ShowThumbnail",false);

}
function GetImageWidth($field,$table="")

{

return GetFieldData($table,$field,"ImageWidth",0);

}
function GetImageHeight($field,$table="")

{

return GetFieldData($table,$field,"ImageHeight",0);

}
// return Lookup Wizard Where expression

function GetLWWhere($field,$table="")

{

global $strTableName;

if(!$table)

$table = $strTableName;

if($table=="
The last line is not a mistake in copying the information from my computer - it really does stop like that.
Thanks.
Darren

Hi,

Hello,
I encountered exactly the same problem with the same build as Darren Phipson.

I've tried to generate my project with PHP Runner 4.1 and there were no issue.

But, as it seemed to be wrong with the "where" clauses, I checked everywhere such a clause was present but I obtained no results.
Best regards.
NB : PHP runner 4.2.337, MySql 5.0.45, Win XP pro SP 2

In the current 4.2 beta, how do you use the add record in a popup functionality? I don't see anywhere to enable that functionality.
Thanks,

David

Gordon,

Tryed it with many databases, also created by phprunner.

Every time the same bug!

I don't think, that the upper info's will help you.

On my test's, it was not possible to end the programm, because it stops with crash on sql querryeditor.
Rgds

Uwe Loyal

Hi,
PHPRunner 4.2 beta2 (347)
Just a few questions on Dynamic Security:

• The generated _ugrights and _ugmembers tables have no primary key in mysql. Should they not have autoincrement primary key?
  
• If a User is assigned to more than one group, what security rights do they get?
  
• Can you add access to the Events for the new permissions pages?
  
• I would like to be able to change 'manage group members' page and add extra information about the user (Name/Job Title/Dept/Location etc) and also change 'manage group rights' page and add extra information about the page (Page Type - Admin/Enquiry/Lookup/Report etc). Ideally I would like to be able to change the SQL easily to add in these extra fields. Is this possible?
  Regards,
  Gordon

Hi, mrcaseyman,

I can't find the feature to "Import data from CSV and Excel files". Is it me? I am using build 340. Thanks for any help. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=26072&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />

the import function is not available in all themes (e.g. layout and color scheme both set to "London" works, "Default" as layout does not).
And even if you find the import, you cannot export data to either of the two formats and then reimport the generated file immediately. At least not if you use a date format different from the US settings.
For more info, please check: http://www.asprunner.com/forums/index.php?showtopic=7250
My last frustrating attempts were with 4.2 beta (build 348) today - same errors as stated in the above mentioned topic.
Greetings,

Wilfried

Hi,
PHPRunner 4.2 beta2 (348)
Thanks for fixing the bug that was crashing PHPRunner in Query Designer. I have now had a chance to have a play and have found some more issues with the Query Designer and MySQL 4.1.16

1. Group By. Select a Table and press the Group By Button. For each field, change the Group By Column to Blank. Go back to the same field and try and change the Blank Group By to anything and the PC hangs with PHPRunner trying to use 100% CPU.
   
2. Can Comments be retained. If you create a comment in SQL, then go to Query Designer and back to SQL, the Comment has been deleted
   
3. Joins. Can the Graphics be changed to indicate what sort of join is involved (i.e. 1 to many) and also which fields are being linked (like MS Access)
   
4. The default view in Query Designer is to lay all tables in one row with a grey line linking them together. However it is not immediately obvious which tables are linked to which without moving the tables around. The tables can be moved around, but the new layout is not saved. So can you either make it clearer which tables are linked to which, or allow the layout to be saved, or even better both! Also would be nice to have a zoom and show/hide fields.
   
5. Can the Query Designer be changed to allow for variables to be included in SQL Statements? The variables could then be given a value in the appropriate PHPRunner event
   
6. Will there be any support for UNION or LIMIT?
   
7. Can a Table be given an Alias in Query Designer? Also the longest table name that can be shown in the Table Box on my PC is 22 characters.
   
8. The popup box to add a table should have a title. What is the system tab on the popup box?
   
9. In Query Designer, in the top half of the screen, if I go into a table where there are more fields than will fit into the table box, if I click on the scroll bar to scroll down (not move scroll pointer with mouse, or click to scroll up), then extra separation lines appear over each field in the box (maybe this is just my graphics card!)
   
10. Query Designer does not recognise brackets on joins. Example: This query is recognised:
    SELECT
    
    questions.question,
    
    category.cc_desc
    
    FROM questions
    
    INNER JOIN category ON questions.qu_cat = category.cc_id
    This query is not recognised and get error message:
    
    PHPRunner was unable to parse your SQL query. Designer tab is not available
    SELECT
    
    questions.question,
    
    category.cc_desc
    
    FROM questions
    
    INNER JOIN category ON (questions.qu_cat = category.cc_id)
    
11. Join Problems, when there are more complex joins between different tables. The following query is accepted by the Query Designer and runs in Results. The Query Designer shows all the links:
    SELECT
    
    questions.qu_ref,
    
    questions.question,
    
    questions.qu_report_order
    
    FROM bu_survey_grade
    
    INNER JOIN questions ON bu_survey_grade.bg_sid = questions.sid
    
    INNER JOIN bu_survey_summary ON bu_survey_grade.bg_no = bu_survey_summary.ss_bg_no AND bu_survey_summary.ss_qid = questions.qid
    However when you go from the Query designer to SQL, the SQL Statement has been changed to:
    SELECT
    
    questions.qu_ref,
    
    questions.question,
    
    questions.qu_report_order
    
    FROM bu_survey_grade
    
    INNER JOIN questions ON bu_survey_grade.bg_sid = questions.sid
    
    INNER JOIN bu_survey_summary ON bu_survey_grade.bg_no = bu_survey_summary.ss_bg_no
    If you go back into Query Designer it allows you to add the missing join, but it disappears as soon as you go into SQL
    
12. BETWEEN in WHERE Statement - If there is a BETWEEN clause in the WHERE Statement, then the Query Designer does not show any of the WHERE conditions under Filters (All Filter, Or, Having Columns are now greyed out)
    SELECT
    
    sid,
    
    qu_ref,
    
    question
    
    FROM questions
    
    WHERE (sid between 11 AND 21) and qu_ref like '%CF%'
    Also similar effect if AND & OR is mixed
    SELECT
    
    qu_ref,
    
    question
    
    FROM questions
    
    WHERE ( qu_ref like '%CF%' and sid = 11) or ( qu_ref like '%RV%' and sid = 12)
    Thanks for your work on the new Beta
    Regards
    Gordon

Is the "group by" issue solved in the beta?

Ok, tested, the grouping issue is solved.

Hi,
Build 348 solved my problem.

Thanks a lot. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=26111&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

Have a nice day.

Ok, tested, the grouping issue is solved.

Sorry to bother, but which one grouping issue?

In my practice (build 348) several 'group by' problems are still in place (count, search, mysql editor)...

Sorry, the group by issue on search when it shows only a single result in the count and messes up the paging, there's another forum post asking about it.

Yes, this was my post. You mean it? I still experience this problem.

Top mixed menus not aligned
I have a project with user login page and menu page. I use either Paris or Madrid to have the horizontal navigation menu. The layout for Paris is working well as for the alignment of the Login menu with the Search-Print-Import menu. But the Madrid layout is not shown properly. The valign is not level for the two menus, even though in both cases, the valign=middle code is there. The Search-Print-Import menu is aligned to bottom or lower whenever the table is populated. Sorry that I could not attach my pictures. I am using PR 4.2, Build 348.

Top mixed menus not aligned

Have figured out why. The reason is that there are too many control boxes along the top bar. When it is crowded, the PR could not align them well. I solved this by trimming all the button display values, like Change password --> chg pwd, Export results--> Export...

I just tried Build 348 with my 4.1 project. It manages to build the project, but when I try to view my main list page, i get a PHP error -

Technical information

The red text above was the proper field/table names, but I don't want to post those details here.

What's weird, is I went to C:\Inetpub\wwwroot\i2o\include\dbconnection.mssql.win.php and added a var_dump of $qstring, and it shows this -

string(28) "SELECT FROM [] WHERE = '2'"

So, how is the error showing what looks like valid SQL, but the $qstring variable has no fields or table defined in it? It's obvious the actual query string is what $qstring is showing, which is why it's complaing about the incorrect syntax near 'FROM'. Where should I look to find the culprit here?

spintz,
you can post your application to "Demo Account" (last tab in PHPRunner) and send the URL to support@xlinesoft.com for investigation.

spintz,

Huh? What do you mean last tab in PHPRunner?
Anyways, I've found this bug also exists in 4.1. The bug is that the error output for SQL operations does not display the most recent executed SQL. I had some bad SQL in my After Edit event, and the SQL displayed was not that SQL, it was the SQL from the Update for the Edit.

I believe it did work (we are only testing this at present) but we then changed to a different set of queries that didn't need to group by in the end.

The first time I loaded my PR41 project into PR42. I clicked on any changed pages in the Visual Editor, and I got a popup box saying the following -

Unable to apply project changes to the following page(s).

It lists NO pages, and the really confusing part, is the Yes/No buttons, even though no question is asked. If I click Yes, it automatically resets the page I was trying to view. No, leaves me to do it. Just a little confusing, should point out what it's going to do when you click Yes, or simply be an Ok button prompting you to reset the page yourself.
Also, it should list the file(s) in the popup box as well.

Hello,
are you planing more chart types? If they are from anycharts, may it be a possibility to buy them for a fee?

Vitas,
we plan to use AnyChart 4 in the next version of PHPRunner/ASPRunnerPro.

No firm date yet.