*

osuser

  • **
  • 10 posts
not working phone verification
« on: February 13, 2024, 07:34:33 PM »
When i click verify phone number im getting just "Error" no more details.
Below is log from debug file:

PHP Fatal error:  Uncaught ValueError: Unknown format specifier "," in /oc-content/plugins/sms/index.php:169
Stack trace:
#0 /oc-content/plugins/sms/index.php(169): sprintf()
#1 /oc-includes/osclass/classes/Plugins.php(42): sms_init()
#2 /oc-includes/osclass/helpers/hPlugins.php(34): Plugins::runHook()
#3 /oc-includes/osclass/core/BaseModel.php(71): osc_run_hook()
#4 /oc-includes/osclass/controller/main.php(26): BaseModel->__construct()
#5 /index.php(322): CWebMain->__construct()
#6 {main}
  thrown in /oc-content/plugins/sms/index.php on line 169

*

osuser

  • **
  • 10 posts
Re: not working phone verification
« Reply #1 on: February 14, 2024, 08:46:48 AM »
error code in theme:

<fieldset id="osc-database-logs" style="border:1px solid #000;line-height:1.4;padding:8px 10px 10px 10px;margin: 12px;width:calc(100% - 24px);background-color:#fff;"> <legend style="font-size:14px;font-weight:600;padding:4px 8px;border:1px solid #000;background:#fff;">Database queries (Total queries: 9 - Total queries time: 0.0028448104858398 sec)</legend> <table style="border-collapse: collapse;width:100%;font-size:13px;padding:0;border-spacing:0;font-family:monospace;line-height:1.4;"> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.0006248950958252</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT *<br /> FROM (oc_t_preference)</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.00049805641174316</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" </td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.00014615058898926</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, i_login_fails, dt_login_fail_date, b_moderator, s_moderator_access<br /> FROM (oc_t_admin)<br /> WHERE pk_i_id = '1'</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.0003359317779541</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views<br /> FROM (oc_t_item i)<br /> LEFT JOIN oc_t_item_location l ON l.fk_i_item_id = i.pk_i_id <br /> LEFT JOIN oc_t_item_stats s ON i.pk_i_id = s.fk_i_item_id<br /> WHERE i.pk_i_id = '3'<br /> GROUP BY s.fk_i_item_id</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.0001380443572998</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT *<br /> FROM (oc_t_item_description)<br /> WHERE oc_t_item_description.fk_i_item_id = '3'</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.00029301643371582</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT a.*, b.*, c.i_num_items<br /> FROM (oc_t_category as a)<br /> INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "lt_LT")<br /> LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id<br /> WHERE b.s_name != '' AND a.b_enabled = 1<br /> ORDER BY i_position ASC</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.0004270076751709</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT a.pk_i_id, a.i_position, b.*<br /> FROM (oc_t_category as a)<br /> INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id<br /> WHERE b.s_name != '' AND a.b_enabled = 1<br /> GROUP BY a.pk_i_id<br /> ORDER BY i_position ASC</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.0002589225769043</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">SELECT *<br /> FROM (information_schema.tables)<br /> WHERE table_name = 'oc_t_item_delta'<br /> LIMIT 1</td> </tr> <tr > <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;min-width:75px;">0.0001227855682373</td> <td style="padding:6px 8px;text-align:left;vertical-align:top;border: 1px solid #ccc;">UPDATE oc_t_item_delta SET s_phone = '221542', fk_i_item_id = '3' WHERE fk_i_item_id = '3'</td> </tr> </table> </fieldset>
« Last Edit: February 14, 2024, 02:03:45 PM by osuser »

Marked as best answer by osuser on February 14, 2024, 02:02:55 PM
*

MB Themes

Re: not working phone verification
« Reply #2 on: February 14, 2024, 10:35:33 AM »
@osuser
Pretty sure it's error/mistake in your translation where you changed %s to something else or just to %,
2nd are database logs.
https://docs.osclasspoint.com/database-debug-mode
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

osuser

  • **
  • 10 posts
Re: not working phone verification
« Reply #3 on: February 14, 2024, 02:02:45 PM »
yep there was issue with "%,"  but its strange because in original english translation is %, and its working. Thank you.

*

MB Themes

Re: not working phone verification
« Reply #4 on: February 14, 2024, 06:08:35 PM »
I have %s in english.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots