websgt
Forum Replies Created
-
@peterschulznl
I am adding a id column (rec_ID), I have it as mandatory, and key. How do I set it to auto-increment?Well I changed the table type to InnoDB and dropped the index. To do this I had to drop the table. I exported the records as a CSV , of course I did not realize that import only supports SQL, and it only exported 10 records :(. Luckily I had an older list of the officers (up to 2014), and and inserted the appropriate SQL statements and got most of it imported.
Regardless, this change did not change the order of the records.
Peter,
It is one table with one view.
Here is the SQL for the create table:
CREATE TABLEMCL_Officers
(Termchar(10) NOT NULL
,Commandantchar(100) NULL
,Sr_Vice_Commandantchar(100) NULL
,Jr_Vice_Commandantchar(100) NULL
,Judge_Advocatechar(100) NULL
,Adjutantchar(100) NULL
,Paymasterchar(100) NULL
,Sergeant_At_Armschar(100) NULL
,Chaplainchar(100) NULL
,Aide_de_Campchar(100) NULL
,Jr_PastCommandantchar(100) NULL
,WebSergeantchar(100) NULL
,Historianchar(100) NULL
,Public_Affairschar(100) NULL
,PRIMARY KEY (Term)
) ENGINE MyISAM DEFAULT CHARACTER SET utf8 COLLATE=utf8_general_ci;CREATE UNIQUE INDEX
MCL_INDXONMCL_Officers(Term);On the data publisher I have the columns set for:
Term,Commandant,Sr_Vice_Commandant,Jr_Vice_Commandant,Judge_Advocate,Adjutant,Paymaster,Sergeant_At_Arms,Chaplain,Aide_de_Camp,Jr_PastCommandant,WebSergeant,Historian(it is essentially everything except the last field which is public affairs (not currently needed.)
Output: responsive
number of columns: 1In all its one table with 1 view.
Default Order/By: 0,descTerm is the first column, hence 0 for the order by, and I have tried both asc and desc to see if it make a difference.
The page is live and I put the link in the initial post to see the out put (second table down, the first table is static)
I have gone through the data designer, project templates, data projects and data publisher and reviewed all the options. Did I miss something?
Thanks for your help.
@rvwill48,
Thank you for your reply.hmm.. I don’t seem to have access to the underlaying SQL in this plugin. I would think that would need to be entered in the Data Publisher section, but it requires Column, asc|desc. I don’t see where I can use the LEFT clause for TERM.
Regards,
StevePeter,
I had tried it both asc and desc with and without the “;”, as I read somewhere that might be required. Just to be sure, I just tried it again, without the “;” and the results are unchanged. I also tried it asc and desc. One of them should have changed the results.
I’m open for suggestions.
Thanks.
StevePeter,
Thank you for your quick reply.1. I should have known that..
2. I tried it both way, 0,desc and 0,asc. The table results are unchanged.Thanks,
SteveI will review. Once the plugin is installed, it works fine, it is just the updating process that seems to break it. I am using the current version at the moment, so I cannot try the debug methods listed. These are some of my PHP settings, do you have any recommendations?
Directive—————-Local Value——-Master Value
max_execution_time——-600—————60
max_file_uploads———20—————-20
max_input_nesting_level–64—————-64
max_input_time———–400—————60
max_input_vars———–1000————–1000
memory_limit————-256M————–128MThanks.
- This reply was modified 5 years, 5 months ago by websgt.
Thank you for the reply.
How much memory do you recommend for a World Press Installation?