This is the warning on Test
warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in .../includes/database.mysqli.inc on line 323.
It retrieves some data but surely not all arrays. Latest beta5 version. In the node I bypass the error with making it hidden in the display field as suggested but the test shows the error anyhow and not everything is retrieved. Ideas?

CommentFileSizeAuthor
#6 Modules-dev.arcticreviews.co_.uk_1256651246697.png347.16 KBmichaelfoggin
#4 Amazon API - 1.png44.78 KBmichaelfoggin
#4 Amazon API - 2.png50.28 KBmichaelfoggin
#4 Amazon API - 3.png50.13 KBmichaelfoggin

Comments

charos’s picture

charos commented
Title: Partial data retrieved but with error mysqli_real_escape_string() expects parameter 2 to be string, array » Partial data retrieved but with error mysqli_real_escape_string() expects parameter 2 to be string, array is SOME products

warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in .../includes/database.mysqli.inc on line 323. This happens with e.g. this ASIN: B000A2GYEO
But with this ASIN: 0805444777 no error is shown. Ideas?

FrontBurner’s picture

FrontBurner commented

subscribing

michaelfoggin’s picture

michaelfoggin commented
Version: 6.x-1.0-beta5 » 6.x-1.0-beta7

likewise subscribing...

using example ASIN as in #1 I get the following returned

