English > Scripts and Templates

PHP Script Development

<< < (4/4)

mgpw4me@yahoo.com:
Pining for the fjords?

I have this magic pillow I put my head on and it drains all the clutter.  I did that last night and when I awoke...rick.ca was still not working.  This makes sense since he's the tester and not necessarily the 'follow it to the letter' guy.  'nuf on that.

Fix #...30 or 40?  

No messages = wrong php installation
script exits immediately = path to database wrong or interbase not installed

Time to check your install, Rick.ca.  Go into the control panel -> programs and features.  Find PHP and right-click your mouse on it...in the menu that appears, select CHANGE.

First, change your install type from SCRIPTING to CLI.  This will fix the lack of messaging (the scripting install is for background processes that do not use messaging or open command windows).

Next, scroll down to the extensions section and enable interbase.

This was step #1 in my install instructions, but ("HELLO POLLY !!!") since I've done this several times I skimmed over it without much explanation, thinking it was obvious.  I've added an image to the install instructions to clarify this.

Now that the install is correct, the script will work (be sure not to CANCEL out of the install... :)).  NOTE:  gds32.dll will be overwritten, I think, so make sure to copy fbembed.dll from PVD into the PHP directory and rename it to gds32.dll.

If this doesn't work, post your php.ini for me.

rick.ca:

--- Quote ---First, change your install type from SCRIPTING to CLI.  This will fix the lack of messaging (the scripting install is for background processes that do not use messaging or open command windows).
--- End quote ---

I don't have this option—see screen shot. You're using an earlier version. It doesn't appear to make any difference anyway. Following is the result of php.exe -v...


--- Code: ---PHP 5.2.13 (cli) (built: Feb 24 2010 14:32:32)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
--- End code ---


--- Quote ---script exits immediately = path to database wrong or interbase not installed
--- End quote ---

Yes, it works better with interbase installed. I thought "install PHP with interbase" is what the referenced installation did, not an instruction to "install PHP without the server and with the option to include interbase." ::)

So now the database is accessed and the script runs...


--- Code: ---database connected
creating sql update statements
ready to run updates
30356 records to be updated...here we go
0 1 2 3...
--- End code ---

...and that's the number of people in my database. Unfortunately, only the names having no accented/special characters are written to Transname. :(

[attachment deleted by admin]

mgpw4me@yahoo.com:
I was getting tired and making changes to the script trying to get it working...all the while having no idea why it wasn't working.  So of course, I broke it in the process.

I've uploaded a new version with database checking and logic to update only records without a transname setting.  I'm going to use this thread for testing new scripts and set up a "clean" thread for working scripts.

rick.ca:

--- Quote ---I was getting tired and making changes to the script trying to get it working...all the while having no idea why it wasn't working.  So of course, I broke it in the process.
--- End quote ---

If I didn't know better, I'd think you were not having fun. I believe you meant to say...

"Yeah! You stunned him, just as he was wakin' up! Norwegian Blues stun easily, major."

Now it works. ;)

mgpw4me@yahoo.com:
Let's just say I can smile about it...now.

Navigation

[0] Message Index

[*] Previous page