No Data Being Displayed

Talk about installation process and problems

Moderator: alexandrleonenko

Bitster
Newbie
Newbie
Posts: 2
Joined: Jan 27th, '11, 21:17

No Data Being Displayed

Postby Bitster » Jan 27th, '11, 21:35

Hello,

I just purchased and am installing PHP DataGrid for testing, however I have hit a snag... I setup everything according to the Getting Started, however the grid is showing no data.

Here is the select statement I am using: "SELECT npiAmountID, Year, Carrier_Number FROM for_testing"

"npiAmountID" is the primary key, and "Year" & "Carrier_Number" are two other columns. "for_testing" is a MySQL InnoDB database with 800k + records.

When the php page is executed it shows the "+ Add New", "View", "Delete" columns, however no data columns. The pager lists:"Results: 1 - 10 of 803,042", so it is obvious the database connection is occurring correctly to this table.

Below the grid the following debug info is being displayed:

Code: Select all

Retrieve data for current mode:
select sql (total: 10) SELECT npiAmountID, Year, Carrier_Number FROM for_testing WHERE 1=1 ORDER BY npiAmountID ASC LIMIT 0, 10

Retrieve data for current mode:
select sql (total: 10) SELECT npiAmountID, Year, Carrier_Number FROM for_testing WHERE 1=1 ORDER BY npiAmountID ASC LIMIT 0, 10

POST: Array ( [abc_mode] => cancel [abc_rid] => -1 [abc_page_size] => 10 [abc_p] => 1 [abc_new] => 1 )

GET: Array ( )


There are no SQL errors being displayed & this Select statement works flawlessly in phpMyAdmin.

Thanks for your assistance...

-BB

administrator
Site Admin
Site Admin
Posts: 6105
Joined: Jan 7th, '09, 23:18
Contact:

Re: No Data Being Displayed

Postby administrator » Jan 30th, '11, 09:31

Did you define Edit Mode settings? At least table name, condition etc..?
What version of datagrid you work with?

Bitster
Newbie
Newbie
Posts: 2
Joined: Jan 27th, '11, 21:17

Re: No Data Being Displayed

Postby Bitster » Jan 31st, '11, 16:38

Yes, Edit mode settings are:

Code: Select all

$table_name  = "for_testing";
$primary_key = "npiAmountID";
$condition   = "";
$dgrid->SetTableEdit($table_name, $primary_key, $condition);


DataGrid version is : 6.4.1

-B

administrator
Site Admin
Site Admin
Posts: 6105
Joined: Jan 7th, '09, 23:18
Contact:

Re: No Data Being Displayed

Postby administrator » Feb 1st, '11, 09:26

Please send us a link to your site with debug = true.
You may do this via private messaging

lawfultoad
Newbie
Newbie
Posts: 3
Joined: May 3rd, '11, 12:22

Re: No Data Being Displayed

Postby lawfultoad » May 3rd, '11, 12:26

Hello,
It looks like I'm having the same issue.

The grid is displayed with the appropriate number of results except there's no data, just 'Edit' in the Add New field, 'Details' in the View column and a Delete column.

The query displayed works fine as well:

Retrieve data for current mode:
select sql (total: 10) SELECT cust_id, last_updated, acct_num, other_acct_num, name_first, name_last from customer WHERE 1=1 ORDER BY name_last ASC LIMIT 0, 10

POST: Array ( [abc_mode] => view [abc_page_size] => 10 )

GET: Array ( )

What was the resolution to this?

Thanks!

administrator
Site Admin
Site Admin
Posts: 6105
Joined: Jan 7th, '09, 23:18
Contact:

Re: No Data Being Displayed

Postby administrator » May 3rd, '11, 12:42

There were some issues fixed last days in datagarid. Please download the latest archive version and try with it.
does it help now?

lawfultoad
Newbie
Newbie
Posts: 3
Joined: May 3rd, '11, 12:22

Re: No Data Being Displayed

Postby lawfultoad » May 3rd, '11, 20:13

I just bought and downloaded the product yesterday. On my customer page there is only one button to download the current version.

lawfultoad
Newbie
Newbie
Posts: 3
Joined: May 3rd, '11, 12:22

Re: No Data Being Displayed

Postby lawfultoad » May 4th, '11, 02:52

Got it. I failed to uncomment this line and set it to true.


$auto_column_in_view_mode = true;


Return to “Installation”