Elxis CMS Forum

Support => Database => Topic started by: muharihar on October 24, 2008, 20:20:10

Title: [Oracle Problem] When execute function "_form_mos_category" (core: elxisxml.php)
Post by: muharihar on October 24, 2008, 20:20:10

hello...

there is problem when execute function "_form_mos_category" (core file: elxisxml.php).

URI: index2.php?option=com_modules&client=&task=editA&hidemainmenu=1&id=13
Message: ORA-01722: invalid number

SELECT c.id AS value, s.title||' / '||c.title AS text FROM web2_categories c LEFT JOIN web2_sections s ON s.id=c.section WHERE c.published='1' AND s.scope='content' ORDER BY c.title

it's happend when loading mod_newsflash.

and i'm try fo fix it by adding query like this: [AND length(c.section)<5]

SELECT   c.ID AS VALUE, s.title || ' / ' || c.title AS text
    FROM web2_categories c LEFT JOIN web2_sections s ON s.ID = c.section
   WHERE c.published = '1' AND s.SCOPE = 'content' AND length(c.section)<5
ORDER BY c.title
 
any advice for me?

thanks...
sory for my english.

Title: Re: [Oracle Problem] When execute function "_form_mos_category" (core: elxisxml.php)
Post by: muharihar on October 24, 2008, 20:50:06

the problem my be caused by non numeric data on table __CATEGORIES field SECTION

examples: table _CATEGORIES
.........|SECTION          |.......
--------------------------------
.........|com_weblinks   |.......
.........|com_newsfeeds|......

thanks...
sory for my english

Title: Re: [Oracle Problem] When execute function "_form_mos_category" (core: elxisxml.php)
Post by: datahell on October 25, 2008, 12:33:38

Oracle support is experimental, such errors maybe appear somewhere in Elxis.
The query must be modified to be compatible to Oracle.
I write down this specific error to fix it as soon as possible.

Title: Re: [Oracle Problem] When execute function "_form_mos_category" (core: elxisxml.php)
Post by: muharihar on October 27, 2008, 06:17:18

thanks....
we always waiting for you..... ;D

---------------------------------------
sorry for my english....