Search found 597 matches

by WWu777
Sat Oct 19, 2019 7:02 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Dear David63, Something with your auto backup extension isn't working as expected. I set the number of stored backups to 3. However, I found 6 backups in my server under the /store folder. It seems that it is not overwriting the oldest backup and keeping the number to 3. When I click the Restore tab...
by WWu777
Mon Oct 14, 2019 3:48 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

If I set the extension to backup every 3 days (or 72 hours), and the maximum stored backups to 3 databases, does that mean that every time a backup is made, the oldest stored backup will be replaced and overwritten? Is that assumption correct? More or less. From memory every time a backup is perfor...
by WWu777
Sat Oct 12, 2019 11:53 pm
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

I got another question about the table "phpbb_posts" which contain all the forum posts. Every time i optimize it in phpmyadmin it causes it to crash for some reason. Then i have to repair it. But even after i repair it, it will still crash if i try to optimize it for some reason. If you're running ...
by WWu777
Sat Oct 12, 2019 11:20 pm
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

To David63, I got your auto backup extension to work now. It seems to work fine and is making the backups as scheduled. Thanks a lot. I will be glad to send you a donation for this helpful extension you designed. :) I have a question though. If I set the extension to backup every 3 days (or 72 hours...
by WWu777
Thu Oct 10, 2019 3:18 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

I got another question about the table "phpbb_posts" which contain all the forum posts. Every time i optimize it in phpmyadmin it causes it to crash for some reason. Then i have to repair it. But even after i repair it, it will still crash if i try to optimize it for some reason. Is this due to some...
by WWu777
Thu Oct 10, 2019 3:12 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Search indexes are big because they're lossless and they provide instant access to any record. Video codecs are lossy and can only seek to certain frames. FWIW, the MySQL FULLTEXT back end takes less space because it uses specialized data structures. So the search index is basically a duplicate of ...
by WWu777
Thu Oct 10, 2019 1:26 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

A few quick questions: 1. Does importing tables into a database cause any overwrites? Does it add data or replace the whole table and overwrite it? I tried this but it doesn't seem to do anything but result in error messages. No new posts are added. 2. I noticed that when I delete the search indexes...
by WWu777
Wed Oct 09, 2019 1:10 am
Forum: phpBB Custom Coding
Topic: Merging two phpBB3.2 forums
Replies: 14
Views: 800

Re: Merging two phpBB3.2 forums

Yeah, as far as I know. But if I put in this URL: http://happierabroad.com/forum/phpbb-merge-script/config.php I get: 403 Permission Denied You do not have permission for this request /forum/phpbb-merge-script/config.php When I should just be seeing a blank page. So it still seems like a permission...
by WWu777
Tue Oct 08, 2019 11:02 pm
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

PrimeHalo or Prime Halo. I have a board. The last post id is 100. But, Like you, I lose some posts. Let's say I lose 90 through 100. Them, like you, I restore what I have (last post id 89). Users make new posts, lets say 11 of them. So now, the last post id is again 100. Now you insert the lost pos...
by WWu777
Tue Oct 08, 2019 10:45 pm
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

It will probably work in the sense that data from one database will be inserted into another. However, it will not work in the sense of actually creating a working version of a phpBB database. There are many more tables involved other than the posts table and, just for example, there will almost ce...
by WWu777
Tue Oct 08, 2019 6:28 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Steve Maury, Will this work to merge my database tables and posts? https://www.digitalberg.com/WiKi/how-to-importexport-mysql-database/ CPANEL 1. From cPanel, you need to click the phpMyAdmin icon. 2. Click the SQL tab at the top. You will see where it says, ‘Run SQL query/queries on server “localho...
by WWu777
Tue Oct 08, 2019 6:20 am
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

What you want to do is not practically possible. That is, merging posts into an existing database. I am not saying it can't be done, but not easily or cheaply. You're right. I tried to export the phpbb_posts table and import it into the restored database. I got these error messages on phpmyadmin: S...
by WWu777
Tue Oct 08, 2019 5:15 am
Forum: phpBB Custom Coding
Topic: Merging two phpBB3.2 forums
Replies: 14
Views: 800

Re: Merging two phpBB3.2 forums

primehalo wrote:
Mon Oct 07, 2019 10:39 pm
Are the file and folder permissions all correct?
Yes I think so. The number value is set to 775. See screenshot below. Is that correct?


Untitled.jpg
by WWu777
Mon Oct 07, 2019 10:18 pm
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

One more important question everyone. I'm about to restore my database backup from Sept 13 that Bluehost retrieved for me. However, I want to try to merge or add the posts made after the crash on Sept 18 too. What if I exported the phpbb_posts and phpbb_topics tables from the database after the cras...
by WWu777
Mon Oct 07, 2019 10:10 pm
Forum: [3.2.x] Support Forum
Topic: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?
Replies: 91
Views: 4554

Re: Help! "phpbb_posts" table crashed and ejected all data! All posts in forum gone! What can be done?

Dear David63, Ok thanks. I've correctly installed your extension. In my ACP though it says your extension is outdated and that a newer version exists. See the screenshots below. Why does it say that? Is it a bug? Or does that mean there is a newer version? If so, where? Is it in the phpbb extensions...

Go to advanced search