Database Error ( please help me )

[MalluParadise]

Hey guys

Before 2 month ago, i just upgrade my forum 3.7.2 to 3.8.2 , Last weak i try to add sum Plugins & Products then it's showing like this

Database error in vBulletin 3.8.2:

Invalid SQL:
DELETE FROM faq WHERE product = 'welcomepm' AND volatile = 1;

MySQL Error : Unknown column 'product' in 'where clause'
Error Number : 1054
Request Date : Monday, June 1st 2009 @ 09:21:51 PM
Error Date : Monday, June 1st 2009 @ 09:21:52 PM
Script : http://www.xxxxxxx......../forums/admincp/plugin.php?do=productimport
Referrer : http://www..................../forums/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.75-community-log

when i try to go in FAQ it's showing same database error. I think , it's have sum problem in my SQL. i don't want to lose any post or my members!! if any one able to help me! that will be great thing.please help me...... Sorry for my bad english!!

--------------- Added 1243915028 at 1243915028 ---------------

please help me!!!!

[josh2007]

seems that a product has messed something up. try to remove your product files from the system. Access your FTP and go to the /forums/includes/xml and remove the "welcomepm" product or any file related to that

before you do that be sure to disable/uninstall from admincp product manager

[Dismounted]

You'll want to open a support ticket over @ vB.com, as the issue (so far) looks complicated and probably can only be fixed with someone going into the database.

[MalluParadise]

You'll want to open a support ticket over @ vB.com, as the issue (so far) looks complicated and probably can only be fixed with someone going into the database.

sure if they can fix that prob for me i will ,.. i don't any thing about SQL things. if i did anything happen wrong i will lose my data in site also members . i need sum one know how to do these thing please tell the process to make ticket and sorry for my bad English thank you !!!

[Lynne]

Here's a link to the Support Ticket System (http://members.vbulletin.com/membersupport_contactform.php). You will need your customer number to get into the members area.

[MalluParadise]

Here's a link to the Support Ticket System. You will need your customer number to get into the members area.
yea sure i will do it my VBulletin is 100% lincensed

--------------- Added 1244162225 at 1244162225 ---------------

i made ticket out they just give sum thing tell me to add ......... when i try to do that it's showing when i try to do that ...it's showing like this

Error
SQL query:

ALTER TABLE faq ADD product VARCHAR( 25 ) NOT NULL DEFAULT ''

MySQL said:

#1060 - Duplicate column name 'product'

[MalluParadise]

If any one able to do this............ we will pay for $ 40 USD to them so please fix for me!!!

[Guest210212002]

Do you still get the error if you disable the plugin system?

[Lynne]

If any one able to do this............ we will pay for $ 40 USD to them so please fix for me!!!
You should post in the Paid Requests forum if you wish to offer money to get this fixed.

[MalluParadise]

You should post in the Paid Requests forum if you wish to offer money to get this fixed.

where is paid request forum? please fix my databse ....... ..no one is help me !!! :(:(:(:(

[Lynne]

where is paid request forum? please fix my databse ....... ..no one is help me !!! :(:(:(:(
Requests For Paid Services (https://vborg.vbsupport.ru/forumdisplay.php?f=30)

[puertoblack2003]

Do you still get the error if you disable the plugin system?



that's not going to help.It's complicated and no one would like to do it.You missing that table product.Best way is, if you have any backup re-import it.

[MalluParadise]

i fix this ..... thing thanx 4 every one help!!