Jim R Posted Monday at 05:08 PM Share Posted Monday at 05:08 PM (edited) If you need to move this to Applications, no worries, and I'm not getting much help from the platform's community. I'm trying to install Xenforo into a new server space. Clean install. I have successfully installed Xenforo twice before on two other server spaces and have managed a Xenforo platform since 2016. I've produced a couple of add-ons for my needs and custom styling. (Nothing advanced, just for my local message board.) In other words, I've never had any issues and have fairly dug through their code for my needs. Based on the information I have below, I'm curious if it's a server/host permissions issue, and perhaps what question I should be asking my host. It's not producing the tables it should be producing, then throwing an error about a table it has yet to create. If anyone has dealt with this, I appreciate any guidance. I had to go in and populate their config file just to get it this far. It seems like the install package isn't working, and I've triple checked to make sure I've uploaded the correct package. An exception occurred: [mysqli_sql_exception] Table 'nitoaute_csi.xf_data_registry' doesn't exist in src/XF/Db/Mysqli/Statement.php on line 35 mysqli->prepare() in src/XF/Db/Mysqli/Statement.php at line 35 XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54 XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94 XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175 XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 135 XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83 XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226 XF\DataRegistry->offsetGet() in src/XF/Install/App.php at line 74 XF\Install\App->XF\Install\{closure}() in src/XF/Container.php at line 28 XF\Container->offsetGet() in src/XF/App.php at line 2280 XF\App->setupAddOnComposerAutoload() in src/XF/Install/App.php at line 160 XF\Install\App->setup() in src/XF.php at line 437 XF::setupApp() in src/XF.php at line 460 XF::runApp() in install/index.php at line 14 Edited Monday at 05:11 PM by Jim R Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/ Share on other sites More sharing options...
mac_gyver Posted Tuesday at 01:00 AM Share Posted Tuesday at 01:00 AM are you sure of the database name and its capitalization? what type of hosting is this? on shared web hosting, the actual database name usually gets some unique part of the account naming prepended to it, so that everyone who creates a database named 'abc' actually gets a separate database that only their account can see and access. Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/#findComment-1649703 Share on other sites More sharing options...
Jim R Posted Wednesday at 04:11 AM Author Share Posted Wednesday at 04:11 AM I'm sure of the nitoaute_csi part. nitoaute_ is what is assigned to me. I appended the csi part. I'm using HostGator, shared hosting, and in the past their support ticket has been very good. However, it's been awhile since I've had an issue on this side of things since I changed server spaces. This is just taking too long. Part of that is my fault for getting help via chat. Luckily it's not a production site, but the Users of this forum are a small but vocal group (of freeloaders). 🙂 Meanwhile, I have also installed other platforms on this server space since starting it up. This issue is the only one I'm having. I was hoping someone else had come across it and can direct to which questions to ask, or even if there is something I add to htaccess. Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/#findComment-1649961 Share on other sites More sharing options...
mac_gyver Posted Wednesday at 04:59 AM Share Posted Wednesday at 04:59 AM it would be nice to know what you do and what the software does concerning database creation, database user creation, and database user permissions. do you create the database, the database user, and assign permissions, then enter the connection information into the configuration file? are any tables being created in that database? are there any other similarly named databases that if they for example stripped out non-ascii characters could match the desired database name? what i suspect is there is more than one database, that they then get switch somewhere in the process so that at the point where the query in question is executed it's not using the correct database or that the table creation fails due to a permission issue and there's no error handling and/or no reporting of the failed table creation queries. Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/#findComment-1649965 Share on other sites More sharing options...
gizmola Posted Wednesday at 08:44 PM Share Posted Wednesday at 08:44 PM We don't have enough information to really help you here. Looking into xenforo, I see that it is a commercial product, with a self host license of $195, and no open source version. Without the source people really can't do any debugging for you. My advice would be to contact the company directly as this is some sort of installation issue, and they are really the only ones in a position to understand the implications of that stack trace. Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/#findComment-1650120 Share on other sites More sharing options...
Jim R Posted 22 hours ago Author Share Posted 22 hours ago 22 hours ago, gizmola said: We don't have enough information to really help you here. Looking into xenforo, I see that it is a commercial product, with a self host license of $195, and no open source version. Without the source people really can't do any debugging for you. My advice would be to contact the company directly as this is some sort of installation issue, and they are really the only ones in a position to understand the implications of that stack trace. That's fair. I was mostly wondering if anyone else had had this issue. Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/#findComment-1650187 Share on other sites More sharing options...
Jim R Posted 22 hours ago Author Share Posted 22 hours ago On 2/18/2025 at 11:59 PM, mac_gyver said: it would be nice to know what you do and what the software does concerning database creation, database user creation, and database user permissions. do you create the database, the database user, and assign permissions, then enter the connection information into the configuration file? are any tables being created in that database? are there any other similarly named databases that if they for example stripped out non-ascii characters could match the desired database name? what i suspect is there is more than one database, that they then get switch somewhere in the process so that at the point where the query in question is executed it's not using the correct database or that the table creation fails due to a permission issue and there's no error handling and/or no reporting of the failed table creation queries. Xenforo is a message board platform. It has a guided installation process for those who need it, but I was going through it because I wanted a clean install. The prevailing thought is it's a server permission issue, but my host support hasn't been responsive. Quote Link to comment https://forums.phpfreaks.com/topic/326806-could-use-some-insight-on-a-database-installation-issue/#findComment-1650188 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.