RC2 to RC3 Upgrading SQL error

I am running into this during the BoonEx Dolphin Upgrade Script routine:

"7.0.0.RC2-7.0.0RC3 upgrade can be applied

System SQL script was successfully executed

The following languages will be affected for system:

- en

Error

Database query error"

Is this a known issue?  I've tried restoring back to RC2 and upgrading again, same problem happens.

yes you are about the forth person with this problem.

I just want to add mine executed fine without any issues.  I know it doesn't help but it helps to know some are working fine and others are not.

I upgraded fine as well. No SQL errors at all. Not sure why some are having this problem either. No modifications were done to your RC2 database?

Chris

Also here no problems by upgrading to RC3.

No problems here, smooth upgrade

test.Bykespace.com/7

Have the same problem .

System SQL script was successfully executed

The following languages will be affected for system:

- en

Error

Database query error"

Any ideas why??

That's odd. Mine went smooth.  No error.. nothing. :-/

you think it depends on what browser you guys use?  I used firefox and it went good.  I dunno if that matters.

Have the same problem .

And now, 7.0.0.RC2-7.0.0.RC3 Update can not be applied, error

"7.0.0.RC2-7.0.0RC3 upgrade can be applied

System SQL script was successfully executed

The following languages will be affected for system:

- en

- ru

Error

Database query error"

My modifications:
- New Predefined Values
- Language phrases are added
- New Profile Fields

There are ideas?

Anybody come up with a solution for this?? Please help

Hmm.. OK.. How many of you are having this problme AND have another language besides English installed?

Chris

It is not important. Read above, for me two languages, one for kayex.

I think Chris is right, it seems the issue is on people with more than one language.  did you guys follow the special steps for language conversion before doing the upgrade?

Same problem here...

I got English and Swedish language installed, placed my translated lang_se.php in the upgrade/files/7.0.0.RC2-7.0.0.RC3/ folder

Used firefox to do the upgrade..

I only have one language.     Followed upgrade instructions.

Actually it is important:

