Unknown column 'status' in 'field list'

[momfer]

Hi all,

I am running:
ispCP 1.0.0 RC4 OMEGA
build: 20080316

I succesfully converted my old VHCS database with some modifications.
Everything seems to run fine BUT when I do add user under reseller (/reseller/rau1.php) it gives: Unknown column 'status' in 'field list'

Does anyone know how to fix it or put me in the right direction.
It clearly has to do with mysql missing something.

Thx

[momfer]

Really nobody knows how to put me in some kind of direction?

[sci2tech]

In rau1.php column status is used in function function get_hp_data_list, refering status field from table hosting_plans. Structure of table hosting_plans look like this:

Quote:`id` int(10) unsigned NOT NULL auto_increment,
`reseller_id` int(10) unsigned NOT NULL default '0',
`name` varchar(255) collate utf8_unicode_ci default NULL,
`props` text collate utf8_unicode_ci,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`price` decimal(10,2) NOT NULL default '0.00',
`setup_fee` decimal(10,2) NOT NULL default '0.00',
`value` varchar(255) collate utf8_unicode_ci default NULL,
`payment` varchar(255) collate utf8_unicode_ci default NULL,
`status` int(10) unsigned NOT NULL default '0'

check if you table is structured in same way, or alter acording

[momfer]

Thank you for helping me out, my table looked messed up somehow.
I updated it with your information and now it works
If I only knew where to look.