Kryptronic Software Support Forum

Dave wrote:

To have the UK counties displayed in the selection lists throughout CCP issue the following raw DB commands :

Code:

UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usecon=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.createaccount.stateprov' LIMIT 1 ;

Code:

UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usecon=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.accountmaint.stateprov' LIMIT 1 ;

Code:

UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usedel=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.addbookins.stateprov' LIMIT 1 ;

Code:

UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usedel=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'core.addbookupd.stateprov' LIMIT 1 ;

Code:

UPDATE `core_formfields` SET `typeparam` = 'SELECT {COLS} FROM core_stateprov WHERE usecon=''1'' AND iseu=''1''' WHERE `core_formfields`.`id` = 'ecom.guestco.stateprov' LIMIT 1 ;

Dave, I tried that three times and received this error (the same as zanart's post earlier):

Script Execution Error
There was a processing problem encountered while processing your request. Please try again later.
File: /core/CORE/CORE.php Line: 510 Error Number: 256

What did I do wrong? (When submitting the DB commands I left the Output Type as XHTML Table, was that correct?)

Regards
Paul

Last edited by NicheDev (04-08-2010 16:29:49)

Any ideas, Dave?   
I can see you lurking in the shadows 

Paul

Last edited by NicheDev (04-09-2010 10:21:27)