Im getting troubles with the populaton of the tables. When loading the elcAdmin-sql-base-X.X.sql script some tables are created, but some some of them show an error.
error 1171: All parts of a Primary Key musb be not null; if you need a null key, use unique instead; I guess that these problems are realated to a wrong sql syntax... or probably the script provided in this release does not match with the system.
Can you help me with this?
Regards.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Now I have other problems that might be the platform requirements.
when using elcAdmin with the
following configuration the webserver crashes and
reboot itself,
I will try to test it using solaris 8, linux or windows based machines, and Apache or IIS as webservers.
It is a little is strange that the SunOne webserver crashes when using elcAdmin,I have been using similar technologies and I've never had such a problems, I will try to upgrade Smarty and let you know if it works with.
This configuration makes the Sun One Webserver to
crash and reboot itself.
Here is the error log:
[18/Nov/2004:10:48:08] failure ( 314): CORE3107: Child
process closed admin channel <-----------------------
------
[18/Nov/2004:10:48:09] info ( 5065): php4_init reports:
Initialized PHP Module (128 threads exspected)
[18/Nov/2004:10:48:11] info ( 5065): CORE5076: Using
[Java HotSpot(TM) Server VM, Version 1.4.2_04] from
[Sun Microsystems Inc.]
[18/Nov/2004:10:48:12] info ( 5065): WEB0100: Loading
web module in virtual server [https-rebeca] at [/search]
[18/Nov/2004:10:48:20] info ( 5065): HTTP3072: [LS
ls1] http://rebeca:80 ready to accept requests
[18/Nov/2004:10:48:20] info ( 5065): CORE3274:
successful server startup
======================================
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
as I expected, it was an asql syntax error and I have created those tables aready.
Now I'm trying to access the system but the web browser shows me this error:
Warning: fetch(templates_c/%%45^45E^45E480CD%%index.tpl.php): failed to open stream: No such file or directory in/export/home/elcAdmin/Smarty/Smarty/Smarty.class.php on line 1247
Warning: fetch(): Failed opening 'templates_c/%%45^45E^45E480CD%%index.tpl.php' for inclusion (include_path='.:/usr/local/lib/php') in /export/home/elcAdmin/Smarty/Smarty.class.php on line 124
I granted all provileges on the directory templates_c but I still have these errors... any suggestion?
Hope to have any answer soon. thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When I've had these problems, I've cleared out all the files in the templates_c directory. That is Smarty's caching stuff and sometimes it gets out of synch.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there,
Im getting troubles with the populaton of the tables. When loading the elcAdmin-sql-base-X.X.sql script some tables are created, but some some of them show an error.
error 1171: All parts of a Primary Key musb be not null; if you need a null key, use unique instead; I guess that these problems are realated to a wrong sql syntax... or probably the script provided in this release does not match with the system.
Can you help me with this?
Regards.
I've fixed this problem and have uploaded a new sql-base script.
Hi Jonathan,
many thanks for your answers.
Now I have other problems that might be the platform requirements.
when using elcAdmin with the
following configuration the webserver crashes and
reboot itself,
I will try to test it using solaris 8, linux or windows based machines, and Apache or IIS as webservers.
It is a little is strange that the SunOne webserver crashes when using elcAdmin,I have been using similar technologies and I've never had such a problems, I will try to upgrade Smarty and let you know if it works with.
________________________________________________
_________________
uname -aimnprsvX
SunOS rebeca 5.9 Generic_112233-05 sun4u sparc
SUNW,Ultra-60System = SunOS
Node = hostname
Release = 5.9
KernelID = Generic_112233-05
Machine = sun4u
BusType = <unknown>
Serial = <unknown>
Users = <unknown>
OEM# = 0
Origin# = 1
NumCPU = 1
________________________________________________
_________________
php -version
PHP 4.3.7 (cli) (built: Aug 9 2004 13:57:32) (DEBUG)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend
Technologies
________________________________________________
_________________
Sun One Web Server 6.1
________________________________________________
_________________
Your MySQL connection id is 74 to server version:
4.0.20-max
________________________________________________
_________________
This configuration makes the Sun One Webserver to
crash and reboot itself.
Here is the error log:
[18/Nov/2004:10:48:08] failure ( 314): CORE3107: Child
process closed admin channel <-----------------------
------
[18/Nov/2004:10:48:09] info ( 5065): php4_init reports:
Initialized PHP Module (128 threads exspected)
[18/Nov/2004:10:48:11] info ( 5065): CORE5076: Using
[Java HotSpot(TM) Server VM, Version 1.4.2_04] from
[Sun Microsystems Inc.]
[18/Nov/2004:10:48:12] info ( 5065): WEB0100: Loading
web module in virtual server [https-rebeca] at [/search]
[18/Nov/2004:10:48:20] info ( 5065): HTTP3072: [LS
ls1] http://rebeca:80 ready to accept requests
[18/Nov/2004:10:48:20] info ( 5065): CORE3274:
successful server startup
======================================
Hi there,
as I expected, it was an asql syntax error and I have created those tables aready.
Now I'm trying to access the system but the web browser shows me this error:
Warning: fetch(templates_c/%%45^45E^45E480CD%%index.tpl.php): failed to open stream: No such file or directory in/export/home/elcAdmin/Smarty/Smarty/Smarty.class.php on line 1247
Warning: fetch(): Failed opening 'templates_c/%%45^45E^45E480CD%%index.tpl.php' for inclusion (include_path='.:/usr/local/lib/php') in /export/home/elcAdmin/Smarty/Smarty.class.php on line 124
I granted all provileges on the directory templates_c but I still have these errors... any suggestion?
Hope to have any answer soon. thanks!
When I've had these problems, I've cleared out all the files in the templates_c directory. That is Smarty's caching stuff and sometimes it gets out of synch.