independent and unofficial
Prince fan community
Welcome! Sign up or enter username and password to remember me
Forum jump
Forums > prince.org site discussion > errors: maybe you need some MySQL tuning?
« Previous topic  Next topic »
  New topic   Printable     (Log in to 'subscribe' to this topic)
Author

Tweet     Share

Message
Thread started 01/25/13 6:50am

udo

avatar

errors: maybe you need some MySQL tuning?

ERROR in DB::fetchArray() on
Query failed: SELECT SQL_CACHE * FROM users2 u LEFT JOIN user_levels l ON u.level=l.level_id WHERE userid=156, sth=0

ERROR in DB::fetchArray() on
Query failed: SELECT SQL_CACHE * FROM user_prefs WHERE userid=156, sth=0

ERROR in DB::fetchArray() on
Query failed: SELECT SQL_CACHE * FROM msg_forums WHERE forumid=7, sth=0

Pills and thrills and daffodils will kill... If you don't believe me or don't get it, I don't have time to try to convince you, sorry.
  - E-mail - orgNote - Report post to moderator
Reply #1 posted 01/29/13 10:48am

dualboot

avatar

Yep user 156, I saw that too. confused

[Edited 1/29/13 10:49am]

  - E-mail - orgNote - Report post to moderator
Reply #2 posted 01/30/13 10:27am

udo

avatar

See tuning-primer.sh for tuning MySQL.

I can help, but you won't let me. biggrin

Pills and thrills and daffodils will kill... If you don't believe me or don't get it, I don't have time to try to convince you, sorry.
  - E-mail - orgNote - Report post to moderator
Reply #3 posted 01/31/13 7:46am

RodeoSchro

Tha dang user 156 causes trouble everywhere they go.

  - E-mail - orgNote - Report post to moderator
Reply #4 posted 01/31/13 7:50am

udo

avatar

No, the MySQL admin causes trouble for user 156, which could be my id. \o/

Pills and thrills and daffodils will kill... If you don't believe me or don't get it, I don't have time to try to convince you, sorry.
  - E-mail - orgNote - Report post to moderator
Reply #5 posted 01/31/13 9:30am

RodeoSchro

^In that case, my statement is more true than ever. razz

  - E-mail - orgNote - Report post to moderator
  New topic   Printable     (Log in to 'subscribe' to this topic)
« Previous topic  Next topic »
Forums > prince.org site discussion > errors: maybe you need some MySQL tuning?