MyBB Community Forums

Hello!
I just installed my myBB forum and everything went quite well to begin with, but when I finished the installation and was to go to my forum, this showed up? I've looked around the site here to try and find anything on this issue with  this issue, but I can't find anything on it, similar, but not with the error code I have in front of me :\ What does it even mean? I read it as if some table somewhere in the coding I downloaded from here, tossed over to my domain through Filezilla, installed aand I got stuck here 

I'm a n00b at this with these kinds of forums, so please explain things as if I was 5 and kind of just got my own computer or something lol!
Please help?    (english is also not my native language, but I get around kind of okay)



MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
0 - Array
Query:
SQLSTATE[HY000]: General error: 1 no such table: mybb_datacache



Dimmornas Stad - Internal Error (ladaena.com)



[attachment=46734]

Have a read through here and follow the steps: https://community.mybb.com/thread-228008...50448.html

Thank you for your reply!
I looked through the link and searched for both   $config['database']['table_prefix']. and  $config['database']['database']. I have none of them in the list of codes? I don't use sqlite though I used mysql? I tried to go through sqlite but it didn't go through so I went back to mysql, but now when I look in the codes, it does say sqlite? 

I don't understand the rest or how to fix it no matter how much I try to read the thread I get confused and panic and don't know what to do  

Here is the config.php codes

<?php
/**
 * Database configuration
 *
 * Please see the MyBB Docs for advanced
 * database configuration for larger installations
 * https://docs.mybb.com/
 */

$config['database']['type'] = 'sqlite';
$config['database']['database'] = 'mysql.ladaena.com';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = '';
$config['database']['username'] = '';
$config['database']['password'] = '';

/**
 * Admin CP directory
 *  For security reasons, it is recommended you
 *  rename your Admin CP directory. You then need
 *  to adjust the value below to point to the
 *  new directory.
 */

$config['admin_dir'] = 'admin';

/**
 * Hide all Admin CP links
 *  If you wish to hide all Admin CP links
 *  on the front end of the board after
 *  renaming your Admin CP directory, set this
 *  to 1.
 */

$config['hide_admin_links'] = 0;

/**
 * Data-cache configuration
 *  The data cache is a temporary cache
 *  of the most commonly accessed data in MyBB.
 *  By default, the database is used to store this data.
 *
 *  If you wish to use the file system (cache/ directory), MemCache (or MemCached), xcache, APC, APCu, eAccelerator or Redis
 *  you can change the value below to 'files', 'memcache', 'memcached', 'xcache', 'apc', 'apcu', 'eaccelerator' or 'redis' from 'db'.
 */

$config['cache_store'] = 'db';

/**
 * Memcache configuration
 *  If you are using memcache or memcached as your
 *  data-cache, you need to configure the hostname
 *  and port of your memcache server below.
 *
 * If not using memcache, ignore this section.
 */

$config['memcache']['host'] = 'localhost';
$config['memcache']['port'] = 11211;

/**
 * Redis configuration
 *  If you are using Redis as your data-cache
 *  you need to configure the hostname and port
 *  of your redis server below. If you want
 *  to connect via unix sockets, use the full
 *  path to the unix socket as host and leave
 *  the port setting unconfigured or false.
 */

$config['redis']['host'] = 'localhost';
$config['redis']['port'] = 6379;

/**
 * Super Administrators
 *  A comma separated list of user IDs who cannot
 *  be edited, deleted or banned in the Admin CP.
 *  The administrator permissions for these users
 *  cannot be altered either.
 */

$config['super_admins'] = '1';

/**
 * Database Encoding
 *  If you wish to set an encoding for MyBB uncomment
 *  the line below (if it isn't already) and change
 *  the current value to the mysql charset:
 *  http://dev.mysql.com/doc/refman/5.1/en/charset-mysql.html
 */

// $config['database']['encoding'] = '';

/**
 * Automatic Log Pruning
 *  The MyBB task system can automatically prune
 *  various log files created by MyBB.
 *  To enable this functionality for the logs below, set the
 *  the number of days before each log should be pruned.
 *  If you set the value to 0, the logs will not be pruned.
 */

$config['log_pruning'] = array(
	'admin_logs' => 365, // Administrator logs
	'mod_logs' => 365, // Moderator logs
	'task_logs' => 30, // Scheduled task logs
	'mail_logs' => 180, // Mail error logs
	'user_mail_logs' => 180, // User mail logs
	'promotion_logs' => 180 // Promotion logs
);

