Dev {Tricks}

You are here: Home / Home

by

OJS plugin for Index Copernicus XML files

These plug-ins allows the journal manager to export issues’ metadata as an XML file for Index Copernicus International (ICI) indexing.

Git-Hub Links

OJS 2+

https://github.com/ekodidik/ojs2-ici-export-plugin

OJS 3+

https://github.com/a-vodka/ojs_copernicus_export_plugin

 

by

Error: BIOS/Legacy Boot of UEFI-Only Media

  • The drive can boot in UEFI mode only. It will not boot in BIOS/Legacy mode.

To remove this message you need to do one of the following:

  1. If your computer supports UEFI, go to your UEFI settings and lower or disable the priority of CSM/Legacy mode.
  2. Or Recreate the drive in MBR partition scheme where target system is BIOS (…….)
  3. Or Recreate the disk with Boot type: Non bootable

My suggestion the number 2 option.

 

 

 

by

Update a column value, replacing part of a string

  • How to Replace Part of a String in MySQL
  • Replace part of string in mysql table column
  • Find and Replace text in the entire table
  • MySQL REPLACE String Function: Find & Replace Text

Replace the bold text as per your table name, field/column name, strings and conditions.

UPDATE table_name
SET field_name = REPLACE(field_name, 'string_to_find', 'string_to_replace')
WHERE conditions;

Example,
Table name: publication_settings
Field/column name: setting_value
String to change: Copyright © to ©

where conditions
Field/column name: setting_name
Field string/value: abstract

UPDATE publication_settings
SET setting_value = REPLACE(setting_value, 'Copyright ©', '©')
WHERE setting_name LIKE ('abstract');