vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Invalid SQL Data Base error on Admincp and forum (https://vborg.vbsupport.ru/showthread.php?t=286061)

BirdOPrey5 07-29-2012 11:54 AM

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.

Naijasite 07-29-2012 11:54 AM

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

Quote:

Originally Posted by borbole (Post 2352339)
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.


BirdOPrey5 07-29-2012 11:57 AM

Are you sure you are working the same database that your forum is running off of?

Naijasite 07-29-2012 12:03 PM

Yes is my forum Database.

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

any recommendation please...

BirdOPrey5 07-29-2012 12:13 PM

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.

Naijasite 07-29-2012 12:21 PM

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.

borbole 07-29-2012 12:22 PM

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.

ozzy47 07-29-2012 12:35 PM

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

https://vborg.vbsupport.ru/

Naijasite 07-29-2012 12:38 PM

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 (Post 2352366)
I can verify that it is indeed in there, here is a screenshot:

http://www.myfriendsspace.com/imageh...53beed336c.png


borbole 07-29-2012 12:44 PM

Quote:

Originally Posted by felixkomo (Post 2352368)
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 (Post 2352368)

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.


All times are GMT. The time now is 03:17 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01132 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete