XLApp-Convert Excel to App

XLApp, Excel to App Converter Forum.

You are not logged in.

#1 2019-04-03 03:35:55

jody
Member
Registered: 2018-02-03
Posts: 2

Invalid query Table is full

App has worked great until today. I haven't made any changes. Here's the message:

Invalid query: The table 'logmaster' is full Whole query: insert into LogMaster (AppID,UID,LogInUID,Email,Name,Input,Output,OutputID,InputID,IP,PROXY,UserAgent,OwnerEmail,OwnerGroupName,RecSelector ) values (25534,13185,13185,'xxx@xxxxx.com','Lastname, Firstname','{\n\"input\":[\n{\"0_1_0\":\"10\"}],\n\"output\":[\"0_0_4\",\"0_0_8\",\"0_0_9\",\"0_1_4\",\"0_1_8\",\"0_1_9\"]\n}','{\"cells\":{\"0_1_4\":\"$0.87\",\"0_0_9\":\"total\",\"0_0_8\":\"s/h\",\"0_1_9\":\"$11.92 \",\"0_1_8\":\"$1.05 \",\"0_0_4\":\"tax\"},\"status\":\"0\",\"validations\":{}}',0,0,'174.24.107.193','','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36','','','').
.

Last edited by jody (2019-04-03 03:42:24)

Offline

#2 2019-04-03 19:08:35

cbowessr
Member
Registered: 2015-10-07
Posts: 1

Re: Invalid query Table is full

Anybody find a solution?

Offline

#3 2019-04-05 16:20:19

escherer
Member
Registered: 2016-04-26
Posts: 5

Re: Invalid query Table is full

I have same issue...
Invalid query: The table 'logmaster' is full Whole query: insert into LogMaster (AppID,UID,LogInUID,Email,Name,Input,Output,OutputID,InputID,IP,PROXY,UserAgent,OwnerEmail,OwnerGroupName,RecSelector ) values (11292,6434,6434,'escherer@exactdispensing.com','escherer@exactdispensing.com','{\n\"input\":[\n{\"0_16_6\":\"29\"}],\n\"output\":[\"0_0_0\",\"0_0_1\",\"0_0_2\",\"0_0_3\",\"0_0_4\",\"0_1_0\",\"0_1_1\",\"0_1_2\",\"0_1_3\",\"0_1_4\",\"0_2_0\",\"0_2_1\",\"0_2_2\",\"0_2_3\",\"0_2_4\",\"0_3_0\",\"0_3_1\",\"0_3_2\",\"0_3_3\",\"0_3_4\",\"0_4_0\",\"0_4_1\",\"0_4_2\",\"0_4_3\",\"0_4_4\",\"0_5_0\",\"0_5_1\",\"0_5_2\",\"0_5_3\",\"0_5_4\",\"0_6_0\",\"0_6_1\",\"0_6_2\",\"0_6_3\",\"0_6_4\",\"0_7_0\",\"0_7_1\",\"0_7_2\",\"0_7_3\",\"0_7_4\",\"0_8_0\",\"0_8_1\",\"0_8_2\",\"0_8_3\",\"0_8_4\",\"0_9_0\",\"0_9_1\",\"0_9_2\",\"0_9_3\",\"0_9_4\",\"0_10_0\",\"0_10_1\",\"0_10_2\",\"0_10_3\",\"0_10_4\",\"0_11_0\",\"0_11_1\",\"0_11_2\",\"0_11_3\",\"0_11_4\",\"0_12_0\",\"0_12_1\",\"0_12_2\",\"0_12_3\",\"0_12_4\",\"0_13_0\",\"0_13_1\",\"0_13_2\",\"0_13_3\",\"0_13_4\",\"0_14_0\",\"0_14_1\",\"0_14_2\",\"0_14_3\",\"0_14_4\"]\n}','{\"cells\":{\"0_13_3\":\"731.00\",\"0_13_2\":\"28.78\",\"0_13_4\":\"974.59\",\"0_13_1\":\"1.14\",\"0_13_0\":\"29.00\",\"0_12_0\":\"Torr Ab\",\"0_11_4\":\"\",\"0_12_2\":\"InHg Ab\",\"0_12_1\":\"Gauge*\",\"0_10_0\":\"29.00\",\"0_12_4\":\"mbar Ab\",\"0_11_0\":\"\",\"0_12_3\":\"Torr\",\"0_11_1\":\"\",\"0_11_2\":\"\",\"0_11_3\":\"\",\"0_2_0\":\"\",\"0_2_1\":\"\",\"0_2_2\":\"\",\"0_2_3\":\"\",\"0_2_4\":\"\",\"0_0_1\":\"InHg\",\"0_0_0\":\"Torr\",\"0_0_4\":\"Torr Ab\",\"0_0_3\":\"mbar\",\"0_0_2\":\"Gauge\",\"0_1_4\":\"731.00\",\"0_1_3\":\"38.66\",\"0_1_2\":\"28.78\",\"0_1_1\":\"1.14\",\"0_1_0\":\"29.00\",\"0_8_3\":\"\",\"0_5_0\":\"\",\"0_7_0\":\"29.00\",\"0_8_2\":\"\",\"0_7_1\":\"0.92\",\"0_7_2\":\"23.37\",\"0_8_4\":\"\",\"0_7_3\":\"31.2\",\"0_7_4\":\"736.6\",\"0_8_1\":\"\",\"0_8_0\":\"\",\"0_5_3\":\"\",\"0_5_4\":\"\",\"0_5_1\":\"\",\"0_5_2\":\"\",\"0_4_4\":\"23.40\",\"0_4_2\":\"0.92\",\"0_4_3\":\"982.1\",\"0_3_4\":\"Torr Ab\",\"0_3_3\":\"mbar\",\"0_3_2\":\"Gauge\",\"0_3_1\":\"Torr\",\"0_3_0\":\"InHg\",\"0_9_0\":\"mbar\",\"0_4_0\":\"29.00\",\"0_9_2\":\"InHg\",\"0_4_1\":\"736.60\",\"0_9_1\":\"Gauge\",\"0_9_4\":\"Torr Ab\",\"0_9_3\":\"Torr\",\"0_10_4\":\"738.25\",\"0_10_3\":\"21.75\",\"0_10_2\":\"0.86\",\"0_10_1\":\"29.06\",\"0_6_4\":\"Torr Ab\",\"0_6_1\":\"InHg\",\"0_14_0\":\"* using 29.92 for atmospheric \\\"Zero\\\"\",\"0_6_0\":\"Gauge\",\"0_6_3\":\"mbar\",\"0_6_2\":\"Torr\"},\"status\":\"0\",\"validations\":{},\"warnings\":[\"could not get data for 0_14_1: invlalid col index 1\",\"could not get data for 0_14_2: invlalid col index 2\",\"could not get data for 0_14_3: invlalid col index 3\",\"could not get data for 0_14_4: invlalid col index 4\"]}',0,0,'216.68.148.162','','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36','','','').

Last edited by escherer (2019-04-05 16:21:29)

Offline

#4 2019-04-06 06:42:27

ymp.1928
Member
Registered: 2019-03-29
Posts: 3

Re: Invalid query Table is full

I have same problem...

Offline

#5 2019-04-06 11:49:56

smalleast_love
Member
Registered: 2019-03-11
Posts: 5

Re: Invalid query Table is full

it seems admin hasn't noticed it :(

Offline

#6 2019-04-08 07:02:21

gauravpoddar.weber
Member
Registered: 2017-06-24
Posts: 2

Re: Invalid query Table is full

Even i am facing the same issue. And have no clue of what to do about it. does any one has any solution ?

Offline

#7 2019-04-08 07:13:40

gauravpoddar.weber
Member
Registered: 2017-06-24
Posts: 2

Re: Invalid query Table is full

i found a solution. Atleast temporarily. For an app, go to settings > Advanced and click on "Do not Log Input Output. " and then save.

You will start seeing results, however the log will not be created.

Offline

#8 2019-04-08 11:02:31

smalleast_love
Member
Registered: 2019-03-11
Posts: 5

Re: Invalid query Table is full

gauravpoddar.weber wrote:

i found a solution. Atleast temporarily. For an app, go to settings > Advanced and click on "Do not Log Input Output. " and then save.

You will start seeing results, however the log will not be created.


It really works. Thank you very much!

It seems this is the only temporary solution at the moment.

Offline

#9 2019-04-08 15:55:56

jody
Member
Registered: 2018-02-03
Posts: 2

Re: Invalid query Table is full

gauravpoddar.weber wrote:

i found a solution. Atleast temporarily. For an app, go to settings > Advanced and click on "Do not Log Input Output. " and then save.

You will start seeing results, however the log will not be created.

Thank you!

Offline

#10 2019-04-10 20:16:04

kathireshin2000_0
Member
Registered: 2019-04-10
Posts: 2

Re: Invalid query Table is full

It really works. Thank so much

Offline

Board footer

Powered by FluxBB