Search found 51 matches

by davss
Mon Oct 20, 2008 3:21 pm
Forum: [3.0.x] Support Forum
Topic: Too many connections [1040]
Replies: 18
Views: 4190

Re: Too many connections [1040]

Make sure you keep your phpbb_posts table as MyISAM otherwise you won't be able to recreate your indexes later on and the following error will occur:
MySQL fulltext indexes can only be used with MyISAM tables.
by davss
Mon Oct 20, 2008 3:19 pm
Forum: [3.0.x] Support Forum
Topic: Too many connections [1040]
Replies: 16
Views: 7294

Re: Too many connections [1040]

Make sure you keep your phpbb_posts as MyISAM otherwise you won't be able to recreate your indexes later on and get the following error:
by davss
Thu Oct 16, 2008 12:58 pm
Forum: [3.0.x] Support Forum
Topic: Too many connections [1040]
Replies: 16
Views: 7294

Re: Too many connections [1040]

It worked for us and the same error never came back.
by davss
Thu Oct 16, 2008 12:57 pm
Forum: [3.0.x] Support Forum
Topic: Too many connections [1040]
Replies: 18
Views: 4190

Re: Too many connections [1040]

It worked for us and the same error never came back. Please note I am writing this article in a hurry and haven't tested the below steps (we changed on our forums long time ago). I do not take any responsibility for any data loss although with a proper back up you should be OK. I'll try to improve t...
by davss
Sat Aug 30, 2008 3:11 pm
Forum: [3.0.x] Support Forum
Topic: Field 'topic_last_poster_name' doesn't have a default value
Replies: 21
Views: 11967

Re: Field 'topic_last_poster_name' doesn't have a default value

Just follow the KB article linked in the post 2 above yours http://www.phpbb.com/kb/article/doesnt-have-a-default-value-errors/ It'll output a page of SQL commands to automatically do the changes for you. Many thanks for this link. I run it successfully but it didn't fix all the tables and had to d...
by davss
Wed Aug 27, 2008 8:28 pm
Forum: [3.0.x] Support Forum
Topic: General Error, Sql error, too many connections 1040, help
Replies: 17
Views: 16227

Re: General Error, Sql error, too many connections 1040, help

I think we have solved the problem of MySQL DB falling over. Basically, by default tables are MyISAM which means each time DB is read whole table gets locked hence no other operations could be carried out at the same time. What we did was converted most tables to InnoDB that supports row locking apa...
by davss
Wed Aug 27, 2008 8:27 pm
Forum: [3.0.x] Support Forum
Topic: Too many connections [1040]
Replies: 16
Views: 7294

Re: Too many connections [1040]

I think we have solved the problem of MySQL DB falling over. Basically, by default tables are MyISAM which means each time DB is read whole table gets locked hence no other operations could be carried out at the same time. What we did was converted most tables to InnoDB that supports row locking apa...
by davss
Wed Aug 27, 2008 8:26 pm
Forum: [3.0.x] Support Forum
Topic: Too many connections [1040]
Replies: 18
Views: 4190

Re: Too many connections [1040]

I think we have solved the problem of MySQL DB falling over. Basically, by default tables are MyISAM which means each time DB is read whole table gets locked hence no other operations could be carried out at the same time. What we did was converted most tables to InnoDB that supports row locking apa...
by davss
Fri Jul 25, 2008 1:39 am
Forum: [3.0.x] Support Forum
Topic: No Smileys, no signup on phpbb3
Replies: 11
Views: 675

Re: No Smileys, no signup on phpbb3

icon_ naming convention got messed up somewhere in the code hence error messages. I renamed those with icon_e_ to icon_ and now seems to be working fine. Am still getting some other errors in httpd log though (not related to the above) [Fri Jul 25 02:33:25 2008] [error] [client 201.218.250.106] File...
by davss
Wed Jul 23, 2008 1:01 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: MOD not updating templates for other langs than EN
Replies: 16
Views: 729

Re: MOD not updating templates for other langs than EN

You are right - it was set to DB and changed it to file system now. I wasn't aware it was changed as someone else set up previous forums.

Thanks for all your help.
D
by davss
Tue Jul 22, 2008 8:53 am
Forum: [3.0.x] MOD Writers Discussion
Topic: MOD not updating templates for other langs than EN
Replies: 16
Views: 729

Re: MOD not updating templates for other langs than EN

I had to remove the Credit Mod (CM) from the DE forum and that's why it's not there at the moment. It's still on the EN at http://forums.alfresco.com/styles/prosilver/template/viewtopic_body.html. The problem is solved now. Need to upgrade all code to 3.0.1/2 then reapply CM, manually edit and updat...
by davss
Mon Jul 21, 2008 6:36 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: MOD not updating templates for other langs than EN
Replies: 16
Views: 729

Re: MOD not updating templates for other langs than EN

Solved!

As suspected - the template file on a running forum was kept in MySQL DB and cache was pulling it from there rather than file that was updated by our MOD. Purging cache doesn't update certain template files in DB hence old version was always cached.

Many thanks for taking the time.
by davss
Mon Jul 21, 2008 5:34 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: MOD not updating templates for other langs than EN
Replies: 16
Views: 729

Re: MOD not updating templates for other langs than EN

sure working MOD: http://forums.alfresco.com/en/viewtopic.php?f=6&t=13328 you should see '0 Points (What's this)' on the right hand side. am testing now in my test env and notice that when applied MOD to our german forum the company's top navigation bar sitting in overall_header template has dis...

Go to advanced search