The Arcive of Official vBulletin Modifications Site.

hwlp I can't modify the options!! · **Released**: 04-08-2005

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

Zero Tolerance · #2 04-08-2005, 01:25 PM

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

nnjj.net · #3 04-08-2005, 01:29 PM

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

Zero Tolerance · #4 04-08-2005, 01:34 PM

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

nnjj.net · #5 04-08-2005, 01:40 PM

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

Zero Tolerance · #6 04-08-2005, 01:51 PM

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

nnjj.net · #7 04-08-2005, 02:03 PM

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 · #8 04-08-2005, 02:11 PM

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 · #9 04-08-2005, 02:18 PM

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 · #10 04-16-2005, 08:49 PM

Quote:

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 ?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05926 seconds Memory Usage 2,287KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!