Chaoselbows.com Life, like your elbow, is chaos

Interesting couple of days.

I found out that the site wend down again with the mysql 28 errors. This seems to be caused by the tmp table getting abused somehow. I really am not sure why.

The next thing that happens is a bunch of tables become corrupt. In the process of logging the inability to access the tables, the process that logs the tables reaches the max number of queries run per hour (this is 5 thousand). When this happens, I start getting recursive logging problems where this process tries to log that this (same process) can't log that (this same process) can't log some error. and so on. So this means that rapidly, I use up 50 thousand connections to the database.

Well, I can't control the tmp data, this is outside of my purview. But I can throttle the number of simultaneous connections and allow persistent connections, which reuse existing connections, as well as turn on some throttle control code. I also rewrote a module to automatically fix the corrupt tables if they occur again. Hopefully.

It seems that if I create a group with my lordly permissions, the book created for the group gets made by anonymous instead of by me. This makes it public, since the way the privleges get set is by your user privleges as well as the configuration, and mr anonymous has no privleges.

the way to fix this is to edit the book twice. The first time, edit it, add a body (its required) and change the authoring information to a valid user, typically yourself.

Save, and re-edit. This time you should be able to check off the right audience. Preview might work too but I haven't experimented with that yet.

When I went to fix the problem with the wordpress database being abused, I accidentally corrupted the cache table; Fortunately its an easy fix. REPAIR TABLE [tablename] works wonders

I added the poll you see to get your opinion. Should Chaoselbows show up on the "radar?" This would attract new users, give us a greater group for advertising to, increase our community, and make new friends. It also exposes us to other things.

I am leaning strongly towards exposure. First, one of the things I want to do is experiment with earning money here. Not to be rude or anything but there is only a finite amount of money to be found amongst our group of friends.

Also, the google ads would be much better targeted.

Comment at the poll.

warning: array_keys(): The first argument should be an array in /home/chaoselb/public_html/modules/user.module on line 348. warning: implode(): Bad arguments. in /home/chaoselb/public_html/modules/user.module on line 348. user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(p.perm) FROM chaos_role r INNER JOIN chaos_permission p ON p.rid = r.rid WHERE r.rid IN () in /home/chaoselb/public_html/includes/database.mysql.inc on line 120. If you see something like this, it is a "known issue" and I am trying to resolve it. There is some kind bug in SQL I think.

So, now you're here, how do you ask for help?

Well, the best thing to do is add it to my task list. All you need to do is, under create content, click on task, and then type in a title and your question. Assign it to Zeus or CraigW (as we go forward I will be using CraigW more and more, as Zeus is special.)

Submit it to me, and I will add it to The Chaos.The Elbows. book and cause it to be more developed. Then, when you need help, you have one place to go.

1. How do I post some content public but keep most private?
2. how do I manage the forums better?
3. What is the best site navigation options?