SQL question... help please!

3 Mar 2012, 2:09 AM

#1

feznizzle

Totally Zenned

Join Date:: Apr 2010
Posts:: 900
Plugin Contributions:: 0

SQL question... help please!

In the SQL, what controls the turning on/off of product meta title and product name?

Here is a screen shot:
http://904roofing.com/metascreen.jpg

Can somebody show me how I could write a little script I could send thru the sql patch that would flip the switch to ON for all prod meta titles?

Then another script to for flipping on all the product names?

Thanks,
Mike

3 Mar 2012, 4:19 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: SQL question... help please!

You really should fix your import problem instead: http://www.zen-cart.com/forum/showthread.php?p=1108596#post1108596

This will turn the title/prod-name switches on for EVERY product in your database:

UPDATE products SET metatags_title_status = 1, metatags_products_name_status = 1;

Use with caution. Backup your database first.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Mar 2012, 5:40 PM

#3

feznizzle

Totally Zenned

Join Date:: Apr 2010
Posts:: 900
Plugin Contributions:: 0

Re: SQL question... help please!

DrByte,

Words cannot express how grateful I am! This worked perfectly! If you weren't a dude I'd kiss you!:D

I totally agree with you that it would be far better to fix the import problem, but for some reason Apsona forgot to include the metatags_products_name_status field in their ShopAdmin.

Thanks again,
Mike

3 Mar 2012, 5:58 PM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: SQL question... help please!

:D You can kiss Ajeh instead. She fixed my typo :)

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Mar 2012, 9:31 PM

#5

feznizzle

Totally Zenned

Join Date:: Apr 2010
Posts:: 900
Plugin Contributions:: 0

Re: SQL question... help please!

aaah yes, a much more pleasant idea! :yes: