We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Database error - User Credits | Forum

Volga
Volga Sep 10 '14
Hi, dear all,

please help to fix problem.

After recent updating core and plagins on website "Credits" plugin can`t do final step: put credits to user`s accounts and "Finance" log. All process debore is normal (payment success, money come to payment gate, website answer "Your order is success").


Payment gate log show errors from website database. How can we fix it?

Example of response:




Date of transaction: 09.09.2014 в 16:32
ID: 24996858
Тип операции: Перевод
Название: @merchant → P3027137
Магазин: friendly.ru
Платежная система (смс- мегафон)
Статус: выполнен
Сумма получения: 25.00 p
Комментарий: @merchant: friendly.ru [4971590]; History ID: 24996748; Pay system: Мегафон; Date: 09.09.2014 16:31:59; Pay date: 09.09.2014 16:32:58; Order ID: 1411; Client: ********@gmail.com [P3027137]; Email:  ********@gmail.com; Desc: Пополнение счета  ********@gmail.com;

More:

ID: 24996859
ID операции: 24996748
Статус: в процессе

POST-данные: m_operation_id: 24996748
m_operation_ps: 4505598
m_operation_date: 09.09.2014 16:31:59
m_operation_pay_date: 09.09.2014 16:32:58
m_shop: 4971590
m_orderid: 1411
m_amount: 25.00
m_curr: RUB
m_desc: 0J/QvtC/0L7Qu9C90LXQvdC40LUg0YHRh9C10YLQsCB2b2xnYXZvbGdhQGdtYWlsLmNvbQ==
m_status: success
m_sign: F4A38E13DC4E355CDB9804CAA855602D367ED4B087EA251420F5B720AB89F2EA
summa_out: 25.00
client_account: P3027137
client_email:  ********@gmail.com
Ответ обработчика:
Array
(
[REQUEST] => POST /billing-payeer/order/notify HTTP/1.1
Host: friendly.ru
User-Agent:Mozilla/5.0 (Windows NT 6.1; rv:12.0) Gecko/20100101 Firefox/12.0
Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language:ru-ru,ru;q=0.8,en-us;q=0.5,en;q=0.3
Accept-Charset:windows-1251,utf-8;q=0.7,*;q=0.7
Connection:keep-alive
Content-Length: 441
Content-Type: application/x-www-form-urlencoded


[HEADER] => Array
(
[0] => HTTP/1.1 200 OK
[Date] => Tue, 09 Sep 2014 12:35:16 GMT
[Server] => Apache/2.2.16 (Debian)
[X-Powered-By] => PHP/5.3.3-7+squeeze19
[Set-Cookie] => base_language_id=31; expires=Thu, 09-Oct-2014 12:35:17 GMT; path=/
[Expires] => Thu, 19 Nov 1981 08:52:00 GMT
[Cache-Control] => no-store, no-cache, must-revalidate, post-check=0, pre-check=0
[Pragma] => no-cache
[Vary] => Accept-Encoding
[Content-Length] => 3345
[Keep-Alive] => timeout=15, max=100
[Connection] => Keep-Alive
[Content-Type] => text/html; charset=utf-8
[1] => 
)

[BODY] => <style> .ow_debug_cont{padding:15px 0;width:80%;margin:0 auto;} .ow_debug_body{background:#fff;border:4px double;padding:5px;} .ow_debug_cap{font:bold 13px Tahoma;color:#fff;padding:5px;border:1px solid #000;width:250px;margin-top:-20px;} .ow_debug_body .notice{background:#fdf403;color:#555;} .ow_debug_body .warning{background:#f8b423;color:#555;} .ow_debug_body .error{background:#c10505;color:#fff;} .ow_debug_body .exception{background:#093dd3;color:#fff;} .ow_debug_body .vardump{background:#333;color:#fff;} .vardumper .string{color:green} .vardumper .null{color:blue} .vardumper .array{color:blue} .vardumper .bool{color:blue} .vardumper .property{color:brown} .vardumper .number{color:red} .vardumper .class{color:black;} .vardumper .class_prop{color:brown;} </style> <div class="ow_debug_cont"> <div class="ow_debug_body"> <div class="ow_debug_cap exception">OW Debug - Exception</div> <table> <tr> <td class="lbl">Message:</td> <td class="cnt">SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm_orderid' in 'field list'</td> </tr> <tr> <td class="lbl">File:</td> <td class="cnt">/var/www/friendly/data/www/friendly.ru/ow_core/database.php</td> </tr> <tr> <td class="lbl">Line:</td> <td class="cnt">707</td> </tr> <tr> <td class="lbl">Trace:</td> <td class="cnt"><pre>#0 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(707): PDOStatement->execute()#1 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(435): OW_Database->execute('UPDATE `ow_base...', Array)#2 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(475): OW_Database->query('UPDATE `ow_base...', Array)#3 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(547): OW_Database->update('UPDATE `ow_base...', Array)#4 /var/www/friendly/data/www/friendly.ru/ow_core/base_dao.php(211): OW_Database->updateObject('ow_base_billing...', Object(BOL_BillingSale))#5 /var/www/friendly/data/www/friendly.ru/ow_system_plugins/base/bol/billing_service.php(297): OW_BaseDao->save(Object(BOL_BillingSale))#6 /var/www/friendly/data/www/friendly.ru/ow_system_plugins/base/bol/billing_service.php(239): BOL_BillingService->saveSale(Object(BOL_BillingSale))#7 /var/www/friendly/data/www/friendly.ru/ow_plugins/billing_payeer/controllers/order.php(106): BOL_BillingService->verifySale(Object(BILLINGPAYEER_CLASS_PayeerAdapter), Object(BOL_BillingSale))#8 [internal function]: BILLINGPAYEER_CTRL_Order->notify(Array)#9 /var/www/friendly/data/www/friendly.ru/ow_core/request_handler.php(263): call_user_func_array(Array, Array)#10 /var/www/friendly/data/www/friendly.ru/ow_core/application.php(327): OW_RequestHandler->dispatch()#11 /var/www/friendly/data/www/friendly.ru/index.php(73): OW_Application->handleRequest()#12 {main}</pre></td> </tr> <tr> <td class="lbl">Type:</td> <td class="cnt" style="color:red;">PDOException</td> </tr> </table> </div> </div> 
)



********************************************************************


Developer of website wrote to me:


The error message from your logs is telling that "m_orderid" column can not found in ow_base_billing_sale database table. 
"m_orderid" variable gets introduced in ow_plugins/billing_payerr/controllers/order.php file. 

Unfortunately we don't know how this plugin was designed and what "m_orderid" is and how it is supposed to work. You will need to get hold of the plugin developer.




OW Debug - Exception
Message:
Column not found: 1054 Unknown column 'm_orderid' in 'field list' /var/www/friendly/data/www/friendly.ru/ow_core/database.php Line:707 #0 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(707): PDOStatement->execute()#1 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(435): OW_Database->execute('UPDATE `ow_base...', Array)#2 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(475): OW_Database->query('UPDATE `ow_base...', Array)#3 /var/www/friendly/data/www/friendly.ru/ow_core/database.php(547):

OW_Database->update('UPDATE `ow_base...', Array)#4 /var/www/friendly/data/www/friendly.ru/ow_core/base_dao.php(211):
OW_Database->updateObject('ow_base_billing...', Object(BOL_BillingSale))#5 /var/www/friendly/data/www/friendly.ru/ow_system_plugins/base/bol/billing_service.php(297):
OW_BaseDao->save(Object(BOL_BillingSale))#6 /var/www/friendly/data/www/friendly.ru/ow_system_plugins/base/bol/billing_service.php(239):
BOL_BillingService->saveSale(Object(BOL_BillingSale))#7 /var/www/friendly/data/www/friendly.ru/ow_plugins/billing_payeer/controllers/order.php(106):
BOL_BillingService->verifySale(Object(BILLINGPAYEER_CLASS_PayeerAdapter), Object(BOL_BillingSale))#8 [internal function]: BILLINGPAYEER_CTRL_Order->notify(Array)#9 /var/www/friendly/data/www/friendly.ru/ow_core/request_handler.php(263): call_user_func_array(Array, Array)#10 /var/www/friendly/data/www/friendly.ru/ow_core/application.php(327): OW_RequestHandler->dispatch()#11 /var/www/friendly/data/www/friendly.ru/index.php(73): OW_Application->handleRequest()#12 {main}




Best regards.


Skalfa LLC Partner
Skalfa LLC Sep 18 '14
This question has been resolved. The error was due to Payeer billing gateway.
The Forum post is edited by Skalfa LLC Sep 18 '14
You do not have permission to reply this topic