[Phpgroupware-tracker] [Bug #1824] MySQL Error

[nobody]

=================== BUG #1824: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1824&group_id=509

Changes by: Paul Appleby <address@hidden>
Date: 2003-Jan-18 13:08 (GMT)

------------------ Additional Follow-up Comments ----------------------------
I'm not sure if this is the same thing but....

1st time i installed phpgroupware it went in fine but as I went to do the first 
login all passwords were incorrect
i did use the right ones of course.  (Having looked around, maybe I didnt use 
the @domain.tld bit)

so I del'ted the phpgroupware dir and removed all php-gw entries from mysql and 
since then I cant reinstall, I get the same errors as above.

Maybe the problem is the same as for Skwashd but I don't understand where "That 
was it. I mistakenly said "from host permissions" instead of "localhost"" would 
be set.

Sorry if this is a noob question :p

My mySQL is on vdomain hosting btw.  I do have phpmyAdmin connected and working.

Paul.




=================== BUG #1824: FULL BUG SNAPSHOT ===================


Submitted by: mhanze                  Project: phpGroupWare                 
Submitted on: 2002-Nov-28 17:26
Category:  None                       Bug Group:  0.9.14.001 release        
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  Invalid                  Assigned to:  skwashd                 
Status:  Closed                       Component Version:  TGZ               
Platform Version:  Linux - RedHat     Reproducibility:  Every Time          

Summary:  MySQL Error

Original Submission:  <b>After installing the header, I go to Setup/Config 
Admin Login. At the top of the page i see:</b>

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result 
resource in /var/www/html/phpgroupware/phpgwapi/inc/class.db_mysql.inc.php on 
line 583

<b>So now i when i click install all apps, I get:</b>

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result 
resource in /var/www/html/phpgroupware/phpgwapi/inc/class.db_mysql.inc.php on 
line 583

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result 
resource in /var/www/html/phpgroupware/phpgwapi/inc/class.db_mysql.inc.php on 
line 583
Database error: Invalid SQL: CREATE TABLE phpgw_config (config_app varchar(50), 
config_name varchar(255) NOT NULL, config_value varchar(100), 
UNIQUE(config_name))
Database error: Invalid SQL: INSERT INTO languages (lang_id, lang_name, 
available) VALUES ('aa','Afar','No')
Database error: Invalid SQL: INSERT INTO languages (lang_id, lang_name, 
available) VALUES ('ab','Abkhazian','No')
Database error: Invalid SQL: INSERT INTO languages (lang_id, lang_name, 
available) VALUES ('af','Afrikaans','No')
Database error: Invalid SQL: INSERT INTO languages (lang_id, lang_name, 
available) VALUES ('am','Amharic','No')
Database error: Invalid SQL: INSERT INTO languages (lang_id, lang_name, 
available) VALUES ('ar','Arabic','No')

MySQL server version: 3.23.52
phpGroupWare version 0.9.14.001 Setup III - Domain: default(mysql)
Red Hat Linux 8.0 3.2-7
Linux version 2.4.18-18.8.0 
gcc version 3.2
Apache/2.0.40 Server built: Sep 4 2002 17:20:34
<b>Any Ideas</b>

Follow-up Comments
*******************

-------------------------------------------------------
Date: 2003-Jan-18 13:08             By: Luap
I'm not sure if this is the same thing but....

1st time i installed phpgroupware it went in fine but as I went to do the first 
login all passwords were incorrect
i did use the right ones of course.  (Having looked around, maybe I didnt use 
the @domain.tld bit)

so I del'ted the phpgroupware dir and removed all php-gw entries from mysql and 
since then I cant reinstall, I get the same errors as above.

Maybe the problem is the same as for Skwashd but I don't understand where "That 
was it. I mistakenly said "from host permissions" instead of "localhost"" would 
be set.

Sorry if this is a noob question :p

My mySQL is on vdomain hosting btw.  I do have phpmyAdmin connected and working.

Paul.


-------------------------------------------------------
Date: 2002-Nov-29 03:34             By: skwashd
Another satisfied customer :)

-------------------------------------------------------
Date: 2002-Nov-29 02:21             By: mhanze
That was it. I mistakenly said "from host permissions" instead of "localhost"


Thanks!

-------------------------------------------------------
Date: 2002-Nov-28 23:34             By: skwashd
Have you created the database and assigned the permissions to the phpgw user in 
mysql?


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1824&group_id=509