Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

javascript error on demo with current mysql table #64

Open
DiegoJArg opened this issue Aug 9, 2018 · 1 comment
Open

javascript error on demo with current mysql table #64

DiegoJArg opened this issue Aug 9, 2018 · 1 comment

Comments

@DiegoJArg
Copy link

Hi.
I need to make a table easily editable for highlevel users.
demo and demo table works fine as it comes.
If I change database and rable to formtools -> ft_form_1
I get this javascript error.
Sorry, but it lacks of details to know what to send to you

Uncaught SyntaxError: Unexpected token <
at EditableGrid.processJSON (eval at (editablegrid-2.1.0-49.js:12), :1:12202)
at XMLHttpRequest.d.onreadystatechange (eval at (editablegrid-2.1.0-49.js:12), :1:10151)
EditableGrid.processJSON @ VM86:1
d.onreadystatechange @ VM86:1
XMLHttpRequest.send (async)
EditableGrid.loadJSON @ VM86:1
DatabaseGrid.fetchGrid @ demo.js:90
DatabaseGrid @ demo.js:76
window.onload @ index.html:61
load (async)
(anonymous) @ index.html:60

@DiegoJArg
Copy link
Author

-- Adminer 4.6.2 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS ft_form_1;
CREATE TABLE ft_form_1 (
submission_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
operador varchar(255) DEFAULT NULL,
linea varchar(1) DEFAULT NULL,
puesto varchar(20) DEFAULT NULL,
proceso varchar(20) DEFAULT NULL,
posicion varchar(20) DEFAULT NULL,
submission_date datetime NOT NULL,
last_modified_date datetime NOT NULL,
ip_address varchar(15) DEFAULT NULL,
is_finalized enum('yes','no') DEFAULT 'yes',
manual varchar(1) DEFAULT NULL,
falla varchar(255) DEFAULT NULL,
observaciones text,
placa varchar(255) DEFAULT NULL,
ot varchar(255) DEFAULT NULL,
accion varchar(255) DEFAULT NULL,
subensamble varchar(255) DEFAULT NULL,
horario varchar(255) DEFAULT NULL,
referencia varchar(255) DEFAULT NULL,
dbinsertion_date datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (submission_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO ft_form_1 (submission_id, operador, linea, puesto, proceso, posicion, submission_date, last_modified_date, ip_address, is_finalized, manual, falla, observaciones, placa, ot, accion, subensamble, horario, referencia, dbinsertion_date) VALUES
(49, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'R4A17', '2018-06-19 11:51:45', '2018-06-19 12:10:36', '10.3.1.89', 'yes', 'A', 'Falt. Con Epoxi / Estaño', '', '62', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 12:10:36'),
(50, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'CNOL2', '2018-06-19 12:15:28', '2018-06-19 12:18:34', '192.168.1.144', 'yes', 'A', 'Material Corrido', '', '73', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 12:18:34'),
(51, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'JA0J1', '2018-06-19 12:19:14', '2018-06-19 12:37:04', '192.168.1.144', 'yes', 'A', 'Falt. Con Epoxi / Estaño', '', '86', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 12:37:04'),
(52, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'CN1J2', '2018-06-19 12:37:41', '2018-06-19 13:15:06', '192.168.1.144', 'yes', 'A', 'Terminal Levantado', '', '89', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 13:15:06'),
(53, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'JA0J1', '2018-06-19 13:15:11', '2018-06-19 13:35:45', '192.168.1.144', 'yes', 'A', 'Material Levantado', '', '160', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 13:35:45'),
(54, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'CN1J1', '2018-06-19 13:36:46', '2018-06-19 13:37:41', '192.168.1.144', 'yes', 'A', 'Material Levantado', '', '162', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 13:37:41'),
(55, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'CN1J2', '2018-06-19 13:38:14', '2018-06-19 13:51:30', '192.168.1.144', 'yes', 'A', 'Corto', '', '175', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 13:51:30'),
(56, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'T0D1', '2018-06-19 13:51:59', '2018-06-19 13:54:36', '192.168.1.144', 'yes', 'M', 'Material Levantado', '', '201', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 13:54:36'),
(57, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'T0D1', '2018-06-19 13:55:18', '2018-06-19 13:56:23', '192.168.1.144', 'yes', 'M', 'Material Levantado', '', '202', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 13:56:23'),
(58, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'JA0J1', '2018-06-19 13:57:35', '2018-06-19 14:07:09', '192.168.1.144', 'yes', 'A', 'Falt. Con Epoxi / Estaño', '', '209', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 14:07:09'),
(59, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'R23', '2018-06-19 14:10:49', '2018-06-19 14:13:10', '192.168.1.144', 'yes', 'A', 'Contaminación externa', '', '229', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 14:13:10'),
(60, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'SINTO', '2018-06-19 14:14:16', '2018-06-19 14:15:10', '192.168.1.144', 'yes', 'M', 'Falt. Con Epoxi / Estaño', '', '236', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 14:15:10'),
(61, 'SANCHEZ, Maria Dla', '3', 'Control AOI', 'SMT TOP', 'R3B1', '2018-06-19 14:15:31', '2018-06-19 14:25:45', '192.168.1.144', 'yes', 'A', 'Contaminación externa', '', '261', '465025', 'Segregado', 'PR', NULL, NULL, '2018-06-19 14:25:45'));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant