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

17 Feb 2010, 23:45

#1

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

18 Feb 2010, 01:00

#2

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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

18 Feb 2010, 01:38

#3

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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?

18 Feb 2010, 01:50

#4

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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

18 Feb 2010, 01:52

#5

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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

18 Feb 2010, 02:01

#6

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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?

18 Feb 2010, 02:06

#7

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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!

18 Feb 2010, 02:36

#8

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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!

18 Feb 2010, 02:51

#9

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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

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.

18 Feb 2010, 03:06

#10

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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

18 Feb 2010, 03:53

#11

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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

18 Feb 2010, 05:57

#12

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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?

18 Feb 2010, 09:15

#13

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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

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

18 Feb 2010, 20:06

#14

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

Get Em Fast:
[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?:(

18 Feb 2010, 20:15

#15

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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.

18 Feb 2010, 21:13

#16

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

Thank you very much!!!

18 Feb 2010, 22:42

#17

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

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

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

19 Feb 2010, 01:24

#18

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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

19 Feb 2010, 01:41

#19

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Posts:: 2,072
Plugin Contributions:: 1

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

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

Thanks Kobra.

19 Feb 2010, 01:47

#20

derek_h_bao

New Zenner

Join Date:: Feb 2008
Posts:: 18
Plugin Contributions:: 0

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

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