Syed Jahanzaib Personal Blog to Share Knowledge !

May 9, 2016

Radius Manager Table Missing Errors

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

Error # 1

Unknown column ‘pm_sagepay’ in ‘field list’

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

 

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.


Error # 2

Unknown column in ‘pm_netcash’ in ‘field list’

[Updated 27th-Feb-2017]

If you see following error

pm_netcash-error-in-radius-manager

Then follow this …

login to mysql, change db to radius, and alter the table. full commands are as below …

mysql -u root -pYOUR_MYSQL_PASSWORD
use radius;
ALTER TABLE `rm_settings` ADD `pm_netcash` INT NOT NULL;
exit

Done. Now refresh ACP page in browser and all will be fine Insha Allah.

 

Regard’s
Syed Jahanzaib

 

Advertisements

4 Comments »

  1. Did rm released an updated version?

    Like

    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” >

    Like

    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.

      Like

      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

%d bloggers like this: