| Radicore v1.33.0/Search sort problem [message #1259] |
Thu, 21 February 2008 04:18  |
Jovan
Messages: 24
Registered: February 2008
Location: Serbia
|
Junior Member |
|
|
I succesfuly migrate from v1.30.0 to v1.33.0 with two pilot projects.
Step1: Install blank new version (v1.33.0)
Step2: Install your dbprefix update
Step3: Analyse changes, especially DDL
Step4: Run DDL and DML scripts (in this order)
Step5: Copy aplications (Subsystems) in new version
Step5: Testing migration
When I choose Search for Task(Proc) first screen after I submit is o.k. , as this search have more than one screen next screen system loose sort and return on begining. I sow list Task(Proc) from the very first Task(Proc) in Dictionary (ex. alfa ....).
When I run search with more than one screen with production data in my applications everything is o.k. only when I try to search something from system tables.
'Dbprefix' working o.k. when I have more than one set of databases which has different prefix. When I try to Insert new Databases, system list all new databases as choice.
Jovan
|
|
|
|
|
|
|
|
| Re: Radicore v1.33.0/Search sort problem [message #1262 is a reply to message #1261] |
Thu, 21 February 2008 05:46  |
AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
I cannot reproduce this problem. When I run "List Task (Proc)" without any search criteria it shows 165 pages. If I then go to the search page and enter '%x_%' in task id and press SUBMIT this is reduced to 10 pages, showing 'page 1 of 10'. I then press NEXT and it shows page '2 of 10'. It does not lose any search criteria by pressing the NEXT link.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
| Re: Radicore v1.33.0/Search problem/dbprefix exist [message #1270 is a reply to message #1262] |
Tue, 26 February 2008 17:10 |
Jovan
Messages: 24
Registered: February 2008
Location: Serbia
|
Junior Member |
|
|
I install Radicore v1.33.0 on client Ubuntu on 'clean' db.
than I import ddl/dml for audit,dict,menu and workflow, without dbprefix
1. step Than test SEARCH Task(proc) with 'w' criteria and everything was o.k. (1-5 pages) when I press next I get 10 more with leading w....
2. step Than I add, generate new set of databases (test_audit, test_dict test_menu, test_workflow) and import data, change config.ini and test on the SAME way, with SEARCH 'w'
Everything was o.k.
3. Than I implement one by one (first dml.mysqli.class.inc than mysql.class.inc) scripts which you sent me for update version 1.33.0, and found that when I implement after these two std_table_class.inc I have situation which I explain you few days ago:
After first page with 'w' SEARCH (1-5) when I press next control of process goes out of search criteria and list new page with :
date ...
dict ...
dict ...
(2-22) and when I press next I have new pages from the (dict ...) subset.
Jovan
|
|
|
|
| Re: Radicore v1.33.0/Search problem/dbprefix exist [message #1271 is a reply to message #1270] |
Tue, 26 February 2008 20:10 |
AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
I cannot reproduce this fault. These are the steps I have used:
1. I have created a set of databases with a 'test_' prefix (test_audit, test-dict, test_menu and test_workflow), and populated them with data from the *.dict_export.sql and *.menu_export.sql files.
2. I have changed my config.ini file to set $dbprefix to 'test_'.
3. I log on and go to Menu System->Task(Proc), and without any search criteria I see a total of 22 pages. I use the PREV and NEXT hyperlinks and I still see 22 pages.
4. I go into the search screen and set task_id to 'w%', press SUBMIT, and when I return to the list screen it shows 'Page 1 of 5'. I press NEXT and see 'Page 2 of 5'. I press PREV and see 'Page 1 of 5'. This is what I expect.
As I cannot reproduce this problem you will have to step through with your debugger to see where $this->sql_search is being reset.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
|
|
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
