Results 1 to 10 of 30

Threaded View

  1. #13
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

    Default Re: Anyone any good at SQL? Can you help?

    Quote Originally Posted by DrByte
    You could also try inserting without the blank strings, like this:

    Code:
    INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');
    
    INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
    ('Display the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 300, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display the name.', 'QUICKUPDATES_DISPLAY_NAME', 'true', 'Enable/Disable the name displaying', 300, 3, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the name of the products.', 'QUICKUPDATES_MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 300, 4, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display the Description.', 'QUICKUPDATES_DISPLAY_DESCRIPTION', 'true', 'Enable/Disable the displaying of description', 300, 5, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the description of the products.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Allow/Disallow the Description modification?', 300, 6, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the status of the products.', 'QUICKUPDATES_DISPLAY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', 300, 7, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the weight of the products.', 'QUICKUPDATES_DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 300, 8, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the quantity of the products.', 'QUICKUPDATES_DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 300, 9, '2003-06-04 05:06:48', '2003-06-04 04:34:34', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', 300, 10, '2003-06-04 05:06:57', '2003-06-04 04:37:40', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', 300, 11, '2003-06-04 05:06:40', '2003-06-04 04:31:53', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', 300, 12, '2003-06-04 05:07:02', '2003-06-04 04:38:45', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', 300, 14, '2003-06-04 05:19:13', '2003-06-04 05:15:50', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', 300, 15, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display the manufacturer.', 'QUICKUPDATES_DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 300, 16, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Display the tax.', 'QUICKUPDATES_DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 300, 17, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
    ('Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', 300, 18, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
    Thanks for your help again doc.
    I tried the above and got the same
    I checked out upgrade_exceptions and it reports the same as the error above.
    phpmyadmin reports that 2 items were succesfully inserted.
    When I click the quick updates mod, all I get is a table with the prices only, Im pretty sure its an sql issue as none of the configs are being read from the config settings as they cant be inserted.
    I will try inserting one by one now
    PS yes I have searched the forum and read 4 threads related to this mod (some are 7 pages long) but havent tried contacting the author yet as im 99% sure its an sql thing.
    Last edited by Reesy; 23 May 2006 at 04:49 AM.

 

 

Similar Threads

  1. Problems with installation
    By bmw2182 in forum Installing on a Linux/Unix Server
    Replies: 8
    Last Post: 1 Aug 2008, 05:32 PM
  2. Problems with XAMPP installation
    By Marlake in forum Installing on a Windows Server
    Replies: 6
    Last Post: 26 Mar 2008, 07:11 PM
  3. How to get Group Pricing (per Item) to work with QuickUpdates?
    By Gamer in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 0
    Last Post: 14 Feb 2008, 04:22 PM
  4. Problems with Installation
    By monicagallien in forum Installing on a Linux/Unix Server
    Replies: 10
    Last Post: 29 Jun 2006, 10:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg