-
-
What does this SQL error mean?
Nicholas Schuester replied to Nicholas Schuester's post in a topic in Classic self-hosted technical helpHere'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.
-
What does this SQL error mean?
Nicholas Schuester replied to Nicholas Schuester's post in a topic in Classic self-hosted technical helpHere 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. 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.
-
Lost All Formatting After Migration/Upgrade
Yes. No bueno there.
-
Lost All Formatting After Migration/Upgrade
I have a simple IPB site that's broken and unusable after a supposedly simple migration involving an account-account transfer on the same host (no DNS changes). There were no errors during transfer of files and databases, and conf has been updated accordingly. However, the new site after changing the addon domain settings in cPanel displays without any formatting whatsoever. I'm at the very end of my wits trying to figure this out and obviously any sort of reinstall is not possible on an active site. There's only one other guy who had this issue and he didn't seem to have found a resolution I tried toggling designer mode but couldn't disable it, only doing so after trying to force an upgrade to 4.5.4 which was successful but the unformatted/no-CSS situation remains. Would really appreciate some urgent help here.
-
What does this SQL error mean?
Nicholas Schuester replied to Nicholas Schuester's post in a topic in Classic self-hosted technical helpUpdated 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.
-
What does this SQL error mean?
Nicholas Schuester replied to Nicholas Schuester's post in a topic in Classic self-hosted technical helpHi 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
-
What does this SQL error mean?
Nicholas Schuester replied to Nicholas Schuester's post in a topic in Classic self-hosted technical helpThanks Rhett, trying that out right now.
-
What does this SQL error mean?
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?
Nicholas Schuester
Members
-
Joined
-
Last visited