/**
 * Disallowed Remote Hosts
 *  List of hosts the fetch_remote_file() function will not
 *  perform requests to.
 *  It is recommended that you enter hosts resolving to the
 *  forum server here to prevent Server Side Request
 *  Forgery attacks.
 */

$config['disallowed_remote_hosts'] = array(
	'localhost',
);

/**
 * Disallowed Remote Addresses
 *  List of IPv4 addresses the fetch_remote_file() function
 *  will not perform requests to.
 *  It is recommended that you enter addresses resolving to
 *  the forum server here to prevent Server Side Request
 *  Forgery attacks.
 *  Removing all values disables resolving hosts in that
 *  function.
 */

$config['disallowed_remote_addresses'] = array(
	'127.0.0.1',
	'10.0.0.0/8',
	'172.16.0.0/12',
	'192.168.0.0/16',
);

/**
 * Admin CP Secret PIN
 *  If you wish to request a PIN
 *  when someone tries to login
 *  on your Admin CP, enter it below.
 */

$config['secret_pin'] = '';

Make sure the following matches the database:

$config['database']['type'] = 'sqlite'; <-- If this is MySQL, it should be 'mysql' or 'mysqli'
$config['database']['database'] = 'mysql.ladaena.com'; <-- This is the name you gave the database
$config['database']['table_prefix'] = 'mybb_'; <-- this is the prefix that you either made in the database, or allowed MyBB to create

You said you changed from sqlite to MySQL? From memory, the database type should then be 'mysql' or 'mysqli' if its MySQL Improved.

Database name MUST exactly match.

Table prefix MUST match the prefix you set in the database. So if you set the prefix to 'myboard_' then that's what it needs to be in your config.php file. Those 3 settings are at the very top of your config file.

No need to panic  It'll get sorted.

I had a dropdown menu where I could choose mysql or lite or some other thing I don't remember. Lite didn't work so I did the mysql, I haven't poked on anything else as far as I know :3 I just installed, wrote things in and... ended up with the error lol! I think it was mysql improved now when I think about it?

the mybb_ is the same, I didn't change that name I think? So if that's what it says in the database I'd say that's what I managed to put in? I'm so stupid, I usually take a photo of the registration of what I put in and where... I didn't this time and it bit my bum  

So, how do I change things and how do I make it right?  I figured I needed to use the mysql thing in the database name from what I tried to read on the guide? ladaena.com/rpgforum is where I want to add it, come to think of it I think I added that as the database index too?

I had hoped this was to just download, toss up, click and done lol! apparently not (so typically me too lol ) :3 

Since the database refused several times to be made, I wrote different things I think so I don't know or am not sure what went through and what didn't  This is all I can see that I gave you now? Where do I go to fix it in the system? At least I know how to get into the database through my webhost domain (dreamhost).

Mentally I'm banging my head on the keyboard right now :p thank GOD for people like you who can save us code and setup -illiterates lol!

God... this is totally not working... I've tried mysql, mysqli and sqlite nothing works but I get different errors every time... :\ 

I tried with ladaena_rpgforum_ and ladaena_rpgforum but I always end up with "there is no cashe"... :\ 

