Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #11  
Old 07-29-2012, 11:54 AM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to run this query:

Code:
ALTER TABLE  `language` ADD  `phrasegroup_global` MEDIUMTEXT NULL DEFAULT NULL AFTER  `thousandsep`
EDIT- borbole beat me to it. :up:

I included the code to put it in the same location it used to be even though there is probably no reason that is necessary.
Reply With Quote
  #12  
Old 07-29-2012, 11:54 AM
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Posts: 281
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just did that this the result i got:
#1060 - Duplicate column name 'phrasegroup_global'

Quote:
Originally Posted by borbole View Post
You are using it wrong. You should run the following code. Copy/paste it in the sql box in the phpmyadmin at the db that your forum resides on.

Code:
 ALTER TABLE `language` ADD `phrasegroup_global` mediumtext;

If you use a custom prefix for your db tables, append it to the table name in the query above.
Reply With Quote
  #13  
Old 07-29-2012, 11:57 AM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you sure you are working the same database that your forum is running off of?
Reply With Quote
  #14  
Old 07-29-2012, 12:03 PM
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Posts: 281
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes is my forum Database.

--------------- Added [DATE]1343567383[/DATE] at [TIME]1343567383[/TIME] ---------------

any recommendation please...
Reply With Quote
  #15  
Old 07-29-2012, 12:13 PM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm stumped.

The error clearly says the column doesn't exist- at least from what vBulletin sees.

You MySQL error trying to run the ALTER command clearly says the column does exist.

And if you are sure it is the same database... I don't know what would cause this to happen.
Reply With Quote
  #16  
Old 07-29-2012, 12:21 PM
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Posts: 281
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks so much for trying to help. i have contacted vbulletin but no feedback from them yet.
Am stuck don't no what to do.
Reply With Quote
  #17  
Old 07-29-2012, 12:22 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Indeed. The op is reporting conflicting messages. Make sure to run the query at the SQL box for the db that your forum with the db error resides on.
Reply With Quote
  #18  
Old 07-29-2012, 12:35 PM
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Location: USA
Posts: 10,929
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can verify that it is indeed in there, here is a screenshot:

Reply With Quote
  #19  
Old 07-29-2012, 12:38 PM
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Posts: 281
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just Run SQL query on SQL box, on my Forum SQL db where my forum reside.
ALTER TABLE `language` ADD `phrasegroup_global` mediumtext;

Result
#1060 - Duplicate column name 'phrasegroup_global'

Do you mind i pm you my login details so you could help resolve the problem?

--------------- Added [DATE]1343569371[/DATE] at [TIME]1343569371[/TIME] ---------------

wow thanks.. ok please help to correct the error.
Quote:
Originally Posted by ozzy47 View Post
I can verify that it is indeed in there, here is a screenshot:

Reply With Quote
  #20  
Old 07-29-2012, 12:44 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by felixkomo View Post
I just Run SQL query on SQL box, on my Forum SQL db where my forum reside.
ALTER TABLE `language` ADD `phrasegroup_global` mediumtext;

Result
#1060 - Duplicate column name 'phrasegroup_global'
Then the db error you posted doesn''t make much sense if it is reporting that field missing when in fact that field exists. That is if it is indeed in the right db.

But if you submitted a ticket at your vb customer area then wait until the vb staff can have a look and see what is really going on.


Quote:
Originally Posted by felixkomo View Post

Do you mind i pm you my login details so you could help resolve the problem?
You can pm me the details but I provide paid services only.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:26 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04402 seconds
  • Memory Usage 2,280KB
  • Queries Executed 14 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)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_postinfo_query
  • fetch_postinfo
  • 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