FreeBSD7 Help with this error, please

[blocker]

add this patch, not yet perfect.

- fix those error except dmesg.boot, you have to allow and add it manually on basedir.
- fix backup routine

[server801]

Excuse me, how to apply this patch?I understand that this is simply replacing common_functions.php? if you can attach the working common_functions.php

[blocker]

go to first source ispcp directory and issue patch < patch-20090330.txt after that you can reinstall or just copy common_functions.php

[server801]

I did the same file, with the same name.error.may be ready to attach a file?

[blocker]

hmm, did you update your source first to lastest trunk ? becouse that patch is for lastest trunk

[server801]

from the date of 28/03/2009 set

[blocker]

what is the error ? i need to make sure that my patch can be applied generally and you need special case before I send to you the modified file.

[artful]

I install this patch.
has 1 error
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/var/run/dmesg.boot) is not within the allowed path(s): (/usr/local/www/ispcp/gui/:/usr/local/etc/ispcp/:/var/run/ispcp.lock:/proc/:/bin/df:/bin/mount:/var/log/rkhunter.log:/var/log/chkrootkit.log:/usr/local/lib/php/20060613/) in /usr/local/www/ispcp/gui/include/phpsysinfo/common_functions.php on line 358

as you add a new reseller error:
Unknown column 'state' in 'field list'
this error occurs even without the patch

[BeNe]

You use a trunk and not the 1.0.0 or ?

Quote:Unknown column 'state' in 'field list'

You have to create the column 'state' in 'field list' on your own and it should work.

Greez BeNe

[artful]

i use last trunk version

---

file trunk\gui\admin\personal_change.php
code:

Code:

$query = "
                UPDATE
                        `admin`
                SET
                        `fname` = ?,
                        `lname` = ?,
                        `firm` = ?,
                        `zip` = ?,
                        `city` = ?,
                        `state` = ?,
                        `country` = ?,
                        `street1` = ?,
                        `street2` = ?,
                        `email` = ?,
                        `phone` = ?,
                        `fax` = ?,
                        `gender` = ?
                WHERE
                        `admin_id` = ?

and trunk\configs\freebsd\database\database.sql

Code:

CREATE TABLE `admin` (
  `admin_id` int(10) unsigned NOT NULL auto_increment,
  `admin_name` varchar(200) DEFAULT NULL,
  `admin_pass` varchar(200) DEFAULT NULL,
  `admin_type` varchar(10) DEFAULT NULL,
  `domain_created` int(10) unsigned NOT NULL DEFAULT '0',
  `customer_id` varchar(200) DEFAULT '0',
  `created_by` int(10) unsigned DEFAULT '0',
  `fname` varchar(200) DEFAULT NULL,
  `lname` varchar(200) DEFAULT NULL,
  `gender` varchar(1) DEFAULT NULL,
  `firm` varchar(200) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `country` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `fax` varchar(200) DEFAULT NULL,
  `street1` varchar(200) DEFAULT NULL,
  `street2` varchar(200) DEFAULT NULL,
  `uniqkey` varchar(255) DEFAULT NULL,
  `uniqkey_time` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `admin_id` (`admin_id`),
  UNIQUE KEY `admin_name` (`admin_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Table admin is not a field state!
what type of box should be state?