Cant't access or update phpBB on GoDaddy-hosted site

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
wayneh
Registered User
Posts: 17
Joined: Sun May 22, 2022 3:29 pm

Cant't access or update phpBB on GoDaddy-hosted site

Post by wayneh »

Help! Semi-noob here.

I administer three websites on GoDaddy, two using phpBB forums. One of them is fine and was automatically updated to 3.3.7 by GoDaddy not long ago. The other is stuck at 3.3.1 and is no longer accessible to users. I've tried to get help from GoDaddy but, well, 'nuff said...

Here's the error a user sees:

Code: Select all

General Error
SQL ERROR [ mysqli ]
Table 'i4577560_bb1.sessions' doesn't exist [1146]
An SQL error occurred while fetching this page. Please contact the Boa rd Administrator if this problem persists.
Here is the error that GoDaddy's Installatron returns when I attempt to update:

Code: Select all

Error
A database query has failed. Is the entered database information correct? Does the account have available disk space?

type = mysql
host = localhost
database = i4577560_bb1
username = i4577560_bb1
password = **HIDDEN**

Technical information:
method = query
arguments = array ( 0 => 'SELECT `config_value` FROM `config` WHERE `config_name`=\'version\'', 1 => NULL, 2 => 'config_value',)

errstr = 

Technical Error: 1146 Table 'i4577560_bb1.config' doesn't existSELECT `config_value` FROM `config` WHERE `config_name`='version
Fortunately I can access and edit the files using the phpMyAdmin tool, but I have no idea what to do.
Last edited by Mick on Wed May 25, 2022 6:42 am, edited 2 times in total.
Reason: Solved.
User avatar
bubbathegimp
Registered User
Posts: 192
Joined: Tue Sep 25, 2018 8:02 pm
Location: Off Plumb
Name: Bubba
Contact:

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by bubbathegimp »

have you tries doing it yourself manually?
i usually upload the files using coreftp, and following the posted instructions...
I have had problems with incompatible extensions affecting tables, and had success by using the extension disable script, doing the upgrade, then adding the extensions back...
If at first you don't succeed, Sky diving is not for you....
Ymmv
User avatar
warmweer
Jr. Extension Validator
Posts: 11197
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by warmweer »

wayneh wrote: Sun May 22, 2022 3:50 pm ...
Fortunately I can access and edit the files using the phpMyAdmin tool, but I have no idea what to do.
phpMyAdmin is a database management tool, not a file editor.
As such it can be used to edit/check the database: in this case are the tables mentioned present or not?

You mentioned one of the boards was updated using Installatron (successfully) ...
How was the update attempted on the other board? (and did you take a database and files backup before starting the update?)
If yes to the last question, just restore your board and follow the official update instructions
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26456
Joined: Fri Aug 29, 2008 9:49 am

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by Mick »

Welcome to phpBB.

Please fill out the Support Request Template and post it back here to enable us to assist you better.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
wayneh
Registered User
Posts: 17
Joined: Sun May 22, 2022 3:29 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by wayneh »

I should have added a sample of the error log entries:

Code: Select all

[22-May-2022 15:55:36 UTC] PHP Fatal error:  Uncaught mysqli_sql_exception: Table 'i4577560_bb1.sessions' doesn't exist in /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/mysqli.php:193
Stack trace:
#0 /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/mysqli.php(193): mysqli_query()
#1 /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/factory.php(345): phpbb\db\driver\mysqli->sql_query()
#2 /home/kusg6qsegg2v/public_html/forums/phpbb/session.php(358): phpbb\db\driver\factory->sql_query()
#3 /home/kusg6qsegg2v/public_html/forums/index.php(27): phpbb\session->session_begin()
#4 {main}
  thrown in /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/mysqli.php on line 193
[22-May-2022 15:55:58 UTC] PHP Fatal error:  Uncaught mysqli_sql_exception: Table 'i4577560_bb1.users' doesn't exist in /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/mysqli.php:193
Stack trace:
#0 /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/mysqli.php(193): mysqli_query()
#1 /home/kusg6qsegg2v/public_html/forums/phpbb/db/driver/factory.php(345): phpbb\db\driver\mysqli->sql_query()
#2 /home/kusg6qsegg2v/public_html/forums/phpbb/session.php(635): phpbb\db\driver\factory->sql_query()
#3 /home/kusg6qsegg2v/public_html/forums/phpbb/session.php(472): phpbb\session->session_create()
#4 /home/kusg6qsegg2v/public_html/forums/viewtopic.php(26): phpbb\session->session_begin()
#5 {main}
But I can see and work on both the "sessions" and "users" tables using phpMyAdmin.

