Page 1 of 1

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

Posted: Mon Nov 21, 2005 7:24 pm
by predatorkill
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!

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

Posted: Mon Nov 21, 2005 8:44 pm
by predatorkill
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.

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

Posted: Thu Nov 24, 2005 9:04 pm
by Predator
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.

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

Posted: Fri Nov 25, 2005 7:39 pm
by Feropen
Just got this error too.....  :'(

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

Posted: Fri Nov 25, 2005 8:17 pm
by Predator
Feropen wrote: Just got this error too.....  :'(
Yes it is noticed i prepare a fixed versiion this weekend, currently working on this.

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

Posted: Wed Nov 30, 2005 7:16 am
by Pabs
Ive got the same prob now too  ;)

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