What does this SQL error mean?

[Nicholas Schuester]

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]

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]

Thanks Rhett, trying that out right now.

Edited October 24, 2020 by Nicholas Schuester

[Nicholas Schuester]

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]

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]

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]

"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]

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]

 

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.