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 ➜ SMAUG ➜ SMAUG coding ➜ Smaug and MySQL

Smaug and MySQL

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


Pages: 1  2 

Posted by Gohan_TheDragonball   USA  (183 posts)  Bio
Date Reply #15 on Tue 07 Mar 2006 04:04 AM (UTC)
Message
WhiteKnight had it right from the start, i switched over to global definitions and an open_db_connect() at startup and now it works just fine, i can connect and query the database. wierd huh, don't know why that would be any different but learn something every day.
Top

Posted by David Haley   USA  (3,881 posts)  Bio
Date Reply #16 on Tue 07 Mar 2006 04:56 AM (UTC)
Message
Maybe you weren't closing it correctly, so it worked the first time you updated the database but any subsequent call failed because the first one was still around. That's usually a danger with opening it every time.

(besides, you don't really need to, and in fact it's arguably much more efficient to open it only once, as Whiteknight suggested)

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org
Top

Posted by Gohan_TheDragonball   USA  (183 posts)  Bio
Date Reply #17 on Sat 25 Mar 2006 07:56 AM (UTC)
Message
actually no, it was not working at any time until i switched it to a global definition. its strange i know, but since i switched it i have had no problems at all.
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.


60,277 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.