vBadvanced CMPS is disabled in your vBulletin Installed Products section.

[Brian]

You should be able to run this query to add the product:

		INSERT INTO " . TABLE_PREFIX . "product
			(productid, title, description, version, active)
		VALUES (
			'adv_cmps',
			'vBadvanced CMPS',
			'vBadvanced Content Management & Portal System',
			'4.1.2',
			1
	)

[Joe Blow]

Hi Brian,

Many thanks for your help!!!

I tried to execute that query from the vBulletin admincp and got the following message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "product
(productid, title, description, version, active)' at line 1

I am running PHP 5.2.17 and MySQL 5.1.58

Any ideas?

[Joe Blow]

Hi Brian, I got it to work by executing the following query:

INSERT INTO product
			(productid, title, description, version, active)
		VALUES (
			'adv_cmps',
			'vBadvanced CMPS',
			'vBadvanced Content Management & Portal System',
			'4.1.2',
			1
	)

[karlm]

I've got the same problem... Running current VBA & most recent VB.

Does one of the above queries work still?

[Brian]

Yes, the above query would still work if the CMPS is not showing up as an installed product.

[karlm]

Which one, please?

[kmacinct]

Where and how does one 'execute a query'

[Brian]

http://www.vbulletin.com/docs/html/m...ntenance_query