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

[Derek H Bao]

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

[Get Em Fast]

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

[Derek H Bao]

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?

[Get Em Fast]

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

[Derek H Bao]

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

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

[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?

[Derek H Bao]

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!

[Derek H Bao]

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!

[Get Em Fast]

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

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.

[Derek H Bao]

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