I installed Amazon Tools 4.6 on Drupal 4.6.3, created the database tables, configured all access settings, and when I click amazon tools import, no matter what input I give to the form, the php script always dies with no output. Environment: Drupal 4.6.3, PHP 5.0.3, MySQL 4.1.9, Apache 1.3, GNU/Linux.

Comments

Prometheus6’s picture

Prometheus6 commented

My laptop with the PHP5 setup died. It's going to take a day or two for me to look at this.

nsk’s picture

nsk commented

I am sorry to hear about your laptop. My webserver, my home PC and my laptop all have php5 installed, so I can run any test you like if you want.

Prometheus6’s picture

Prometheus6 commented
Assigned: Unassigned » Prometheus6
Category: bug » support

Okay, I forgot my webserver has PHP5 installed too.

I have to apologize for giving advise without being the Apache guy. If you remember

http://drupal.org/node/28371

my own web host (Apache/1.3.33, MySQL 4.0.25, PHP 5.0.3, Linux of some flavor) says the line that has to go into .htaccess is

AddType x-mapp-php5 .php
nsk’s picture

nsk commented

Do you mean the error is caused because that line is not in httpd.conf ? I have uninstalled PHP 4.3 and MySQL 3.23 and installed PHP 5.0 and MySQL 4.1 using my webhost's control panel. I don't have that line in my httpd.conf and I use Apache 1.3. Every other application I use works fine, however. Should I add that line?

Prometheus6’s picture

Prometheus6 commented

I've already given you bad advice once :-<

All I can say is I add the line to my .htaccess file in the directory I want to use PHP5 to interpret .php files.

Random thought: you're not using the cvs version, are you?

nsk’s picture

nsk commented

I tried adding that line, I restarted Apache, and everything went broken, no php script could work because the browser was trying to download it as a text file. Of course I reverted the change and now I am back to the previous situation. I use Amazon Items 4.6. The server has been migrated to pure PHP5 now, I don't run PHP4 anymore. I think that line is mostly useful if you run both php4 and php5.

Does Amazon Items 4.6 works on your php5 server? Can you import books?

Prometheus6’s picture

Prometheus6 commented

I have nothing to do with Amazon Items. Entirely different project.

nsk’s picture

nsk commented

Sorry, I actually meant Amazon Tools 4.6.

Prometheus6’s picture

Prometheus6 commented

No problem importing at all. Can you set up a phpinfo() script?

nsk’s picture

nsk commented

phpinfo works fine, as well as any other php script. it's php 5.0.3.

'./configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-libxml-dir=/usr/local' '--enable-ftp' '--with-mysql=/usr/local/mysql' '--enable-sockets' '--with-zlib' '--with-zlib-dir=/usr/local/include' '--enable-bcmath' '--enable-calendar' '--enable-dba=shared' '--enable-dbase' '--enable-dbx' '--enable-dio' '--enable-exif' '--enable-mbstring' '--enable-mbregex' '--with-pear' '--enable-memory-limit' '--with-bz2' '--with-gd' '--with-png-dir=/usr' '--with-freetype-dir=/usr/local/lib' '--with-jpeg-dir=/usr' '--with-ttf' '--with-gettext' '--with-iconv' '--with-dom=shared' '--enable-track-vars' '--enable-safe-mode' '--enable-xslt' '--with-xslt-sablot' '--enable-xml' '--disable-mbstr-enc-trans' '--with-regex=system' '--with-kerberos' '--with-mhash' '--with-curl' '--with-gmp' '--with-t1lib=/usr/local,shared' '--with-db3=shared' '--with-imap=/usr/local/include' '--with-ldap' '--with-mcrypt' '--with-pgsql=/usr/local/pgsql' '--with-imap-ssl' '--with-xml-rpc' '--with-mysqli' '--with-openssl'

Prometheus6’s picture

Prometheus6 commented

I was hoping to see the output, but that may do. Here's the output from my server that documents all the modules that affect Amazon associate tools:

'../configure' '--program-suffix=5' '--with-pear=/usr/local/lib/php5' '--with-config-file-path=/usr/local/lib/php5' '--without-sqlite' '--enable-soap' '--with-xsl' '--enable-mbstring=all' '--with-mysql=/usr' '--with-zlib' '--enable-debug=no' '--enable-safe-mode=no' '--enable-discard-path=no' '--with-png-dir=/usr/lib' '--enable-track-vars' '--with-db' '--with-gdbm' '--enable-force-cgi-redirect' '--with-ttf=/usr/' '--enable-ftp' '--enable-dbase' '--enable-memory-limit' '--enable-calendar' '--enable-wddx' '--with-jpeg-dir=/usr/src/kundenserver/jpeg-6b' '--enable-bcmath' '--enable-gd-imgstrttf' '--enable-shmop' '--enable-mhash' '--with-mhash=/usr/src/kundenserver/mhash-0.8.9/' '--with-openssl' '--enable-xslt' '--with-xslt-sablot' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--with-imap' '--with-iconv=/usr/local' '--with-bz2' '--with-gettext' '--enable-exif' '--with-idn' '--with-curl=/usr/local/php5' '--with-mcrypt=/usr/local/php5' '--with-gd=/usr' '--with-freetype-dir=/usr'

curl

CURL support enabled
CURL Information libcurl/7.12.0 OpenSSL/0.9.6g zlib/1.2.1

dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.9
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

libxml

