Re: Tabbed Products ''LITE'' version - Delimiter based
after uploads all this files to my server
Quote:
/includes/templates/my_template/css/stylesheet_tablitev3_silver.css
/includes/templates/my_template/jscript/jscript_tablitev3.js
/includes/templates/my_template/templates/tpl_product_info_display.php
/includes/templates/my_template/templates/tpl_product_music_info_display.php
/includes/templates/my_template/templates/tpl_product_free_shipping_info_display.php
/includes/templates/my_template/tpl_modules_tabbed_products_lite_reviews.php /includes/templates/my_template/templates/tpl_tabbed_products_lite.php
/includes/modules/tabbed_products_lite.php
/includes/languages/english/extra_definitions/tabbed_products_lite.php
/includes/templates/my_template/images/(all gif files)
my product info just dissapears.. nothing shows
and i try to upload this file TabbedProducts_v3.8_Full.sql from admin>tools but i get this error
Quote:
1146 Table 'mensdesi_zc1.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
why is that?? wht ive done wrong..?:no:
Re: Tabbed Products ''LITE'' version - Delimiter based
Quote:
Originally Posted by
miles
after uploads all this files to my server
my product info just dissapears.. nothing shows
and i try to upload this file TabbedProducts_v3.8_Full.sql from admin>tools but i get this error
why is that?? wht ive done wrong..?:no:
This is because you are using a prefix in your database. Edit the included sql file and globally replace:
Code:
configuration_group
with
Code:
mensdesi_zc1.configuration_group
(Do that one first)
After that one do:
with
Code:
mensdesi_zc1.configuration
So you should result in things like:
DELETE FROM `mensdesi_zc1.configuration_group`
and
INSERT INTO mensdesi_zc1.configuration_group
This will solve your empty page problem that is occurring because it is erroring on your missing database calls.
Re: Tabbed Products ''LITE'' version - Delimiter based
I think this is a two thumbs up contribution.
I am not exactly a coder, but had some basic training.
How do I add to the Admin section the Attributes tab?
I have a product with brief description and underneath some sections can be configured.
The product nicely appears on the tab, however, I'd like the Attribute section under a different tab, let say "configure"
What happens now is that the Attributes show up on every page the tab opens, including the Review tab.
and this is ugly. Plus I have a dupplicate Product description tab with zero content.
Any suggestions?
Re: Tabbed Products ''LITE'' version - Delimiter based
Happen to have a link that I could see?
Re: Tabbed Products ''LITE'' version - Delimiter based
Paging President qhome....
I finally got around to upgrading to 3.8. All seemed to go well until I tried to apply the sql file and now I have nothing on the product pages. I got the following error message when I tried to upload the sql file:
1146 Table 'stormstr_zcstore.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Any ideas qhome? I made a back up of the files and database just a couple days ago so all isnt lost if its bad. The store is essentially down since you cant see any products, but I can deal with that for now if it can be fixed.
Re: Tabbed Products ''LITE'' version - Delimiter based
Oh, I just noticed as well, that my Tabbed Products Config on the admin side isnt showing anything if that helps any....
Re: Tabbed Products ''LITE'' version - Delimiter based
where did you run the sql file, in phpmyadmin or in the ZC install sql patches admin link? if you ran it in phpmyadmin, you need to put your prefix on all the tables created by the sql file. if you're running it in the ZC SQL Patch thing.. well.. idk lol. qhome would probably know better in that case :)
Re: Tabbed Products ''LITE'' version - Delimiter based
Qhome,, you mean i should replace the whole configuration_group & configuration with mensdesi_zc1.configuration_group & mensdesi_zc1.configuration in my SQL file..?
Re: Tabbed Products ''LITE'' version - Delimiter based
Quote:
Originally Posted by
miles
Qhome,, you mean i should replace the whole configuration_group & configuration with mensdesi_zc1.configuration_group & mensdesi_zc1.configuration in my SQL file..?
Yes. Same goes for you SyntheticShield. Replace with your prefix. I didnt think of prefixes when i created the file. sorry.
Re: Tabbed Products ''LITE'' version - Delimiter based
Okay, I got the script to run after a lot of trial and error from the ZC Install SQL patch page.
I was thinking that the table prefixes had to be added to all the statements, come to find out it only needed to be added to one of them.
Anyway, I got it installed, I can see my products again, but I have a problem with the Configuration > Tabbed Products Config link again. I show three of them on the menu, and none of them show anything on the page. I had this issue with the last upgrade, but one of the links worked, this time none of them do.
Any suggestions on what I should do? The gids are as shown below for the three links.
gID=900
gID=901
gID=905
Should I just reload the database with my latest back up and then reapply the 3.8 Sql patch now that the table prefixes are set correctly?
That shouldnt affect any of the files that were uploaded for 3.8, correct?