[stuie_b]

Originally Posted by EdQ

Installing over it didn't work.
This is when I tried to promote an Article

PHP Code:

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE xxx_cms_node SET agelock='', agelock_method='',agelock_age='' WHERE nodeid='135';

MySQL Error   : Unknown column 'agelock' in 'field list' 


So I tried to uninstall and got this

PHP Code:

Database error in vBulletin 4.1.5:

Invalid SQL:
ALTER TABLE xxx_forum DROP `agelock` ,
DROP `agelock_parent` ,
DROP `agelock_method` ,
DROP `agelock_age`;

MySQL Error   : Can't DROP 'agelock'; check that column/key exists 


Both errors are because agelock isn't installed correctly, the fields necessary for agelock to function dont exist.

If you have access to phpmyadmin manually confirm this before trying the following. (Making sure that all agelock fields dont exist! - forum,blog,cms_node)
If they dont exist you have 2 options


* Edit the agelock product in vb and remove the uninstall code, then uninstall agelock before installing agelock with "product-aglk35b (CMS Edition).xml"

-or-

* Re-create the fields via phpmyadmin using the sql code below. (replacing " . TABLE_PREFIX . " with your tables prefix)

ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock_parent INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock_method INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock_age varchar(10);

ALTER TABLE " . TABLE_PREFIX . "blog ADD agelock INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "blog ADD agelock_method INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "blog ADD agelock_age varchar(10);

ALTER TABLE " . TABLE_PREFIX . "cms_node ADD agelock INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "cms_node ADD agelock_method INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "cms_node ADD agelock_age varchar(10);

If they do exist
* Check all the agelock fields exist (forum,blog,cms_node)

If it is missing the fields on certain tables you can either

* Remove the fields from the tables that do have the fields and then perfom option 1 from above

* Re-create the missing fields using the SQL code above.

None of the fields exist on any tables

* Edit the agelock product in vb and remove the uninstall code, then uninstall agelock before installing agelock with "product-aglk35b (CMS Edition).xml"

If you opt to re-create the fields then agelock will function as it should, However to prevent any issues elsewhere i would recommend re-installing age lock using "product-aglk35b (CMS Edition).xml"

Stuie