Thread Closed 
MySQL errors
Author Message
michaelp
s0ny d0minator

Posts: 1,009.4190
Threads: 100
Joined: 19th Jan 2007
Reputation: -1.92737
E-Pigs: 12.5158
Offline
Post: #31
RE: MySQL errors
I've gotten both of the errors shown I think.
The character one, and the one about a new thread thing.

[Image: michaelp3.png]
26/09/2007 03:20 PM
Visit this user's website Find all posts by this user
usif
Im just usif

Posts: 274.4127
Threads: 17
Joined: 20th Apr 2007
Reputation: 2.04707
E-Pigs: 1.1680
Offline
Post: #32
RE: MySQL errors
i got the latin error and this one aswell

Code:
MySQL error: 1135
Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
Query:


[Image: shoppingcopy.png]
26/09/2007 03:40 PM
Find all posts by this user
Anger
Angered Observer (0).(0)

Posts: 605.8490
Threads: 4
Joined: 14th Apr 2007
Reputation: 1.65651
E-Pigs: 5.4993
Offline
Post: #33
RE: MySQL errors
MySQL error: 2019
Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)
Query:

MySQL error: 1135
Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
Query:

consult this site for information about the 1135 error - i think it may be the main cause of the problem.
http://www.haqthegibson.com/article/34

Always remember - Google is your friend :)

[Image: avatar_416_482669e4.jpg]
(This post was last modified: 26/09/2007 04:07 PM by Anger.)
26/09/2007 04:00 PM
Find all posts by this user
ix_stylez
("')(O.o)('')

Posts: 758.5250
Threads: 23
Joined: 9th Apr 2007
Reputation: -7.62267
E-Pigs: 8.2221
Offline
Post: #34
RE: MySQL errors
Anger Wrote:consult this site for information about the 1135 error - i think it may be the main cause of the problem.
http://www.haqthegibson.com/article/34

worth a try..

[Image: IxStyleZ.jpg]
26/09/2007 07:43 PM
Visit this user's website Find all posts by this user
ZiNgA BuRgA
Smart Alternative

Posts: 17,023.4213
Threads: 1,174
Joined: 19th Jan 2007
Reputation: -1.71391
E-Pigs: 446.0333
Offline
Post: #35
RE: MySQL errors
Hmm, I'm having all sorts of weird memory issues here.  I'll need to try the suggestions when I get home.  Thanks guys :)
26/09/2007 07:57 PM
Visit this user's website Find all posts by this user
UncertainGod
Illogical mindfuckery

Posts: 1,492.4476
Threads: 88
Joined: 16th Aug 2007
Reputation: -8.70083
E-Pigs: 7.1412
Offline
Post: #36
RE: MySQL errors
MySQL 2002 today.

It means it can't connect to the MySQL.sock, it's much like the unable to initialise the latin1 charset problem.

ZiNgA, check you apache.conf and my.cnf to make sure all the PATH variables are set correctly, also that enough connections are allowed for the load on this server.
27/09/2007 03:09 AM
Find all posts by this user
ZiNgA BuRgA
Smart Alternative

Posts: 17,023.4213
Threads: 1,174
Joined: 19th Jan 2007
Reputation: -1.71391
E-Pigs: 446.0333
Offline
Post: #37
RE: MySQL errors
^ Looking at the time of post, that could've been when I was restarting the server.  Host just told me how to access VZPP - I didn't even know it existed O_o.  So now, if I get locked out of SSH, I can 'restore' it by rebooting the server at least :P

So that error only occurs when I reboot the server - no other time.


Anyways, I've changed some settings in my.cnf - let's see if it works better.
27/09/2007 03:31 AM
Visit this user's website Find all posts by this user
UncertainGod
Illogical mindfuckery

Posts: 1,492.4476
Threads: 88
Joined: 16th Aug 2007
Reputation: -8.70083
E-Pigs: 7.1412
Offline
Post: #38
RE: MySQL errors
* UncertainGod keeps appendages crossed.
27/09/2007 03:35 AM
Find all posts by this user
roberth
Resident Full Stop Abuser.....

Posts: 4,580.2098
Threads: 200
Joined: 18th Jun 2007
Reputation: -5.5814
E-Pigs: 43.8419
Offline
Post: #39
RE: MySQL errors
new error i think...i havent seen it posted, but i might have missed it

Code:
MySQL error: 5
Out of memory (Needed 1677304 bytes)
Query: SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup, u.nameformat FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1190890079' ORDER BY u.username ASC, s.time DESC 


27/09/2007 03:59 AM
Find all posts by this user
UncertainGod
Illogical mindfuckery

Posts: 1,492.4476
Threads: 88
Joined: 16th Aug 2007
Reputation: -8.70083
E-Pigs: 7.1412
Offline
Post: #40
RE: MySQL errors
^ just had that myself ^

Also this one trying to load this thread, but it's not a MySQL error this time;

Quote:Fatal error: Can only throw objects in /var/www/vhosts/endlessparadigm.com/forum/global.php(396) : eval()'d code on line 1
27/09/2007 04:02 AM
Find all posts by this user
Thread Closed 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

 Quick Theme: