jariolaine / apex-blog Goto Github PK
View Code? Open in Web Editor NEWBlog application built using Oracle Application Express (APEX)
License: MIT License
Blog application built using Oracle Application Express (APEX)
License: MIT License
Hi Jari,
none of the new "constants" work if I translate the latest app to german and use it as Application Primary Language.
As usual I duplicated and translated all text messages to german.
Where do you init the items?
Best regards
Steffen
New install of version 22.2.2.20230304, search in the public application gives an error:
report error:
Oracle Text error:
DRG-10599: column is not indexed
Same error on page 11 of admin app when using report search field.
If the application is upgraded from the previous version, the problem doesn't occur.
Root cause
Supporting objects install scripts creates index to wrong column. Upgrade script works correctly.
Workaround
Run in application parsing schema:
drop index blog_posts_ctx force;
create index blog_posts_ctx on blog_posts(post_txt_search)
indextype is ctxsys.context parameters(
'datastore blog_post_uds_ds
lexer blog_post_uds_lx
section group ctxsys.auto_section_group
stoplist ctxsys.empty_stoplist
filter ctxsys.null_filter
sync (on commit)'
);
"Error at line 0: ORA-01730: invalid number of column names specified" -> "LIST_BADGE" doesn't exist anymore in the source sql ;-)
CREATE OR REPLACE FORCE VIEW "BLOG_V_TAGS" ("TAG_ID", "TAG", "TAG_URL", "POSTS_COUNT", "CHANGED_ON", "TAG_BUCKET", "SHOW_POST_COUNT", "LIST_BADGE") AS
select
v1.tag_id as tag_id
,v1.tag as tag
,v1.tag_url as tag_url
,count( v1.post_id ) as posts_count
,max(
greatest(
v1.changed_on
,v2.changed_on
)
) as changed_on
,width_bucket(
count( v1.post_id )
,min( count( v1.post_id ) ) over()
,max( count( v1.post_id ) ) over()
,7
) as tag_bucket
,feat.show_post_count as show_post_count
from blog_v_post_tags v1
join blog_v_posts v2 on v1.post_id = v2.post_id
cross join(
select
apex_util.get_build_option_status(
p_application_id => sys_context( 'APEX$SESSION', 'APP_ID' )
,p_build_option_name => 'BLOG_FEATURE_TAG_CLOUD_POST_COUNT'
) as show_post_count
from dual
) feat
where 1 = 1
group by v1.tag_id
,v1.tag
,v1.tag_url
,feat.show_post_count
with read only
Hi Jari,
I have a problem that is only indirectly related to the blog.
My blog runs on the "Always Free Autonomous Database" in the Oracle Cloud.
There is the following error when I want to edit an entry
DRG-50850: drftsync on-commit internal error...
In MyOracleSupport I find for DRG-50850:
"Inserting into a table with a Text index with the SYNC ON COMMIT attribute fails"
Do you have any idea what I can do?
(How) can I customize the Oracle Text Index from "sync on commit" to for example "intervals"?
Can I disable / drop the Oracle Text Index? Is the app usable afterwards?
Thx
Steffen
Hi Jari,
first of all, Merry Christmas and a Happy New Year 2023.
I have an enhancement request:
Could you please integrate the folllowing javascript snippet in the "JavaScript code for item initialization", f.e.
P12_BODY_HTML in APP 401.
function ( options ) {
// link - activate "Open in a new tab" switch
options.editorOptions.link = {
decorators: {
openInNewTab: {
mode: "manual",
label: "Open in a new tab",
attributes: {
target: "_blank",
rel: "noopener noreferrer"
}
}
}
};
return options ;
}
Thank you in advance.
By the way - there are many other features for CKEditor5
Thanks for the open source project, really great work.
But I have some questions in using it, I hope to get your answers, thank you
In the App Builder when I send files (blog-administration-latest.sql) & (blog-public-pages-latest.sql) to import the below errors appears:
3 errors have occurred
Build Status must be specified.
Parse As Schema must be specified.
File is not a valid Oracle APEX application export file.
Please help me.
Hi Jari,
I tried to register my blog for the APEX Developer Blogs from Jon Dixon.
He needs "raw XML" like the following: hartenfeller.dev/orclapex-rss.xml
Is it possible that you implement this in the blog? Maybe as alternative XML ?
Kind regards
Steffen
Hi.
if you're interested in the (german) translated app, I can upload it ...
Happy Easter
ORA-04063: package body "WKSP_AIGOOGLE.BLOG_UTIL" has errors
Technical Info (only available for developers)
is_internal_error: false
ora_sqlcode: -4063
ora_sqlerrm: ORA-04063: package body "WKSP_AIGOOGLE.BLOG_UTIL" has errors
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06508: PL/SQL: could not find program unit being called: "WKSP_AIGOOGLE.BLOG_UTIL"
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC_LOCAL", line 3062
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2823
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2861
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 34
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1347
ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634
component.type: APEX_APPLICATION_PROCESSES
component.id: 53582057650954562157
component.name: Initialize Items
error_backtrace:
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC_LOCAL", line 3062
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2823
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2861
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 34
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1347
ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS", line 192
error_statement:
begin blog_util.initialize_items(
p_app_id => :APP_ID
);
end;
Pagination on page 2 of the public application works incorrectly if several posts have the same published on date and time.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.