Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Avalonica
Registered User
Posts: 23
Joined: Fri Jun 09, 2006 10:03 pm
Location: Terra Australis
Contact:

Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Avalonica » Wed Oct 16, 2019 4:49 pm

General Error
SQL ERROR [ mysqli ]

Table 'edenreal_p_bb3.phpbb_config_text' doesn't exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
<|Á|>Avalonica<|Á|>

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21681
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Mick » Wed Oct 16, 2019 4:59 pm

Did you transfer by following Transferring Your Board to a New Host or Domain or some other method? Can you post a link to your board please?
"The more connected we get the more alone we become" - Kyle Broflovski

Avalonica
Registered User
Posts: 23
Joined: Fri Jun 09, 2006 10:03 pm
Location: Terra Australis
Contact:

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Avalonica » Wed Oct 16, 2019 5:37 pm

1. I TRANSFERRED MY BOARD ...
To a 'New Host' using a Site .zip file and a Database .dmp.gz file

2. THE LINK TO MY BOARD ...
https://www.edenrealm.com/ER-SD-avalonica/index.php
<|Á|>Avalonica<|Á|>

User avatar
warmweer
Registered User
Posts: 3041
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by warmweer » Wed Oct 16, 2019 5:51 pm

Avalonica wrote:
Wed Oct 16, 2019 5:37 pm
1. I TRANSFERRED MY BOARD ...
To a 'New Host' using a Site .zip file and a Database .dmp.gz file

2. THE LINK TO MY BOARD ...
https://www.edenrealm.com/ER-SD-avalonica/index.php
And ... does the table exist in that database? (did you modify your config.php to the new location?)
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21681
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Mick » Wed Oct 16, 2019 5:56 pm

I’m seeing two different addresses here https://sigs.interserver.net/ and https://www.edenrealm.com/ER-SD-avalonica/index.php. Do your ACP settings reflect your new board?
"The more connected we get the more alone we become" - Kyle Broflovski

Avalonica
Registered User
Posts: 23
Joined: Fri Jun 09, 2006 10:03 pm
Location: Terra Australis
Contact:

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Avalonica » Wed Oct 16, 2019 8:28 pm

warmweer (Registered User)
1. 'phpbb_config_text' does not exist in the database;
2. yes I did modify your config.php to the new location.

Mick (Support Team)
1. no idea what this is "https://sigs.interserver.net/";
2. this is the address "https://www.edenrealm.com/ER-SD-avalonica/index.php";
3. how do I access my 'ACP settings' when I don't have access to the Board??
<|Á|>Avalonica<|Á|>

User avatar
warmweer
Registered User
Posts: 3041
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by warmweer » Wed Oct 16, 2019 8:49 pm

Avalonica wrote:
Wed Oct 16, 2019 8:28 pm
1. 'phpbb_config_text' does not exist in the database;
Then the database you used wasn't complete.
Check your database backup.
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21681
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Mick » Wed Oct 16, 2019 8:56 pm

This is what i’m seeing: Testing the URL: https://sigs.interserver.net/ normalised from: https://www.edenrealm.com/ER-SD-avalonica/index.php

So from that I can only conclude it’s something to do with your new host?

Also I followed https://sigs.interserver.net/ and it goes to a malware reporting site with a message:

“Real time suspected malware list as detected by InterServer's InterShield protection system“

Any idea what that’s all about? Where is the root of your board, where config.php is?
"The more connected we get the more alone we become" - Kyle Broflovski

Avalonica
Registered User
Posts: 23
Joined: Fri Jun 09, 2006 10:03 pm
Location: Terra Australis
Contact:

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by Avalonica » Thu Oct 17, 2019 4:21 pm

1. warmweer » Thu Oct 17, 2019 7:19 am
'phpbb_config_text' does not exist in the database ...
Then the database you used wasn't complete.
Check your database backup.
:arrow: How do I do that? ... All I have is a dated '[backup].zip' to work with. Perhaps the problem is that being dated it means that it would work 'better' with an older version of mySQL? 8-)

2. Mick » Thu Oct 17, 2019 7:26 am
1.This is what i’m seeing: Testing the URL: https://sigs.interserver.net/ normalised from: https://www.edenrealm.com/ER-SD-avalonica/index.php ...So from that I can only conclude it’s something to do with your new host? ... Also I followed https://sigs.interserver.net/ and it goes to a malware reporting site with a message:
“Real time suspected malware list as detected by InterServer's InterShield protection system“
Any idea what that’s all about?
2. Where is the root of your board, where config.php is?
:arrow: I'll press the 'New Host' for 'What's it all about?' and I've done some changing of the 'Root' folder in the 'config.php' and changed to a 'different Database Backup' with the resultant response per this Screen-Shot
Screen Shot 2019-10-18 at 02.05.25.png
<|Á|>Avalonica<|Á|>

User avatar
janus_zonstraal
Registered User
Posts: 3744
Joined: Sat Aug 30, 2014 1:30 pm

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by janus_zonstraal » Thu Oct 17, 2019 5:48 pm

What and how many tables are in the database?
Sorry! My English is bat ;) !!!

User avatar
warmweer
Registered User
Posts: 3041
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Got this transferring my avalonica.edenrealm.com phpbb from ipower to interserver

Post by warmweer » Thu Oct 17, 2019 6:19 pm

It seems that in your database the config and config_text tables are missing. Your database is most probably incomplete (and who knows what else is missing).

If you still have access to your old host, log in to your forum and make new backup using the phpBB backup feature. If a timeout occurs (probaly because of database size), empty the search_tables en split the backup: posts seperately, and topic_track also.
If all you have is a dump file then list all the tables you have (take a printscreen to show the nr of records in each table.)

That seems to be your 3.2.2 board from a previous topic? Just in case: Do still still have the backups you used in that topic?
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

Post Reply

Return to “[3.2.x] Support Forum”