Product videos from youtube [Support Thread]

[sigung]

Never mind. I had to change the table prefixes.

I am struggling to get this to work, what did you mean you had to change the table prefiixes? What tables are you talking about and what did you change them to please?

[sigung]

the directions say: admin/includes/modules/product/collect_info.php and go to end of the last but one table and paste the following code after this:

what in the world does:" go to the end of the last but one table mean?

I am confused - I dont know what the end of the last but one table is

What he means is go to the next to the last table and insert the code there. Good luck getting it to work, though. All I get are sql errors..

[sigung]

Hello mates,
Thanks for choosing this addon. if you experience any problems regarding the addon 'PRODUCT VIDEOS FROM YOUTUBE' please post here. I can help you.

Okay I'm posting here. All I get after installing according to instructions is this when I try to add a video ID

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myusername/public_html/admin/product_video_youtube.php on line 19
Inserted Successfully

[sigung]

Never mind. I had to change the table prefixes.

I emailed Jeremy and asked him what specifically he did to fix this. Here is his fix, I've implemented it, and it works perfectly.


admin/product_video_youtube.php
LINE 18
insert your table prefix before "products_videos"
LINE 21
insert your table prefix before "products_videos"
LINE 24
insert your table prefix before "products_videos"
includes/templates/your template/templates/tpl_modules_youtube.php
LINE 14
insert your table prefix before "products_videos"
For example. The prefix for my ZenCart tables is "cart_" So mine looks like this: cart_products_videos.

You must change both files.

[Ubique17]

Brilliant, works well - thanks for this. Especially like how easy it is to place to a specific point within the page, certainly beats the hard coding like I was doing for every clip previous to this!

[sigung]

You're quite welcome. I followed the original parts of this thread and found the one reference to how he got it to work, but it was too vague to be useful. Contacted him directly through his zen cart contact page and he was kind enough to respond with specifics. Thought it might be a good idea to let everyone else in on it. Glad I could help in some small way.

[kencor1]

I tried to use this mod but I could not get the video to display on the product page. I applied all of the fixes listed here, everything seems to load fine but nothing shows up on the product page. Does anyone have any ideas?

Thanks
Tom

[sigung]

I tried to use this mod but I could not get the video to display on the product page. I applied all of the fixes listed here, everything seems to load fine but nothing shows up on the product page. Does anyone have any ideas?

Thanks
Tom

Can you be more specific in regards to the statement "everything seems to load fine" What exactly is loading?

[sgspeer]

I emailed Jeremy and asked him what specifically he did to fix this. Here is his fix, I've implemented it, and it works perfectly.


admin/product_video_youtube.php
LINE 18
insert your table prefix before "products_videos"
LINE 21
insert your table prefix before "products_videos"
LINE 24
insert your table prefix before "products_videos"
includes/templates/your template/templates/tpl_modules_youtube.php
LINE 14
insert your table prefix before "products_videos"
For example. The prefix for my ZenCart tables is "cart_" So mine looks like this: cart_products_videos.

You must change both files.

Hi Where can i finf the " Prefix for my ZenCart tables" .

Thank you in advance

[sigung]

either download a copy of your:

includes/configure.php file or open it with the built in editor in cpanel.

do a find for the phrase:

define('DB_SERVER_USERNAME

and you will come to a line that says something like this:

define('DB_SERVER_USERNAME', '( your database prefix here )_zc1');

so, it might look like

define('DB_SERVER_USERNAME', 'sgspeer_zc1');

or whatever name you set up originally when you defined your database.