Categories
Hints

PHPBB upgrade from 3.0 to 3.2

Here are the altered instructions from one of the instructions to upgrade phpBB from 3.0.x to 3.2.1 by Lumpy Burgertushie.

Prerequisites

  • Your server must be running at least PHP 5.4 and less than PHP 7.1
  • Your database must be running MariaDB 5.1 or MySQL 3.4 and higher or other supported databases
  • All MODs for 3.0.x will be removed.
  • Styles for 3.0.x will be removed.

Steps

SET FTP TRANSFER MODE TO BINARY to avoid future problems.

  1. Backup up your board’s files and database
  2. Remove all existing modules and modifications by doing the following:
    1. Overwrite all the modified files with original content (e.g. download original 3.0.x zip file and copy its content to your web), EXCEPTconfig.php
    2. Download the Support ToolkitInstall it and run the database cleaner to remove all old MODs from the database.
    3. Remove the content of phpbb_mods table
    4. Remove suspicious content of phpbb_modules table by checking module_basename. Here’s a list of typical modules to be removed:
      1. tapatalk – acp_mobiquo
      2. autoMOD – acp_mods
      3. ABB codes – acp_abbcodes
      4. RSS feed – acp_rss
      5. Calendar – acp_calendar
    5. Remove suspicious content of phpbb_modules table by checking module_langname. Here’s a list of typical modules to be removed:
      1. tapatalk – ACP_MOBIQUO
      2. ABB codes – ACP_ABBCODES
  3. Put the board to “compatibility mode” by doing the following:
    1. Set default style to prosilver
    2. Deactivate all styles except for prosilver
      1. Choose prosilver as the replacement
    3. Ensure that the activated spambot countermeasure is one of the standard phpBB plugins (Simple image, GD image, GD 3D image, Q&A, reCaptacha).
    4. Disable memcache if you have it by editing switch acm_type to file in config.php
    5. Set British English as the only language pack in General / Board settings
  4. Upgrade to 3.1 by doing the following:
    1. Delete all of your phpBB 3.0.x files EXCEPT for the following:
      1. The config.php file
      2. The /images/ directory
      3. The /files/ directory
      4. The /store/ directory
    2. Upload the contents of phpbb 3.1.11 zip to web folder and overwrite everything EXCEPT config.php
    3. Open yourdomain.com/yourphpbb/install/database_update.php
    4. Removeinstall directory
    5. Go to administrator’s page and check all the screens whether there are keys which are not translated. If you find any, remove them from phpbb_modules table by checking agains module_langname column.
    6. Purge the cache in General screen and refresh the page. You shouldn’t see any deprecated menu items from step above.
  5. Upgrade to 3.2 by doing the following:
    1. Upload the contents of phpbb 3.2.x zip to web folder and overwrite everything EXCEPT config.php
    2. Updateconfig.phpentries as follows:
      $dbms = ‘phpbb\\db\\driver\\mysqli’;
      $phpbb_adm_relative_path = ‘adm/’;
      $acm_type = ‘phpbb\\cache\\driver\\file’;
    3. Browse to yourdomain.com/yourphpbb/install/ then click the update tab. Click update. then submit for update database only.
    4. The updater will most likely fail with timeout “The installer detected a timeout”. Login to ACP, which will warn you about unsuccessfull update. Click to retry database update. This time it should finish.
    5. Delete the folder named /install/
  6. There you go 🙂
Categories
Hints

Samsung Smart TV Motion Control

Do you have Samsung Smart TV and you’re missing the option to turn on Motion Control? This is on purpose for European market:

http://forum.samygo.tv/viewtopic.php?t=6474

Steps how to turn it on:

  1. Turn off your TV
  2. Press the following buttons on your remote control after each other: Info, Menu, Mute, Power On
  3. Tv will power on and open service menu
  4. Go to Option / MRT Option
  5. Look for Motion Recog or Motion Control and press Enter on it (do not play with camera support or other items!)
  6. Use left/right arrow to change it from Off to On
  7. Press back
  8. Turn off the TV
  9. Turn on the TV
  10. Done
Categories
Hints

Acer Aspire One 722 – disable charger beep in windows 7

There is one and only working way to disable PC speaker beep in Windows for Acer Aspire One 722 (Acer AO722):

  1. Install original Conexant audio driver (otherwise PC speaker option won’t be available!)
  2. Go to Control Panel > Sound > Playback Tab > Speakers > Properties > Levels Tab
  3. Mute PC Speaker

There is also the disable Beep alternative. The same as above applies – it won’t work unless you install the original Conexant audio driver (for both x86 and x64).

 

Good luck!

Categories
Hints

Windows 7 keeps adding keyboard layout

English

Windows 7 keeps adding keyboard layout after re-logging in or system restart. Removed keyboard layout is restored.

This is caused by windows log-in screen (Welcome screen) which has separate keyboard settings. To fix this problem do the following:

  1. Go to: Control panel > Region and Language > Keyboards and languages
  2. Click “Change keyboards”
  3. You’ll see the dialog where you can choose which layouts you want to have and which one should be the default one
  4. Remove all unwanted layouts and press OK
  5. Go to the last tab : Control panel > Region and Language > Administrative
  6. Click on “Copy settings”
  7. Tick “Welcome screen and system accounts”
  8. Press OK
  9. Press OK
  10. You’re done

Slovensky

Možno ste sa stretli s problémom, kedy Windows 7 pridáva po reštarte alebo opätovnom prihlásení klávesnicu, ktorú ste predtým odobrali. V mojom prípade to bola”Slovenčina”, ktorá má štandardne QWERTZ rozloženie. Používam QWERTY a vždy po prihlásení som zrazu mal pre slovenčinu QWERTY aj QWERTZ variantu, pričom prvá zvolená bola samozrejme QWERTZ.

Po troche bádania som prišiel na to, že to spôsobuje prihlasovacia obrazovka, ktorá má svoje vlastné nastavenie klávesníc. Nechcená klávesnica sa tak dá odstrániť nasledovne:

  1. Otvor: Control panel > Region and Language > Keyboards and languages (Ovládací panel > Región a jazyk > Klávesnice a jazyky)
  2. Klikni na “Change keyboards” (Zmeniť klávesnice)
  3. Otvorí sa štandardné okno, kde sa dajú pridávať a odoberať klávesnice
  4. Odstráň všetky nechcené klávesnice a stlač OK
  5. V poslednej záložke : Control panel > Region and Language > Administrative (Ovládací panel > Región a jazyk > Správa)
  6. Klikni na “Copy settings” (Kopírovať nastavenia)
  7. Zakvační “Welcome screen and system accounts” (Prihlasovacia obrazovka a systémové účty)
  8. Stlač OK
  9. Stlač OK
  10. Hotovo