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:
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:
Then I manually created an "topic_datastore" table in the database and received a similar error message:
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.
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';
$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:
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 :
SELECT *
FROM topic_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');
MySQL Error : Table 'dxw_vBulletin.topic_datastore' doesn't existFROM topic_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');
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:
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 :
SELECT *
FROM topic_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','maxl oggedin','acpstats','mailqueue','pluginlistadmin');
MySQL Error : Unknown column 'title' in 'where clause'FROM topic_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','maxl oggedin','acpstats','mailqueue','pluginlistadmin');
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.
Comment