phpgroupware-tracker
[Top][All Lists]
Advanced

[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/





reply via email to

[Prev in Thread] Current Thread [Next in Thread]