SQL Error DB function failed with error number 1050???

Discuss the universal connector for forums and other applications. (including vBridge )
Locked
predatorkill
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Wed Sep 21, 2005 7:32 pm
Contact:

SQL Error DB function failed with error number 1050???

Post by predatorkill » Mon Nov 21, 2005 7:24 pm

i tried to install the component and i get this error:

SQL Error DB function failed with error number 1050
Table 'joomla_vbridge_config' already exists SQL=CREATE TABLE joomla_vbridge_config ( id tinyint(2) NOT NULL default '0', vb_path varchar(255) NOT NULL default '', vb_url varchar(255) NOT NULL default '', vb_redirect tinyint(1) NOT NULL default '0', vb_useextdb tinyint(1) NOT NULL default '0', vb_dbhost varchar(25) NOT NULL default 'localhost', vb_dbuser varchar(25) NOT NULL default '', vb_dbpass varchar(25) NOT NULL default '', vb_dbname varchar(25) NOT NULL default '', vb_prefix varchar(25) NOT NULL default '', vb_cookie varchar(25) NOT NULL default '', wrapped tinyint(1) NOT NULL default '0', vb_license varchar(50) NOT NULL default '', cb_login tinyint(1) NOT NULL default '0', vb_reg tinyint(1) NOT NULL default '1', check_user tinyint(1) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM;
SQL =

CREATE TABLE joomla_vbridge_config (
id tinyint(2) NOT NULL default '0',
  vb_path varchar(255) NOT NULL default '',
vb_url varchar(255) NOT NULL default '',
  vb_redirect tinyint(1) NOT NULL default '0',
vb_useextdb tinyint(1) NOT NULL default '0',
vb_dbhost varchar(25) NOT NULL default 'localhost',
vb_dbuser varchar(25) NOT NULL default '',
vb_dbpass varchar(25) NOT NULL default '',
vb_dbname varchar(25) NOT NULL default '',
  vb_prefix varchar(25) NOT NULL default '',
vb_cookie varchar(25) NOT NULL default '',
  wrapped tinyint(1) NOT NULL default '0',
  vb_license varchar(50) NOT NULL default '',
cb_login tinyint(1) NOT NULL default '0',
vb_reg tinyint(1) NOT NULL default '1',
check_user tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

Any help?Thanks in advance!

EDIT: I know that error 1050 is this:
#

Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)

Message: Table '%s' already exists



But why it exists?I ve uninstalled the old component first through normal procedure!
Last edited by predatorkill on Mon Nov 21, 2005 7:33 pm, edited 1 time in total.
Oσοι παιζετε xbox live ελατε στο http://www.xbox-live.gr ....

predatorkill
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Wed Sep 21, 2005 7:32 pm
Contact:

Re: SQL Error DB function failed with error number 1050???

Post by predatorkill » Mon Nov 21, 2005 8:44 pm

I found the solution by deleting the table "joomla_vbridge_config"
then i deleted the table "salt" in joomla_users
then i deleted the table `vb_userid` in joomla_users
then i deleted the table  `vb_threadid`  in joomla_content

After all those drops the component installed perfectly.

Mark,i think there is a bug in the uninstallation through the "Components" uninstaller.
It seems it doesnt drop the tables during uninstall.
Oσοι παιζετε xbox live ελατε στο http://www.xbox-live.gr ....

User avatar
Predator
Joomla! Ace
Joomla! Ace
Posts: 1827
Joined: Wed Aug 17, 2005 10:12 pm
Location: Germany-Bad Abbach
Contact:

Re: SQL Error DB function failed with error number 1050???

Post by Predator » Thu Nov 24, 2005 9:04 pm

predatorkill wrote: I found the solution by deleting the table "joomla_vbridge_config"
then i deleted the table "salt" in joomla_users
then i deleted the table `vb_userid` in joomla_users
then i deleted the table  `vb_threadid`  in joomla_content

After all those drops the component installed perfectly.

Mark,i think there is a bug in the uninstallation through the "Components" uninstaller.
It seems it doesnt drop the tables during uninstall.
Upps will check this.
The "Humor, Fun and Games" forum has  more than 2500 Posts, so why not build a "Humor, Fun and Games Working" Group?
.....
Malicious tongues say we have this WG right from the start, they call it core team :D

Feropen
Joomla! Intern
Joomla! Intern
Posts: 53
Joined: Mon Sep 05, 2005 10:25 am

Re: SQL Error DB function failed with error number 1050???

Post by Feropen » Fri Nov 25, 2005 7:39 pm

Just got this error too.....  :'(

User avatar
Predator
Joomla! Ace
Joomla! Ace
Posts: 1827
Joined: Wed Aug 17, 2005 10:12 pm
Location: Germany-Bad Abbach
Contact:

Re: SQL Error DB function failed with error number 1050???

Post by Predator » Fri Nov 25, 2005 8:17 pm

Feropen wrote: Just got this error too.....  :'(
Yes it is noticed i prepare a fixed versiion this weekend, currently working on this.
The "Humor, Fun and Games" forum has  more than 2500 Posts, so why not build a "Humor, Fun and Games Working" Group?
.....
Malicious tongues say we have this WG right from the start, they call it core team :D

Pabs
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Nov 30, 2005 6:57 am

Re: SQL Error DB function failed with error number 1050???

Post by Pabs » Wed Nov 30, 2005 7:16 am

Ive got the same prob now too  ;)

Predatorkill....where abouts do i find those things you deleted?
I  cant find where they are hiding  ???


Locked

Return to “com_connector - Multi Joomla Bridge”