SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area
FROM ipb_core_tags t WHERE 1=1
AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM ipb_core_tags_perms p WHERE
( ( FIND_IN_SET(3,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text
ORDER BY times DESC
LIMIT 0, 50
How do I stop this from happening in the future? It caused the load to skyrocket. I could, of course, increase tmp_table_size, but I'd like to know if there's something about optimizing IPB that I should be aware of. Am I missing some indexes?
It comes straight from the testing forum: http://community.invisionpower.com/topic/377972--/#entry2368179
This is bad. Have you considered blockquote and cite elements to differentiate quotes from the rest of the post?
They wouldn't. It's their choice. If you care about spamming users with notifications then leave verification enabled.
As the OP mentioned, there are websites with focus on privacy or simplicity, where the e-mail field becomes a burden. Especially if a user wants to create multiple accounts on a single website. Some boards allow this due to privacy concerns - you don't have to, but don't force your idea of a website on others.
All the services you mentioned feed off users giving them more or less personal data so they can sell targeted advertisements. Not really the best examples for privacy-concerned people.
No functionality has to be lost as nobody forces website owners to disable the requirement. Should they do that, accounts created without the address could, as a workaround, be created with an email in the form of <uuid>@example.com. Voila, simple as that.
But it IS a workaround - it doesn't have to be used if the services you mentioned were properly redesigned with the possibility of an e-mail lacking user in mind.
An e-mail adress is not reliable anymore because of services providing temporary email addresses, such as mailinator.com. Therefore, I have disabled email verification altogether and rely on IPS Spam Service to stop spambots. It works very well.
Please have a look at http://reddit.com - their email field is optional and the whole registration form fits right next to the login form. It is so much more appealing to create an account there than it is on IPB forums.
That would require a bit of coding :)
Take a look at http://en.wikipedia.org/wiki/List_of_HTTP_header_fields -> Last-modified . The IPS Suite would need to print this header appropriately, depending on the page being rendered.
Hello guys. There's something wrong with the double enter functionally. It won't split the quote for me most of the time (Chrome 23).
To split the comment, I have to:
Press up arrow to come back to the previous line
Press enter again
Then it works, mostly. Sometimes it won't even create a new line when I press enter though.
I would love the new editor if it wasn't for those constant bugs appearing from time to time, proving it unreliable. Catch up with them and it will be perfect. :smile: That is if one can catch up with RTE incompatibilities across different browsers. :)
The browser assumes it's fine to cache the entire webpage and doesn't pull the data from the webserver, but from its own cache instead.
I guess it could be fixed by adding the time of the last post/update of a topic in headers.