+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: Unknown column 'status' in 'field list' (/thread-3489.html)
Unknown column 'status' in 'field list' - momfer - 06-10-2008 03:14 AM
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
RE: Unknown column 'status' in 'field list' - momfer - 06-11-2008 12:10 AM
Really nobody knows how to put me in some kind of direction?
RE: Unknown column 'status' in 'field list' - sci2tech - 06-11-2008 01:34 AM
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,check if you table is structured in same way, or alter acording
`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'
RE: Unknown column 'status' in 'field list' - momfer - 06-11-2008 04:30 AM
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.