Database error

[niki@pe]

Invalid SQL:
 
			SELECT *
			FROM vb3datastore
			WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','smiliecache','bbcodecache');
 
MySQL Error  : Table 'xxxxxxx.vb3datastore' doesn't exist
Error Number : 1146

Can Anybody Help me ?

 

[bluescorpion]

You want to add a little context around this? What / How did you get this error, doing what? Is your database up and running?

 

[niki@pe]

I Cant enter to my forum for this problem :S

I have 1000 Messages for day in my Inbox :S

Can you help me How to fix this problem :s

 

[niki@pe]

Any help

Please !!!!!

 

[dusean]

which plugin did u recently added to you vb .... you have deleted the database as you can see so the go to the plugins product.xml ... and copy the query inside it
it look like this
CREATE TABLE `web_members` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`lastname` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


and paste it in your mysql database through PHPMYADMIN ... and done

 

[niki@pe]

Thnx for your Help

But i dont find `pluginsproduct.xml`

Can you i Detalist tell mee what to do

Thnx very much

 

[bluescorpion]

this looks like a two way conversation, don't know what the context is to help...

 

[niki@pe]

Invalid SQL:

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

MySQL Error : Table 'xxxxxxx.vb3datastore' doesn't exist
Error Number : 1146

This text come to my Inbox 1000 time in day

What do you think can i fix this problem or i must start from ZERO :S

My Backup Files says same think in other Host :S

 

[exel]

because Table 'xxxxxxx.vb3datastore' doesn't exist

says it right there..

try executing this sql:

DROP TABLE IF EXISTS vb3datastore;
CREATE TABLE `vb3datastore` (
`title` char(50) NOT NULL default '',
`data` mediumtext,
`unserialize` smallint(6) NOT NULL default '0',
PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[bluescorpion]

Okay, lets backup a second. Did the system ever work? If yes, what hacks have you installed and which ones recently, like since the problem started. Did you set your database up to use the vb3 prefix? If you didn't check you should check your config.php file around line 35. It should be : $config['Database']['tableprefix'] = '';

If it contains vb3 that might be the source of your problem.

 

[niki@pe]

$config['Database']['tableprefix'] = 'vb3';

I have Delete vb3 but Again ERROR DATABASE :s

 

[bluescorpion]

Same error? Do you / can you use phpMyAdmin?

You didn't say if this ever worked?

If it did, what mods have you installed since it was working?

 

[bluescorpion]

I am thinking that the vbulletin database is using vb3_ not vb3. Can you check in phpMyAdmin to see what prefix if any your database is using? Here is something else you can do, go into admincp>Maintenance>Diagnostics>system information select Table Status and submit it. It should give you a listing of the tables including their names. See what it thinks the Datastore table is called.

thanks

 

[niki@pe]

The forum Work 1 Year but now NOT :S
I have Change dhe DB User and Pas in CONFIG.PHP and in that moment comes DATABASE ERROR

Again I put same Informatin like has ben before Mesages : Databas error

I can't Enter tu ADMIN CPANEL

 

[exel]

@ niki@pe, pm me your ftp info and site link.

ill see what i can do

 

[w5a]

Normally its best to do a full backup once a week, if anything happen, you can always use your backup, I'm not talking about the backup from your vb panel, i am talking about you host cpanel which is

http://www.xxxxxxxxxxxx:2083