Help! Errors on Thank You Page

10 replies [Last post]

Mon, 08/10/2009 - 07:57

thebetteritgets...

Offline

Joined: 06/29/2009

Status:

Answered

HI there

I'm getting some errors, could you take a look please? I don't know where to start to be honest.

warning: array_fill() [function.array-fill]: Number of elements must be positive in includes/database.inc on line 241.
warning: implode() [function.implode]: Invalid arguments passed in includes/database.inc on line 241.
warning: array_keys() [function.array-keys]: The first argument should be an array in modules/user/user.module on line 502.
user warning: 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 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in modules/user/user.module on line 502.
warning: array_keys() [function.array-keys]: The first argument should be an array in modules/block/block.module on line 406.
warning: array_fill() [function.array-fill]: Number of elements must be positive in includes/database.inc on line 241.
warning: implode() [function.implode]: Invalid arguments passed in includes/database.inc on line 241.
warning: array_merge() [function.array-merge]: Argument #2 is not an array in modules/block/block.module on line 407.
user warning: 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 ') OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module' at line 1 query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = '' AND b.status = 1 AND (r.rid IN () OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in modules/block/block.module on line 407.
warning: array_keys() [function.array-keys]: The first argument should be an array in sites/all/modules/content_access-6.x-1.1/content_access/content_access.module on line 65.
warning: array_keys() [function.array-keys]: The first argument should be an array in sites/all/modules/forum_access-6.x-1.0-rc1/forum_access/forum_access.module on line 19.
warning: Invalid argument supplied for foreach() in modules/node/node.module on line 2150.
warning: Invalid argument supplied for foreach() in modules/node/node.module on line 2150.
user warning: 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 'AND realm = 'content_access_author')) AND grant_view >= 1' at line 1 query: SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = AND realm = 'content_access_author')) AND grant_view >= 1 in modules/node/node.module on line 2161.
warning: array_keys() [function.array-keys]: The first argument should be an array in sites/all/modules/content_access-6.x-1.1/content_access/content_access.module on line 65.
warning: array_keys() [function.array-keys]: The first argument should be an array in sites/all/modules/forum_access-6.x-1.0-rc1/forum_access/forum_access.module on line 19.
warning: Invalid argument supplied for foreach() in modules/node/node.module on line 2102.
warning: Invalid argument supplied for foreach() in modules/node/node.module on line 2102.
user warning: 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 'AND na.realm = 'content_access_author'))) AND ( n.status = 1 AND n.nid IN (29, ' at line 1 query: SELECT DISTINCT(n.nid) FROM node n INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = AND na.realm = 'content_access_author'))) AND ( n.status = 1 AND n.nid IN (29, 30, 118, 152)) in includes/menu.inc on line 1006.

Kind regards

Mandy

Mon, 08/10/2009 - 07:58

Leighton Whiting

Offline

Joined: 06/02/2009

Amanda, I did some initial

Amanda,

I did some initial debugging, and from what I can tell, the IPN is not reaching the paypal/backend page once payment is completed. I can't figure out why tonight, but maybe something will give me an idea tomorrow morning.

Sincerely,
Leighton Whiting

Mon, 08/10/2009 - 07:59

thebetteritgets...

Offline

Joined: 06/29/2009

Thanks for that, here's

Thanks for that, here's hoping, the site owner is getting a bit annoyed with me because it's urgent really.

Kind regards
Amanda

Mon, 08/10/2009 - 07:59

Leighton Whiting

Offline

Joined: 06/02/2009

Amanda, I understand

Amanda,

I understand about the deadline, but from what I can tell and through all of my debugging, it must be a problem with your site blocking access to the Paypal Servers. Here is what I get when I used the IPN Simulator tool in Paypal Sandbox:

IPN delivery failed. HTTP error code 403: Forbidden

I suspect that you may have a module installed which is blocking certain IP addresses from accessing the site. The debug logs show that Paypal is trying to access the notification url with the IPN, but that it is getting denied access by the site. Do you have any ideas which module may be doing this? Or is it a server setting?

Sincerely,
Leighton Whiting

Mon, 08/10/2009 - 08:00

Leighton Whiting

Offline

Joined: 06/02/2009

Amanda, Another possibility

Amanda,

Another possibility is that your host may be blocking the IPN url:

http://www.pdncommunity.com/pdn/board/message?board.id=ipn&thread.id=18422

Sincerely,
Leighton Whiting

Mon, 08/10/2009 - 08:00

thebetteritgets...

Offline

Joined: 06/29/2009

Thanks Leighton I'm looking

Thanks Leighton

I'm looking into it now. They did change the site to a new server when we wanted to add our .com about 10 days ago and it appears that that server is running php4 whereas the previous was running php3, could that be causing this do you think?

Kind regards
Amanda

Mon, 08/10/2009 - 08:00

thebetteritgets...

Offline

Joined: 06/29/2009

Ok, well I've been in touch

Ok, well I've been in touch with the host and he says he needs more information.

Can he have screen shots and more information about the error? He also said it sounds like there might be root files hard coded and it's going to the wrong url?

Also asked if you could contact him but I mentioned you're in the States so he asked if he can have more info and some screen shots?

Not sure where to go from here and thank you for your help with this.

Apparently it is php 5 although this comes up in phpmyadmin

Your PHP MySQL library version 4.1.10 differs from your MySQL server version 5.0.32. This may cause unpredictable behavior.

Mandy

Mon, 08/10/2009 - 08:01

Leighton Whiting

Offline

Joined: 06/02/2009

Mandy, Here is what I can

Mandy,

Here is what I can gather of the problem:

When the 'paypal/backend' page is visited from my browser, it works fine, no blockage, etc. But when the page is visited by Paypal's servers, it is finding a 403 error, meaning access denied. SO I think the problem here is that paypal's IP is being denied access for some reason. This could be caused by a number of things, some of which could be .htaccess file coded to block that IP, modules which are blocking IPs from the Paypal Server's country, etc... There aren't really any screenshots which can illustrate this.

Worth mentioning is that the Paypal IP is getting the 403 error when it tries to access ANY page on the server, not just the paypal/backend page. This shows that it is not a problem with my module, but must be some other module/setting that is interfering.

Sincerely,
Leighton Whiting

Mon, 08/10/2009 - 08:01

thebetteritgets...

Offline

Joined: 06/29/2009

Thanks Leighton I'll get onto

Thanks Leighton

I'll get onto the host again

:0)

Mon, 08/10/2009 - 08:02

thebetteritgets...

Offline

Joined: 06/29/2009

Hi Leighton It was the bad

Hi Leighton

It was the bad behavior module blocking the ipn :0)

Thanks for all your help over the last few days.

Kind regards
Mandy

Mon, 08/10/2009 - 08:02

#10

Leighton Whiting

Offline

Joined: 06/02/2009

Mandy, So glad to hear you

Mandy,

So glad to hear you got it fixed! Do you mind if I move excerpts of this problem to the forums so that others having similar problems will know what to do?

Sincerely,
Leighton Whiting

Support

Your Cart

Twitter Feed

Random FAQs

Helpful Information

Tools I Use