Hello

Here is what I need to do. On the site we are providing a way for users to put in a request for a paid service. So, I am trying to have a multi-step workflow where the user adds the details of the service request and then is taken to a payment page to complete the requesting process.

I thought I could use lm_paypal_advert for this. is this the right approach or is there a simpler module in Drupal 7 to achieve this?
So, I setup a subscription for the node type and associated it with the lm_advert.

As an admin, I am able to create that node type and shown the paypal tab after node creation, but as a normal authenticated user, when I create that node type, this SQL error is thrown always
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'nid' in where clause is ambiguous: SELECT DISTINCT node.nid AS entity_id, node.vid AS revision_id, node.type AS bundle, :entity_type AS entity_type FROM {node} node INNER JOIN {node_access} na ON na.nid = node.nid WHERE (nid IN (:db_condition_placeholder_0)) AND (type IN (:db_condition_placeholder_1)) AND(( (na.gid = :db_condition_placeholder_2) AND (na.realm = :db_condition_placeholder_3) )OR( (na.gid = :db_condition_placeholder_4) AND (na.realm = :db_condition_placeholder_5) )OR( (na.gid = :db_condition_placeholder_6) AND (na.realm = :db_condition_placeholder_7) ))AND (na.grant_view >= :db_condition_placeholder_8) ; Array ( [:db_condition_placeholder_0] => 8 [:db_condition_placeholder_1] => expert [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => all [:db_condition_placeholder_4] => 4 [:db_condition_placeholder_5] => content_access_author [:db_condition_placeholder_6] => 2 [:db_condition_placeholder_7] => content_access_rid [:db_condition_placeholder_8] => 1 [:entity_type] => node ) in EntityFieldQuery->execute()

I am using Drupal 7 with entity relationships on this content type.

Please help as this is stopping me from going live with my website.