[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [support #102349] Error from Blank DB and new ins
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [support #102349] Error from Blank DB and new install |
Date: |
Wed, 13 Aug 2003 17:15:36 -0400 |
User-agent: |
Mozilla/5.0 (compatible; Konqueror/3.1; Linux) |
Support Request #102349, was updated on Mon 08/11/2003 at 20:31
You can respond by visiting:
http://savannah.gnu.org/support/?func=detailsupport&support_id=102349&group_id=509
Category: None
Status: Open
Priority: 5
Summary: Error from Blank DB and new install
By: jpfingstmann
Date: Wed 08/13/2003 at 17:15
Logged In: NO
Browser: Mozilla/5.0 (compatible; Konqueror/3.1; Linux)
No one? Am I the only one who can reproduce this problem?
----------------------------------------------------------------------
By: jpfingstmann
Date: Mon 08/11/2003 at 20:31
Logged In: YES
user_id=5431
Browser: Mozilla/5.0 (compatible; Konqueror/3.1; Linux)
I have been having this problem with our production DB and
have decided to try it with a blank DB and new site setup. The
error we've been getting is regarding Infolog. Here is what I
did and what happened:
I downloaded 9.14.006 from Savannah and unpacked to its
own directory. I then assigned the directy to a vhost in apache
and gave the directory 777 permissions (so it can write its
configs, etc) and then went in to setup the DB. I had it install
itself to a DB phpgwdev and, again, only for testing, told it to
use the root user with password. It created the DB and I then
told it to use Mail for Authentication, SQL to Store/Retreive info.
Had it install ALL apps (takes 2 go arounds due to prerequisites
from other modules). I then tried to log in. (Not successfully,
had to go back and enable SQL auth and then setup the mail
server, then switch back to Mail (always forget about this quirk)).
When I had it all working, I created an entry in the addressbook
that fills ALL fields with something. Here is a copy and paste of
the record:
Full Name:
Prefix FirstName Middle LastName Suffix
First name:
FirstName
Last name:
LastName
Middle Name:
Middle
Prefix:
Prefix
Suffix:
Suffix
Birthday:
1/01/2001
Notes:
Notes This one marked private
URL:
http://www.url.com
Public Key:
Pub Key
Company Name:
Company
Department:
Dept
Title:
Title
Business Street:
BStreet
Business City:
BCity
Business State:
BState
Business Postal Code:
BZip
Business Country:
BCountry
Business Address Type:
dom
Label:
Label
Home Street:
HStreet
Home City:
HCity
Home State:
HState
Home ZIP Code:
HZip
Home Country:
HCountry
Home Address Type:
dom
Business Phone:
480-921-2111
Home Phone:
HPhone
Fax:
480-921-3013
Message Phone:
Msg
Mobile Phone:
573-746-1234
Pager:
480-232-2323
Car Phone:
Car
ISDN Phone:
SDN
Video Phone:
Video
Business EMail:
address@hidden
Home EMail:
address@hidden
Home EMail Type:
INTERNET
Other Phone:
OtherNum
Address Line 2:
BStreet2
Address Line 3:
BStreet3
This causes the following when pulling up the record:
Database error: Invalid SQL: SELECT info_id,info_id_parent
FROM phpgw_infolog WHERE (info_owner=6 OR info_owner IN
(6) OR (info_access='public' AND info_owner IN(6))) AND
info_addr_id= order by info_datecreated desc LIMIT 15
MySQL Error: 1064 (You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server
version for the right syntax to use near 'order by
info_datecreated desc LIMIT 15' at line 1)
File:
/home/httpd/htdocs/simplygwdev.wearesimply.com/infolog/inc/class.soinfolog.inc.php
Line: 417
Session halted.
I get this error with our existing DB:
Database error: Invalid SQL: SELECT info_id,info_id_parent
FROM phpgw_infolog WHERE (info_owner=3 OR info_owner IN
(3) OR (info_access='public' AND info_owner
IN(2,3,4,25,6,19,23,24,10,21,22))) AND info_addr_id= order by
info_datecreated desc LIMIT 20
MySQL Error: 1064 (You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server
version for the right syntax to use near 'order by
info_datecreated desc LIMIT 20' at line 1)
File:
/home/httpd/htdocs/simplygw.wearesimply.com/infolog/inc/class.soinfolog.inc.php
Line: 417
Session halted.
So, where does the problem lie? Is there anything else I can
do to help troubleshoot this problem? Oh, just in case, here are
some versions:
Server version: Apache/1.3.27 (Unix) (Gentoo/Linux)
Server built: May 26 2003 18:30:23
mysql Ver 12.20 Distrib 4.0.13, for pc-linux-gnu (i686)
PHP Info:
PHP Version 4.3.2
System
Linux nautilus.wearesimply.com 2.4.20-ck6 #6 Mon May 26
16:26:35 GMT 2003 i686
Build Date
Jul 21 2003 10:46:20
Configure Command
'./configure' '--prefix=/usr' '--host=i686-pc-linux-gnu'
'--mandir=/usr/share/man' '--infodir=/usr/share/info'
'--datadir=/usr/share' '--sysconfdir=/etc' '--localstatedir=/var/lib'
'--without-readline' '--with-apxs=/usr/sbin/apxs' '--without-db3'
'--without-db4' '--without-db2' '--with-mcrypt=/usr' '--with-mhash'
'--with-ming=/usr' '--with-swf=/usr' '--with-gdbm=/usr'
'--with-java=/opt/blackdown-jdk-1.4.1' '--with-mcal=/usr'
'--with-unixODBC=/usr' '--with-pgsql=/usr' '--with-snmp'
'--enable-ucd-snmp-hack' '--with-xpm-dir=/usr/X11R6'
'--with-pdflib=/usr' '--with-gd' '--with-png-dir=/usr' '--with-jpeg'
'--with-jpeg-dir=/usr' '--enable-exif' '--without-jpeg'
'--with-tiff-dir=/usr' '--with-mysql=/usr'
'--with-mysql-sock=/var/run/mysqld/mysqld.sock'
'--with-freetype-dir=/usr' '--with-gettext' '--with-qtdom'
'--with-pspell' '--with-openssl' '--with-curl' '--with-imap'
'--with-ldap' '--with-dom' '--with-dom-xslt' '--with-kerberos'
'--with-pam' '--disable-memory-limit' '--disable-mbstring'
'--disable-mbregex' '--enable-ipv6' '--enable-dbx'
'--with-imap-ssl' '--with-zlib' '--with-zlib-dir=/usr/lib'
'--with-sablot=/usr' '--enable-xslt' '--with-xslt-sablot' '--with-xmlrpc'
'--enable-wddx' '--with-xml' '--with-bz2' '--with-crack'
'--with-ndbm' '--with-cdb' '--enable-bcmath' '--enable-calendar'
'--enable-dbase' '--enable-filepro' '--enable-ftp'
'--with-mime-magic' '--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-sysvipc' '--with-iconv'
'--enable-shmop' '--enable-dio' '--enable-inline-optimization'
'--enable-track-vars' '--enable-trans-sid' '--enable-versioning'
'--with-config-file-path=/etc/php/apache1-php4'
Server API
Apache
Virtual Directory Support
disabled
Configuration File (php.ini) Path
/etc/php/apache1-php4/php.ini
PHP API
20020918
PHP Extension
20020429
Zend Extension
20021010
Debug Build
no
Thread Safety
disabled
Registered PHP Streams
php, http, ftp, https, ftps, compress.bzip2, compress.zlib
I have been fighting with this problem for quite some time. Any
help I can provide to help solve this problem, I will try to be
more responsive than in the past (I got sent on a service call for
a week suddenly last time and couldn't respond quickly)..
Thanks.
----------------------------------------------------------------------
You can respond by visiting:
http://savannah.gnu.org/support/?func=detailsupport&support_id=102349&group_id=509
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/