Mike Toppa

Hi asaf – when you clicked the sync icon, did it successfully sync the album, or did it fail but not report an error? Can you try the following:

* click the sync button for a new album, and check if it’s succesful,
* click the sync button for an old album and check if it’s successful
* then click the “sync all” button and check if it’s successful

I haven’t heard of this problem before, so I’m trying to determine the scope of the syncing problem you’re having.

Hi aleli – You should be trying to connect to a picasa server – from your error message, it looks like you’re trying to connect to something called “sededecana”

Hi Mark – sorry for the late reply. I’m guessing you’re running into the same problem zer0efx ran into (above). But he upgraded his mySQL before we got to the bottom of the problem. If you have a mySQL browser like phpMyAdmin, browse the wp_shashin_album table and look for a record with the album ID you see in the error message. It may be that it’s trying to insert a record that’s already there, and it’s failing since the “on duplicate key update” option isn’t available (but it shouldn’t be relying on that in this case – if it is, then there’s a problem in my code).

Hi Mark – go to ToppaWPFUnctions.php and comment out lines 245-248. The “on duplicate key update” syntax was introduced in mySQL 4.1. In doing this you’ll lose the ability of Shashin to accommodate photos being moved from one album to another. As long as you don’t move photos between albums, you’ll be ok. I’m pretty sure that’s the only 4.1 specific code, but if you run into something else, post a follow-up.

Did you get this working? If not, let me know and I’ll take a look.

Please tag your posts (in this case a “shashin” tag) – that makes them easier to find.

I tested your SQL statement, and it worked fine for me, so it’s not a syntax problem. Let’s see if we can get a message from your database as to why it’s failing for you. Please go to line 251 again in ToppaWPFunctions.php and remove the lines you added before. Then make it look like this:

// return $wpdb->query($sql);
var_dump($wpdb->query($sql));
$wpdb->print_error();
exit;

So you’re commenting out the “return” line that’s there, and then adding 3 lines that should tell us why the database insert is failing. Then try to add the album again, and copy-and-paste the output here.

Hi – I just uploaded Shashin 2.4.2 to wordpress.org – the Shashin::getAlbumList() function should work for you now. But I don’t know why some of the widgets aren’t working for you – I’m not aware of a problem with them. I’d like to see a screenshot of your widget admin page, so I can see exactly how you’re using them and then try to reproduce it. Can you upload a screenshot somewhere I can see it?