Elxis CMS Forum
Support => Database => Topic started by: dot°NETt on November 01, 2006, 16:55:21
-
Hi,
I had a new installation of Elxis - fresh downloaded from 'Elxis Directory'.
Now I can't use Content >> Category Manager?!
The error shown is this:
'DB function failed with error number 1037
Out of memory; restart server and try again (needed 65528 bytes)'
Tried with PHP 4.4.4 and 5.1.6, restarted Apache, ... - always the same.
Any hint for me, please?
Thanks
dot°NETt
-
First of all I would like to ask you if install it in your local computer?
If yes I will suggest you to install the Xampp from the
url: http://www.apachefriends.org/en/xampp.html
If not please give us some information about your server, MySQL & PHP version.
If you have any other question or you need any help you can point on us.
Elxis Fan
Nick Sirigos
-
Thank you - and no, I have no other question.
Mambo works fine on my development equipment - Joomla! does it too.
Only Elxis produces this error.
I use XAMPP by Apachefriends since 4 yours - from v.0.13 up - now I use v.1.5.4a.
dot°NETt
-
Please let us know if you have resolve the problem.
If you didn’t resolve the problem give us the information about the MySQL and PHP version.
One other think you can do is to register throw the tool menu, and then to ask for a technical support from the Elxis Team.
Elxis Fan
Nick Sirigos
-
Yes I could solve this issue.
But: I can't believe, that you don't get this errormessage.
Please have a look inside your admin.categories.php >> function showCategories( $section, $option ) and check the GROUP BY clause in the db-statement (line 185ff.)
dot°NETt
-
GROUP BY is like this in order to be compatible with PostgreSQL. Normally you should nt have any problem with this query in MySQL. Try to increase your memory limit although the specific query it's not so memory consuming.
-
Hi datahell,
please try to run your CMS with a mySQL-database, not PostgreSQL. And you'll see what happens.
My memory_limit is always set to 64M (php.ini) - that's not enought?
I've never seen a 'GROUP BY'-clause grouping by 19(!) fields ... do you want to handle millions of categories - may be, then this should make sense?
dot°NETt
//€dit
The 'out of memory'-message is in 90% of all cases not the real reason.
The Debug-mode can help (so I could find the 'real' reason):
F:\xampp\htdocs\www\cms\elxis\20063\includes\Core\database.php:543
F:\xampp\htdocs\www\cms\elxis\20063\administrator\components\com_categories\admin.categories.php:211
F:\xampp\htdocs\www\cms\elxis\20063\administrator\components\com_categories\admin.categories.php:99
F:\xampp\htdocs\www\cms\elxis\20063\administrator\templates\admin\forest\index.php:109
F:\xampp\htdocs\www\cms\elxis\20063\administrator\index2.php:103DB function failed with error number 1037
Out of memory; restart server and try again (needed 65528 bytes)
-
From my side I have installed until now 9 Elxis with fresh installation.
2 local with Xampp (windows) with 0 problems,
2 local with linux with 0 problems,
3 on server with MySQL with 0 problems,
2 on server with PostgreSQL with 0 problems.
-
I run Elxis in both MySQL and Postgres and I (or any other member of the development team) had never such a problem. I do not even see any delay in query execution. Although I will tomorrow check again this issue. I think it has something to do with your system enviroment. Can you please give me more info? You use php 4 and 5 ok with this. Do you run php in cgi mode or as an apache module? I need to tell me if you use XAMP or any other similar tool, your OS, your mysql version and anything else you think will help us with this issue. Thanks.
-
Hi datahell,
my testinstallation runs on a windows-machine (Windows 2003 Server).
Environment based on XAMPP 1.5.4a with
- PHP 5.1.6 or 4.4.4 (using XAMPP's 'php-switch.bat') as Apache-module
- Apache 2.2.3
- mySQL 4.1.21-community-nt
Tomorrow I'll try to test on a Linux-machine.
dot°NETt
-
Same problem - same error. And mySQL says - errors in DB. Sorry for bad english
-
Same problem - same error. And mySQL says - errors in DB. Sorry for bad english
You must copy/paste here what are the errors before anyone can help you.
EXAMPLE:
'DB function failed with error number 1037
Out of memory; restart server and try again (needed 65528 bytes)'
If you get exactly like the above message, this means you need to allocate more memory. So, in order to get help, you need to give us more information.
-
There is something wrong in your server environment. Maybe the problem is MySQL. Did you manage to connect to the database with another script? Does the Elxis's database exist? You can also try mysql 5.x.
-
No - its not working. If mySQL5 , then site not started right. Its like no template availible - only texts , but not formatted.
-
That means you CSS is not loading. It proves datahell's point about server misconfiguration, or wrong read/write permissions, or wrong paths. Can you tell me what server do you use? Is it on a USB flash drive?
-
May be anywhere availible all propertys of apache,php and mySQL , which must be set for correct working ? I like elxis and dont want lose him :)
-
You have an exelent tool called updiag in the download section of elxis.org. Besides other functions it has a feature to check files and permissions.
-
Thank you, a will try it.
-
May be i do anything wrong ? I installed updiag and here results:
Version: Elxis 2006.4 Stable rev1080 [ Nestor ] 04-December-2006 23:08 GMT+2
PHP Version: 4.4.7 (cgi-fcgi)
Database Version: mysql 4.1.22 (Version: 4.1.22)
PHP built On: FreeBSD wapportal.ru 6.2-STABLE FreeBSD 6.2-STABLE #2: Fri Jul 6 02:47:42 CEST 2007 ....
Elxis register globals emulation is set to ON
PHP function system is enabled
PHP function exec is enabled
PHP function passthru is enabled
PHP function shell_exec is enabled
PHP allows openning remote files
Elxis error reporting is set to ON
Your database password is weak
Elxis FloodBlocker is disabled
Elxis Defender is disabled - about permission-i am set all rights at full access for testing
is this help to tell me whats wrong ?
-
Oh, man... PLEASE don't post sensitive data in public!!!!!
Yes, we are all friends here, or as I prefer to say a family, but remember that everyone can come here, see your settings, and play a "big hacker"! Especially don't write about read/write permissions, username/passwords or about elxis defender settings. You can use PM for this stuff.
-
Ok :) But what about my settings ? Is wrong place is freeBSD ?
-
I see anything wrong there... that's why I asked about templates...
But I see error reporting is ON, so what is the error reported?
EDIT: sorry it was on another topic (about admin templates)