Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Server side pagination
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Server side pagination
#55052
Server side pagination 8 Years, 10 Months ago Karma: 0
I am attempting to use a larger .csv file for a customer, the file is about 3.8 megs. I am trying to use the server side pagination to process this as I get size allocation errors when I don't.

Code:


Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 85 bytes) in /home/variap/public_html/main/administrator/components/com_arismartcontent/kernel/CSV/class.CSVParser.php on line 419



I only have a couple really large ones that I will need to use but for some reason this is not working for me.
Last Edit: 2015/06/27 11:05 By admin.
The administrator has disabled public write access.
 
#55055
Re:Server side pagination 8 Years, 10 Months ago Karma: 747
Hello,

Server side pagination doesn't work with CSV files. It works with data from a database.

You can try to increase value of "memory_limit" PHP parameter, but preferable to load a large data from a database.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#55057
Re:Server side pagination 8 Years, 10 Months ago Karma: 0
I am not familiar with how to import .csv information into a database. I'm not a good enough programer to do that, I tried to increase the memory in the php.ini file and it is still giving me the same error. This website is to go live on July 1 and I need to find an resolution for this.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 85 bytes) in /home/variap/public_html/main/administrator/components/com_arismartcontent/kernel/CSV/class.CSVParser.php on line 419
Last Edit: 2015/06/27 19:21 By webtomix.
The administrator has disabled public write access.
 
#55058
Re:Server side pagination 8 Years, 10 Months ago Karma: 747
The parameter is defined in php.ini file. You can also try to increase it's value with help of PHP Settings plugin, but limit for value of this parameters can be set by hosting administrators.

If it is not possible to increase memory limit then possible solutions:

1. Split the CSV file into several files.

2. Show data from a database and use server side pagination. With this solution it is possible to show very large data.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#55059
Re:Server side pagination 8 Years, 10 Months ago Karma: 0
Ok, I created a database and tried to get it connected, I'm not sure what I'm not doing correctly but it is telling me there is no data.

print.innovsys.com/main/index.php/home/customer-page/2015-03-02-22-48-57/acc-inserter-log
The administrator has disabled public write access.
 
#55060
Re:Server side pagination 8 Years, 10 Months ago Karma: 0
Ok, I created a database and tried to get it connected, I'm not sure what I'm not doing correctly but it is telling me there is no data.

print.innovsys.com/main/index.php/home/customer-page/2015-03-02-22-48-57/acc-inserter-log

I am not able to use ODBC as it would cause conflicts with other database pieces this website uses.
The administrator has disabled public write access.
 
Go to topPage: 12