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?

[Derek H Bao]

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?

[Get Em Fast]

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


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

[Derek H Bao]

[QUOTE=Get Em Fast;845109]

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

[Get Em Fast]

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.

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