Search:

Following on from my post about browsing by top-level category .. we have moved on by moving all our downloads to an unlimited web host one at a time ... therefore we are opening all products to...

Thanks very much for taking another look at this. I am a little confused though. The Adult category currently starts off with 56 sub-categories so I put a counter in to ensure I wasn't stuck in an...

Hi it is PHP Memory Limit: 3000M

Hi

Having installed v155 on a test site to customize it the standard Advanced Search function seems to be falling over.

I am getting the following screen:

18318

and the error log reads:

Just looking at the out of memory error message and wondering if the patch you posted is trying to browse the entire catalog or just a selected Top-level category?

The Adult category does not have...

I'm testing this on a newly installed V1.5.5 - that's where I am getting the error message. This is what the error log reads:

[04-Feb-2019 20:04:58 Europe/London] Request URI:...

Ok thanks

I am getting:


WARNING: An Error occurred, please refresh the page and try again.
WARNING: An Error occurred, please refresh the page and try again.

Thanks, But this doesn't work in 155 just a white screen

Thanks. I will give that a try.

I think the problem is that with the conglomeration of Zen-Cart contributors, the databases have been maybe over-complicated.

I was brought up 40 years ago on a...

Hi All

I have been following similar threads where people are having the same issue. Logically it should be simple enough but I am struggling to find the correct solution.

To simplify my...

Hi.

OK this is not BookX or Book by Moku. I tried BookX a long while back and it completely destroyed my database!!

The way we use the system is based on the original V1.5.1 installation with...

Good morning.

This is probably a very simple change but I'm stuck at the moment!

On our book library we have Genres (Categories) which have sub-categories for authors (manufacturers) so when...

Evening all.

After working and rewriting this system for the past 4 years I have just hit another sticky patch!

We deliver downloadable e-books. In the early days we decided on (not knowing...

You're a star! Thank you. And Yes I will comment the heck out of it all. But 4 and a half years ago Zen-Cart was the better option after being screwed over by OSCommerce.

We don't "sell"...

Hi

We are doing a lot of tidying up in our Admin section which includes removing unwanted menu items.

Now we know that we can create an Administrator level beneath the main Superuser and simply...

Thanks Design75

Great idea but my intention is to do away with attributes entirely which are really slow on the server. Just add the filename as part of the add product process and check it...

Thanks mc12345678

I always love your responses but having read it over and over it just made me more confused!!

As a bit of background: the first reason I am looking to do this file existence...

Hi all.

I thought I was beginning to get to grips with reading from tables but clearly need more learning!!!!

In...

Thank you so much Carlwhat and Design75 for crawling over this so quickly.

The code changes posted here have everything working for adding new categories and you have both given me that vitally...

I just realised that line 205 should read:

'cat_series_link' => zen_db_prepare_input($cat_series_link_array[$language_id]),

I had this as $cat_seriies_link

but still get the same...

I added the new field to the categories_description table before I started recoding.

The exit is there because I wanted to see what the value of the array was on screen as it doesn't update the...

Evening all. It's been a while since I have been here but I'm stuck on a problem as I want to make some more bespoke changes.

We run a closed membership book site with multiple server access -...

As a very quick fix I increased the field size but I do get your point (this will affect the zip files as well which while they don't have spaces can be very long).

Job has gone onto the work list...

Thanks again. I downloaded the products database and found only 11 records out of 18,500 which needed correcting :)

OMG thanks guys .. sitting at the front-end you just don't get to see these things .. I'll do some more investigation.

Regards
Alan

Ok I seem to have got rid of the client Option FollowSymLinks not allowed in line 8 of /home/sites/digibooks.org.uk/public_html/db_library/pub/.htaccess by changing the .htaccess line 8 to:

...

Hi

As per my previous post we are moving our production site back to the older site as a Mirror due to the fact that our current server keeps crashing on advanced searches.

Naturally we've had...

Hi all

We are currently in the throes of creating the mirror site which is functioning perfectly with all 18,100 products and accompanying images and zip files.

Our hosts are saying that they...

Our plan of action now is to reload the live site to the old server/domain name (only difference between the two is a dash in the name).

We will then make this live whilst our host migrates the...

Hi

No I wasn't aware of this edition. I have installed it and will try the strict error reporting module with it tonight to ensure that works ok

Thanks
Alan

Madness!! Ran this on Firefox on two local systems .. neither of them reported that Strict Reporting was switched on.

Just as a hunch ran it on Microsoft Edge on my newest system ... it reported...

FINALLY!

Micorsoft Edge reported strict error reporting which Firefox failed to do!!!!!

2008 Out of memory
in:
[select c.categories_id, cd.categories_name, c.categories_status from categories...

A fresh install (so just barebones) ... with demo products ==> PASS

Reload the live data to the new database ==> FAIL

I will pursue a support ticket and see what they come back with.

That is another option I have been considering but a test database probably won't fail .. it seems that when the database hits certain high levels then the AS stops loading mid-way through the...

The databases when created with the same name are created on cl28_ and cl50 respectively. PHPMyAdmin will only show the database under those designations.

OK guys .. that was a worthwhile exercise. Reckon Rod is right pinning it down to the DB server.

DB and files replicated from web122 to web60 and Advanced Search functions with or without the...

I have tried mc1-8's suggestion - hope I interpreted it correctly!

In the working site I changed the configure.php to point to the "problem" database on server cl28 instead of it's normal cl50...

Ok .. So just perfoming Rod's suggestion - one step at a time -.

Test One: web122 (currently 17,590 products) - What's New plugin enabled: FAIL
Test Two: web122 - What's New plugin disabled -...

We don't use the bookx module .. I tried it back on web60 18 months ago and it crashed our systems horribly taking around 2 weeks to recover the site!

Hi Rod

I certainly don't have an issue with the hosts they are 24/7 live chat based in the UK but they are of course limited to what the datacenter technicians tell them.

I've decided to bite...

OK so the DB server could well be the issue ... Advanced Search just terminates early all the time now.

Hi Rod

At the weekend I can copy the latest web122 data back to the web60 DB and the files into a new directory (that way at least I will have the original scripts on web60 for comparison).

The...

Hi DrByte.

I created the file you suggested:

<?php
define('STRICT_ERROR_REPORTING', true);
?>

and placed that in the includes/extra_configures folder.

Just to clarify - the new server is new to us (September 2016) but is the same physical age as the old server at the datacenter. The old server experienced numerous crashes last year so our host...

Thanks guys for your concerted efforts to try to locate the real issue (and sorry Rod for the frustration I caused you).

I was preparing to try out Rod's test scenarious by moving files from new...

Please accept my apologies - I will reel my brain in and work through this step at a time.

"The database" = being the one with the latest data? True/false ==> TRUE

"original server" = The...

I am going to run a trial by putting a clean version of Zen-Cart into a new folder linking it to the existing database that is crashing and the image/zip folders. If that all works on the new server...

Hi The hosts say that all their platforms/ MSQL are the same on all servers but they have advised the engineers to look into it. They are also making a soft lauinch of new servers/datacenter in...

Hi RodG

Sorry I haven’t maybe been using the right terms to describe the issue. So before I plough into carrying out extensive tests I will try to clarify thiings.

My reference "The database"...

Hi and thanks for a very comprehensive explanation. All was going well until we hit 17,400 books online again today (around 5,660 categories). I am struggling to see what is going wrong though I...