songohan
Posts: 89
|
| Posted: 11/13/2007, 5:44 AM |
|
Hi all!
Well, I have strange problem. I use Editable grid to insert and edit data in one table. After I insert 40records I can't insert any more... no errors no nothing, record does not make it to the database...
This table contains bunch of records, I edit small part depending on search criteria...
Page size and number of records is set to 100. If I manually ad record in database, it is visible in the grid but still cant insert new ones, update is OK. Anyone any idea??? I re-generated page but still nothing. Can I check .php code manually to see what might be wrong, what to look for??
Thnx,
Andrej
|
 |
 |
wkempees
|
| Posted: 11/13/2007, 5:59 AM |
|
What is the definition of your primary key field.
How many records in table before you try and add the 40 rows.
I sort of think you might have reached maximum number of records in the
table by the size of the key field.
Walter
|
|
|
|
songohan
Posts: 89
|
| Posted: 11/13/2007, 7:30 AM |
|
Quote wkempees:
What is the definition of your primary key field.
How many records in table before you try and add the 40 rows.
I sort of think you might have reached maximum number of records in the
table by the size of the key field.
Primary key is INT(11), about 49000 records in that table.. I think I'm not near max record number for that table..
Table is used for radio station programe by days. First you choose date you want to add/edit programe for and than you are taken to this Editable Grid where you enter start hour, length and sutuff...
Thing is that I can add as many records as I want but not more than 40 for certain date (page). I deleted page navigation and set limit to 100 what should be enough for one day of data.... but when I have 40 records on page and one empty row (it is set to have one empty row) I cant add any more data...
Andrej
|
|
|
|
songohan
Posts: 89
|
| Posted: 11/15/2007, 6:35 AM |
|
Update
Well, problem solved... strange as it may be but still... think it had to do something with server setup. At local machine I had no trouble with more than 40 records per page, but on live it did not work...
I limited number of rows in grid to 20, added pagination and now it works like charm... strange strange...
Andrej
|
|
|
|
wkempees
|
| Posted: 11/15/2007, 9:18 AM |
|
ok
|
|
|
|
|
