WP iTunes

Aww ok well I deleted the xml file and redid the settings, the itunesblogger is writing to the database. Am I calling the function properly? Or do I need to point the function to the wpitunes.php file.
I now have the function in index.php, and am stating <?php wp_get_itunes(3); ?>
Am I calling the function properly?
Thanks for the help ??

Ok…today all the tables are created in the database..but i still get the same error:
Database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
SELECT * FROM wp_itunes ORDER BY added_date DESC LIMIT
if the code in de wp-itunes.php is
$itunes_key = “personaltest”;
the line in the ITunesBlogger must be..
https://www.myweblog.com/?wpitunes=personaltest&track=%t&artist=%a&album=%b&genre=%g
or is this wrong?

Still waiting for an answer ??

dawson, the line in iTunesBlogger looks fine, it looks like there is some problem with the database query to retrieve the iTunes tracks…Do you know what version of mySQL your host is running? also, is the table named something like wp_itunes in your database, or whatever the prefix is for all your other wordpress tables?

Hi Lucky thanks for your answer…the mysql Version is 4.0.20 , the table in the database is named wp_itunes and there are following fields in the table:
itunes_id
album
track
artist
genre
image
added_date
The output-code on the page is ‘<?php get_wp_itunes($limit); ?>’
Thanks for your help, love this plugin! Hope we can solve my problem ??

silly question, but does $limit have a value in the output code above? try putting a value in there, like 3 or just leaving it as ‘<?php get_wp_itunes(); ?>’…

that should be all you have to put in the output file…have you looked in the database and seen if there are any songs in the wp_itunes table? if there are no values there, something is not set correctly between iTunesBlogger and your WordPress install…it could either be the $itunes_key value, or the URL is not pointing to the correct path on your site…

No there are no values in the wp_itunes table so…i’ll check the ituneskey and URL.. ??
thx

I don’t think the plugin is creating the table for me either. I went into MyPHPAdmin and I don’t see a WP-itunes table. I think this is because my wordpress is installed in a separate directory (/wp). Anyway, this plug-in sounded cool. Too bad I lack the SQL and PHP skills to install it correctly. ??
Here is the error if anyone wants to help me out:
Fatal error: Call to undefined function: wp_get_itunes() in /home/asian/public_html/wp/wp-includes/footer.php on line 50
Also, I think I might have this error because I split up my index.php into three parts (header, main, footer). I’m going to deactivate the plugin for now. Any suggestions/help would be greatly appreciated. Thanks!

If you look at the code you can see that the function is :
get_wp_itunes(); and not wp_get_itunes();
I had same problem, but now it works fine ??

Okay I fixed that, and as expected, I don’t think I have the table created. When does the plugin create the table? Is it when I activated it in WP? Anyway, here is the error message:

Database error: [Table 'asian_wrdp1.wp_itunes' doesn't exist]
SELECT * FROM wp_itunes ORDER BY added_date DESC LIMIT 1

How does one create the table manually in PHPMyAdmin? I need a very descriptive method since it looks very confusing. Thanks.
??

the table gets created the first time that iTunesBlogger posts a playing song to your site…

ooh i got it working . anyone know how to adjust the time to EST? right now it shows up as 3:30 am (dec 5) when it’s 10:30 pm on dec. 4. yay!

Alright, since installing the plugin, I’m getting two errors.
Firstly, I’m having a caching trouble where when I reload my home page, the track listing isn’t getting updated with the most recent tracks played.
Has anyone else seen this issue? I’m running the server on a Windows 2000 Pro box, running Apache 2, MySQL 4.0.22, and PHP 5.0.3.
Oh, and is there an easy way to mod the plugin so that if no image was found from Amazon that a general image could be loaded? Thanks

Whoops, alright, you can ignore my question about the general image. *Shakes head in self disappointment*