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

Hi all, I just can't send the SQL patches when I install the Column Layout Grid for Product Listing, why? Thanks lot!!!

Any more details..........? Any error messages? Any messages at all? Where are you trying to insert this code?

Thanks quick reply!
I use Column Layout / Grid Layout for Products Listing (Add On Module for Zen Cart v1.3.8)
After upload two .php files, then I use Admin->Tools->Install SQL Patches to send the code provided with this module. Here the message.

"The server encountered an internal error or misconfiguration and was unable to complete your request.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

Why?

Are you using the "Browse & upload" method, or are you using the "copy & paste" method?

Quote:

---

Originally Posted by Get Em Fast

Are you using the "Browse & upload" method, or are you using the "copy & paste" method?

---

Yes, I think I was using "copy & paste" method. ?

Don't know why ZC won't take it. I just ran it mine, and it went through install & uninstall with flying colors.

Have you tried going through phpMyAdmin to run the SQL?

Quote:

---

Originally Posted by Get Em Fast

Don't know why ZC won't take it. I just ran it mine, and it went through install & uninstall with flying colors.

Have you tried going through phpMyAdmin to run the SQL?

---

Ok, I will try phpMyAdmin, see how's going. Thank you very much!

Quote:

---

Originally Posted by Get Em Fast

Don't know why ZC won't take it. I just ran it mine, and it went through install & uninstall with flying colors.

Have you tried going through phpMyAdmin to run the SQL?

---

Hi, I am not good on SQL. Is this problem caused by permission of files? Or can you just tell me how did you do? Thanks a million!

Quote:

---

Originally Posted by Get Em Fast

I just ran it mine, and it went through install & uninstall with flying colors.

---

Quote:

---

Originally Posted by Derek H Bao

Or can you just tell me how did you do? Thanks a million!

---

The way I just done it was by opening the SQL file with notepad, select all, copy, then going to Admin>Tools>Install SQL Patches, then paste the code into the blank field and click send.

But, that's probably the way you done it also, right?


Do you know how to get to your phpMyAdmin on your server?

If so, just click once on your database on the left side making sure it's highlighted, then in the top menu, click on the SQL tab. In the next screen, you'll see a big box...........paste your code into that box and click Go. You should see the green bar at the top telling you that 2 tables was processed.

Thank you so much! I did as you did. Here the reply I had:

Error
SQL query:

INSERT INTO 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:<br />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"),'
);

MySQL said:

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

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

According to that, looks like you're missing a configure table? Do you see that table in the list of tables on your database?

Quote:

---

Originally Posted by Get Em Fast

According to that, looks like you're missing a configure table? Do you see that table in the list of tables on your database?

---

I am back, sorry late reply. I see the zen_configuration and zen_configuration_group table. Are they the tables you mentioned?

[QUOTE]
#1146 - Table 'health_zc2.configuration' doesn't exist
[/QOUTE]


It's looking for that table...........should that table exist?

[QUOTE=Get Em Fast;845109]

Quote:

---

#1146 - Table 'health_zc2.configuration' doesn't exist
[/QOUTE]


It's looking for that table...........should that table exist?

---

No, there isn't. But I check my another database which is good with this function doesn't have this kind of table as well. Should I create it myself?:(

Well, you might try creating the table yourself...........you can always delete it, if it doesn't help, right?


In the mean time, I'm gonna see if I can get someone who's a lot more experienced with SQL to review this thread, just to make sure I don't lead you in the wrong way.

Thank you very much!!!

Derek H Bao,
From your post #10

Quote:

---

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

Code:

---

INSERT INTO configuration

---

change to

Code:

---

INSERT INTO health_zc2.configuration

---

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

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


Thanks Kobra.

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

Quote:

---

Originally Posted by Get Em Fast

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


Thanks Kobra.

---

:smile: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!

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.

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

My Problem was it was already added :blush: