[vbplusme]

Originally Posted by MAD-DOG

when i try to Import Product video directory_1-1-0_RC_2 again after unintall it it gives me this Database error


Database error in v Bulletin 3.7.4:

Invalid SQL:
CREATE TABLE video (
videoid int(10) unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL,
description mediumtext NOT NULL,
videourl varchar(255) NOT NULL,
videocategoryid int(10) unsigned NOT NULL default '0',
dateline int(10) NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
videoservice varchar(250) NOT NULL,
videoidservice varchar(250) NOT NULL,
views int(10) unsigned NOT NULL default '0',
PRIMARY KEY (videoid)
);

MySQL Error : Table 'video' already exists
Error Number : 1050
Request Date : Saturday, February 14th 2009 @ 08:21:14 PM
Error Date : Saturday, February 14th 2009 @ 08:21:15 PM
Script : http://my site.com/forum/admincp/plugin.php?do=productimport
Referrer : http://my site.com/forum/admincp/plugin.php?do=productadd
IP Address : xxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-community

how can i fix this plazz help thank you

That error is telling you that the video table already exists. MySQL will not "overwrite" tables that exist, you either have to uninstall the product and reinstall or manually remove the tables that got created from the previous install before the import will work. HTH