Forum now unavailable - 'White Screen' - phpBB SiteMaker
Forum now unavailable - 'White Screen'
I decided to continue with other work and come back to SiteMaker at a later time. I clicked to leave the editor and I got a blank white screen. Now I can't access my forum at all; when I try and reload my forum I get a white screen and I get the same if I try to go to the adm index.
The only access I have to my forum is by ftp; I have tried removing the SiteMaker files AND disabling the extension using phpMyAdmin but that has made no difference.
What else can I do to get my forum back?
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
I used ftp to clear the cache and all is well.
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
I have deleted and replaced the ext files and tried to 'delete data' which gave the same error.SQL ERROR [ mysqli ]
Table 'havenown_hof.phpbb_sm_blocks' doesn't exist [1146]
I have cleared the cache again, but still can't get the ext to enable.
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
Code: Select all
UPDATE phpbb_migrations SET migration_depends_on = 'a:2:{i:0;s:51:\"\\blitze\\sitemaker\\migrations\\v20x\\m1_initial_schema\";i:1;s:64:\"\\blitze\\sitemaker\\migrations\\converter\\c4_convert_primetime_data\";}' WHERE migration_name = '\\blitze\\sitemaker\\migrations\\v30x\\m16_add_block_view_field'
-
- Registered User
- Posts: 429
- Joined: Tue Nov 29, 2005 5:06 pm
- Contact:
Re: Forum now unavailable - 'White Screen'
Are these the correct steps for running your query?
1. Back Up my DBase (within my forum)
2. Login to my cPanel
3. phpMyAdmin
4. Select my DBase
5. Select SQL Tab
6. Paste your query into window
7. Select GO
8. Cross my fingers and hope I've not screwed anything up
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
-
- Registered User
- Posts: 429
- Joined: Tue Nov 29, 2005 5:06 pm
- Contact:
Re: Forum now unavailable - 'White Screen'
So, when I've done that what should I do?
1. Delete the ext Data or
2. Enable the ext or
3. Re-install the ext
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
-
- Registered User
- Posts: 429
- Joined: Tue Nov 29, 2005 5:06 pm
- Contact:
Re: Forum now unavailable - 'White Screen'
1. I ran your query and all seemed to be ok (I got a green message)
2. I tried to delete the data and my original error message
3. I deleted the old files and uploaded a new set and then tried to enable the ext and again I got the error.
This is the full error:
General Error
SQL ERROR [ mysqli ]
Table 'havenown_hof.phpbb_sm_blocks' doesn't exist [1146]
SQL
SHOW COLUMNS FROM phpbb_sm_blocks
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 885
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 902
CALL: phpbb\db\tools\tools->sql_list_columns()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 541
CALL: phpbb\db\tools\tools->sql_column_exists()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php
LINE: 190
CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()
FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
Appreciate the extensions/mods/support then buy me a beer
- RMcGirr83
- Former Team Member
- Posts: 22016
- Joined: Wed Jun 22, 2005 4:33 pm
- Location: Your display
- Name: Rich McGirr
- Contact:
Re: Forum now unavailable - 'White Screen'
I just did what I do with any other ext update - disable (your ext was already disabled) - delete existing files - upload new files - enable ext.
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
-
- Registered User
- Posts: 429
- Joined: Tue Nov 29, 2005 5:06 pm
- Contact:
Re: Forum now unavailable - 'White Screen'
Just to be sure, I have run your query again and still can't delete data. I have also tried enabling the ext but again I get the same error.
Will installing your new version, when it is available, rectify the error?
If everything seems to be going well, you have obviously overlooked something.
-
- Registered User
- Posts: 142
- Joined: Fri Aug 04, 2006 5:14 pm
- Location: Bolton
- Contact:
Re: Forum now unavailable - 'White Screen'
With version 3.0.1, I made a change (migration) that added a table column and dropped another in the sm_blocks table. I also added instructions to revert the changes when the extension is purged. This change has a dependency on the initial migration that created the sm_blocks table. When you purge the extension, it deletes the sm_blocks table before reverting the aforementioned migration, thereby causing the error message you see.
I have addressed this issue going forward but here's the problem: If you had purged this extension and ran into this bug, you lost the sm_blocks table but the extension was not purged. So you can't purge it because of the database error message, but you also cannot enable it because the sm_blocks table is missing. So what to do? I am weighing options. I have reached out to the devs for advice. Waiting for response... Stay tuned...
-
- Registered User
- Posts: 429
- Joined: Tue Nov 29, 2005 5:06 pm
- Contact: