Announcements Setting

Software Support
1

Hi All

@asmecher

When i try to update Announcement but update can’t save

This is PHP ERROR Below

2025-08-25 17:20:38.186293 [NOTICE] [1499774] [T0] [115.127.129.240:58589:HTTP2-55#APVH_ijbssrnet.com:443] [STDERR] Slim Application Error:\nType: Illuminate\Database\QueryException\nCode: HY000\nMessage: SQLSTATE[HY000]: General error: 1364 Field ‘setting_type’ doesn’t have a default value (SQL: insert into announcement_settings (announcement_id, locale, setting_name, setting_value) values (13, en_US, description,

\n

International Journal of Business and Social Science Research (IJBSSR) is multidisciplinary journal which publishes blind peer reviewed high-quality manuscript of interdisciplinary in content and methodology. The scope of the journal is all fields of Business, Economics and Social Science including, but not limited to, following areas:

\n

Accounting Information System, Anthropology, Corporate Governance, Development Economics and Economic Policies, Education Research, Environmental Studies, Finance & Banking, History & Culture, Human Geography, Tourism and Hospitality, Insurance and Actuarial Science, International Relations, Legal Studies, Marketing Research, Mass Communication, Management Information System, Management & Business Studies, Operations Research, Peace and Conflict, Philosophy, Political Science, Population Studies, Education, Law, Economics, Public Administration, Psychology, Quantitative and Qualitative Management, Religious Studies, Social Policy and Social Welfare, Sociology, Teaching, Tourism and Hospitality, Women Studies.

\n

Please Submit your Manuscript at mail: editor@ijbssrnet.com

\n
) on duplicate key update announcement_id = values(announcement_id), locale = values(locale), setting_name = values(setting_name), setting_value = values(setting_value))\nFile: /home/ijbssrnetcom47/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php\nLine: 671\nTrace: #0 /home/ijbssrnetcom47/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCal
2025-08-25 17:19:15.569325 [NOTICE] [1453327] [T0] [115.127.129.240:58573:HTTP2-99#APVH_ijbssrnet.com:443] [STDERR] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/ijbssrnetcom47/public_html/plugins/blocks/keywordCloud/KeywordCloudBlockPlugin.inc.php:1) in /home/ijbssrnetcom47/public_html/lib/pkp/classes/core/PKPRouter.inc.php on line 412\n
2025-08-25 17:19:11.843842 [NOTICE] [1453327] [T0] [115.127.129.240:58573:HTTP2-79#APVH_ijbssrnet.com:443] [STDERR] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/ijbssrnetcom47/public_html/plugins/blocks/keywordCloud/KeywordCloudBlockPlugin.inc.php:1) in /home/ijbssrnetcom47/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 1186\n
2025-08-25 17:19:11.843833 [NOTICE] [1453327] [T0] [115.127.129.240:58573:HTTP2-79#APVH_ijbssrnet.com:443] [STDERR] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/ijbssrnetcom47/public_html/plugins/blocks/keywordCloud/KeywordCloudBlockPlugin.inc.php:1) in /home/ijbssrnetcom47/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 1185\n

2

Hi @IJBSRR_Journal,

What version of OJS are you using? (Please include this in your posts.)

Regards,
Alec Smecher
Public Knowledge Project Team

4

ojs 3.3.0.14

php 7.4

5

Hi @IJBSRR_Journal,

What do you get for the following SQL query?

SHOW CREATE TABLE announcement_settings;

Regards,
Alec Smecher
Public Knowledge Project Team

6

de primer El código de error 1364 indica que se está intentando insertar un registro en la tabla announcement_settings, pero no se está proporcionando un valor para el campo setting_type, y ese campo no tiene un valor por defecto definido en la base de datos.

puedes correr SELECT * FROM announcement_settings WHERE setting_type IS NULL;

revisa la integridad de la tabla y campo… en este caso tocara realizar nuevamente la migración desde el respaldo o incluir el campo con los valore correctos

1 Like
7

This topic was automatically closed after 12 days. New replies are no longer allowed.