Search found 155 matches

by Thanks in advance
Sun Sep 18, 2011 10:47 pm
Forum: [3.0.x] Support Forum
Topic: SQL ERROR [ mysql4 ] - Incorrect string value
Replies: 14
Views: 3174

Re: SQL ERROR [ mysql4 ] - Incorrect string value

Oyabun1 wrote:Did you get a message 'The MySQL Upgrader has been run successfully'?
Yes.

I deleted the board cache. The problem always occurs when I do this: I get the error message, but when I (or somebody else) reloads the main page, it goes away.
by Thanks in advance
Sun Sep 18, 2011 10:24 pm
Forum: [3.0.x] Support Forum
Topic: SQL ERROR [ mysql4 ] - Incorrect string value
Replies: 14
Views: 3174

Re: SQL ERROR [ mysql4 ] - Incorrect string value

I have the same problem "Incorrect string value..." whenever I cleared the board cache (after pressing F5 in my browser the forum / main page loads normally again). I used the MySQL Upgrader from the Support Tool Kit ("Run"), but after finishing the problem still exists. Are ther...
by Thanks in advance
Sun Sep 18, 2011 10:16 am
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

Thanks for your ongoing support. I downloaded phpBB 3.0.8 and copied the functions_admin.php in the /includes folder overwriting the existing file (which had the same size) and cleared the cache, didn't help.
by Thanks in advance
Sat Sep 17, 2011 6:05 am
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

It's the original code block from the functions_admin.php (3.0.8), it's not doubled. Deleting 7.000 users on a local install user did speed things up somewhat, but not a lot.
by Thanks in advance
Thu Sep 15, 2011 8:45 pm
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

I highly doubt it's a bug. The problem might be that I have ~8.000+ users which haven't been active since two years and this could slow down some ACP operations a lot (shared host). But as one of those is the "prune users" function I can't delete these useless accounts. I need the right SQ...
by Thanks in advance
Thu Sep 15, 2011 7:52 pm
Forum: [3.0.x] Support Forum
Topic: Bulk delete users with phpmyadmin
Replies: 2
Views: 906

Bulk delete users with phpmyadmin

I have thousands of users that haven't been active since at least two years and want to delete those. I can't use the "prune users" option in the ACP because it's very slow in my case and times out often, even if I just try to delete like 100 old accounts. Could someone please tell me the ...
by Thanks in advance
Thu Sep 15, 2011 12:42 pm
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

For sure - so first to do is to delete the inactive user accounts. Only problem is that deleting accounts which haven't been used since years via the ACP again takes a long time, even for like 100 inactive users and I have thousands of accounts that are not necessary anymore. Just "deactivatin...
by Thanks in advance
Wed Sep 14, 2011 9:15 pm
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

Thanks for your help, I have already checked / repaired & optimized the DB as first thing. On my board exist many old & inactive user accounts (~8.000). Might those be the problem?
by Thanks in advance
Wed Sep 14, 2011 9:06 pm
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

I checked, they all exist.
by Thanks in advance
Wed Sep 14, 2011 8:07 pm
Forum: [3.0.x] Support Forum
Topic: ACP / MCP operations are very slow
Replies: 24
Views: 1047

Re: ACP / MCP operations are very slow

I used database_update.php (again), just to be sure no indexes are missing.

5 million rows examined is a LOT, that's true. The lines can be found in the functions_admin.php btw.
by Thanks in advance
Mon Jun 27, 2011 9:09 am
Forum: [3.0.x] Support Forum
Topic: Adding noindex, follow to some pages.
Replies: 13
Views: 2359

Re: Adding noindex, follow to some pages.

I found a way to add those meta tags to phpBB-files. Could someone here (mayb with some SEO-experience) please tell me for which files "noindex, follow" is perfect and for which "noindex, nofollow"?
by Thanks in advance
Mon Jun 20, 2011 9:07 pm
Forum: [3.0.x] Support Forum
Topic: Adding noindex, follow to some pages.
Replies: 13
Views: 2359

Re: Adding noindex, follow to some pages.

Why on earth would I block Google from indexing my site? To get much less visitors and money through ads?
by Thanks in advance
Sun Jun 19, 2011 7:09 pm
Forum: [3.0.x] Support Forum
Topic: Adding noindex, follow to some pages.
Replies: 13
Views: 2359

Re: Adding noindex, follow to some pages.

BOTS don't know about php files, they crawl content displayed by html files. If you do not want bots to see, for example, the FAQ, use this switch in the template: <!-- IF not S_IS_BOT -->what you do not want them to see<!--ENDIF --> Cloaking refers to the practice of presenting different content o...

Go to advanced search