PDA

View Full Version : hwlp I can't modify the options!!


nnjj.net
08 Apr 2005, 15:17
hello

after upgrading going fine to 2.3, I had this error when I try to save the changes on the admincp

Database error in vBulletin 3.0.3:

Invalid SQL: update vbchat_datastore set d_online='yes',d_allowbbcode='yes',d_chat_order='bottom',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
08 Apr 2005, 15:25
Did you run the upgrader? If so it seems you have missed an update somewhere, run this query:

alter table vbchat_datastore
add `d_smilequery` tinyint(2) not null default '1';

- Zero Tolerance

nnjj.net
08 Apr 2005, 15:29
I did run it

I had another one now

Database error in vBulletin 3.0.3:

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

mysql error number: 1054

I think something going wrong when I run the upgrade of the database, because the upgrade didn't say anything about this! not like the previous upgrads :s

Zero Tolerance
08 Apr 2005, 15:34
Run this:

alter table vbchat_datastore
add `d_autoprune` tinyint(2) not null default '1';

You may get another error after running this one, but eventually it will work, lol.

- Zero Tolerance

nnjj.net
08 Apr 2005, 15:40
oh my God, its still not working the error this time is:

Database error in vBulletin 3.0.3:

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

mysql error number: 1054




can you tell me what queries I shall run all :(

Zero Tolerance
08 Apr 2005, 15:51
Run:
alter table vbchat_datastore
add `d_autoprunedays` int(15) not null default '1';

If an error still occurs let me know :)

- Zero Tolerance

nnjj.net
08 Apr 2005, 16:03
its working now and I turn it on, but when I try to write something nothing appear! its just keep on refreshing but nothing appear?!

Zero Tolerance
08 Apr 2005, 16:11
What browser are you using, it works in IE/Netscape/Firefox, others are unknown at this time, apart from Safari, it doesn't work in that.

Ensure you're not trying to reply when it's loading, some users on slow connections/slow pc's can suffer from lag.

- Zero Tolerance

nnjj.net
08 Apr 2005, 16:18
I am using IE, and I was waiting alot 10 mins. but nothing

I also I did Ensure that I am not trying to reply when it's loading but also nothing

if you would like to test be my guest :)

http://www.nnjj.net/vb

any ideas ?! :(

where are you Zero :(

Kalomax
16 Apr 2005, 22:49
Database error in vBulletin 3.0.7:

Invalid SQL: select d_groupperms,d_bannedgroups from lxit_vbchat_datastore where did='1'
mysql error: Unknown column 'd_groupperms' in 'field list'

mysql error number: 1054

I got this errwhen i try to access Usergroup Permissions in admincp
How do i fix it ?

nnjj.net
20 Apr 2005, 09:37
no comments!

Deepdog009
03 May 2005, 21:09
Database error in vBulletin 3.0.7:

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

mysql error number: 1054


Where be fix???

Sophocles
13 Jul 2005, 21:34
I know that some of you have resolved this and if so how. This occurred while upgrading to vbChat 2.3


Database error in vBulletin 3.0.7:

Invalid SQL: update vbchat_datastore set d_online='no',d_allowbbcode='yes',d_chat_order='bottom',d_smiliedisplay='1',d_sm ilieamount='10',d_allowbantag='1',d_maxrooms='5',d_smilequery='1',d_autoprune='1 ',d_autoprunedays='1',d_roomprune='1' where did='1'
mysql error: Unknown column 'd_roomprune' in 'field list'

mysql error number: 1054