viktork
Posts: 22
|
| Posted: 12/23/2012, 12:31 PM |
|
Successfully upgraded project from 4th version to 5th version.
But all Totals now show 'CCS not counted'. As it as the case for previous version I've changed to
supportSelectFromSelect="True" in CodeChargeStudio5\Components\Databases\MySQL.xml
What's could be wrong? Any ideas?
All worked perfectly fine in 4th version?
|
 |
 |
viktork
Posts: 22
|
| Posted: 12/24/2012, 9:34 AM |
|
Hello
Any idea why 'Total' / Count is different in Version 5 from Version 4?
Thanks!
|
|
|
|
viktork
Posts: 22
|
| Posted: 12/27/2012, 9:51 AM |
|
Any ideas what is the difference between 'Totals' in a Grid in 4.x version and 5.x version?
|
|
|
|
Lucius
Posts: 220
|
| Posted: 01/09/2013, 6:53 AM |
|
Hi,
I don't know if there is a difference, but it is very easy to check...
Open backup of your old files and newly upgraded files and check db_adapter.php file, especially the PageCount() function.
If there is a difference, you should see it in the function, or the code this function executes.
It is also very possible that the event that is connected to counting the records was not upgraded to new version. If so then unfortunately you will need to manually re-add this in the page code.
|
|
|
|
viktork
Posts: 22
|
| Posted: 01/28/2013, 10:12 AM |
|
Navigation and Totals do not work with simple query like
SELECT MAX(value1) FROM test GROUP BY id;
And this does work on CCS4
|
|
|
|
Lucius
Posts: 220
|
| Posted: 01/28/2013, 10:29 AM |
|
SELECT MAX(value1) FROM test GROUP BY id;
The above query doesn't give you amount of records in the DB, it gives you highest number from group.
|
|
|
|
Lucius
Posts: 220
|
| Posted: 01/28/2013, 10:31 AM |
|
Also for me if I create new grid with Total count of records it works perfectly well in CCS5.
So this is most likely some CCS4 to CCS5 project upgrade error.
|
|
|
|
viktork
Posts: 22
|
| Posted: 01/28/2013, 12:15 PM |
|
Total count works ok for "usual" grid. But if I use Max(v2) from test group by v2 the total does not work. Even preview shows the correct number and navigation. But once in live - I get CCS not counted ( an old error which usually could have been solved by updating mysql.xmls. But not anymore). The ver same files work ok under CCS4. Surprise.
|
|
|
|
Lucius
Posts: 220
|
| Posted: 01/28/2013, 1:27 PM |
|
I think it might be related to GROUP BY clause in SQL. I had some issues with that also, but was able to find easy workarounds iirc.
Where exactly do you use this statement? Somewhere in grid properties, in some custom event?
|
|
|
|
viktork
Posts: 22
|
| Posted: 01/29/2013, 2:58 AM |
|
Simple query like this
SELECT id,
name AS TestName,
MAX(value) AS TestValue
FROM test
GROUP BY id
ORDER BY id DESC
Does not work in CCS5 and *does* work in CCS4 under the very same environment
EasyPHP 5.4.6 with MySQL ODBC Connector 5.1.
What shall I do with CCS4 project that has CASE in it and conditional SUM? or sub-queries? Id are not upgrade it 
|
|
|
|