Here are my current codes of the config again. Putting up all three variations of errors in pictures as well...  I don't know what else to do? I've tried to read on the link you gave as well but I can't get my head around it, my english isn't good enough to get what it actually says I think? (not to mention coding is not my strong side either :\  so that language in itself is confusing (I'm better at design).

<?php
/**
 * Database configuration
 *
 * Please see the MyBB Docs for advanced
 * database configuration for larger installations
 * https://docs.mybb.com/
 */

$config['database']['type'] = 'sqlite';
$config['database']['database'] = 'mysql.ladaena.com';
$config['database']['table_prefix'] = 'ladaena_rpgforum_';

$config['database']['hostname'] = '';
$config['database']['username'] = '';
$config['database']['password'] = '';

/**
 * Admin CP directory
 *  For security reasons, it is recommended you
 *  rename your Admin CP directory. You then need
 *  to adjust the value below to point to the
 *  new directory.
 */

$config['admin_dir'] = 'admin';

/**
 * Hide all Admin CP links
 *  If you wish to hide all Admin CP links
 *  on the front end of the board after
 *  renaming your Admin CP directory, set this
 *  to 1.
 */

$config['hide_admin_links'] = 0;

/**
 * Data-cache configuration
 *  The data cache is a temporary cache
 *  of the most commonly accessed data in MyBB.
 *  By default, the database is used to store this data.
 *
 *  If you wish to use the file system (cache/ directory), MemCache (or MemCached), xcache, APC, APCu, eAccelerator or Redis
 *  you can change the value below to 'files', 'memcache', 'memcached', 'xcache', 'apc', 'apcu', 'eaccelerator' or 'redis' from 'db'.
 */

$config['cache_store'] = 'db';

/**
 * Memcache configuration
 *  If you are using memcache or memcached as your
 *  data-cache, you need to configure the hostname
 *  and port of your memcache server below.
 *
 * If not using memcache, ignore this section.
 */

$config['memcache']['host'] = 'localhost';
$config['memcache']['port'] = 11211;

/**
 * Redis configuration
 *  If you are using Redis as your data-cache
 *  you need to configure the hostname and port
 *  of your redis server below. If you want
 *  to connect via unix sockets, use the full
 *  path to the unix socket as host and leave
 *  the port setting unconfigured or false.
 */

$config['redis']['host'] = 'localhost';
$config['redis']['port'] = 6379;

/**
 * Super Administrators
 *  A comma separated list of user IDs who cannot
 *  be edited, deleted or banned in the Admin CP.
 *  The administrator permissions for these users
 *  cannot be altered either.
 */

$config['super_admins'] = '1';

/**
 * Database Encoding
 *  If you wish to set an encoding for MyBB uncomment
 *  the line below (if it isn't already) and change
 *  the current value to the mysql charset:
 *  http://dev.mysql.com/doc/refman/5.1/en/charset-mysql.html
 */

// $config['database']['encoding'] = '';

/**
 * Automatic Log Pruning
 *  The MyBB task system can automatically prune
 *  various log files created by MyBB.
 *  To enable this functionality for the logs below, set the
 *  the number of days before each log should be pruned.
 *  If you set the value to 0, the logs will not be pruned.
 */

$config['log_pruning'] = array(
	'admin_logs' => 365, // Administrator logs
	'mod_logs' => 365, // Moderator logs
	'task_logs' => 30, // Scheduled task logs
	'mail_logs' => 180, // Mail error logs
	'user_mail_logs' => 180, // User mail logs
	'promotion_logs' => 180 // Promotion logs
);

/**
 * Disallowed Remote Hosts
 *  List of hosts the fetch_remote_file() function will not
 *  perform requests to.
 *  It is recommended that you enter hosts resolving to the
 *  forum server here to prevent Server Side Request
 *  Forgery attacks.
 */

$config['disallowed_remote_hosts'] = array(
	'localhost',
);

/**
 * Disallowed Remote Addresses
 *  List of IPv4 addresses the fetch_remote_file() function
 *  will not perform requests to.
 *  It is recommended that you enter addresses resolving to
 *  the forum server here to prevent Server Side Request
 *  Forgery attacks.
 *  Removing all values disables resolving hosts in that
 *  function.
 */

$config['disallowed_remote_addresses'] = array(
	'127.0.0.1',
	'10.0.0.0/8',
	'172.16.0.0/12',
	'192.168.0.0/16',
);

/**
 * Admin CP Secret PIN
 *  If you wish to request a PIN
 *  when someone tries to login
 *  on your Admin CP, enter it below.
 */

$config['secret_pin'] = '';

Error 44 is incorrect database type which is this bit - $config['database']['type'].

So either you've setup the wrong database, or you're trying to link to an incorrect database or one that doesn't exist.

500 error could be a lot of things. It's hard to narrow down. Are you trying to install this on localhost (this is local to your computer and isn't visible on the internet) or a live site? If you're happy to allow me access to your server (which won't work on localhost) I can take a look for you. You can PM the details and your URL if so (don't post them publicly on here).

I restarted with everything, I deleted it all, including the database and re-made it from scratch, it works now! All thanks to your guidance too! Thank you!! I finally understood how to put everything in while registering all thanks to this! It made everything simple enough for me to follow to do the steps right, instead of trying to fix a broken thing, I began again :3 (I know it says it's not recommended, but I figured I didn't have anything to loose) 

Thank you So much for your patience with me! It means the world to me! (and I'll probably be back when I try to add stuff in design later on lol but in the right forum of course ;p )

$config['database']['type'] = 'sqlite'; <-- If this is MySQL, it should be 'mysql' or 'mysqli'
$config['database']['database'] = 'mysql.ladaena.com'; <-- This is the name you gave the database
$config['database']['table_prefix'] = 'mybb_'; <-- this is the prefix that you either made in the database, or allowed MyBB to create

https://www.ladaena.com/dimmornasstad/rp.../index.php

No problem at all. Glad I could help 😊

The theme is outdated for your mybb version. The styling is weird. Why do you have phpbb? https://ladaena.com/forum/ and mybb...