Nicholas Schuester Posted October 24, 2020 Posted October 24, 2020 (edited) Gday gents, I'm doing a rather straightforward migration of an IPS between 2 accounts on the same host (so no DNS update needed, just move the files and databases and update config). After importing the database to phpmyadmin on the new account, I receive the following: -- -- Database: `singap08_trznet` -- -- -------------------------------------------------------- -- -- Table structure for table `trznetbbcode_mediatag` -- CREATE TABLE `trznetbbcode_mediatag` ( `mediatag_id` smallint(10) UNSIGNED NOT NULL, `mediatag_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mediatag_match` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mediatag_replace` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mediatag_position` smallint(6) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci MySQL said: #1046 - No database selected Can someone shed a light on what it means, if I can ignore it or how I can resolve it please? Edited October 24, 2020 by Nicholas Schuester
Rhett Posted October 24, 2020 Posted October 24, 2020 Here is a guide on a transfer, in your case it's the same method, never use phpmyadmin to export and import the database unless it's like 10Mb. Always use mysqldump via ssh to backup and restore via the command line. You mentioned this is the same host, is it also the same mysql server? if not please ensure you are on the proper version on the new server, we recommend mysql 5.7+ or Mariadb 10.2+
Nicholas Schuester Posted October 24, 2020 Author Posted October 24, 2020 (edited) Thanks Rhett, trying that out right now. Edited October 24, 2020 by Nicholas Schuester
Nicholas Schuester Posted October 24, 2020 Author Posted October 24, 2020 (edited) Hi guys, Database migrated without errors. Updated conf as per instructions and cleared cache as per guide. Folders uploads, plugins, datastore and applications are set to 766 recursive. However the site seems to be missing style sheet or something. Her are results from admin panel test: PHP Requirements PHP version 7.1.33. cURL extension loaded. Multibyte String extension loaded DOM extension loaded GD extension loaded MySQLi extension loaded OpenSSL extension loaded Session extension loaded SimpleXML extension loaded XML extension loaded XMLReader extension loaded XMLWriter extension loaded Phar extension loaded Zip extension loaded Exif extension loaded 512 MB memory limit. File System Requirements /home/bungalq8/public_html/www.trainz.net/applications is writable /home/bungalq8/public_html/www.trainz.net/datastore is writable /home/bungalq8/public_html/www.trainz.net/plugins is writable /home/bungalq8/public_html/www.trainz.net/uploads is writable /home/bungalq8/public_html/www.trainz.net/downloads is writable /home/bungalq8/public_html/www.trainz.net/screenshots is writable /home/bungalq8/public_html/www.trainz.net/uploads/logs is writable MySQL Requirements MySQL version 5.5.5-10.3.25-MariaDB. Check Again System Information PHP v7.1.33 phpinfo MySQL v5.5.5-10.3.25-MariaDB SQL Toolbox · Enable utf8mb4 Server Path /home/bungalq8/public_html/www.trainz.net Server IP 107.6.153.210 Hooks 7 www.trainz.net Edited October 24, 2020 by Nicholas Schuester
Nicholas Schuester Posted October 24, 2020 Author Posted October 24, 2020 Updated to 4.5.4 and while the upgrade went without a hitch, the entire site is still unformatted. Old google results from botched upgrade/migration attempts have had people suggest toggling designer mode. However once enabled it cannot be disabled (I was only able to disable this during the upgrade process warning). Also the issue remains unresolved. Any and all advice appreciated.
CoffeeCake Posted October 25, 2020 Posted October 25, 2020 Your CSS resources and such are returning 404 errors. Can you confirm that they are on the filesystem where the theme is calling them from? Have you checked filesystem permissions? I think the requirements checker does this:
Rhett Posted October 25, 2020 Posted October 25, 2020 "Folders uploads, plugins, datastore and applications are set to 766 recursive" That should be 777 for a standard setup on writable folders/files, if you're using suPHP then it would be 755 for all folders and 644 for all files.
Nicholas Schuester Posted October 25, 2020 Author Posted October 25, 2020 3 hours ago, Paul E. said: Your CSS resources and such are returning 404 errors. Can you confirm that they are on the filesystem where the theme is calling them from? Have you checked filesystem permissions? I think the requirements checker does this: Here is the result from that test:http://prntscr.com/v6cq6p How do I check which folder the theme is calling these CSS's from, or in which file is there a reference to the folder? It's the default theme that comes with v4. At any rate, the files were copied wholesale from the origin server and into the same folder (public_html/www.trainz.net), so 404s are not really making any sense to me right now. 3 hours ago, Rhett said: "Folders uploads, plugins, datastore and applications are set to 766 recursive" That should be 777 for a standard setup on writable folders/files, if you're using suPHP then it would be 755 for all folders and 644 for all files. I was previously following advice of "never set 777 due to security concerns" (eg. https://linuxize.com/post/what-does-chmod-777-mean/). 777 is being applied right now.
Nicholas Schuester Posted October 25, 2020 Author Posted October 25, 2020 Here's my conf_global: <?php $INFO['sql_driver'] = 'mysql'; $INFO['sql_host'] = 'localhost'; $INFO['sql_database'] = 'bungalq8_trznet'; $INFO['sql_user'] = 'xxxxxxxxxxx'; $INFO['sql_pass'] = 'xxxxxxxxxxx'; $INFO['sql_tbl_prefix'] = 'trznet'; $INFO['sql_debug'] = '0'; $INFO['sql_charset'] = ''; $INFO['board_start'] = '1439556890'; $INFO['installed'] = '1'; $INFO['php_ext'] = 'php'; $INFO['safe_mode'] = '0'; $INFO['board_url'] = 'https://www.trainz.net'; $INFO['banned_group'] = '5'; $INFO['admin_group'] = '4'; $INFO['guest_group'] = '2'; $INFO['member_group'] = '3'; $INFO['auth_group'] = '1'; $INFO['use_friendly_urls'] = '1'; $INFO['_jsDebug'] = '0'; $INFO['mysql_tbl_type'] = 'MyISAM'; define('IN_DEV', 0); /* Remote archive DB - complete these details if you\'re using a remote DB for the post archive. If content has already been archived in the local DB, this will need transferring and will not be done automatically. */ $INFO['archive_remote_sql_host'] = ''; $INFO['archive_remote_sql_database'] = ''; $INFO['archive_remote_sql_user'] = ''; $INFO['archive_remote_sql_pass'] = ''; $INFO['archive_remote_sql_charset'] = ''; ?> A small step in the right direction though: there was a mistake under "board_url" where it was http instead of https. The site now loads sort of correctly but is missing everyone's profile pictures.
Recommended Posts