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?

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: