Radicore Forum: RADICORE Installation Issues

Home » RADICORE » RADICORE Installation Issues » Install Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Install Problem [message #307]

Wed, 11 October 2006 15:21

billg97
Messages: 2
Registered: October 2006

Junior Member

Hello,

Below is a summary of my installation environment and the error message I receive. Any help or guidance is greatly appreciated...

Thanks

Bill

When installing on Fedora Core 4, php 4,
Apache 2.x
document root is set to /home/golfer/www

my httpd.conf directory directive is also set as:

<Directory "/home/golfer/www/radicore">

Options Indexes FollowSymLinks

AllowOverride All

Order allow,deny
Allow from all

</Directory>

I believe I followed the install instructions completely.

phpinfo() from a test script reports my include path as

.:/home/golfer/www/radicore/includes:/home/golfer/www/radico re/menu:/home/golfer/www/radicore/audit:/home/golfer/www/rad icore/dict:/home/golfer/www/radicore/workflow

I try to run the logon.php script and receive the following error:

This application has encountered an unrecoverable error
The following has been reported to the administrator:

2006-10-11 13:32:14
Fatal Error: MySQL error: 1064 : You have an error in your SQL syntax near 'FROM php_session WHERE session_id='08b98f4536146a4787782ac950e1e4b8' ' at line 1 (# 256).

SQL query: SELECT SQL_CALC_FOUND_ROWS * FROM php_session WHERE session_id='08b98f4536146a4787782ac950e1e4b8'

Error in line 372 of file '/home/golfer/www/radicore/includes/dml.mysql.class.inc'.

Script: /radicore/menu/logon.php

Remote Address: 24.185.xxxx.xxxx

Request URI: /radicore/menu/logon.php

Report message to a moderator

Re: Install Problem [message #308 is a reply to message #307]

Wed, 11 October 2006 15:54

AJM
Messages: 2396
Registered: April 2006
Location: Surrey, UK

Senior Member

That SQL statement is perfectly valid as I have run it through phpMyAdmin without error.

What version of MySQL are you using? If it is less than 4.0.0 then the SQL_CALC_FOUND_ROWS function will not work. The minimum version acceptable to Radicore is 4.0.6, as mentioned on page http://www.radicore.org/radicore-for-php.php

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Install Problem [message #309 is a reply to message #308]

Wed, 11 October 2006 16:48

billg97
Messages: 2
Registered: October 2006

Junior Member

I am using mysql version 3.23.58.

I guess I need to upgrade, I was not aware of this requirement. Thankyou for the quick response. I will repost the result after upgrading.

Report message to a moderator

Previous Topic:	eregi(): REG_BADRPT (# 256)
Next Topic:	File Include problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Sep 21 14:27:30 EDT 2026

Total time taken to generate the page: 0.01215 seconds