Issues with Radicore V 1.75 [message #3013] |
Wed, 04 July 2012 12:31 |
juanguilarte
Messages: 27 Registered: June 2012
|
Junior Member |
|
|
1.I have some problems with the header. It doesn´t show the header. I replace in the xls library the std.head with the old one V1.62 and show the header but I can´t use the new feature (favorites, etc.)
2. I have fatal error en some request. For example:
a.-2012-07-04 11:52:38
Error fatal: Cannot extract token from: '= ='454600'' (# 256).
Error en linea 6013 del archivo 'C:\wamp\www\radicore\includes\include.library.inc'.
PHP_SELF: /radicore/sistemapagos/reg_fin_th(multi2).php
b. 2012-07-04 11:54:15
Error fatal: Cannot extract token from: '= ' (# 256).
Error en linea 6013 del archivo 'C:\wamp\www\radicore\includes\include.library.inc'.
PHP_SELF: /radicore/sistemapagos/reg_misc_th(search).php
Everything is working in V 1.62
I will appreciate your comments
Regards
Juan Guilarte
|
|
|
Re: Issues with Radicore V 1.75 [message #3016 is a reply to message #3013] |
Sat, 07 July 2012 04:17 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
If you get a blank page instead of an HTML response it means that the script aborted before it got to the part where it builds the HTML output. In your development environment you should have the following in your php.ini file:
display_errors = on
error_reporting = E_ALL
The error message "Cannot extract token from: '= ='454600'' (# 256)" tells me that you have a badly constructed query such as "field= ='454600''" with TWO '=' signs and TWO single quotes at the end. This is invalid, so fix it in your code.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Issues with Radicore V 1.75 [message #3132 is a reply to message #3123] |
Wed, 07 November 2012 10:33 |
juanguilarte
Messages: 27 Registered: June 2012
|
Junior Member |
|
|
I have some issue with float datatype when i try to update or insert table columns in the dictionary database.
T am using Radicore V 1.76 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
I attached the message
Thank you in advance
Juan Guilarte
Esta aplicacion ha encontrado un error inrrecuperable
Lo siguiente ha sido reportado al administrador:
2012-11-07 15:27:01
Error fatal: ORA-01426: desbordamiento numérico (# 1426).
SQL instruccion: UPDATE dict_column SET col_comment=NULL,col_type='float', col_type_native='float', col_array_type=NULL,col_values=NULL,user_size=22,col_maxsize =22,col_unsigned='N', col_zerofill_bwz=NULL,col_minvalue=-1.000000e+126,col_maxval ue=1.000000e+126,user_minvalue=-1.000000e+126,user_maxvalue= 1.000000e+126,noedit_nodisplay=NULL,no_search=NULL,no_audit= NULL,upper_lowercase=NULL,col_subtype=NULL,boolean_true=NULL ,boolean_false=NULL,control=NULL,optionlist=NULL,checkbox_la bel=NULL,task_id=NULL,foreign_field=NULL,align_hv=NULL,align _lr=NULL,custom_validation=NULL,revised_date='2012-11-07 15:27:01', revised_user='MGR' WHERE database_id='sistema_pagos' AND table_id='reg_mov_fac' AND column_id='num_tarj_ft'
Error en linea 1571 del archivo 'C:\wamp\www\radicore\includes\dml.oracle.php5.class.inc'.
Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Database: ORCL32, Schema: TREOMDP_DICT
PHP_SELF: /radicore/dict/column(add4)import.php
CURRENT DIRECTORY: C:\wamp\www\radicore\dict
SERVER_ADDR: 127.0.0.1
SERVER_NAME: localhost
HTTP_HOST: localhost
Codigo de Usuario: MGR
REMOTE_ADDR: 127.0.0.1
REQUEST_URI: /radicore/dict/column(add4)import.php?session_name=menu1
|
|
|
|
Re: Issues with Radicore V 1.75 [message #3135 is a reply to message #3133] |
Wed, 07 November 2012 21:40 |
juanguilarte
Messages: 27 Registered: June 2012
|
Junior Member |
|
|
Sure this is the create script:
CREATE TABLE "TREOMDP_SISTEMA_PAGOS"."REG_MOV_FAC"
( "EMPRESA_FT" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"BIN_TARJ_FT" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_TARJ_FT" FLOAT(126) DEFAULT '0' NOT NULL ENABLE,
"CONSE_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"COD_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_AUTO_MOV" CHAR(7 CHAR) DEFAULT '0' NOT NULL ENABLE,
"NRO_COMER_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_SUC_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"MONTO_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_MOV" CHAR(2 CHAR) DEFAULT 'BS' NOT NULL ENABLE,
"MONTO_EXT_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_EXT_MOV" VARCHAR2(2 CHAR) DEFAULT ' ' NOT NULL ENABLE,
"MONTO_INTER_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_INTER_MOV" VARCHAR2(2 CHAR) DEFAULT ' ' NOT NULL ENABLE,
"FECHA_PRO_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"NOMBRE_CON_MOV" CHAR(25 CHAR) NOT NULL ENABLE,
"FECHA_TRAN_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"CONT_COM_MOV" CHAR(1 CHAR) NOT NULL ENABLE,
"FECHA_DEP_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"CON_NRO_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NOM_PAIS_MOV" CHAR(8 CHAR) NOT NULL ENABLE,
"PROCED_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"TIPO_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"MARCA_AJU_MOV" CHAR(1 CHAR) NOT NULL ENABLE,
"NRO_REF_INC_MOV" CHAR(23 CHAR) NOT NULL ENABLE,
"CATEGORIA_COMER_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"FECHA_FT" CHAR(10 CHAR) DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
CONSTRAINT "PRIMARY_31" PRIMARY KEY ("BIN_TARJ_FT", "NUM_TARJ_FT", "FECHA_FT", "CONSE_MOV")
|
|
|
|
|
Re: Issues with Radicore V 1.75 [message #3365 is a reply to message #3364] |
Wed, 23 January 2013 02:12 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
The contents of your menu database appears to be out of date. The original 'relationship(add2).php' file has been split into two giving 'relationship(add2)a.php' and 'relationship(add2)b.php'.
I suggest you try reloading file 'radicore/dict/sql/dict.menu_export.sql'. This will reload all the menu details for the 'dict' subsystem.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|