Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » Install Problem
Install Problem [message #307] Wed, 11 October 2006 15:21 Go to next message
billg97 is currently offline  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





Re: Install Problem [message #308 is a reply to message #307] Wed, 11 October 2006 15:54 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
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


Re: Install Problem [message #309 is a reply to message #308] Wed, 11 October 2006 16:48 Go to previous message
billg97 is currently offline  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.

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


Current Time: Thu Mar 28 10:26:17 EDT 2024

Total time taken to generate the page: 0.01233 seconds