Tabbed Products ''LITE'' version - Delimiter based

[p m]

SQL problem?

i ran the SQL patch through the zencart interface, but the only value showing up under the configuration --> tabbed products config table is "global product description tab".

so i restored my backed up database, and tried again with cut-and-paste via phpMyAdmin. same thing.

i want to have the product image, title and price display under the tabs header. as far as i can tell from reading this long thread, i need to turn on mainimageontabs. but that's not showing up.

any idea?

this is a week-old installation of zencart 1.3.5. a few mods so far, all carefully backed up.

here's one of the product pages.

[qhome]

SQL problem?

i ran the SQL patch through the zencart interface, but the only value showing up under the configuration --> tabbed products config table is "global product description tab".

so i restored my backed up database, and tried again with cut-and-paste via phpMyAdmin. same thing.

i want to have the product image, title and price display under the tabs header. as far as i can tell from reading this long thread, i need to turn on mainimageontabs. but that's not showing up.

any idea?

this is a week-old installation of zencart 1.3.5. a few mods so far, all carefully backed up.

here's one of the product pages.

Hi P.M.,

Ericpeng also had this problem. And I know I've run into this in the past as well. I'm not sure exactly why it does it, but sometimes the database doesnt hold the value of last_insert_id(). A few posts up I give instructions on how to delete those records and try again but i think ericpeng had to actually edit them inside phpmy admin and change the configuration_group_id to match the latest group.

Try copy and pasting the contents of the sql file into the textarea as opposed to uploading the file. or try both and see if any of them work. Be sure to do the whole file as one step.

Anyone else with db skill know a better way of doing it?

[p m]

i'd already tried to restore and then retry using cut-and-paste from the SQL file, and it didn't work. based on ericpeng's experience, i went right to phpMyAdmin.

and it worked! i was surprised -- i'd never edited an SQL table before.

i'll go through the steps one by one:

1. in phpMyAdmin --> table: configuration_group:
Tabbed Products config (last on the list because most recently installed) has configuration_group_id of 32 (in my zencart installation -- this would vary for others)

2. in phpMyAdmin --> table: configuration:
the last ten items on the list (#592-601 on my set-up) list are the elements of tabbed products config. the first one, Global Product Description Tab, had the correct corresponding configuration_group_id of 32.

the others had the wrong value in that column, in a particular pattern = (n-1), where n = # on the item list in the configuration table (#592-601, as i mentioned). so Global Main Image On Tab, #593 in my table, had a configuration_group_id of 592, and Show Tab Headers when Javascript is Off, #601 had a configuration_group_id of 600.

someone who knows more about SQL than i do should be able to figure out the syntax error from that description, right?

3. select the 9 incorrect items and edit ("change"). insert the correct corresponding value for configuration_group_id (#32 in my case) in all items and save.

4. browse zencart admin to configuration --> tabbed products config, and there they all are...

hope that helps.

[qhome]

i'd already tried to restore and then retry using cut-and-paste from the SQL file, and it didn't work. based on ericpeng's experience, i went right to phpMyAdmin.

and it worked! i was surprised -- i'd never edited an SQL table before.

i'll go through the steps one by one:

1. in phpMyAdmin --> table: configuration_group:
Tabbed Products config (last on the list because most recently installed) has configuration_group_id of 32 (in my zencart installation -- this would vary for others)

2. in phpMyAdmin --> table: configuration:
the last ten items on the list (#592-601 on my set-up) list are the elements of tabbed products config. the first one, Global Product Description Tab, had the correct corresponding configuration_group_id of 32.

the others had the wrong value in that column, in a particular pattern = (n-1), where n = # on the item list in the configuration table (#592-601, as i mentioned). so Global Main Image On Tab, #593 in my table, had a configuration_group_id of 592, and Show Tab Headers when Javascript is Off, #601 had a configuration_group_id of 600.

someone who knows more about SQL than i do should be able to figure out the syntax error from that description, right?

3. select the 9 incorrect items and edit ("change"). insert the correct corresponding value for configuration_group_id (#32 in my case) in all items and save.

4. browse zencart admin to configuration --> tabbed products config, and there they all are...

hope that helps.

Thank you P.M. for detailing those steps! Glad you got it working and that it was easy enough for you. I am still trying to find out a better way.

[knuckle-101]

qnome,
When I turn on cross sell, it gives a parse error, and then when i turned it on before upgrading to 3.6 the product description would disappear, any idea why?

Cross sell is installed.

[knuckle-101]

ok, parse fixed, product description still missing.

[Woodymon]

Q-

Pretty cool, TPL 3.6 admin edition is. Installed on a fresh ZC 1.35 and have not done much configuration or mod loading yet (IH2, Xsell or AAQ).

Any "ez" method to place product details on a tab (could be it's own tab or on same tab as product description or on same tab as add to cart) but leave main product image, product name and price above tabs?

Woody

[knuckle-101]

Any idea whats causing this error?

Warning: ereg_replace(): REG_EMPTY in /home/again/public_html/includes/templates/template_default/templates/tpl_tabbed_products_lite.php on line 89

thanks

[qhome]

Any idea whats causing this error?

Warning: ereg_replace(): REG_EMPTY in /home/again/public_html/includes/templates/template_default/templates/tpl_tabbed_products_lite.php on line 89

thanks

That is called from the Additional Images code that I replicated from zen-cart core code. Im surprised you'd ever see that error as it must pass 5 outer logic statements to even reach that. Did you edit something that would break that?

[knuckle-101]

Im sorry , forgot to repost the fix, the error was caused from a image that did not have an extension jpg, gif so on.

Anyone who uses this mod, make sure you have extensions at the end of the image you upload for the product.

Rob