Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] Unable to download project BidS****1-2-5

Unable to download project BidS****1-2-5 30 Nov 2016 11:45 #14772

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
I have unticked 'include dataset' and still cant download it, just sits and spins

Thanks

Morgan
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 30 Nov 2016 21:08 #14774

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
Even though i was not including the dataset, once i flushed the datasets, i was able to download it

However if I try to add just one more view, I sit and spin again, but working for now
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 30 Nov 2016 21:12 #14775

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
This is because your project is too big.
Coding is now a piece of cake
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 30 Nov 2016 21:13 #14776

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
Its a big project for a big site :-)

I will try to streamline it
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 30 Nov 2016 21:16 #14777

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
You have a table which is really huge.
It is a memory overflow, so the table size could be the reason.
I saw projects with more tables, but never a table with so much fields.

I am gonna check the load of the server, and I can maybe dedicate a bit more RAM memory, but thats only putting the limit a bit further.
Coding is now a piece of cake
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 30 Nov 2016 21:18 #14778

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
Yes, one of the tables is full of meta data for an object
I have managed to download it now and will see what I can do to shrink it or even break it up if possible
Maybe you need an extra premium service payment for greedy buggers like me
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 01 Dec 2016 18:40 #14803

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
Might be smaller if you use a JSON field :)
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 02 Dec 2016 10:26 #14806

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Correct.

Anyone knows better how to use JSON field inside a SQL query, of research ?
JSON is a SQL type. So I guess the contained values can be searchable, like a tree of values, any help on this ?

Because Cook do not handle JSON as a SQL JSON field. If you use JSON with Cook, it will store it into a text field.
I'd like to improve that but I never dig in really. That's the opportunity to improve something.

Anyone who used SQL JSON field with SQL queries ?
Coding is now a piece of cake
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 02 Dec 2016 10:28 #14807

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
By the way (and Morgan knows already), I have increased the RAM memory limit which helps for our problem of downloading.
Coding is now a piece of cake
The administrator has disabled public write access.

Unable to download project BidS****1-2-5 02 Dec 2016 19:29 #14813

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
Sorry, never used it
The administrator has disabled public write access.
Time to create page: 0.091 seconds

Get Started