Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 MySQL client run out of memory
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  14:25:19  Show Profile  Visit spyderuk's Homepage
Got this error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-standard]MySQL client run out of memory

/forum/inc_func_common.asp, line 1342
Forum recently converted from Access to MySQL by Rui and was running sweet.
Had a search here in Mysql forums but nothing turned up.

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 03 January 2007 :  14:55:50  Show Profile  Visit HuwR's Homepage
sounds like a server issue to me
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  15:05:38  Show Profile  Visit spyderuk's Homepage
Not going onto hosting discussion, but when I saw this one I thought the package and price was quite reasonable. I was looking for the catch!

Not got any doubts about Rui's work but just hoping it ain't my forum that has done this

I remember on the old host installing one of the other members who are active mods, it took about 2 minutes for a page to load only to show around 150 of the same user online Oh it's all fun.

Sorry for the little off topic ramble.

EDIT.. I have tried to access MySQL through PHPMyAdmin and can connect and view fine. Would this still indicate a server issue?

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum

Edited by - spyderuk on 03 January 2007 15:43:28
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 03 January 2007 :  15:55:16  Show Profile  Visit HuwR's Homepage
quote:
EDIT.. I have tried to access MySQL through PHPMyAdmin and can connect and view fine. Would this still indicate a server issue?

Yes, PHPMyAdmin will be using a different method of connecting to MySQL than your forum is, it is more than likely a driver issue, and judging from the number of results google returns, it is quite a common mysql problem.

I don't have access to my snitz files currently, so if you could tell me what function line 1342 relates to, it may help shed some light.
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  16:10:59  Show Profile  Visit spyderuk's Homepage
Er, working from laptop and have no editor with line numbering. Here is link to txt file if that helps at all.

As mentioned the forum has been running fine for over 24 hrs after conversion and no script files have been modded since.

EDIT.. Also if I refresh the error messages alternate with this as the other error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-standard]Lost connection to MySQL server during query

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum

Edited by - spyderuk on 03 January 2007 16:26:07
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 03 January 2007 :  18:09:14  Show Profile  Visit HuwR's Homepage
some questions, what page are you trying to access when you get this error ?

does the same error occur for any page, active.asp topic.asp etc
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  18:26:05  Show Profile  Visit spyderuk's Homepage
Just the deafault.asp. Not tried any other pages.

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  18:36:16  Show Profile  Visit spyderuk's Homepage
Yup, must be server as it's all working again now.

Sorry, Lock it up

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 03 January 2007 :  18:38:35  Show Profile  Send ruirib a Yahoo! Message
This is a server error. Your MySQL server is a Lunix machine, so this may be related to the number of file handles or similar. You will need to talk to your host about it.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  19:18:19  Show Profile  Visit spyderuk's Homepage
Talking to my host about stuff seems hit n miss. It's all these support tickets to raise an issue then 9 times outa 10 they send you a reply with a link and say check this. The link rarely produces the answers you are looking for. I still have not discovered the email server address to put in email settings so would only confuse them with this.

I hope this situation is not going to be a regular occurance with this host.

Just got email from my current host I plan to leave onl 3 days to go, what a dilema

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 03 January 2007 :  19:19:46  Show Profile  Send ruirib a Yahoo! Message
Didn't you say you had 3 free months on the new host? You can always find an alternative if that does not work...


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 03 January 2007 :  19:55:44  Show Profile  Visit spyderuk's Homepage
Yes, only time will tell.

I guess I picked the wrong week to quit smoking.

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.45 seconds. Powered By: Snitz Forums 2000 Version 3.4.07