Missing DB field after upgrade to v2

[slavetothename]

I just upgraded, twice over, and get the same error. Perhaps this is an issue due to my blog being a vBlogetin conversion.

The jist of the error message is:

MySQL Error : Unknown column 'language.phrasegroup_vbblogcat' in 'field list'

You can find it here: www.dragonninja.co.uk/blogs

How can I create the column with the required contents?

Thanks!

[Steve Machol]

Did you remove or rename the vbolgetin tables before installing the Blog? By default they have the same table prefix that we use.

[Tigratrus]

I ran into the same problem on our testbed. All sorts of DB inconsistencies and problems. And you can't run the upgrade a second time as it fails if the tables it wants to create are already there, or if the changes it wants to make to existing tables have already been made.

We too are running a vBlog DB that had data pulled in from vBlogetin via Impex. And yes, all vBlogetin tables were renamed/removed. We're up and running fine on vBlog 1.05, though impex left some orphan records behind.

I think it might be a good idea to have a DB validation tool that can be run before you try and upgrade? The vBlog 2.0 B3 upgrade process makes a *LOT* of DB changes, and if it doesn't work perfectly the first time you appear to be up the proverbial creek... That's why I always do upgrades on the testbed first .

BTW, I did put a bug report in on what we saw as a heads up to Freddie. Will follow-up with a more detailed breakdown once I have a chance to rebuild the testbed, it's gotten out of sync with the live site.

James and Susan

[Freddie Bingham]

Did you do a new install of beta 3? I think I see what the problem is.

Run this query:

ALTER TABLE language ADD phrasegroup_vbblogcat MEDIUMTEXT

[slavetothename]

I stopped using vBlogetin almost a year ago, as far as I know all traces of that are long gone.

It was an upgrade to Beta 3 from the latest stable 1.x version. Should I still run the query Freddie?

[Yves Rigaud]

You should do

[dodgeboard.com]

Unknown column 'language.phrasegroup_vbblogcat' in 'field list'

I had the same problem, ran the query, and that fixed it. Never had vBlogoten.

Thanks Freddie!

VB 3.7.3
Blog v2.0.0 b3

[Tigratrus]

Sorry I didn't get back to this earlier, took a while to get the testbed rebuilt, then something went south and I got to do it again!

Anyway, the query worked for us too.

::thumbs up::

Now to start playing with it so we can get a feel for it... Thanks Freddie!

James and Susan

[Frogfish]

I tried to run the Run thequery:
but got thiss error message:

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1146 
error desc: Table 'mysite_no3.language' doesn't exist

upgraded from latest stable relase to Blog v2.0.0 b3 I am running Vb 7.3
I had no error messages before the upgrade.

[Steve Machol]

Sounds like you are using a table prefix and you need to add that prefix to the query.

[Frogfish]

Could you leed me in the right direction?

This is the error I get when using the blog

Invalid SQL:

					SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM vb_language
					WHERE languageid = 5;

MySQL Error   : Unknown column 'phrasegroup_vbblogcat' in 'field list'
Error Number  : 1054

If I try to run this Quiery:
ALTER TABLE language ADD phrasegroup_vbblogcat MEDIUMTEXT
I get this error message..

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1146 
error desc: Table 'mysite_no3.language' doesn't exist

Where do i need to search to find the correct table prefix that i am suposed to miss?

[Yves Rigaud]

Run this query:

ALTER TABLE vb_language ADD phrasegroup_vbblogcat MEDIUMTEXT

[Frogfish]

Run this query:

ALTER TABLE vb_language ADD phrasegroup_vbblogcat MEDIUMTEXT

That did it!
Thank you very much!

[slavetothename]

Sorry for the delay in stopping by again. I just ran the query and it worked for me too. Thanks so much.

[barroca]

Unfortunately don't works in my install
the sql returns

Um erro ocorreu enquanto tentava executar sua consulta. A seguinte informação foi retornada.
número do erro: 1146
descrição do erro: Table 'xtrad_vb2.vb_language' doesn't exist

the blogs section is offline!

if you can help ... tks!
joao barroca