Quick Updates

Hi folks
I have just downloaded the Quick Update mod from the downloads section, installed it onto my v1.3.0.1 server, run the sql script, configured the bits in admin on what i would like to be able to edit.

BUT when i try to use the Quick Updates from the Catalog menu, no matter what category i select from my store no products are listed. I have checked the readme file included with the mod on the usage - but there is no info - can anyone help?

Jayson how did you get the SQL bit to go right?

I got this when I went to 'Install SQL Patch' - Browsed, found the right file and uploaded:

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');
1062 Duplicate entry '300' for key 1
in:
[INSERT INTO HODLLC_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Did everything upload fine for you? Is there a permission somewhere you changed? For the life of me honestly I cannot tell if there is an extra blank space in the SQL thing.

The sql script went okay for me, as did the file uploads BUT the module is not working as I do not see any items to update?

hmmm... which zip file do you have and where'd you get it?? My zip file's name is Quick_Updates_1.3 and I think I got it at ZenPortali. Maybe we have the wrong files?

I installed quick updates that i got from the downloads section. At first I was missing all the products in the edit field. Non were showing up. And there were no configuration options either. So on a whim I copied and pasted the sql txt from the UPGRADE folder (I tried uploaded the file as prescribed in the readme.txt but that didnt work) and viola, everything is working fine now. You might give that a shot.

Jason

https://www.abcjewelrydepot.com

Jason did you do a new install? or upgrade from prior stuff? I am just wondering if the sql file you took from the Upgrade folder is the one I should use, instead of the sql file from the new install folder. I keep getting that error with it.

I get the same thing. Blank Browser page with:

If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

No products show up either.

I got it. Open the SQL file in a text editor (I used TextPad) and just delete the first line of SQL save it and upload the SQL a 2nd time. Worked like charm.

Sql is fine BUT No products show up :(

dear guys,

as far as I know, the products not show up just because your server configuration is not with register_globals enabled (due to security issues).

if you are entitled to access .htaccess file, add the following code might help register globals enabled:
php_flag register_globals on

if it still doesn't work, probably this feature is enable-prohibited by your web host provider. contact them and ask if they could help you in this case.

good luck

ladysaat,

I did a new install. I had not had it in my store before. Again, I tried uploading the sql file but that did not work. So I copied and pasted it into the field provided in the sql update page. That did the trick for me. I have 5 stores and its working fine in all of them.

Jason

https://www.abcjewelrydepot.com

Herm. Okay I will do what you did. This will be the fifth time of me putting it on there. It's a PAIN to back it up and remove everything and revert to solid running backup :P If I wasn't such a dunce at times I wouldn't have to go through this LOL! Obviously we're talking operator error here :laugh:

I did get a pm from someone offering to install it but I haven't been able to catch them online yet :cry:

jayson.gurney:

The sql script went okay for me, as did the file uploads BUT the module is not working as I do not see any items to update?

Jason-

I see you have recently posted multiple times in various different mod support threads reporting you are having issues accessing various mod related admin pages.

Likely due to a db configuration issue on your Zen Cart installation.

Before installing any more mods best to resolve your db issue.

As Dr Byte suggested elsewhere it is likely a db prefix issue. Look at the list of tables in your db (e.g. with phpmyadmin). If you have many tables with zen_ prefixes but other tables without the prefix then that is likely your issue.

Thus probable solution is to fix the prefix ;-)

Woody

langtu123:

dear guys,

as far as I know, the products not show up just because your server configuration is not with register_globals enabled (due to security issues).

if you are entitled to access .htaccess file, add the following code might help register globals enabled:
php_flag register_globals on

if it still doesn't work, probably this feature is enable-prohibited by your web host provider. contact them and ask if they could help you in this case.

good luck
Thanks for the reply where does the .htaccess file reside in the root directory of the store?

Hi folks I am getting closer to resolving the issue I have with the installation of this module - on my local test server anyway.

First of I have set globals to on in my local php.ini file

The upload of the module files is also ok, BUT when i run the sql script via the upload file section of the sql import it fails. After a clean install of the server i copy and paste the sql script into the query entry box and that works!

Can anyone explain why the attached file does not work with the file upload import feature of v1.3.0.1?

I think that's the same file I have. I tried the copy and paste also, to no avail. Portali got ahold of me and is going to help me install it. I don't know what I'm looking at when I open the file in a text editor. So I have no idea what it should look like (in ref. to the "blank spaces" part of the error). I think I'm going to download what you've attached and copy and paste it like you did. Maybe you have different stuff in yours? All my other mods (easy pop, image handler2 etc.) are working well and I mssgd my host to make sure the reg. globals were on.

jayson.gurney:

Can anyone explain why the attached file does not work with the file upload import feature of v1.3.0.1?

What error do you observe?

kelvyn:

What would the tasks be to add a column to quick updates, to change the sort order of products? Or is there another/quicker/better way?

Click the little up/down arrows above the column headings.

Could it be that the sql file is attempting to put a configuration_group_id at a high count when the id is actually auto-generated.

Looks to me like the sql wants to install "300" when the next id is 28.

:unsure:

the configuration number doesn't matter as long as 300 isnt being used by anything else.

as for Globals yes this module requires globals ON,
however if you do a little research the globals on isnt the massive evil that some try to make it out to be.