NOTE: You can also update your custom language translations if you create the appropriate translated files for your custom language, BEFORE THE UPGRADE PROCESS, in upgrade/files/7.0.0.RC2-7.0.0.RC3/ and upgrade/files/7.0.0.RC2-7.0.0.RC3/modules/*/ directories. There are lang_en.php files by default in these directories. Create a translated copy of lang_en.php for your custom language. For example, if you have the Russian language installed you can add lang_ru.php files. Then all new language keys for your custom language will be added automatically.

@rhimpr did you change anything at all in your sql database?  Also did you start with RC and upgrade to RC2 and then to RC3 or where did you start in your site creation?

mauricecano,

   Did not change anything in sql database. Started with RC > RC2 > RC3.  Everything was good in RC2 (except few minor issues).

  Tried upgrading with firefox and IE same issue.   Im back to RC2 right now.

Thanks

I got the error with swedish language installed.

Restored my database from backup.

Removed swedish language

Upgraded succesfully.

Imported my swedish language file.

Looks like it is working, guess i have a couple of messed up language keys but that is an easy fix when i find them.

Check your server error logs if you have them and see if it shows anything for the problem with sql.  It won't matter which browser you use to perform the upgrade as your issue is with the sql tables themselves.

Zarcon, i know how to read for a long time, read all subject, even with one language an error.

Tech66, I was not doubting your ability to read, I was simply stating that it IS important when it comes to having additional languages. As you can see from Mikael K's post, it DID have something to do with his language files:

"

I got the error with swedish language installed.

Restored my database from backup.

Removed swedish language

Upgraded succesfully.

Imported my swedish language file.

Looks like it is working, guess i have a couple of messed up language keys but that is an easy fix when i find them."

Maybe you should try doing the same thing as he did. This time without the need of "smart" remarks. We are just trying to help everyone here.

Chris

Mauricecano,

This is the only error in server error logs;

[Fri Dec 11 21:05:14 2009] [error] [client 24.**.**.***] client denied by server configuration: /home/......../public_html/upgrade

Not sure if it has anything to do with it but, the only things we changed was lang keys about 3 days ago;

 _Cancel_Uploads>  Cancel Uploads

_adm_txt_mp_unconfirmed>  Unconfirmed

Thanks

rhimpr, Are you logged in as the admin before you try to run the upgrade script? Just wondering if that might have something to do with it possibly.

Chris

Zarcon,

I was not logged in but didn't delete cookies or cache the first time.   When I tried earlier today comp/cache was clean and got same issue.  

Thanks

@rhimpr double check your sql settings to ensure that the sql user name for your dolphin install has all the actions enabled and not jsut some of them.

It also could be the sql server itself is rejecting the connection from your computer in running the upgrade script.  call your host and see if there is anything they can do to help fix the connection issue.  I believe at this point there is a configuration on your server that is preventing the upgrade.

This way I did, does not work.

There was a similar issues with a previous dolphin upgrade(6.1 somewhere). It was quite some time ago now that it was posted, but it made reference to the "en" as well. I can't remember right off hand without spending some time digging for it, but it was something to do with commenting out a line or removing a comment line if I recall.

After just briefly looking at the upgrade folder there is a line that makes referrence to "en" in /upgrade/classes/BxDolUpgradeUtil.php

You might have a look see at that file and mess with the lines:

function _executeLangAdd ($sModule, $sLang = 'en') {
$sFile = BX_UPGRADE_DIR_UPGRADES . $this->sFolder . '/' . ($sModule ? 'modules/' . $sModule . '/' : '') . 'lang_' . $sLang . '.php';
if (!file_exists($sFile))
return true; // just skip if language file is not found


etc. etc.


Anyway just a thought and something to have a peek at. Back then it was something to do with en and sql. It's in the blog posts somewhere for previous 6.1 upgrades somewhere just don't remember where off hand. Could be something all together different for that matter. Could be your setup, or a number of things really.

Will look into that as well. Still trying to figure it out. Anybody have any luck,  that has the same issue?

Thank

All fine and dandy with my upgrade. Sweet as chocolate

Mighty fine work by the Boonex team here.

Special shout to Zarcon - he is top guy and very very helpful. Geezer, if you ever in UK hook me up for that beer I owe you!

Regs

Simon

ps - off to play with RC3 - which I have issues with!!!

This is what I get into my email

Found error in the file '/home/xxxxxx/public_html/inc/utils.inc.php' at line 620.
Called 'db_res' function with erroneous argument #0.

Can not reproduce database error during upgrade script, please PM me with you server access detail to check it on your site. I need ftp, dolphin admin panel and phpMyAdmin or site cPanel access.

I only have 1 language (EN).. but I do have custom predefined values / language keys added - they all vanished upgrading from RC to RC2. Perhaps this is causing some sort of problem from RC2 -> RC3.

It looks like you have incorrectly added your custom language changes, you need to make all changes through admin interface. If you make changes in langs/lang-*.php files directly, all changes will be lost after language file recompilation. Recompilation may occur even in background for example during some module installation/uninstallation.

No, I did add them properly through the admin panel. I have never made any manual changes in any of the language files. I reported the missing languages in last RC update and was told it was a known issue.

FYI.. I rolled back to RC1 (had all my custom fields/languages back) and tried upgrading using the latest RC3 package... Went through the upgrade process, it gave the option to go RC2 (7.0.0RC-7.0.0.RC2). Selected "UPGRADE" beside it, it failed with the same error as going from RC2->RC3.  Went back to the upgrade page again and now I have 7.0.0RC2-7.0.0.RC3 "Available"... hitting "UPGRADE" on that produces the same errors as initially reported and the previous upgrade.

Can you provide access to your site via PM to check this problem, because it can not be reproduced locally ?

I need ftp, dolphin admin panel and phpMyAdmin or site cpanel access.

Just restore back to RC1 .. and I will try to upgrade to RC2 and then to RC3 and see what will happen

Yes, absolutely. I've forwarded you the details in PM

The problem was when language keys were added manually before upgrade into language category other than 'system':

http://www.boonex.com/trac/dolphin/ticket/1623

Thank you kayex for providing server access info to investigate the problem.

If you want to try upgrade before next RC, apply the following changes before upgrading:

http://www.boonex.com/trac/dolphin/changeset/13449

Confirmed. Upgrade now works with above changes.  My custom languages are still missing however, will these come back in a future RC upgrade, or do I need to redo them?

Upgrade script don't delete any existing lang keys, unless it tries to add the same ones., then it will try to correct it.

The only theoretical problem maybe because of language categories, please try to add your custom language keys to system category only ...

OK.  I was able to see all the predefined lists/values that were created before. I selected one of them and just pressed "Save" without making any changes.  This seems to have resolved the issue with missing languages. All the values are now visible in the front-end.