SQL Query Executor

[DrByte]

I was playing with a dev site and attempted to paste in a 1.5MB txt file of queries

What kind of queries?

and it gave me an error saying "Error: Nothing to do - no query or query-file specified."

That suggests that the data submitted didn't actually get received by the server.[/quote]

I then manually split the file in half and pasted each individually and it worked fine for both files (~4500 queries for one and ~5000 queries for the other).

Well, I guess you've found your best workaround.

There isn't a limit of 1MB to paste in perhaps or the number of queries that can be run?

No.

I know this is an obscure issue but am curious where the limit is imposed. I looked at sqlpatch.php in the admin directory and didn't see a limiter, and I didn't see a class or module file in the admin for sqlpatch either.

That's because the limit is not imposed by Zen Cart. It must be something in your browser or in your server's PHP configuration.

Perhaps it is in the php.ini file on the server? If so, maybe I can override this in the root. Any other ideas?

no limits? Hmmm then what might limit it? A setting on the server?

Maybe your post_max_size in your php.ini


I'm more interested in understanding why you're pasting such huge queries into a tool that's intended for small minor patching, not mass insertion of records or site upgrades.