Search found 69 matches

by gsmaclean
Wed Oct 17, 2018 2:40 pm
Forum: [3.2.x] Support Forum
Topic: MS SQL Server users - here's the latest bug roundup
Replies: 2
Views: 7107

MS SQL Server users - here's the latest bug roundup

It seems like nobody bothers to regression test PHPBB on MS SQL Server, so every time there is a new release, I'm left with a site that either doesn't upgrade, doesn't function, or functions incorrectly. I then spend hours finding all the latest bugs in the SQL Server driver code, fixing them, and p...
by gsmaclean
Wed May 09, 2018 8:25 pm
Forum: [3.2.x] Support Forum
Topic: Bug: Crash running on MSSQL when upload dir > 2GB
Replies: 0
Views: 175

Bug: Crash running on MSSQL when upload dir > 2GB

I'm posting this in case anyone else comes across the same issue, until it gets fixed in the mainline code. This problem is encountered when running PHPBB against MSSQL, any version. My upload (files) directory exceeded 2GB recently, and when this occurred, anyone attempting to post an image with an...
by gsmaclean
Sun Sep 17, 2017 9:38 pm
Forum: [3.2.x] Support Forum
Topic: Upgrading to 3.2 fails when using MSSQL
Replies: 6
Views: 526

Re: Upgrading to 3.2 fails when using MSSQL

david63 wrote:
Sun Sep 17, 2017 9:18 pm
If you believe that you have found a bug then in order for it to get "fixed" you should post it in the bug tracker.
I have done so. But until the next release, people who are attempting to upgrade today on MSSQL need to have something they can find that will solve this problem.
by gsmaclean
Sun Sep 17, 2017 7:06 pm
Forum: [3.2.x] Support Forum
Topic: Upgrading to 3.2 fails when using MSSQL
Replies: 6
Views: 526

Upgrading to 3.2 fails when using MSSQL

Why does it seem like I'm the only person running PHPBB under MSSQL? Every new release it seems the MSSQL database library is released with blatant bugs in it which prevent the system from running. Obviously nobody tested the 3.1 -> 3.2 upgrade under MSSQL, because it would fail. This is to help any...
by gsmaclean
Fri Jul 07, 2017 2:47 am
Forum: [3.2.x] Support Forum
Topic: Symfony error writing to cache
Replies: 5
Views: 394

Re: Symfony error writing to cache

Exception: Unable to write to the "./../cache/production" directory. That speaks books, indeed. Yes, but the site was writing to the /cache/production directory with no problem whatsoever. It was filling up with cached PHP files, the twig directory and all of its subdirectories were all being creat...
by gsmaclean
Fri Jul 07, 2017 1:14 am
Forum: [3.2.x] Support Forum
Topic: Symfony error writing to cache
Replies: 5
Views: 394

Re: Symfony error writing to cache

Incidentally, I did finally find the cause of this problem, and I'm posting it here in case anyone comes across the same problem in the future. By default, the /forum/cache/production folder is created with permissions that allow for files to be written...except by symfony, for some reason. I modifi...
by gsmaclean
Tue Jun 13, 2017 12:43 pm
Forum: [3.2.x] Support Forum
Topic: Symfony error writing to cache
Replies: 5
Views: 394

Re: Symfony error writing to cache

That error message does not correlate with this Do you have any extensions installed? No The error message is saying that there is a problem with one, or more, of your extensions. You need to re-enable them one at a time until you find the culprit. Incidentally this will normally only happen with n...
by gsmaclean
Tue Jun 13, 2017 5:17 am
Forum: [3.2.x] Support Forum
Topic: Symfony error writing to cache
Replies: 5
Views: 394

Symfony error writing to cache

Support Request Template What version of phpBB are you using? phpBB 3.2.0 What is your board's URL? http://goldwingdocs.com Who do you host your board with? Self How did you install your board? I used the download package from phpBB.com What is the most recent action performed on your board? Update...
by gsmaclean
Tue Feb 28, 2017 4:09 pm
Forum: [3.1.x] Support Forum
Topic: The dreaded "hundreds of notification emails" problem returns
Replies: 3
Views: 194

Re: The dreaded "hundreds of notification emails" problem returns

Does the cache directory have all permissions (aka 777)? This is a Windows server (hence MS SQL Server as a back end), so 777 type permissions don't apply. But yes, the IIS USR account has correct permissions (read/write/modify) on the directory. Otherwise the site would not be able to read, write ...
by gsmaclean
Tue Feb 28, 2017 3:00 pm
Forum: [3.1.x] Support Forum
Topic: The dreaded "hundreds of notification emails" problem returns
Replies: 3
Views: 194

Re: The dreaded "hundreds of notification emails" problem returns

Incidentally, I (and many others) have been dealing with this issue, on and off, for over eight years now...you would think maybe it's time to revisit PHPBB's email queuing system.

viewtopic.php?f=46&t=1707575

https://tracker.phpbb.com/browse/PHPBB3-8011
by gsmaclean
Tue Feb 28, 2017 2:36 pm
Forum: [3.1.x] Support Forum
Topic: The dreaded "hundreds of notification emails" problem returns
Replies: 3
Views: 194

The dreaded "hundreds of notification emails" problem returns

Support Request Template What version of phpBB are you using? phpBB 3.1.10 What is your board's URL? http://goldwingdocs.com Who do you host your board with? Self hosted How did you install your board? I used the download package from phpBB.com What is the most recent action performed on your board...
by gsmaclean
Wed Apr 13, 2016 9:54 pm
Forum: [3.1.x] Support Forum
Topic: Error when updating 3.15 -> 3.18 under MSSQL
Replies: 4
Views: 137

Re: Error when updating 3.15 -> 3.18 under MSSQL

https://github.com/phpbb/phpbb/commit/48283d7c62f819769c35e5ef36367e212d47d008 Thanks. :) Glad my fix was correct. Sure would be nice to have this mentioned somewhere for those of us trying to upgrade, and ending up with a half-converted database and a non-functional site. Glad I found this out on ...
by gsmaclean
Wed Apr 13, 2016 9:46 pm
Forum: [3.1.x] Support Forum
Topic: Error when updating 3.15 -> 3.18 under MSSQL
Replies: 4
Views: 137

Re: Error when updating 3.15 -> 3.18 under MSSQL

OK, the problem is line 2342 of \phpbb\db\tools.php: $statements[] = 'ALTER TABLE [' . $table_name . '] ADD CONSTRAINT [DF_' . $table_name . '_' . $column_name . '_1] ' . $this->db->sql_escape($column_data['default']) . ' FOR [' . $column_name . ']'; Beginning at line 1462, we can see the column dat...
by gsmaclean
Wed Apr 13, 2016 9:26 pm
Forum: [3.1.x] Support Forum
Topic: Error when updating 3.15 -> 3.18 under MSSQL
Replies: 4
Views: 137

Error when updating 3.15 -> 3.18 under MSSQL

Support Request Template What version of phpBB are you using? phpBB 3.1.5 What is your board's URL? http://goldwingdocs.com/forum Who do you host your board with? Self How did you install your board? I used the download package from phpBB.com What is the most recent action performed on your board? ...
by gsmaclean
Wed Sep 23, 2015 8:13 pm
Forum: [3.1.x] Support Forum
Topic: BBCodes being ignored when rendered
Replies: 6
Views: 211

Re: BBCodes being ignored when rendered

KevC wrote:It should be on by default anyway.
That user must have decided to turn it off. You can turn it back on again in their profile preferences.
Right. But I have 60,000+ users, so it's a lot simpler to just turn it back on for everyone who might have turned it off, by running the query I wrote above. :)

Go to advanced search