Can't send SQL when install Column Layout Grid for Product Listing

[Derek H Bao]

Thank you very much!!!

[kobra]

Derek H Bao,
From your post #10

MySQL said:

#1146 - Table 'health_zc2.configuration' doesn't exist

What happened???? and the "NULL , NOW( ) , NULL , " are red colored

What were you using when you got this message???

I suspect that you were in phpmyadmin....

Try from Your zc admin again
Open the sql patch file in a PLAIN Text editor Not word or word pad or the like.....Notepad is preferable to any word processor

Paste the sql patch into the zc admin window

Reason: zc admin adjusts for table prefixes

Alternatively you can manually edit the sql patch where it creates the insert into the table and use phpmyadmin

INSERT INTO configuration

change to

INSERT INTO health_zc2.configuration

[Derek H Bao]

tried and tired, different error appeared, give up...

[Get Em Fast]

Ahhh.......don't give up, yet......help has just arrived.


Thanks Kobra.

[Derek H Bao]

Thank you guys Kobra and Get Em Fast so much!!! So tired... want take some days break...

[Derek H Bao]

Ahhh.......don't give up, yet......help has just arrived.


Thanks Kobra.

the problem has fixed up after the server updated (to php 5 or something, can't remember it). everything going well now. thank you so much for your help!

[Get Em Fast]

Oh, yea! That's what we like to hear around here. Thanks for the update letting us know that all is well, and what the problem was.

[rjspomer]

I have similar issue when trying to patch.

this is the response.

1062 Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen'
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:
Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');]
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.


Thanks for any help