ispCP - Board - Support
FreeBSD7 Help with this error, please - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: FreeBSD7 Help with this error, please (/thread-5851.html)

Pages: 1 2 3 4 5 6


RE: FreeBSD7 Help with this error, please - blocker - 03-30-2009 02:36 PM

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


RE: FreeBSD7 Help with this error, please - server801 - 03-30-2009 06:07 PM

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


RE: FreeBSD7 Help with this error, please - blocker - 03-31-2009 12:30 PM

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


RE: FreeBSD7 Help with this error, please - server801 - 03-31-2009 08:38 PM

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


RE: FreeBSD7 Help with this error, please - blocker - 04-01-2009 11:59 AM

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


RE: FreeBSD7 Help with this error, please - server801 - 04-02-2009 04:22 AM

from the date of 28/03/2009 set


RE: FreeBSD7 Help with this error, please - blocker - 04-02-2009 11:50 AM

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.


RE: FreeBSD7 Help with this error, please - artful - 04-03-2009 07:05 PM

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


RE: FreeBSD7 Help with this error, please - BeNe - 04-03-2009 07:10 PM

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


RE: FreeBSD7 Help with this error, please - artful - 04-03-2009 07:35 PM

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?