Quick Updates plugin [support]

[johnd]

You are exactly right. I was just frustrated at the time trying to resolve what I thought was a problem. I do appreciate those out here making Zen Cart what it is. Zen Cart has been a blessing for me and I am really happy with what it has become so far. I expect meany great things in the future and will contribute any usefull information I may come up with.

How did you resolve your layout problem. I am having similar shifting.
Thanks

[Zis]

Ok, I found it - the sql patch tried to insert an invalid value - 0 - instead of the actual group_id_value assigned to the table row. I manually replaced the @t4 variable in the patch with the appropriate value from the configuration_group tabla and can now edit the configurations from the admin.

Hi,
Do you replaced her:
SET @t4=0;

or ???

[paulm]

To everyone that gets this message when installing quick updates (or any other mod that requires you to add sql to the datase):

ERROR: Cannot insert configuration_key "" because it already exists

First install this sql (using the "Install SQL Patches" tool):

DELETE FROM configuration WHERE configuration_key = "";

And then try to install the quick updates sql again. Let us know if it helps.

[kwright]

Before I install Quick Updates, does anyone know if Quick Updates can be used to find products that are assigned to categories that don't exists?

Thanks

[paulm]

As long as you do not select a category in quick updates I think it will show all the products.

[kwright]

Cool, I'll give it a try!

I have move lots of product and category data around in our current iHTML store and know there are orphend products. With over 5K of products sorted under 100's of categories, going through one-at-a-time will be crazy making.

Having a list to work from will be much easier!

[Zis]

To everyone that gets this message when installing quick updates (or any other mod that requires you to add sql to the datase):


First install this sql (using the "Install SQL Patches" tool):

DELETE FROM configuration WHERE configuration_key = "";

And then try to install the quick updates sql again. Let us know if it helps.

[FONT=Calibri]HEEELP!!![/FONT]
[FONT=Calibri]I install:[/FONT]
[FONT=Calibri]DELETE FROM configuration WHERE configuration_key = "";[/FONT]
[FONT=Calibri]And reinstall the quick updates sql again[/FONT]
[FONT=Calibri]But…[/FONT]
[FONT=Calibri]Some orders are registered and some orders not after the modification.[/FONT]
[FONT=Calibri]The system skip orders…[/FONT]

[FONT=Calibri]How can I remove this:[/FONT]
[FONT=Calibri]DELETE FROM configuration WHERE configuration_key = "";[/FONT]

[Louis]

Restore from your backup made before you installed the mod.

You DID make a backup didn't you?

[paulm]

And in addition to the above I would like to add that I have strong doubts that your skipped orders are caused by the formentioned query.

[chadderuski]

And in addition to the above I would like to add that I have strong doubts that your skipped orders are caused by the formentioned query.

I must agree with Paul here, there is NO associate between the two.

This advice is NEVER repeated enough:

1) MAKE A FULL BACKUP OF YOUR DATA from with phpMyAdmin. The zencart admin mysql backup tool is good, but you can brute force the restore with phpMyAdmin.

2) When installing a mod you have no experience with, PLEASE for your own sanity backup your store into a subdirectory, install your data into another database, and first test here. If you botch something, you loose nothing but some time. This requires a little setup time (you need to update your configure.php files), but well worth it in the long run.

-Chaddro