![]() |
hwlp I can't modify the options!!
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='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 |
Did you run the upgrader? If so it seems you have missed an update somewhere, run this query:
[sql]alter table vbchat_datastore add `d_smilequery` tinyint(2) not null default '1';[/sql] - Zero Tolerance |
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='b ottom',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 |
Run this:
[sql]alter table vbchat_datastore add `d_autoprune` tinyint(2) not null default '1';[/sql] You may get another error after running this one, but eventually it will work, lol. - Zero Tolerance |
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='b ottom',d_smiliedisplay='0',d_smilieamount='10',d_a llowbantag='1',d_maxrooms='5',d_smilequery='1',d_a utoprune='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 :( |
Run:
[sql]alter table vbchat_datastore add `d_autoprunedays` int(15) not null default '1';[/sql] If an error still occurs let me know :) - Zero Tolerance |
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?!
|
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 |
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 :( |
Quote:
How do i fix it ? |
no comments!
|
Database error in vBulletin 3.0.7:
Invalid SQL: update vbchat_datastore set d_online='yes',d_allowbbcode='yes',d_chat_order='b ottom',d_smiliedisplay='1',d_smilieamount='6',d_al lowbantag='1',d_maxrooms='5',d_smilequery='1',d_au toprune='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??? |
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='bo ttom',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 |
All times are GMT. The time now is 05:02 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|