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
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.
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!
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.
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
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.
Bookmarks