[ccampo]

Originally Posted by Junkie

I'm getting a database error when importing the product

Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `ffbg_cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : CREATE VIEW command denied to user 'database_username'@'localhost' for table 'ffbg_cp_cats'
Error Number : 1142
Request Date : Saturday, March 27th 2010 @ 08:47:01 PM
Error Date : Saturday, March 27th 2010 @ 08:47:01 PM
Script : http://www.mydomain.com/testforum/ad...=productimport
Referrer : http://www.mydomain.com.com/testforu...?do=productadd
IP Address : my.ip.address
Username : my_username
Classname : vB_Database
MySQL Version : 5.0.90-community

Some web hosting providers revoke the "create view" privileges from users.
Talk to your web hosting providers and see if they can fix that for you.

Otherwise you can do that yourself, you just need to give your MySQL user the GRANT privilege like so.

GRANT CREATE VIEW ON *.* TO 'database_username'@'localhost' ;

You will need to be logged on as root or the main database user to do this.