libXML support active
libXML Version 2.6.9
libXML streams enabled

While doing this another thought occurred to me. The day after you opened this, I committed a change to handle a bug at Amazon (all input is interpreted as ISO-8859-1) so you may want to check the iconv module as well.

iconv

iconv support enabled
iconv implementation libiconv
iconv library version 1.8


Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1
nsk’s picture

nsk commented

I have newer versions of all modules you listed. You can see the full output if you want, but I would need comm via email, not here. My Amazon Tools 4.6 still doesn't work :(

Prometheus6’s picture

Prometheus6 commented

Okay, my contact page is enabled so you can get to me that way.

At this point I'm really curious.

nsk’s picture

nsk commented

I sent you a message with a URL.

Prometheus6’s picture

Prometheus6 commented

So far the big difference is you have the MYSQLI drivers rather than the ones that ship by default with PHP4...which my web host does NOT, even when I'm running under PHP5. As we speak, that driver isn't supported by Drupal.

I'm not writing this off yet. It may compel me to reconfigure things so I can switch PHP versions while I develop. I believe I saw a package on Sourceforge that can help me (Windows machine...).

nsk’s picture

nsk commented

That's wrong, I have both the mysql and the mysqli drivers. And Drupal does support MySQLi because I wrote a support layer for it and, after the community fixes it and improves it, it will be in core in 4.7. However this has nothing to do with amazon tools, since my PHP does have mysql installed, along with mysqli.

nsk’s picture

nsk commented

BTW, MySQLi support was just commited to Drupal HEAD for 4.7. http://drupal.org/node/29910

nsk’s picture

nsk commented

any news? any explanation why this doesn't work?

Prometheus6’s picture

Prometheus6 commented

Frankly, no. I can't duplicate the problem. I'm not closing this in case someone else can but I can't fix what doesn't look broken to me.

nsk’s picture

nsk commented

In what setup (drupal, modules, php, mysql, apache, etc) do you test it? I test it on Drupal 4.6.3 with modules Amazon Items, Taxonomy Menu, Feedback, Image, Excerpt, and others, PHP 5.0.3, MySQL 4.1.9, Apache 1.3.27. I'll try to test it without other modules to see what happens.

Prometheus6’s picture

Prometheus6 commented

You know, you keep mentioning Amazon Items and I keep trying not to make an issue of the fact that Amazon Items is your module.

I'm afraid we've reached the limit of the free support I'm willing to provide. I know there's nothing wrong with the code, I know it runs under PHP4 and 5.

It's entirely possible there an incompatibility with the MySQLi drivers but I don't have a server with them installed so can't test for a conflict there...if one exists I suspect I'll get definitive proof when 4.7 drops in the form of a flood of problems, by which time I will may have a local system.

Meanwhile there is no further I can go. If you can narrow it down (blank pages tend to be caused by lack of processing memory) I'll look at what you find.

nsk’s picture

nsk commented

Amazon Items is not my module: The previous maintainer left and I just volunteered to try to keep it updated and help users who use it, although in the end it seems I have little time to maintain it.

As I said, the PHP5 installation where Amazon Tools runs on uses the MySQL drivers and not MySQLi.

My memory limit is 64MB, so I think it has plenty.

I can't understand what you mean in this sentence: "You know, you keep mentioning Amazon Items and I keep trying not to make an issue of the fact that Amazon Items is your module". Can you elaborate?

nsk’s picture

nsk commented

Clean-install Drupal 4.6.3 on Apache 2.0.53, PHP 5.0.3, MySQL 4.1.9, with MySQLi and MySQL drivers (only the MySQL client used on Drupal): Amazon Tools 4.6 works ok without other modules.

nsk’s picture

nsk commented

it also works ok when Amazon Items 4.6 is loaded.

nsk’s picture

nsk commented

no problems with Excerpt 4.6, Browscap 4.6, Bad Behaviour 4.6 either.

nsk’s picture

nsk commented

also tested Banner 4.6, Feedback 4.6, Hall Of Fame 4.6, Image 4.6, PathAuto 4.6, Print 4.6, and works ok.

nsk’s picture

nsk commented

I tested your module with any other contrib module I use on a fresh Drupal install and works fine. However, it still doesn't work well on my production server. The only difference is Apache (1.3 to 2.0).

Prometheus6’s picture

Prometheus6 commented

I can't understand what you mean in this sentence: "You know, you keep mentioning Amazon Items and I keep trying not to make an issue of the fact that Amazon Items is your module". Can you elaborate?

I consider "Freudian slips" significant, especially when they are repeated. I can't say exactly what the significance is, but I remember you were looking for a configuration option to replace the developer token.

All good, open source and all that. And that is the absolute end of this particular branch of the conversation.

nsk’s picture

nsk commented

Perhaps you read too much Freud; I prefer hard science.

The fact that I volunteered to attempt to provide updates for a module which is similar to yours means nothing by itself. Amazon Items uses an old version of Amazon API, while your module supports the new API. I have to investigate the feasibility of a migration. After this is done, I have to decide what's the best solution for me and all users of Amazon Items. But now I have to find out whether your module can successfully support Amazon associate sites, which means that I must first evaluate your module under real life conditions.

You indicated earlier that you cannot support this for free anymore. Under what conditions can you provide support for your open-source module?

Prometheus6’s picture

Prometheus6 commented
Status: Active » Closed (fixed)

http://drupal.org/node/30077#comment-45104