error in chat options

[boysmom]

Under vbchat options in the control panel, when we push "save vbchat options," we get the following error:

Database error in vBulletin 3.0.3:

Invalid SQL: update vbchat_datastore set d_online='yes',d_allowbbcode='yes',d_chat_order='b ottom',d_smiliedisplay='1',d_smilieamount='10',d_a llowbantag='1',d_maxrooms='5',d_smilequery='0',d_a utoprune='1',d_autoprunedays='1',d_roomprune='1' where did='1'
mysql error: Unknown column 'd_roomprune' in 'field list'

mysql error number: 1054

Date: Wednesday 02nd of March 2005 01:54:53 PM
Script: http://www.storknotes.com/admincp/admin_vbchat.php
Referer: http://www.storknotes.com/admincp/admin_vbchat.php

***********************

Any idea which file might have the error?

Thanks

[Zero Tolerance]

It appears you didn't run an upgrade, the room prune option was established in v2.2, so it means you didn't do the upgrade from v2.1 -> v2.2

Run it, look in the archived versions for the upgrader.

- Zero Tolerance

[boysmom]

This was supposed to be a fresh install of v2.3 but I didn't do it.

So do I run the installer from v2.1? I tried that and got an error. Yikes. This is getting messy.

[Zero Tolerance]

Run this query:
alter table vbchat_datastore
add `d_roomprune` int(15) not null default '0';

If any more errors occur, paste them here :)

- Zero Tolerance

[boysmom]

Thanks! We have it fixed now.

[nnjj.net]

I have the same problem and when I tried to run the query, thats what I got
Error
SQL-query:

ALTER TABLE vbchat_datastore ADD `d_roomprune` int( 15 ) NOT NULL default '0'
MySQL said:

#1060 - Duplicate column name 'd_roomprune'

Database error in vBulletin 3.0.3:

Invalid SQL: update vbchat_datastore set d_online='yes',d_allowbbcode='yes',d_chat_order='b ottom',d_smiliedisplay='0',d_s milieamount='10',d_allowbantag='1',d_maxrooms='5', d_smilequery='0',d_autoprune=' 0',d_autoprunedays='0',d_roomprune='1' where did='1'
mysql error: Unknown column 'd_smilequery' in 'field list'

mysql error number: 1054

[Zero Tolerance]

You have a different error, i replied to it in the other thread. :)

- Zero Tolerance

[nnjj.net]

thanks alot Zero :)