Database Error

T

[TgA] ATI

New Member
Im trying to install vB but I keep getting all these errors that have to do with MySQL. Please help me, I don't know anything about PHPmyAdmin or Mysql.
This is an example i get in my browser when I the URL is http://jonnyclan.com/forums/install/install.php Error


Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield');

MySQL Error : Table 'forum.datastore' doesn't exist
Error Number : 1146
Date : Friday, October 24th 2008 @ 10:11:56 PM
Script : Database Error
Referrer :
IP Address : 192.168.0.1
Username :
Classname : vB_Database





What do I need to do to fix this.


Thanks much
ATI
 
T

[TgA] ATI

New Member
Yes, this is a database called "datebase" in my sql. This error is telling me about fields and I don't really know what to make them or how long, i thought the installation manager did that. Any ideas?


Thanks
ATI
 
S

Smeker

New Member
Run this query:
PHP: 
DROP TABLE IF EXISTS datastore;
CREATE TABLE `datastore` (
  `title` varchar(50) NOT NULL default '',
  `data` mediumtext,
  `unserialize` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
M

moron

New Member
[TgA] ATI;47253 said:
Im trying to install vB but I keep getting all these errors that have to do with MySQL. Please help me, I don't know anything about PHPmyAdmin or Mysql.
This is an example i get in my browser when I the URL is http://jonnyclan.com/forums/install/install.php Error


Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield');

MySQL Error : Table 'forum.datastore' doesn't exist
Error Number : 1146
Date : Friday, October 24th 2008 @ 10:11:56 PM
Script : Database Error
Referrer :
IP Address : 192.168.0.1
Username :
Classname : vB_Database





What do I need to do to fix this.


Thanks much
ATI
Click to expand...
huh??

is this jonnyclan ,is where u trying to install the forum on??? is dat ur website?..
just wandering?


pe@c3
 
M

moron

New Member
[TgA] ATI;47253 said:
Im trying to install vB but I keep getting all these errors that have to do with MySQL. Please help me, I don't know anything about PHPmyAdmin or Mysql.
This is an example i get in my browser when I the URL is http://jonnyclan.com/forums/install/install.php Error


Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield');

MySQL Error : Table 'forum.datastore' doesn't exist
Error Number : 1146
Date : Friday, October 24th 2008 @ 10:11:56 PM
Script : Database Error
Referrer :
IP Address : 192.168.0.1
Username :
Classname : vB_Database





What do I need to do to fix this.


Thanks much
ATI
Click to expand...


Well, i would like to confirm .. is dat your site ??.. u just posted the link .. on there???
if u trying to upload Vb there , i guess one database is already being used by Joomla .
and if u think u can upload the vbulletin in the same database , den u require a hell lot of SQL codin n stuff.
better go for Joomla Bridge for Vbulletin , so dat both can use the same database .
else , create another database for ur forum with the link..
mysite.com/forum/
and upload the vb there with the new databse information.

There u go.


Hope , u just got ur answer.

pe@c3
 
T

[TgA] ATI

New Member
I ran the quarry and got this. Please help. and thanks much!!

Database error in vBulletin :

Invalid SQL:
SELECT varname, value, datatype FROM setting;

MySQL Error : Table 'datastore.setting' doesn't exist
Error Number : 1146
Date : Sunday, October 26th 2008 @ 07:31:54 PM
Script : Database Error
Referrer :
IP Address : 192.168.0.1
Username :
Classname : vB_Database
 
B

bluescorpion

New Member
This last error message looks like the database name is datastore. You need to do a reset I think. Create a new database called something that isn't going to conflict with vBulletin table name, like mydatebaseDB, change your config file to point to it then run the installation program. It looks like you have a hodgepodge otherwise and you will spend a lot more time trying to debug a failed installation than running a completely new install. In the first error message, it thinks that forum is the name of the database.

BTW, sorry to disagree with you mate, but this problem is Installation not programming as has been suggested.
 
T

[TgA] ATI

New Member
Ok, i made a new database called vbull and run that qurry to make the datastore table.
i got this






Database error in vBulletin :

Invalid SQL:
SELECT varname, value, datatype FROM setting;

MySQL Error : Table 'vbull.setting' doesn't exist
Error Number : 1146
Request Date : Monday, November 3rd 2008 @ 11:24:30 AM
Error Date : Monday, November 3rd 2008 @ 11:24:31 AM
Script : http://www.team-tga.com/forum/install/install.php
Referrer :
IP Address : 192.168.0.1
Username :
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt
 
T

[TgA] ATI

New Member
I feel stupid now. I tried using a msqli and that worked. I went into the folder and deleted a file by mistake, so decided to reinstall and deleated evething and now im doing the same things as before and it is no longer working.


Please help this is really frustrating!?!?!?!?!
 
Q

Qwity

New Member
seems hard but its so easy , create database called ( db ) , set config.php , run install.php , thats all .
 
S

ShadowthaKilla

New Member
upload vb again, create another databse again apart from your joomla, in your config.php, configure it to your database AND where it says

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';
Click to expand...

add 'table', so it should look like

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'table';
Click to expand...

try that if it helps
 
T

[TgA] ATI

New Member
Ok, first of all thanks for all your help.
I made a data base called "db"
i changed the table prefix to "table"
- Apache 2.2.8
- MySQL 5.0.51b
- PHP 5.2.6
that is what i have

this is my error:
Database error in vBulletin :

Invalid SQL:

SELECT *
FROM tabledatastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache');

MySQL Error : Table 'db.tabledatastore' doesn't exist
Error Number : 1146
Request Date : Tuesday, November 4th 2008 @ 04:29:46 PM
Error Date : Tuesday, November 4th 2008 @ 04:29:46 PM
Script : http://www.team-tga.com/vbfourms/install/install.php
Referrer :
IP Address : 192.168.0.1
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51b-community-nt





this is my current cfg. in the config.php file.

// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysqli';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'db';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'table';

// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config['Database']['technicalemail'] = '[email protected]';

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = false;



// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'db';
$config['MasterServer']['password'] = 'password';
 
N

NanoEntity

New Member
are you sure your connecting to database right?

some CPANEL creates connections to database with

USERname_DBname_TABLEname

$config['Database']['dbname'] = 'USERname_DBname';
 
You must log in or register to reply here.
Top