OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



upgrade 2.4.2->2.4.3 error

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

upgrade 2.4.2->2.4.3 error

Postby gdardick » Tue Jan 28, 2014 11:09 pm

system windows 2008
MySQL 5.6.13
PHP 5.5.1
OJS 2.4.2

When I try to upgrade to 2.4.3 from 2.4.2 by setting Installed=Off and going to the website and selecting upgrade, I get the following:
Errors occurred during installation:
- A database error has occurred: Incorrect string value: '\xD0\x9D\xD0\xB5\xD0\xBE...' for column 'subject' at row 1

nothing upgraded.

Any suggestions?
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby asmecher » Tue Jan 28, 2014 11:13 pm

Hi gdardick,

Are you using the same database information (e.g. connection character set and database character set) in the 2.4.3 version as you used for the 2.4.2 version? Are these configured for UTF8?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 9060
Joined: Wed Aug 10, 2005 12:56 pm

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Tue Jan 28, 2014 11:22 pm

It is a MySQL innodb schema with a utf8 char set. it was/is a 2.4.2 database that is being upgraded. I have not created a 2.4.3 database as I assumed that the upgrade procedure would do that.
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Tue Jan 28, 2014 11:27 pm

one other curious note: I have also tried patching the upgrade as well as overwriting the entire install - in both cases I notice that the installation/website then tries to execute pages with a double slash:
http://websiteURL//directory/page.php

This may of course be an entirely different issue - which is why I tried to do the other type of upgrade instead (after restoring back to version 2.4.2.
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby asmecher » Tue Jan 28, 2014 11:57 pm

Hi gdardick,

OK, but are the configuration settings in your 2.4.3 config.inc.php the same as your 2.4.2 installation with respect to character sets?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 9060
Joined: Wed Aug 10, 2005 12:56 pm

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Wed Jan 29, 2014 4:02 am

there is only one directory. It is currently containing the 2.4.2 system and the config.inc.php

There is no second directory or config.inc.php file for the 2.4.3 system

The upgrade is supposed to be done in-place.
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Thu Jan 30, 2014 1:14 am

I did locate the problem regarding the double slash (or backslash) problem.
http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=11409

So I am still back to my original problem.

I upgrade the code (I have tried patching and replacing).
Then I change the config to Install=Off
Then I try to Upgrade the database.
That is where I get the subject/row 1 error message.
So currently stuck on 2.4.2.
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Thu Jan 30, 2014 2:15 am

Would anybody know if this is a password problem? The password works under 2.4.2. But the only info I found on the Internet that looks like that string error is when there is an authentication problem.

Could the upgrade process be authenticating differently?
Do I need to store the passwords differently in the MySQL DB?
Do I need to give the userid more rights than just those to the OJS schema?
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby asmecher » Fri Jan 31, 2014 4:33 pm

Hi gdardick,

Can you try the following?
  • Restore your DB from backup before the upgrade was attempted
  • Turn on the "debug" option in config.inc.php
  • Run the upgrade
  • Find the last SQL entries logged before the error and post them here
This will help me debug further.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 9060
Joined: Wed Aug 10, 2005 12:56 pm

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Fri Jan 31, 2014 5:22 pm

(mysql): INSERT INTO email_templates_default_data (email_key, locale, subject, body, description) VALUES ('PAYPAL_INVESTIGATE_PAYMENT', 'ru_RU', 'Необычная активность PayPal', 'Система OJS обнаружила необычную активность, свящанную с поддержкой платежей в системе PayPal для журнала {$journalName}. Может потребоваться внимание и вмешательство в ручном режиме.\n\nПисьмо было сгенерировано модулем платежей PayPal.\n\nПолная информация о запросе:\n{$postInfo}\n\nДополнительная информация (если указана):\n{$additionalInfo}\n\nПеременные сервера:\n{$serverVars}', '')
--------------------------------------------------------------------------------
1366: Incorrect string value: '\xD0\x9D\xD0\xB5\xD0\xBE...' for column 'subject' at row 1
ADOConnection._Execute(INSERT INTO email_templates_default_data
(email_key, locale, subject, body, description)
VALUES
('PAYPAL_INVESTIG..., false) % line 864, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO email_templates_default_data
(email_key, locale, subject, body, description)
VALUES
('PAYPAL_INVESTIG...) % line 452, file: Installer.inc.php
Installer.executeSQL(INSERT INTO email_templates_default_data
(email_key, locale, subject, body, description)
VALUES
('PAYPAL_INVESTIG...) % line 447, file: Installer.inc.php
Installer.executeSQL(Array[2]) % line 623, file: PKPPlugin.inc.php
PKPPlugin.installEmailTemplateData(Installer::postInstall, Array[2]) % line 0, file:
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am

Re: upgrade 2.4.2->2.4.3 error

Postby gdardick » Fri Jan 31, 2014 6:20 pm

well - that did it ... kind of.

Apparently it is a UTF problem with the database but only with the PayPal table. So I emptied out the paypal\locale directory and everything is good for now ... until I need to use PayPal.

(Thanks asmecher for the help! - I should have thought to turn on Debugging earlier)
gdardick
 
Posts: 29
Joined: Sun Sep 13, 2009 3:58 am


Return to OJS Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 13 guests