Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ MUSHclient ➜ General ➜ MySQL access through PHP scripting (ODBC)

MySQL access through PHP scripting (ODBC)

It is now over 60 days since the last post. This thread is closed.     Refresh page


Pages: 1  2 

Posted by Nick Gammon   Australia  (23,133 posts)  Bio   Forum Administrator
Date Reply #15 on Sun 11 Dec 2005 12:23 PM (UTC)
Message
My first reaction is to declare your global variables at global scope. That is, at the start of the script have:

global $reporting;
global $channel;
global $ti;
global $items;


As for the alias, it worked for me. Did it fire? Did you have "regular expression" checked?

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by RashinLord   Canada  (29 posts)  Bio
Date Reply #16 on Sun 11 Dec 2005 02:09 PM (UTC)
Message
Yeah, I got all that working. :)

When does mush send this error?

"Maximum execution time of 60 seconds exceeded"

Before I got it when there was an error and mush hadn't finished processing the script in 60 seconds. Now I'm not getting any errors, only the message 60 seconds after I load the script. My in-script notifications on what it's doing shows up all the way to then end. (i.e. "Script Loaded.").

Any Ideas?
Top

Posted by Nick Gammon   Australia  (23,133 posts)  Bio   Forum Administrator
Date Reply #17 on Sun 11 Dec 2005 07:55 PM (UTC)
Message
Lol. It seems that the interpreter must be counting cumulative time. Google on the error message, there are quite a few hits.

Either increase the limit in php.ini (which only defers the problem) or find a way to make it reset the counter each time you enter a script.

Time to switch to Lua, I think. :)

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Yergo   Poland  (20 posts)  Bio
Date Reply #18 on Tue 26 Dec 2006 04:45 PM (UTC)
Message
ok. i installed php as CGI etc. Edited php_activescript.ini (in mush directory) with this:
---------
; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:\php.5.1.1\ext"

;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for it.
;
extension=php_mysql.dll
---------
And it seems to do "something". There occurs an error at session startup: "PHP Startup: Unable to load dynamic library 'C:\php.5.1.1\ext\php_mysql.dll' - procedure not found"

Maybe this is some clue for Nick ;) I have no other ideas...

I'm doing my best with English... Sorry ;)
Scripting: php (currently rewriting things to Lua)
Top

Posted by Nick Gammon   Australia  (23,133 posts)  Bio   Forum Administrator
Date Reply #19 on Tue 26 Dec 2006 06:04 PM (UTC)
Message
"Procedure not found" can mean either the entry point you are looking for is not there, or there is a missing dependency (on another DLL). If you have a dependency-checker, you can see what other DLLs that one needs.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Yergo   Poland  (20 posts)  Bio
Date Reply #20 on Wed 27 Dec 2006 09:24 AM (UTC)
Message
I checked php_mysql.dll with Dependency Walker. It requires apphelp.dll, so I'd downloaded it and put into windows/system directory. But when checking dll again, there are some errors like "Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module". I don't understan it... Mushclient is still going with previous errors ("procudure not found"). I don't know how to repair it. Any ideas?

I'm doing my best with English... Sorry ;)
Scripting: php (currently rewriting things to Lua)
Top

Posted by Nick Gammon   Australia  (23,133 posts)  Bio   Forum Administrator
Date Reply #21 on Wed 27 Dec 2006 07:17 PM (UTC)
Message
The standard Windows DLL loader gives that error message ("The specified procedure could not be found."), I think, if there is any problem loading the DLL, except finding the DLL itself, in which case the message is "The specified module could not be found.".

Thus, until you get rid of any errors that the dependency checker reports, I don't think it will work.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Nick Gammon   Australia  (23,133 posts)  Bio   Forum Administrator
Date Reply #22 on Wed 27 Dec 2006 07:18 PM (UTC)
Message
You may want to go to the PHP site, this is really a PHP problem, perhaps there is a forum posting there that clears the issue up.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.


68,529 views.

This is page 2, subject is 2 pages long:  [Previous page]  1  2 

It is now over 60 days since the last post. This thread is closed.     Refresh page

Go to topic:           Search the forum


[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.