Search found 3531 matches

by MarkDHamill
Fri Mar 01, 2024 11:15 pm
Forum: [3.3.x] Support Forum
Topic: 3.2.0 database upgrade to 3.3.8 errors out with php fatal error
Replies: 12
Views: 2910

Re: 3.2.0 database upgrade to 3.3.8 errors out with php fatal error

I know it's an old topic but i thought it could be helpful for someone. After updating xampp to 8.2 i forgot to copy the mysql data to the new xampp data directory so while everything was in order (all paths were correct, login was correct AND username/pass of the db was correct, the database (phys...
by MarkDHamill
Sun Jan 28, 2024 3:10 am
Forum: Wanted!
Topic: Importing Posts from SQL or CSV File to Existing PHPBB Page
Replies: 3
Views: 587

Re: Importing Posts from SQL or CSV File to Existing PHPBB Page

For reasons that are hard to explain, this is either technically infeasible or only for someone with very deep pockets. There are I think 71 tables in a phpBB database, but they key ones are the posts, users, topics and forums tables. A post must contain a link to a row in the users table, linked by...
by MarkDHamill
Mon Oct 30, 2023 1:16 pm
Forum: Wanted!
Topic: Help with upgrade from phpBB 3.0.10 to 3.3.11
Replies: 3
Views: 1357

Re: Help with upgrade from phpBB 3.0.10 to 3.3.11

Thanks. This sounds useful.
by MarkDHamill
Sun Oct 29, 2023 3:33 pm
Forum: Wanted!
Topic: Help with upgrade from phpBB 3.0.10 to 3.3.11
Replies: 3
Views: 1357

Help with upgrade from phpBB 3.0.10 to 3.3.11

Title/Job Description: Complete 3.0.10 to 3.3.11 Upgrade Target audience: Hobbyists Reward: Money Deadline: ASAP Preferred contact method: PM Link to the board: Detailed description of the tasks: See https://www.phpbb.com/community/viewtopic.php?t=2646133 Issues during 3.0.10 to 3.3.10 upgrade. php...
by MarkDHamill
Sun Sep 24, 2023 8:45 pm
Forum: [3.3.x] Support Forum
Topic: Not all ACP tabs are showing
Replies: 3
Views: 624

Re: Not all ACP tabs are showing

I can't find a STK toolkit for 3.3. Sounds hopeful though.
by MarkDHamill
Fri Sep 22, 2023 1:12 pm
Forum: [3.3.x] Support Forum
Topic: Not all ACP tabs are showing
Replies: 3
Views: 624

Not all ACP tabs are showing

After an upgrade to phpBB 3.3.10, not all the tabs in the ACP are showing. In the past I solved this problem by emptying the phpbb_modules table and inserting new rows in it from a clean install of phpBB 3.3.10 representing the phpbb_modules table. Purge the cache but it didn't work. Not sure how to...
by MarkDHamill
Tue Sep 19, 2023 7:43 pm
Forum: [3.3.x] Support Forum
Topic: Upgrading using CLI
Replies: 4
Views: 493

Re: Upgrading using CLI

Paul, you are a phpBB God, but you knew that. I guess there are two types of dashes? It's really hard to tell. Thanks to you the upgrade completed.
by MarkDHamill
Tue Sep 19, 2023 5:34 pm
Forum: [3.3.x] Support Forum
Topic: Upgrading using CLI
Replies: 4
Views: 493

Upgrading using CLI

Why is this failing? It's being executed from the phpBB root folder. I've done similar things without an issue, I was just getting persistent timeouts using the web interface: [capedo5@ecbiz226 board]$./bin/phpbbcli.php db:migrate –-safe-mode Too many arguments, expected arguments "command"...
by MarkDHamill
Thu Sep 14, 2023 10:33 pm
Forum: [3.3.x] Support Forum
Topic: Moving Topic - SQL ERROR 1690
Replies: 2
Views: 421

Re: Moving Topic - SQL ERROR 1690

You are probably trying to set a negative value for a column without this constraint. You really don't want to ALTER the topic_posts_unapproved column to allow negative values as it indicates an inconsistent database. It's better to fix the issue. forum_posts_unapproved is normally zero. It likely c...
by MarkDHamill
Wed Jun 14, 2023 1:27 am
Forum: Wanted!
Topic: Converting PostgreSQL to MySQL
Replies: 2
Views: 1034

Re: Converting PostgreSQL to MySQL

I could probably do this but it is somewhat time consuming. I once converted a phpBB database from SQLServer to MySQL for a client.
by MarkDHamill
Thu Apr 27, 2023 1:57 pm
Forum: Extension Writers Discussion
Topic: core.posting_modify_template_vars
Replies: 1
Views: 1443

core.posting_modify_template_vars

I am trying to use this event which occurs on the posting page. I have some code tied to the event: public function check_post_submission($event) { echo var_dump($event['page_data']); if (!$event['submit']) { echo 'Bailing'; return; } // Form is being submitted with data. // If the checkbox checked ...
by MarkDHamill
Wed Jan 25, 2023 9:59 pm
Forum: [3.3.x] Support Forum
Topic: General error, no access during file upload
Replies: 7
Views: 771

Re: General error, no access during file upload

It can't hurt to check the owner and group for the files folder. If it's different from the other files and folders, using chown to make it consistent may fix the problem.
by MarkDHamill
Wed Jan 25, 2023 1:14 pm
Forum: [3.3.x] Support Forum
Topic: General error, no access during file upload
Replies: 7
Views: 771

Re: General error, no access during file upload

It's the images/avatar/upload folder that needs 777 permissions. It's only used to upload user avatar images. Posts and private message attachments should go into the /files folder. It may be a phpBB permission issue. You can view the permissions for the user in the ACP. Look for permissions for upl...
by MarkDHamill
Wed Jan 25, 2023 1:09 pm
Forum: [3.3.x] Support Forum
Topic: Replace link for external images
Replies: 5
Views: 685

Re: Replace link for external images

My SQL could be improved:

Code: Select all

UPDATE phpbb_posts SET post_text = REPLACE(post_text,'THE','THEM') WHERE post_text LIKE '%THE%;
To find these posts and see how they might change, something like:

Code: Select all

SELECT post_id, topic_id, post_text, REPLACE(post_text,'THE','THEM') WHERE post_text LIKE '%THE%;
by MarkDHamill
Wed Jan 25, 2023 3:27 am
Forum: [3.3.x] Support Forum
Topic: Replace link for external images
Replies: 5
Views: 685

Re: Replace link for external images

This can be done in the database but it's somewhat dangerous. I'd disabled the board and back up the phpbb_posts table first. Then I'd find an example post and study the content of the post_text column in a tool like phpMyAdmin. You can get the topic_id from the URL to the topic (ex: viewtopic.php?t...

Go to advanced search