First install: "The database has encountered a problem."
 

Hi,

As an absolute newbie to vBulletin I am working through my first-ever install ... and can't get to first base. I'm carefully following the step-by-step instructions in the manual, but am obiously missing or misinterpretting something.

It seems that my poblem is that vBulletin is unable to create tables or fields in the database, because the initial SELECT query can't find anything.

I'm working from a Linux machine with Apache (2.0.63), PHP (5.2.9), and MySQL (5.0.81-community). The MySQL database for the installation is called dxw_vBulletin, and there are already several other MySQL databases running from the site / domain.

I've installed the various files into a "fora" subdirectory of my public_html directory, and have modified the config.php file as follows:

$config['Database']['dbtype'] = 'mysql';
$config['Database']['dbname'] = 'dxw_vBulletin';
$config['Database']['tableprefix'] = 'topic_';
$config['Database']['technicalemail'] = '[email protected]'*;
$config['Database']['force_sql_mode'] = false;
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;
$config['MasterServer']['username'] = 'dxw_dbadmin';
$config['MasterServer']['password'] = 'password';
$config['MasterServer']['usepconnect'] = 0;

$config['Misc']['admincpdir'] = 'admincp';
$config['Misc']['modcpdir'] = 'modcp';
$config['Misc']['cookieprefix'] = 'topic';

$config['Misc']['forumpath'] = '/home/dxw/public_html/fora';
$config['SpecialUsers']['canviewadminlog'] = '1';
$config['SpecialUsers']['canpruneadminlog'] = '1';
$config['SpecialUsers']['canrunqueries'] = '';
$config['SpecialUsers']['undeletableusers'] = 'dxw_dbadmin';
$config['SpecialUsers']['superadministrators'] = '1';

No changes were made to the other variables in config.php.


When I try http://www.domain-name.org/fora/ or http://www.domain-name.org/fora/admincp/ I receive an error message titled "The database has encountered a problem."

The source code for the initial message indicated:

Invalid SQL:

SELECT *
FROM topic_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache','userstats','birthdaycach e','maxloggedin','iconcache','eventcache','mailque ue');

MySQL Error : Table 'dxw_vBulletin.topic_datastore' doesn't exist
Error Number : 1146
Request Date : [date-time]
Error Date : [date-time]
Script : http://www.domain-name.org/fora/admincp/
[or http://www.domain-name.org/fora/]
Referrer :
IP Address : [IP Address]
Username :
Classname : vB_Database
MySQL Version :

Then I manually created an "topic_datastore" table in the database and received a similar error message:

Invalid SQL:

SELECT *
FROM topic_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache','maxloggedin','acpstats', 'mailqueue','pluginlistadmin');

MySQL Error : Unknown column 'title' in 'where clause'
Error Number : 1054
Request Date : [date-time]
Error Date : [date-time]
Script : http://www.domain-name.org/fora/admincp/
[or http://www.domain-name.org/fora/]
Referrer :
IP Address : [IP Address]
Username :
Classname : vB_Database
MySQL Version :

Something works, because I am receiving lots of error emails at [email protected] :)

Any advice / guidance would be greatly appreciated
dxw

* I've de-identified the domain name, IP Addresses, passwords, etc for this posting but the other data is pretty well as-is.