Re: Trouble Connecting To MySQL Database

egrafeuille — Fri Sep 19, 2008 7:07 pm

Author: egrafeuille

Posted: Fri Sep 19, 2008 7:07 pm

I think the problem is the comma before the FROM clause!
Regards

Re: Trouble Connecting To MySQL Database

accetturo — Tue Sep 16, 2008 2:10 pm

Author: accetturo

Posted: Tue Sep 16, 2008 2:10 pm

Would it be possible for someone to help me setup my database

Re: Trouble Connecting To MySQL Database

zewa666 — Tue Sep 16, 2008 5:32 am

Author: zewa666

Posted: Tue Sep 16, 2008 5:32 am

mmhm

try to make the Primary key integer not tinyint.

greetings
Zewa

Trouble Connecting To MySQL Database

accetturo — Mon Sep 15, 2008 10:37 pm

Author: accetturo

Posted: Mon Sep 15, 2008 10:37 pm

I have been having alot of issues linking with a mysql database, mostly due to my inexperience with Raw editing of MySQL and your script. I took the sample script and loaded the demo SQL data into the database, and the sample worked great. I then created a new table called posystem and added several columns, PO_Number being the primary(tinyint(3)) and added all varchar(100). I replaced the text from the sample with the new table info and columns, and it didnt work as expected.

Errors Received

Code:

search sql (total: 0) SELECT countries.PO_Number, countries.name, countries.description, FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10

search sql (total: 0) SELECT countries.PO_Number, countries.name, countries.description, FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10

Errors:

1) SELECT countries.PO_Number, countries.name, countries.description, FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10
[nativecode=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 'FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10' at line 1]

2) SELECT countries.PO_Number, countries.name, countries.description, FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10
[nativecode=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 'FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10' at line 1]

3) SELECT countries.PO_Number, countries.name, countries.description, FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10
[nativecode=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 'FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10' at line 1]

4) SELECT countries.PO_Number, countries.name, countries.description, FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10
[nativecode=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 'FROM countries WHERE 1=1 ORDER BY name ASC LIMIT 0, 10' at line 1]

Warnings:

1) Wrong parameter in [SELECT]: Check this field carefully, it may be not a Primary Key!

POST: Array ( )

GET: Array ( )

Notice: Undefined property: DataGrid::$columns_view_mode in /x/x/x/x/x/datagrid/datagrid.class.php on line 3189

Warning: Invalid argument supplied for foreach() in /x/x/x/x/x/datagrid/datagrid.class.php on line 3189

Notice: Undefined property: DataGrid::$columns_view_mode in /x/x/x/xx/x/datagrid/datagrid.class.php on line 2344

Warning: Invalid argument supplied for foreach() in /x/x/x/x/x/datagrid/datagrid.class.php on line 2344

NOTE WILDCARDS*/X WERE ADDED

Here is the sample im using

Code:

<php>
################################################################################
## +---------------------------------------------------------------------------+
## | 1. Creating & Calling: |
## +---------------------------------------------------------------------------+
## *** only relative (virtual) path (to the current document)
define ("DATAGRID_DIR", "datagrid/");
define ("PEAR_DIR", "datagrid/pear/");

require_once(DATAGRID_DIR.'datagrid.class.php');
require_once(PEAR_DIR.'PEAR.php');
require_once(PEAR_DIR.'DB.php');

## *** creating variables that we need for database connection
$DB_USER='*'; /* usually like this: prefix_name */
$DB_PASS='*'; /* must be already enscrypted (recommended) */
$DB_HOST='*'; /* usually localhost */
$DB_NAME='*'; /* usually like this: prefix_dbName */

ob_start();
$db_conn = DB::factory('mysql');
$db_conn -> connect(DB::parseDSN('mysql://'.$DB_USER.':'.$DB_PASS.'@'.$DB_HOST.'/'.$DB_NAME));

## *** put a primary key on the first place
$sql=" SELECT "
."posystem.PO_Number, "
."posystem.Date, "
."posystem.Use_Code, "
."posystem.Originator, "
."posystem.Description, "
."posystem.Est_Cost, "
."posystem.Contact, "
."posystem.Signed_Off_By, "
."FROM posystem ";

## *** set needed options
$debug_mode = false;
$messaging = true;
$unique_prefix = "f_";
$dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix, DATAGRID_DIR);
## *** set data source with needed options
$default_order_field = "PO_Number";
$default_order_type = "ASC";
$dgrid->dataSource($db_conn, $sql, $default_order_field, $default_order_type);

## +---------------------------------------------------------------------------+
## | 6. View Mode Settings: |
## +---------------------------------------------------------------------------+
## *** set columns in view mode
$dgrid->setAutoColumnsInViewMode(true);

## +---------------------------------------------------------------------------+
## | 7. Add/Edit/Details Mode settings: |
## +---------------------------------------------------------------------------+
## *** set settings for edit/details mode
$table_name = "posystem";
$primary_key = "PO_Number";
$condition = "";
$dgrid->setTableEdit($table_name, $primary_key, $condition);
$dgrid->setAutoColumnsInEditMode(true);

## +---------------------------------------------------------------------------+
## | 8. Bind the DataGrid: |
## +---------------------------------------------------------------------------+
## *** set debug mode & messaging options
$dgrid->bind();
ob_end_flush();
####################################################

Again, Wildcards were added

Server is updated with all the standards, and has been tested on samples to show it works.

PHP Builder

Re: Trouble Connecting To MySQL Database

Re: Trouble Connecting To MySQL Database

Re: Trouble Connecting To MySQL Database

Trouble Connecting To MySQL Database