Syed Jahanzaib Personal Blog to Share Knowledge !

May 9, 2016

Radius Manager

Filed under: Radius Manager — Tags: , — Syed Jahanzaib / Pinochio~:) @ 11:57 AM

After upgrade radius manager, you may see following error when you click on Home / Settings

Unknown column 'pm_sagepay' in 'field list'

123

It is caused by in-correct table name pm_netcash where as RM searches for `pm_ sagepay`. Issue following command to solve it.

Login to mysql, and change db to radius.

mysql -uroot -pSQLPASS
use radius;
ALTER TABLE `rm_settings`  CHANGE `pm_netcash` `pm_sagepay` TINYINT( 1 ) NOT NULL ;"

Make sure to change mysql password. This will alter the in.correct table name to correct one and then you will be able to access the menu correctly.

Regard’s
Syed Jahanzaib

 

4 Comments »

  1. Did rm released an updated version?

    Comment by srijitb — May 9, 2016 @ 1:25 PM

  2. Dear sir,

    I am facing some problem

    I want to send mobile sms and emails to customer from different manager name

    what i do

    Regards,

    Dilip

    On Mon, May 9, 2016 at 12:28 PM, Syed Jahanzaib Personal Blog to Share Knowledge ! wrote:

    > Syed Jahanzaib / Pinochio~:) posted: “After upgrade radius manager, you > may see following error when you click on Home / Settings Unknown column > ‘pm_sagepay’ in ‘field list’ It is caused by in-correct table name > pm_netcash where as RM searches for `pm_ sagepay`. Issue following command > to” >

    Comment by Dilip Saini — May 10, 2016 @ 12:10 PM

    • its simple, run a search formula in bash and fetch manager name as well along with username/mobile number. and run the loop to send sms according to manager name in FROM. you need customized bash script to do the job. I wrote few on my blog as well. take example from it. if not then pay for the script.

      Comment by Syed Jahanzaib / Pinochio~:) — May 10, 2016 @ 1:18 PM


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: