DB function failed

[dot°NETt]

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

[CREATIVE Options]

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

[dot°NETt]

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

[CREATIVE Options]

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

[dot°NETt]

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

[datahell]

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.

[dot°NETt]

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):

Code: [Select]

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)


[CREATIVE Options]

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.

[datahell]

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.

[dot°NETt]

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

[dmtrlbdv]

 Same problem - same error. And mySQL says - errors in DB. Sorry for bad english

[Ivan Trebješanin]

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.

[datahell]

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.

[dmtrlbdv]

 No - its not working. If mySQL5 , then site not started right. Its like no template availible - only texts , but not formatted.

[Ivan Trebješanin]

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?