Hi, I am getting the below error when using mass pay:

user warning: Unknown column 'payment_id' in 'field list' query: UPDATE mp_seller_order_statuses SET payment_id = 1, seller_paid_status = 1 WHERE uid = 3 AND order_id = 44 in /home/mysite/public_html/sites/all/modules/ubercart_marketplace/mp_reports/mp_reports.admin.inc on line 870.

Looking at the install file for the reports module, I don't see anything about a payment_id field. Thanks for any help you can offer.

Comments

jbrodbeck’s picture

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

This is an old issue but I'd like to ask if you ran update.php or tried doing a clean install of the latest version?

I'm unable to reproduce this error and will be needing more info to properly troubleshoot this one. If anybody is running into this, please feel free to chime in.

jacerider’s picture

jacerider commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Hey bud,

Ya, that was back in the day. No worries... all things resolved.

ravs_drupal’s picture

ravs_drupal commented
Assigned: syndicateStorm » Unassigned

Hello guys,

I installed the new version of ubercart marketplace, the one released on 7th october, dev version. I also, ran the update.php file but no luck. Could you please help me out form the issue??

RAVISH DAVE

jbrodbeck’s picture

jbrodbeck commented
Assigned: Unassigned » jbrodbeck
Status: Closed (fixed) » Needs work

ravs,

This field is directly related to masspay, which I'm currently trying to fix.

ravs_drupal’s picture

ravs_drupal commented

Hello,

What we did is that we created a foreign key in that table but things are still not working fine. I am glad to know that you are working on that. When should I expect you to complete the fix, as a project of mine depends on this issue. Your help is appreciated.

RAVISH DAVE

ravs_drupal’s picture

ravs_drupal commented

Hello jbrodbeck,

Can I talk with you on skype? What is your skype id?

Ravish Dave

ravs_drupal’s picture

ravs_drupal commented

Hello,

As I mentioned earlier, I had added a foreign key 'payment_id' in the table order status table. But I see that the payment id that is added to the new colum as per the inbuild SQL query is always 1, despite of the user or order. I checked further in the code and I could see that it cam from $seller['payment_id']. Now, the value of $seller['payment_id'] is assigned from db_latest_insert_id api which further uses the CURRVAL mysql function. When I tried to further implement the sql query with this CURRVAL function, it stated that no such FUNCTION exists in the database. Could any one guide me that what is happening here.

Ravish Dave

ravs_drupal’s picture

ravs_drupal commented

Hello,

I checked further in the Drupal APi of db_last_insert_id() and in that the MySql function LAST_INSERT_ID() is being used (and not CURRVAL as mentioned on http://api.drupal.org/api/function/db_last_insert_id/6) which is always returning 0 and hence the value of $seller['payment_id'] is always showing to be 1 ( 0 + 1 ). Therefore, even after adding 'payment_id' as the foreign key in the order status table, on each insert, it's value is being inserted as 1 only.

jbrodbeck’s picture

jbrodbeck commented

ravs,

You can contact me through the contact form on this site. If you're interested in helping out with code on the module, you can certainly post patches here and we can review them. I'm unfortunately buried in other projects this week and the renovation required on masspay- reporting, permissions, and installation is fairly large. In fact, having examined the current 6.x release, I don't believe mass pay is even functional (which, all things aside is what should be writing field_id into mp_seller_order_statuses). Also, I've run into some disconcerting bugs in the date area of the reporting which may also need to be fixed in conjunction with payment reporting.

My rough estimate of all that getting fixed is probably no sooner than a week or two if you count the reporting bugs. If you are interested in additional features or a speedier resolution to this problem, maybe we can discuss sponsorship.

ravs_drupal’s picture

ravs_drupal commented

Hello jbrodbeck,

I would be glad to be a part of the solution. However, I am too busy with other stuff. But still I can try my best to get the solution. Can you tell me when you shall be working on the bug issue? This is because a project of our is stranded due to ubercart marketplace. It is a great module but I need to wait till the whole module becomes flawless. Lookign forward to hear from you soon.

Ravish Dave

asak’s picture

asak commented

subscribing to this issue.

syndicateStorm’s picture

syndicateStorm commented
Assigned: jbrodbeck » syndicateStorm
syndicateStorm’s picture

syndicateStorm commented
Status: Needs work » Fixed

I have fixed the unknown column 'payment_id' bug as well as the payment_id always being assigned a value of one.

It may be necessary to uninstall Ubercart Marketplace completely before installing the latest dev release (should be available in a few hours) for the effects to take place.

syndicateStorm’s picture

syndicateStorm commented

I have fixed the unknown column 'payment_id' bug as well as the payment_id always being assigned a value of one.

It may be necessary to uninstall Ubercart Marketplace completely before installing the latest dev release (should be available in a few hours) for the effects to take place.

Status: Fixed » Closed (fixed)

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