OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Abstract Despair in Edit Metadata

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.

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 3:43 am

Dear Alec,

I run the query that you mentioned and got locale table with en_US text there's no empty field and there are 17 IDs.

As I can't revert the database to old, can you please tell me another solution.


Thanks
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 8:25 am

Hi Ubaid,

Can you post the results of the queries?

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

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 8:35 am

Dear Alec,

Here is the result, hope you were talking about this:

SELECT journal_id, primary_locale
FROM journals
LIMIT 0 , 30
[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


journal_id primary_locale
1 en_US
2 en_US
3 en_US
4 en_US
5 en_US
6 en_US
8 en_US
9 en_US
10 en_US
11 en_US
12 en_US
13 en_US
14 en_US
15 en_US
16 en_US
17 en_US


Your SQL query has been executed successfully
SELECT journal_id, setting_value
FROM journal_settings
WHERE setting_name LIKE '%Locales'
LIMIT 0 , 30
[ Inline ] [ Edit ] [ Create PHP Code ]


journal_id setting_value
1 a:1:{i:0;s:5:"en_US";}
1 a:1:{i:0;s:5:"en_US";}
1 a:1:{i:0;s:5:"en_US";}
2 a:1:{i:0;s:5:"en_US";}
2 a:1:{i:0;s:5:"en_US";}
2 a:1:{i:0;s:5:"en_US";}
3 a:1:{i:0;s:5:"en_US";}
3 a:1:{i:0;s:5:"en_US";}
3 a:1:{i:0;s:5:"en_US";}
4 a:1:{i:0;s:5:"en_US";}
4 a:1:{i:0;s:5:"en_US";}
4 a:1:{i:0;s:5:"en_US";}
5 a:1:{i:0;s:5:"en_US";}
5 a:1:{i:0;s:5:"en_US";}
5 a:1:{i:0;s:5:"en_US";}
6 a:1:{i:0;s:5:"en_US";}
6 a:1:{i:0;s:5:"en_US";}
6 a:1:{i:0;s:5:"en_US";}
8 a:1:{i:0;s:5:"en_US";}
8 a:1:{i:0;s:5:"en_US";}
8 a:1:{i:0;s:5:"en_US";}
9 a:1:{i:0;s:5:"en_US";}
9 a:1:{i:0;s:5:"en_US";}
9 a:1:{i:0;s:5:"en_US";}
10 a:1:{i:0;s:5:"en_US";}
10 a:1:{i:0;s:5:"en_US";}
10 a:1:{i:0;s:5:"en_US";}
11 a:1:{i:0;s:5:"en_US";}
11 a:1:{i:0;s:5:"en_US";}
11 a:1:{i:0;s:5:"en_US";}
12 a:1:{i:0;s:5:"en_US";}
12 a:1:{i:0;s:5:"en_US";}
12 a:1:{i:0;s:5:"en_US";}
13 a:1:{i:0;s:5:"en_US";}
13 a:1:{i:0;s:5:"en_US";}
13 a:1:{i:0;s:5:"en_US";}
14 a:1:{i:0;s:5:"en_US";}
14 a:1:{i:0;s:5:"en_US";}
14 a:1:{i:0;s:5:"en_US";}
15 a:1:{i:0;s:5:"en_US";}
15 a:1:{i:0;s:5:"en_US";}
15 a:1:{i:0;s:5:"en_US";}
16 a:1:{i:0;s:5:"en_US";}
16 a:1:{i:0;s:5:"en_US";}
16 a:1:{i:0;s:5:"en_US";}
17 a:1:{i:0;s:5:"en_US";}
17 a:1:{i:0;s:5:"en_US";}
17 a:1:{i:0;s:5:"en_US";}
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 9:47 am

Hi Ubaid,

That looks at a glance as it should. Can you clarify whether or not your modifications affected core OJS source code?

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

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 10:09 am

Dear Alec,

No it didn't affected in core OJS source code. I only add some divs and css and nothing else.


Thanks
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 10:28 am

Hi Ubaid,

Please execute the following queries to set all abstract and title locales to English:
Code: Select all
UPDATE article_settings SET locale='en_US' WHERE setting_name = 'title' OR setting_name = 'abstract' OR setting_name = 'cleanTitle';
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8910
Joined: Wed Aug 10, 2005 12:56 pm

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 10:46 am

Dear Alec,

I have run the query it affected few rows, but the issue is still.

I run the query in my local machine's backup.


Thanks
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 11:00 am

Hi Ubaid,

What do you get for the following query:
Code: Select all
SELECT * FROM versions;
Thanks,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8910
Joined: Wed Aug 10, 2005 12:56 pm

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 11:19 am

Dear Alec,

I got this after mentioned query:

Full texts major minor revision build date_installed current product_type product product_class_name lazy_load sitewide
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.auth ldap 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks donation DonationBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks help HelpBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks role RoleBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks notification NotificationBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks keywordCloud KeywordCloudBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks user UserBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks relatedItems RelatedItemsBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks subscription SubscriptionBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks information InformationBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks readingTools ReadingToolsBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks navigation NavigationBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks authorBios AuthorBiosBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks developedBy DevelopedByBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks languageToggle LanguageToggleBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.blocks fontSize FontSizeBlockPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats apa 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats mla 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats refWorks 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 0 plugins.citationFormats abnt 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats bibtex 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats cbe 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats proCite 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats endNote 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats turabian 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.citationFormats refMan 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.gateways resolver 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.gateways metsGateway 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic googleAnalytics GoogleAnalyticsPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic referral ReferralPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 0 plugins.generic openAIRE OpenAIREPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic announcementFeed AnnouncementFeedPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic translator TranslatorPlugin 1 1
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic thesisFeed ThesisFeedPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic tinymce TinyMCEPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic phpMyVisites PhpMyVisitesPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 2 0 0 2012-11-22 10:56:48 1 plugins.generic staticPages StaticPagesPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic webFeed WebFeedPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic booksForReview BooksForReviewPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic customLocale CustomLocalePlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic roundedCorners RoundedCornersPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic sehl SehlPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic sword SwordPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic thesis ThesisPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic xmlGalley XmlGalleyPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic openAds OpenAdsPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 1 0 0 2012-11-22 10:56:48 1 plugins.generic customBlockManager CustomBlockManagerPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic coins CoinsPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 1 0 0 2012-11-22 10:56:48 1 plugins.generic counter CounterPlugin 1 1
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.generic externalFeed ExternalFeedPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.implicitAuth shibboleth 0 1
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport erudit 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport native 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport mets 0 0
Edit Edit Copy Copy Delete Delete 1 1 0 0 2012-11-22 10:56:48 1 plugins.importexport crossref 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport doaj 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport pubmed 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport quickSubmit 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.importexport users 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.oaiMetadataFormats marcxml 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.oaiMetadataFormats marc 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.oaiMetadataFormats nlm 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.oaiMetadataFormats dc 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.oaiMetadataFormats rfc1807 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.paymethod paypal 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.paymethod manual 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.reports reviews 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.reports articles 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.reports views 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.reports subscriptions 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes steel 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes custom 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes classicGreen 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes uncommon 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes night 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes classicBlue 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes vanilla 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes desert 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes lilac 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes classicBrown 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes classicNavy 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes classicRed 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2012-11-22 10:56:48 1 plugins.themes redbar 0 0
Edit Edit Copy Copy Delete Delete 2 3 6 0 2012-11-22 10:56:47 0 core ojs2 0 1
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.metadata dc11 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.metadata mods34 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.metadata nlm30 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.metadata openurl10 0 0
Edit Edit Copy Copy Delete Delete 1 1 0 0 2013-09-10 16:28:58 1 plugins.citationFormats abnt 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationLookup crossref 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationLookup isbndb 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationLookup pubmed 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationLookup worldcat 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationOutput abnt 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationOutput apa 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationOutput mla 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationOutput vancouver 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationParser freecite 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationParser paracite 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationParser parscit 0 0
major minor revision build date_installed current product_type product product_class_name lazy_load sitewide
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.citationParser regex 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.generic backup BackupPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.generic browse BrowsePlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.generic driver DRIVERPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.generic googleViewer GoogleViewerPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.generic lucene LucenePlugin 1 1
Edit Edit Copy Copy Delete Delete 1 1 0 0 2013-09-10 16:28:58 1 plugins.generic openAIRE OpenAIREPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.generic timedView TimedViewPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.importexport datacite 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.importexport duracloud 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.importexport medra 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.importexport pubIds 0 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.pubIds doi DOIPubIdPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.pubIds urn URNPubIdPlugin 1 0
Edit Edit Copy Copy Delete Delete 1 0 0 0 2013-09-10 16:28:58 1 plugins.themes blueSteel 0 0
Edit Edit Copy Copy Delete Delete 2 4 2 0 2013-09-10 16:28:25 1 core ojs2 0 1

Let me know if you need anything else.

Thanks
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 12:02 pm

Hi Ubaid,

What do you get for the following query?
Code: Select all
SELECT article_id, locale FROM articles;
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8910
Joined: Wed Aug 10, 2005 12:56 pm

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 12:16 pm

Dear Alec,

I got this result after running the query:

Edit Edit Copy Copy Delete Delete 1 en_US
Edit Edit Copy Copy Delete Delete 2 en_US
Edit Edit Copy Copy Delete Delete 3 en_US
Edit Edit Copy Copy Delete Delete 4 en_US
Edit Edit Copy Copy Delete Delete 7 en_US
Edit Edit Copy Copy Delete Delete 9 en_US
Edit Edit Copy Copy Delete Delete 10 en_US
Edit Edit Copy Copy Delete Delete 11 en_US
Edit Edit Copy Copy Delete Delete 12 en_US
Edit Edit Copy Copy Delete Delete 13 en_US
Edit Edit Copy Copy Delete Delete 14 en_US
Edit Edit Copy Copy Delete Delete 15 en_US
Edit Edit Copy Copy Delete Delete 16 en_US
Edit Edit Copy Copy Delete Delete 17 en_US
Edit Edit Copy Copy Delete Delete 18 en_US
Edit Edit Copy Copy Delete Delete 19 en_US
Edit Edit Copy Copy Delete Delete 20 en_US
Edit Edit Copy Copy Delete Delete 21 en_US
Edit Edit Copy Copy Delete Delete 22 en_US
Edit Edit Copy Copy Delete Delete 23 en_US
Edit Edit Copy Copy Delete Delete 24 en_US
Edit Edit Copy Copy Delete Delete 25 en_US
Edit Edit Copy Copy Delete Delete 26 en_US
Edit Edit Copy Copy Delete Delete 27 en_US
Edit Edit Copy Copy Delete Delete 28 en_US
Edit Edit Copy Copy Delete Delete 29 en_US
Edit Edit Copy Copy Delete Delete 30 en_US
Edit Edit Copy Copy Delete Delete 31 en_US
Edit Edit Copy Copy Delete Delete 32 en_US
Edit Edit Copy Copy Delete Delete 33 en_US
Edit Edit Copy Copy Delete Delete 34 en_US
Edit Edit Copy Copy Delete Delete 35 en_US
Edit Edit Copy Copy Delete Delete 36 en_US
Edit Edit Copy Copy Delete Delete 37 en_US
Edit Edit Copy Copy Delete Delete 38 en_US
Edit Edit Copy Copy Delete Delete 39 en_US
Edit Edit Copy Copy Delete Delete 40 en_US
Edit Edit Copy Copy Delete Delete 41 en_US
Edit Edit Copy Copy Delete Delete 42 en_US
Edit Edit Copy Copy Delete Delete 43 en_US
Edit Edit Copy Copy Delete Delete 44 en_US
Edit Edit Copy Copy Delete Delete 45 en_US
Edit Edit Copy Copy Delete Delete 46 en_US
Edit Edit Copy Copy Delete Delete 47 en_US
Edit Edit Copy Copy Delete Delete 48 en_US
Edit Edit Copy Copy Delete Delete 49 en_US
Edit Edit Copy Copy Delete Delete 50 en_US
Edit Edit Copy Copy Delete Delete 51 en_US
Edit Edit Copy Copy Delete Delete 52 en_US
Edit Edit Copy Copy Delete Delete 53 en_US
Edit Edit Copy Copy Delete Delete 54 en_US
Edit Edit Copy Copy Delete Delete 55 en_US
Edit Edit Copy Copy Delete Delete 56 en_US
Edit Edit Copy Copy Delete Delete 57 en_US
Edit Edit Copy Copy Delete Delete 58 en_US
Edit Edit Copy Copy Delete Delete 59 en_US
Edit Edit Copy Copy Delete Delete 60 en_US
Edit Edit Copy Copy Delete Delete 61 en_US
Edit Edit Copy Copy Delete Delete 62 NULL
Edit Edit Copy Copy Delete Delete 63 en_US
Edit Edit Copy Copy Delete Delete 64 NULL
Edit Edit Copy Copy Delete Delete 65 NULL
Edit Edit Copy Copy Delete Delete 66 NULL
Edit Edit Copy Copy Delete Delete 68 NULL
Edit Edit Copy Copy Delete Delete 69 NULL
Edit Edit Copy Copy Delete Delete 70 NULL
Edit Edit Copy Copy Delete Delete 71 NULL
Edit Edit Copy Copy Delete Delete 72 NULL
Edit Edit Copy Copy Delete Delete 73 NULL
Edit Edit Copy Copy Delete Delete 76 NULL
Edit Edit Copy Copy Delete Delete 81 NULL
Edit Edit Copy Copy Delete Delete 83 NULL
Edit Edit Copy Copy Delete Delete 84 NULL
Edit Edit Copy Copy Delete Delete 85 NULL
Edit Edit Copy Copy Delete Delete 86 NULL
Edit Edit Copy Copy Delete Delete 87 NULL
Edit Edit Copy Copy Delete Delete 88 en_US

Thanks
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 12:45 pm

Hi Ubaid,

That looks like your problem -- the value should be 'en_US', not NULL. I suspect if you correct the value the metadata edit form will start working again. Test with the submission you've been working with earlier in the thread before you make the change throughout.

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

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 12:55 pm

Dear Alec,

Yes its working :D really thanks mate.

one more thing will I change NULL to en_US one by one or is there any query by which all NULL replace by en_US.


Thanks Again for your all time and efforts.
Ubaid Ghori
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Re: Abstract Despair in Edit Metadata

Postby asmecher » Fri Sep 27, 2013 2:20 pm

Hi Ubaid,

Glad to hear it's working. To change all, you can use...
Code: Select all
UPDATE articles SET locale='en_US';
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8910
Joined: Wed Aug 10, 2005 12:56 pm

Re: Abstract Despair in Edit Metadata

Postby ubaiddev » Fri Sep 27, 2013 9:57 pm

Dear Alec,

Really Thanks for your all efforts and time. I have done your recommended in my local machine. I'll do on live site on monday.
It must working same as like local machine.


Thanks
Ubaid Ghori
ubaiddev
 
Posts: 27
Joined: Mon Apr 08, 2013 1:35 am

Previous

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 3 guests