Array
(
    [asin] => B000A2GYEO
    [salesrank] => 261899
    [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3D1J2Q3JPFDP3DJM315HR2%26tag%3Darctrevi0e-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO
    [listpriceamount] => 1999
    [listpricecurrencycode] => GBP
    [listpriceformattedprice] => £19.99
    [binding] => Audio CD
    [ean] => 0754863202322
    [format] => Import
    [label] => Neurodisc
    [manufacturer] => Neurodisc
    [numberofdiscs] => 1
    [originalreleasedate] => 2004-02-24
    [productgroup] => Music
    [producttypename] => ABIS_MUSIC
    [publisher] => Neurodisc
    [releasedate] => 2004-02-24
    [studio] => Neurodisc
    [title] => See the Sound
    [upc] => 754863202322
    [artist] => Array
        (
            [0] => Etro Anime
        )

    [participants] => Array
        (
            [0] => Etro Anime
        )

    [imagesets] => Array
        (
            [smallimage] => Array
                (
                    [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg
                    [height] => 75
                    [width] => 75
                )

            [mediumimage] => Array
                (
                    [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg
                    [height] => 160
                    [width] => 160
                )

            [largeimage] => Array
                (
                    [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg
                    [height] => 216
                    [width] => 216
                )

        )

)
michaelfoggin’s picture

michaelfoggin commented
StatusFileSize
new Amazon API - 3.png50.13 KB
new Amazon API - 2.png50.28 KB
new Amazon API - 1.png44.78 KB

I think I've narrowed this problem down to music CD's.

If I test against books, laptops, power drills, games, or even MP3 downloads all is fine.

Everytime I test against a CD I get a couple of errors (see attached). These show up twice per node everytime I run CRON which isn't good considering the site is a music review site!

I'm comparing the arrays returned from different product types but I can't debug code so not sure what's causing the problem. Hopefully this message will prove useful to someone else in fixing the issue.

Cheers :)

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Status: Active » Postponed (maintainer needs more info)

I am unable to recreate this in the current version (tonight's dev release). I tested by using this ASIN in an ASIN cck field, and also on the admin test page. Please re-check.

Thanks,
-Randy

michaelfoggin’s picture

michaelfoggin commented
StatusFileSize
new Modules-dev.arcticreviews.co_.uk_1256651246697.png347.16 KB

Hmm...

I still get it. I'm attaching a screendump so you can see what other modules I have installed / enabled / configured.

If you spot something I should add / delete / enable / disable I'd be happy to oblige.

Cheers :)

Mik

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

I haven't had anybody tell me how to recreate this, so can't really pursue it. If you use the scenario I outlined in #5, do you get this error? When? How?

The way to resolve this, if you can demonstrate it on a test/dev install, is to add something like this to the line right before the offending line, includes/database.mysql.inc, line 323:

if (is_array($text)) {
  drupal_set_message("Got array instead of text. \$text==".print_r($text,TRUE));
  drupal_set_message(print_r(debug_backtrace(),TRUE));
}

Please try that, and I think it will tell us all.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

I read this more carefully and now am able to recreate the issue, so will get it fixed. I hadn't understood that this only happens on the test page (admin/settings/amazon/test).

michaelfoggin’s picture

michaelfoggin commented
Status: Postponed (maintainer needs more info) » Active

I updated includes/database.mysqli.inc rather than includes/database.mysqli.inc and get the following.

Hope this assists :)



    * Got array instead of text. $text==Array ( [0] => Etro Anime )
    * Array ( [0] => Array ( [file] => D:\WWW\drupal-6.14\includes\database.inc [line] => 225 [function] => db_escape_string [args] => Array ( [0] => Array ( [0] => Etro Anime ) ) ) [1] => Array ( [function] => _db_query_callback [args] => Array ( [0] => Array ( [0] => %s [1] => %s ) ) ) [2] => Array ( [file] => D:\WWW\drupal-6.14\includes\database.mysql-common.inc [line] => 41 [function] => preg_replace_callback [args] => Array ( [0] => /(%d|%s|%%|%f|%b|%n)/ [1] => _db_query_callback [2] => INSERT INTO ard_amazon_music (asin, artist, label, studio, numberofdiscs) VALUES ('%s', '%s', '%s', '%s', %d) ) ) [3] => Array ( [file] => D:\WWW\drupal-6.14\includes\common.inc [line] => 3468 [function] => db_query [args] => Array ( [0] => INSERT INTO {amazon_music} (asin, artist, label, studio, numberofdiscs) VALUES ('%s', '%s', '%s', '%s', %d) [1] => Array ( [0] => B000A2GYEO [1] => Array ( [0] => Etro Anime ) [2] => Neurodisc [3] => Neurodisc [4] => 1 ) ) ) [4] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon_media\amazon_media.module [line] => 103 [function] => drupal_write_record [args] => Array ( [0] => amazon_music [1] => stdClass Object ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) [5] => Array ( [function] => amazon_media_amazon_item_insert [args] => Array ( [0] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) [6] => Array ( [file] => D:\WWW\drupal-6.14\includes\module.inc [line] => 471 [function] => call_user_func_array [args] => Array ( [0] => amazon_media_amazon_item_insert [1] => Array ( [1] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) ) [7] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 539 [function] => module_invoke_all [args] => Array ( [0] => amazon_item_insert [1] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) [8] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 553 [function] => amazon_item_insert [args] => Array ( [0] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) ) [1] => 1 ) ) [9] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 350 [function] => amazon_item_save [args] => Array ( [0] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) ) ) ) [10] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 309 [function] => _amazon_item_batch_lookup_from_web [args] => Array ( [0] => Array ( [0] => B000A2GYEO ) ) ) [11] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 289 [function] => amazon_item_lookup_from_web [args] => Array ( [0] => Array ( [0] => B000A2GYEO ) ) ) [12] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.admin.inc [line] => 140 [function] => amazon_item_lookup [args] => Array ( [0] => B000A2GYEO [1] => 1 ) ) [13] => Array ( [file] => D:\WWW\drupal-6.14\includes\form.inc [line] => 774 [function] => amazon_test_form_submit [args] => Array ( [0] => Array ( [asin] => Array ( [#type] => textfield [#title] => Amazon Product ID [#description] => The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number. [#required] => 1 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => asin ) [#array_parents] => Array ( [0] => asin ) [#weight] => 0 [#processed] => 1 [#attributes] => Array ( ) [#input] => 1 [#size] => 60 [#maxlength] => 128 [#autocomplete_path] => [#process] => Array ( [0] => form_expand_ahah ) [#name] => asin [#id] => edit-asin [#value] => B000A2GYEO [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [submit] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit [#defaults_loaded] => 1 [#sorted] => 1 ) [#parameters] => Array ( [0] => amazon_test_form [1] => Array ( [storage] => [submitted] => [post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) ) ) [#build_id] => form-f1a59b34bef78377e68536c898945ca9 [#type] => form [#programmed] => [form_build_id] => Array ( [#type] => hidden [#value] => form-f1a59b34bef78377e68536c898945ca9 [#id] => form-f1a59b34bef78377e68536c898945ca9 [#name] => form_build_id [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_build_id ) [#array_parents] => Array ( [0] => form_build_id ) [#weight] => 0.002 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#defaults_loaded] => 1 [#sorted] => 1 ) [#token] => amazon_test_form [form_token] => Array ( [#id] => edit-amazon-test-form-form-token [#type] => token [#default_value] => 44d46839fd54dbdea0daff8cd665cd20 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_token ) [#array_parents] => Array ( [0] => form_token ) [#weight] => 0.003 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => form_token [#value] => 44d46839fd54dbdea0daff8cd665cd20 [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [form_id] => Array ( [#type] => hidden [#value] => amazon_test_form [#id] => edit-amazon-test-form [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_id ) [#array_parents] => Array ( [0] => form_id ) [#weight] => 0.004 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#name] => form_id [#defaults_loaded] => 1 [#sorted] => 1 ) [#id] => amazon-test-form [#description] => [#attributes] => Array ( ) [#required] => [#tree] => [#parents] => Array ( ) [#method] => post [#action] => /admin/settings/amazon/test [#submit] => Array ( [0] => amazon_test_form_submit ) [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#processed] => [#defaults_loaded] => 1 [#sorted] => 1 ) [1] => Array ( [storage] => [submitted] => 1 [values] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [submit] => Look Up Product [form_build_id] => form-f1a59b34bef78377e68536c898945ca9 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [clicked_button] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit ) [redirect] => ) ) ) [14] => Array ( [file] => D:\WWW\drupal-6.14\includes\form.inc [line] => 414 [function] => form_execute_handlers [args] => Array ( [0] => submit [1] => Array ( [asin] => Array ( [#type] => textfield [#title] => Amazon Product ID [#description] => The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number. [#required] => 1 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => asin ) [#array_parents] => Array ( [0] => asin ) [#weight] => 0 [#processed] => 1 [#attributes] => Array ( ) [#input] => 1 [#size] => 60 [#maxlength] => 128 [#autocomplete_path] => [#process] => Array ( [0] => form_expand_ahah ) [#name] => asin [#id] => edit-asin [#value] => B000A2GYEO [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [submit] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit [#defaults_loaded] => 1 [#sorted] => 1 ) [#parameters] => Array ( [0] => amazon_test_form [1] => Array ( [storage] => [submitted] => [post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) ) ) [#build_id] => form-f1a59b34bef78377e68536c898945ca9 [#type] => form [#programmed] => [form_build_id] => Array ( [#type] => hidden [#value] => form-f1a59b34bef78377e68536c898945ca9 [#id] => form-f1a59b34bef78377e68536c898945ca9 [#name] => form_build_id [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_build_id ) [#array_parents] => Array ( [0] => form_build_id ) [#weight] => 0.002 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#defaults_loaded] => 1 [#sorted] => 1 ) [#token] => amazon_test_form [form_token] => Array ( [#id] => edit-amazon-test-form-form-token [#type] => token [#default_value] => 44d46839fd54dbdea0daff8cd665cd20 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_token ) [#array_parents] => Array ( [0] => form_token ) [#weight] => 0.003 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => form_token [#value] => 44d46839fd54dbdea0daff8cd665cd20 [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [form_id] => Array ( [#type] => hidden [#value] => amazon_test_form [#id] => edit-amazon-test-form [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_id ) [#array_parents] => Array ( [0] => form_id ) [#weight] => 0.004 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#name] => form_id [#defaults_loaded] => 1 [#sorted] => 1 ) [#id] => amazon-test-form [#description] => [#attributes] => Array ( ) [#required] => [#tree] => [#parents] => Array ( ) [#method] => post [#action] => /admin/settings/amazon/test [#submit] => Array ( [0] => amazon_test_form_submit ) [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#processed] => [#defaults_loaded] => 1 [#sorted] => 1 ) [2] => Array ( [storage] => [submitted] => 1 [values] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [submit] => Look Up Product [form_build_id] => form-f1a59b34bef78377e68536c898945ca9 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [clicked_button] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit ) [redirect] => ) ) ) [15] => Array ( [file] => D:\WWW\drupal-6.14\includes\form.inc [line] => 119 [function] => drupal_process_form [args] => Array ( [0] => amazon_test_form [1] => Array ( [asin] => Array ( [#type] => textfield [#title] => Amazon Product ID [#description] => The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number. [#required] => 1 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => asin ) [#array_parents] => Array ( [0] => asin ) [#weight] => 0 [#processed] => 1 [#attributes] => Array ( ) [#input] => 1 [#size] => 60 [#maxlength] => 128 [#autocomplete_path] => [#process] => Array ( [0] => form_expand_ahah ) [#name] => asin [#id] => edit-asin [#value] => B000A2GYEO [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [submit] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit [#defaults_loaded] => 1 [#sorted] => 1 ) [#parameters] => Array ( [0] => amazon_test_form [1] => Array ( [storage] => [submitted] => [post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) ) ) [#build_id] => form-f1a59b34bef78377e68536c898945ca9 [#type] => form [#programmed] => [form_build_id] => Array ( [#type] => hidden [#value] => form-f1a59b34bef78377e68536c898945ca9 [#id] => form-f1a59b34bef78377e68536c898945ca9 [#name] => form_build_id [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_build_id ) [#array_parents] => Array ( [0] => form_build_id ) [#weight] => 0.002 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#defaults_loaded] => 1 [#sorted] => 1 ) [#token] => amazon_test_form [form_token] => Array ( [#id] => edit-amazon-test-form-form-token [#type] => token [#default_value] => 44d46839fd54dbdea0daff8cd665cd20 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_token ) [#array_parents] => Array ( [0] => form_token ) [#weight] => 0.003 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => form_token [#value] => 44d46839fd54dbdea0daff8cd665cd20 [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [form_id] => Array ( [#type] => hidden [#value] => amazon_test_form [#id] => edit-amazon-test-form [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_id ) [#array_parents] => Array ( [0] => form_id ) [#weight] => 0.004 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#name] => form_id [#defaults_loaded] => 1 [#sorted] => 1 ) [#id] => amazon-test-form [#description] => [#attributes] => Array ( ) [#required] => [#tree] => [#parents] => Array ( ) [#method] => post [#action] => /admin/settings/amazon/test [#submit] => Array ( [0] => amazon_test_form_submit ) [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#processed] => [#defaults_loaded] => 1 [#sorted] => 1 ) [2] => Array ( [storage] => [submitted] => 1 [values] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [submit] => Look Up Product [form_build_id] => form-f1a59b34bef78377e68536c898945ca9 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [clicked_button] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit ) [redirect] => ) ) ) [16] => Array ( [function] => drupal_get_form [args] => Array ( [0] => amazon_test_form ) ) [17] => Array ( [file] => D:\WWW\drupal-6.14\includes\menu.inc [line] => 348 [function] => call_user_func_array [args] => Array ( [0] => drupal_get_form [1] => Array ( [0] => amazon_test_form ) ) ) [18] => Array ( [file] => D:\WWW\drupal-6.14\index.php [line] => 18 [function] => menu_execute_active_handler [args] => Array ( ) ) )
    * Got array instead of text. $text==Array ( [0] => Etro Anime )
    * Array ( [0] => Array ( [file] => D:\WWW\drupal-6.14\includes\database.inc [line] => 225 [function] => db_escape_string [args] => Array ( [0] => Array ( [0] => Etro Anime ) ) ) [1] => Array ( [function] => _db_query_callback [args] => Array ( [0] => Array ( [0] => %s [1] => %s ) ) ) [2] => Array ( [file] => D:\WWW\drupal-6.14\includes\database.mysql-common.inc [line] => 41 [function] => preg_replace_callback [args] => Array ( [0] => /(%d|%s|%%|%f|%b|%n)/ [1] => _db_query_callback [2] => INSERT INTO ard_amazon_music (asin, artist, label, studio, numberofdiscs) VALUES ('%s', '%s', '%s', '%s', %d) ) ) [3] => Array ( [file] => D:\WWW\drupal-6.14\includes\common.inc [line] => 3468 [function] => db_query [args] => Array ( [0] => INSERT INTO {amazon_music} (asin, artist, label, studio, numberofdiscs) VALUES ('%s', '%s', '%s', '%s', %d) [1] => Array ( [0] => B000A2GYEO [1] => Array ( [0] => Etro Anime ) [2] => Neurodisc [3] => Neurodisc [4] => 1 ) ) ) [4] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon_media\amazon_media.module [line] => 103 [function] => drupal_write_record [args] => Array ( [0] => amazon_music [1] => stdClass Object ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) [5] => Array ( [function] => amazon_media_amazon_item_insert [args] => Array ( [0] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) [6] => Array ( [file] => D:\WWW\drupal-6.14\includes\module.inc [line] => 471 [function] => call_user_func_array [args] => Array ( [0] => amazon_media_amazon_item_insert [1] => Array ( [1] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) ) [7] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 539 [function] => module_invoke_all [args] => Array ( [0] => amazon_item_insert [1] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) [timestamp] => 1256666275 [invalid_asin] => 0 ) ) ) [8] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.module [line] => 553 [function] => amazon_item_insert [args] => Array ( [0] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) ) [1] => 1 ) ) [9] => Array ( [file] => D:\WWW\drupal-6.14\modules\amazon\amazon.admin.inc [line] => 144 [function] => amazon_item_save [args] => Array ( [0] => Array ( [asin] => B000A2GYEO [salesrank] => 249359 [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO [listpriceamount] => 1999 [listpricecurrencycode] => GBP [listpriceformattedprice] => £19.99 [binding] => Audio CD [ean] => 0754863202322 [format] => Import [label] => Neurodisc [manufacturer] => Neurodisc [numberofdiscs] => 1 [originalreleasedate] => 2004-02-24 [productgroup] => Music [producttypename] => ABIS_MUSIC [publisher] => Neurodisc [releasedate] => 2004-02-24 [studio] => Neurodisc [title] => See the Sound [upc] => 754863202322 [artist] => Array ( [0] => Etro Anime ) [participants] => Array ( [0] => Etro Anime ) [imagesets] => Array ( [smallimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg [height] => 75 [width] => 75 ) [mediumimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg [height] => 160 [width] => 160 ) [largeimage] => Array ( [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg [height] => 216 [width] => 216 ) ) ) ) ) [10] => Array ( [file] => D:\WWW\drupal-6.14\includes\form.inc [line] => 774 [function] => amazon_test_form_submit [args] => Array ( [0] => Array ( [asin] => Array ( [#type] => textfield [#title] => Amazon Product ID [#description] => The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number. [#required] => 1 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => asin ) [#array_parents] => Array ( [0] => asin ) [#weight] => 0 [#processed] => 1 [#attributes] => Array ( ) [#input] => 1 [#size] => 60 [#maxlength] => 128 [#autocomplete_path] => [#process] => Array ( [0] => form_expand_ahah ) [#name] => asin [#id] => edit-asin [#value] => B000A2GYEO [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [submit] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit [#defaults_loaded] => 1 [#sorted] => 1 ) [#parameters] => Array ( [0] => amazon_test_form [1] => Array ( [storage] => [submitted] => [post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) ) ) [#build_id] => form-f1a59b34bef78377e68536c898945ca9 [#type] => form [#programmed] => [form_build_id] => Array ( [#type] => hidden [#value] => form-f1a59b34bef78377e68536c898945ca9 [#id] => form-f1a59b34bef78377e68536c898945ca9 [#name] => form_build_id [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_build_id ) [#array_parents] => Array ( [0] => form_build_id ) [#weight] => 0.002 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#defaults_loaded] => 1 [#sorted] => 1 ) [#token] => amazon_test_form [form_token] => Array ( [#id] => edit-amazon-test-form-form-token [#type] => token [#default_value] => 44d46839fd54dbdea0daff8cd665cd20 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_token ) [#array_parents] => Array ( [0] => form_token ) [#weight] => 0.003 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => form_token [#value] => 44d46839fd54dbdea0daff8cd665cd20 [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [form_id] => Array ( [#type] => hidden [#value] => amazon_test_form [#id] => edit-amazon-test-form [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_id ) [#array_parents] => Array ( [0] => form_id ) [#weight] => 0.004 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#name] => form_id [#defaults_loaded] => 1 [#sorted] => 1 ) [#id] => amazon-test-form [#description] => [#attributes] => Array ( ) [#required] => [#tree] => [#parents] => Array ( ) [#method] => post [#action] => /admin/settings/amazon/test [#submit] => Array ( [0] => amazon_test_form_submit ) [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#processed] => [#defaults_loaded] => 1 [#sorted] => 1 ) [1] => Array ( [storage] => [submitted] => 1 [values] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [submit] => Look Up Product [form_build_id] => form-f1a59b34bef78377e68536c898945ca9 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [clicked_button] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit ) [redirect] => ) ) ) [11] => Array ( [file] => D:\WWW\drupal-6.14\includes\form.inc [line] => 414 [function] => form_execute_handlers [args] => Array ( [0] => submit [1] => Array ( [asin] => Array ( [#type] => textfield [#title] => Amazon Product ID [#description] => The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number. [#required] => 1 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => asin ) [#array_parents] => Array ( [0] => asin ) [#weight] => 0 [#processed] => 1 [#attributes] => Array ( ) [#input] => 1 [#size] => 60 [#maxlength] => 128 [#autocomplete_path] => [#process] => Array ( [0] => form_expand_ahah ) [#name] => asin [#id] => edit-asin [#value] => B000A2GYEO [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [submit] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit [#defaults_loaded] => 1 [#sorted] => 1 ) [#parameters] => Array ( [0] => amazon_test_form [1] => Array ( [storage] => [submitted] => [post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) ) ) [#build_id] => form-f1a59b34bef78377e68536c898945ca9 [#type] => form [#programmed] => [form_build_id] => Array ( [#type] => hidden [#value] => form-f1a59b34bef78377e68536c898945ca9 [#id] => form-f1a59b34bef78377e68536c898945ca9 [#name] => form_build_id [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_build_id ) [#array_parents] => Array ( [0] => form_build_id ) [#weight] => 0.002 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#defaults_loaded] => 1 [#sorted] => 1 ) [#token] => amazon_test_form [form_token] => Array ( [#id] => edit-amazon-test-form-form-token [#type] => token [#default_value] => 44d46839fd54dbdea0daff8cd665cd20 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_token ) [#array_parents] => Array ( [0] => form_token ) [#weight] => 0.003 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => form_token [#value] => 44d46839fd54dbdea0daff8cd665cd20 [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [form_id] => Array ( [#type] => hidden [#value] => amazon_test_form [#id] => edit-amazon-test-form [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_id ) [#array_parents] => Array ( [0] => form_id ) [#weight] => 0.004 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#name] => form_id [#defaults_loaded] => 1 [#sorted] => 1 ) [#id] => amazon-test-form [#description] => [#attributes] => Array ( ) [#required] => [#tree] => [#parents] => Array ( ) [#method] => post [#action] => /admin/settings/amazon/test [#submit] => Array ( [0] => amazon_test_form_submit ) [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#processed] => [#defaults_loaded] => 1 [#sorted] => 1 ) [2] => Array ( [storage] => [submitted] => 1 [values] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [submit] => Look Up Product [form_build_id] => form-f1a59b34bef78377e68536c898945ca9 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [clicked_button] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit ) [redirect] => ) ) ) [12] => Array ( [file] => D:\WWW\drupal-6.14\includes\form.inc [line] => 119 [function] => drupal_process_form [args] => Array ( [0] => amazon_test_form [1] => Array ( [asin] => Array ( [#type] => textfield [#title] => Amazon Product ID [#description] => The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number. [#required] => 1 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => asin ) [#array_parents] => Array ( [0] => asin ) [#weight] => 0 [#processed] => 1 [#attributes] => Array ( ) [#input] => 1 [#size] => 60 [#maxlength] => 128 [#autocomplete_path] => [#process] => Array ( [0] => form_expand_ahah ) [#name] => asin [#id] => edit-asin [#value] => B000A2GYEO [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [submit] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit [#defaults_loaded] => 1 [#sorted] => 1 ) [#parameters] => Array ( [0] => amazon_test_form [1] => Array ( [storage] => [submitted] => [post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) ) ) [#build_id] => form-f1a59b34bef78377e68536c898945ca9 [#type] => form [#programmed] => [form_build_id] => Array ( [#type] => hidden [#value] => form-f1a59b34bef78377e68536c898945ca9 [#id] => form-f1a59b34bef78377e68536c898945ca9 [#name] => form_build_id [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_build_id ) [#array_parents] => Array ( [0] => form_build_id ) [#weight] => 0.002 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#defaults_loaded] => 1 [#sorted] => 1 ) [#token] => amazon_test_form [form_token] => Array ( [#id] => edit-amazon-test-form-form-token [#type] => token [#default_value] => 44d46839fd54dbdea0daff8cd665cd20 [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_token ) [#array_parents] => Array ( [0] => form_token ) [#weight] => 0.003 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => form_token [#value] => 44d46839fd54dbdea0daff8cd665cd20 [#needs_validation] => 1 [#defaults_loaded] => 1 [#sorted] => 1 ) [form_id] => Array ( [#type] => hidden [#value] => amazon_test_form [#id] => edit-amazon-test-form [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => form_id ) [#array_parents] => Array ( [0] => form_id ) [#weight] => 0.004 [#processed] => 1 [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#name] => form_id [#defaults_loaded] => 1 [#sorted] => 1 ) [#id] => amazon-test-form [#description] => [#attributes] => Array ( ) [#required] => [#tree] => [#parents] => Array ( ) [#method] => post [#action] => /admin/settings/amazon/test [#submit] => Array ( [0] => amazon_test_form_submit ) [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#processed] => [#defaults_loaded] => 1 [#sorted] => 1 ) [2] => Array ( [storage] => [submitted] => 1 [values] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [submit] => Look Up Product [form_build_id] => form-f1a59b34bef78377e68536c898945ca9 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [clicked_button] => Array ( [#type] => submit [#value] => Look Up Product [#post] => Array ( [asin] => B000A2GYEO [op] => Look Up Product [form_build_id] => form-3cc3395607d3da585360cce4d852e196 [form_token] => 44d46839fd54dbdea0daff8cd665cd20 [form_id] => amazon_test_form ) [#programmed] => [#tree] => [#parents] => Array ( [0] => submit ) [#array_parents] => Array ( [0] => submit ) [#weight] => 0.001 [#processed] => [#description] => [#attributes] => Array ( ) [#required] => [#input] => 1 [#name] => op [#button_type] => submit [#executes_submit_callback] => 1 [#process] => Array ( [0] => form_expand_ahah ) [#id] => edit-submit ) [redirect] => ) ) ) [13] => Array ( [function] => drupal_get_form [args] => Array ( [0] => amazon_test_form ) ) [14] => Array ( [file] => D:\WWW\drupal-6.14\includes\menu.inc [line] => 348 [function] => call_user_func_array [args] => Array ( [0] => drupal_get_form [1] => Array ( [0] => amazon_test_form ) ) ) [15] => Array ( [file] => D:\WWW\drupal-6.14\index.php [line] => 18 [function] => menu_execute_active_handler [args] => Array ( ) ) )

    * warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in D:\WWW\drupal-6.14\includes\database.mysqli.inc on line 333.
    * warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in D:\WWW\drupal-6.14\includes\database.mysqli.inc on line 333.

Amazon Product ID: *
The ASIN of a product listed on Amazon.com. For books, this is generally the ISBN number.
Image of See the Sound
See the Sound
Manufacturer: Neurodisc
Part Number:
Price: £19.99

Array
(
    [asin] => B000A2GYEO
    [salesrank] => 249359
    [detailpageurl] => http://www.amazon.co.uk/See-Sound-Etro-Anime/dp/B000A2GYEO%3FSubscriptionId%3DAWS-ID%26tag%3DASSOCIATE-ID%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000A2GYEO
    [listpriceamount] => 1999
    [listpricecurrencycode] => GBP
    [listpriceformattedprice] => £19.99
    [binding] => Audio CD
    [ean] => 0754863202322
    [format] => Import
    [label] => Neurodisc
    [manufacturer] => Neurodisc
    [numberofdiscs] => 1
    [originalreleasedate] => 2004-02-24
    [productgroup] => Music
    [producttypename] => ABIS_MUSIC
    [publisher] => Neurodisc
    [releasedate] => 2004-02-24
    [studio] => Neurodisc
    [title] => See the Sound
    [upc] => 754863202322
    [artist] => Array
        (
            [0] => Etro Anime
        )

    [participants] => Array
        (
            [0] => Etro Anime
        )

    [imagesets] => Array
        (
            [smallimage] => Array
                (
                    [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL75_.jpg
                    [height] => 75
                    [width] => 75
                )

            [mediumimage] => Array
                (
                    [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L._SL160_.jpg
                    [height] => 160
                    [width] => 160
                )

            [largeimage] => Array
                (
                    [url] => http://ecx.images-amazon.com/images/I/21G-RqCxS1L.jpg
                    [height] => 216
                    [width] => 216
                )

        )

)
michaelfoggin’s picture

michaelfoggin commented

Being dim: having problems replying for some reason...

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Assigned: Unassigned » rfay
Issue tags: +6.x-1.0 blocker
rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Status: Active » Fixed

The "artist" in the amazon data is often an array, but it was being saved where the database expects a string. I added code to catch that.

This will be in today's dev version and will show up in 6.x-1.0-rc2.

antlib’s picture

antlib commented

Hi there

Any advance on a update on this as I'm getting exactly the same issue on installing this module and running a test:

warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in /home/adamand/public_html/includes/database.mysqli.inc on line 323

Thanks!
Stan

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

@antlib: Have you tried the dev version? If not, please do, and report on your status. I believe this is fixed.

antlib’s picture

antlib commented

Oooh no - would you mind pointing me in the right direction?

Thanks for the very quick response!
Stan

antlib’s picture

antlib commented

Doh found the dev link!
Thanks again!

antlib’s picture

antlib commented

Installed the dev version and works like a charm - thanks again!

Any news on when to look out for an updated release candidate?

Regards,
Stan

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

I'll do an RC before long - next time I work on it.

Status: Fixed » Closed (fixed)
Issue tags: -6.x-1.0 blocker

Automatically closed -- issue fixed for 2 weeks with no activity.

Issue tags: +6.x-1.0 blocker

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.