I have not tried to update the forum manually and have always let Installatron handle it. I thought it made a backup as part of the update process but I don't see one anywhere. It may have trashed it after a certain time. This error popped up a while ago but I've only recently become aware of it.he

I'll fill out a Support Request tomorrow.
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by janus_zonstraal »

I have not tried to update the forum manually and have always let Installatron handle it.
Please never use that, it can break your board for ever.
Follow always the upgrade guide from this board! https://www.phpbb.com/support/docs/en/3 ... radeguide/
Sorry! My English is bat ;) !!!
wayneh
Registered User
Posts: 17
Joined: Sun May 22, 2022 3:29 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by wayneh »

Here's the Support Template

Support Request Template
What version of phpBB are you using? phpBB 3.3.1
What is your board's URL? www.aircompare.us/forums
Who do you host your board with? GoDaddy
How did you install your board? I used a tool provided by my host
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.3.1
What styles do you currently have installed? No answer given
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? GoDaddy's automated system attempted an update but failed. The backup was trashed 2 weeks later, before I was able to get to this.

"The update process for AirCompare User Forum located at http://www.aircompare.us/forums has failed and the details of the failure have been logged.

Technical error:
Error: A database query has failed. Is the entered database information correct? Does the account have available disk space?

type = mysql
host = localhost
database = i4577560_bb1
username = i4577560_bb1
password = **HIDDEN**

Technical information:
method = query
arguments = array ( 0 => 'SELECT `style_id` FROM `styles` WHERE `style_name`=\'prosilver\'', 1 => NULL, 2 => 'style_id',)

errstr =

Technical Error: 1146 Table 'i4577560_bb1.styles' doesn't existSELECT `style_id` FROM `styles` WHERE `style_name`='prosilver'"
Please describe your problem. The forum is not accessible to users and throws an error. I can access the database files but cannot cause an update. I don't have the chops to diagnose the problem.
Generated by SRT Generator
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26456
Joined: Fri Aug 29, 2008 9:49 am

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by Mick »

I’m still seeing:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'i4577560_bb1.users' doesn't exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
wayneh
Registered User
Posts: 17
Joined: Sun May 22, 2022 3:29 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by wayneh »

Yes, that's listed in my first post.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26456
Joined: Fri Aug 29, 2008 9:49 am

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by Mick »

Yes but have you checked that i4577560_bb1.users doesn't exist?
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
warmweer
Jr. Extension Validator
Posts: 11197
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by warmweer »

What does your database (i4577560_bb1) currently contain? Post a list of tables present (with nr of records).Also

Somewhat peculiar is that the queries are looking for the tables "users" and "sessions", which suggests no table prefix was used during installation.

I have to be honest here. If you have no self made database backup (and your host autodeletes or overwrites the host autobackups after a certain time), then I fear your board is completely lost). If by any chance you have older backups, then it may be possible to restore that version.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
wayneh
Registered User
Posts: 17
Joined: Sun May 22, 2022 3:29 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by wayneh »

Following are screen shots of what I see in phpMyAdmin
Screen Shot 2022-05-23 at 1.34.06 PM.jpg
Screen Shot 2022-05-23 at 1.34.26 PM.jpg
Screen Shot 2022-05-23 at 1.34.42 PM.jpg
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by janus_zonstraal »

database looks ok to me.
Did you read your pm's here?
Sorry! My English is bat ;) !!!
User avatar
warmweer
Jr. Extension Validator
Posts: 11197
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by warmweer »

Users and Visits are not default phpBB tables. The tables with prefix bb_ are (and your config.php should confirm that).
I suspect User and Visits are table created by the host and you don't need those with a "normal" phpBB installation.
Can you post your config.php (blank out the the password).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
wayneh
Registered User
Posts: 17
Joined: Sun May 22, 2022 3:29 pm

Re: Cant't access or update phpBB on GoDaddy-hosted site

Post by wayneh »

Code: Select all

<?php
// phpBB 3.2.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'i4577560_bb1';
$dbuser = 'i4577560_bb1';
$dbpasswd = 'HIDDEN';
$table_prefix = '';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';

@define('PHPBB_INSTALLED', true);
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
@define('PHPBB_ENVIRONMENT', 'production');
// @define('DEBUG_CONTAINER', true);
Post Reply

Return to “[3.3.x] Support Forum”