[Home] [Downloads] [Search] [Help/forum]

Gammon Software Solutions forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

[Folder]  Entire forum
-> [Folder]  SMAUG
. -> [Folder]  SMAUG coding
. . -> [Subject]  Smaug and MySQL
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?
Smaug and MySQL

[Reply to this subject]  Reply to this subject   [New subject]  Start a new subject   [Refresh] Refresh page

Pages: 1  2 

Posted by Gohan_TheDragonball   USA  (183 posts)  [Biography] bio
Date Reply #15 on Tue 07 Mar 2006 04:04 AM (UTC)  [ quote  ]
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.
[Go to top] top
Posted by David Haley   USA  (3,881 posts)  [Biography] bio   Moderator
Date Reply #16 on Tue 07 Mar 2006 04:56 AM (UTC)  [ quote  ]
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
[Go to top] top
Posted by Gohan_TheDragonball   USA  (183 posts)  [Biography] bio
Date Reply #17 on Sat 25 Mar 2006 07:56 AM (UTC)  [ quote  ]
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.
[Go to top] 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.

5,340 views.

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

[Reply to this subject]  Reply to this subject   [New subject]  Start a new subject   [Refresh] Refresh page

Go to topic:           Search the forum

[Go to top] top

[Home]

Written by Nick Gammon - 5K

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( http://www.gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Internet Contents Rating Association (ICRA) - 2K]    [Web site powered by FutureQuest.Net]