Results 1 to 10 of 30

Hybrid View

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

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

    Thank you for your suggestion but I dont want to add another configuration somehow.

  2. #2
    Join Date
    May 2006
    Posts
    68
    Plugin Contributions
    0

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

    that is where your error is,
    300 has been used by another module.

    so by adding it as '' it will auto increment.

    you will need this to have the module work.

  3. #3
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

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

    A. BE SURE TO DO A DATABASE BACKUP FIRST !!!

    1. Find out what id#300 is:
    Code:
    SELECT configuration_group_title FROM configuration_group where configuration_group_id = 300;
    2. if the result from the statement above is "Quick Updates", then you can run the following to remove it:
    Code:
    DELETE from configuration_group where configuration_title = 'Quick Updates';
    DELETE from configuration where configuration_key like 'QUICKUPDATES_%';
    3. If the result from step 1 is NOT "Quick Updates", then you have some other mod using that group id, and removing it may cause you other grief.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

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

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

    Quote Originally Posted by DrByte
    A. BE SURE TO DO A DATABASE BACKUP FIRST !!!

    1. Find out what id#300 is:
    Code:
    SELECT configuration_group_title FROM configuration_group where configuration_group_id = 300;
    2. if the result from the statement above is "Quick Updates", then you can run the following to remove it:
    Code:
    DELETE from configuration_group where configuration_title = 'Quick Updates';
    DELETE from configuration where configuration_key like 'QUICKUPDATES_%';
    3. If the result from step 1 is NOT "Quick Updates", then you have some other mod using that group id, and removing it may cause you other grief.
    Database is backed up :)

    Hi Chris,
    Thanks for the above. It is definately quick updates and it definately has a config id of 300 as I can see it in the task bar but when I tried your code I received...

    1054 Unknown column 'configuration_title' in 'where clause'


  5. #5
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

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

    I THINK that should have read...
    configuration_group_title not configuration_title
    Can anyone confirm please?

    Code:
    DELETE from configuration_group where configuration_group_title = 'Quick Updates';
    DELETE from configuration where configuration_key like 'QUICKUPDATES_%';

  6. #6
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

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

    Well the database is backed up and the sql errors suggested to me the above was correct so I tried it and it worked!

    Thanks to all those that helped!!!!!!!!!!!!!!!

  7. #7
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

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

    yup - correct ... sorry for the typo.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

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

    No need to apologise Dr.
    Without your help I wouldnt have had much of an idea.

  9. #9
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

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

    Sorry, I re-read the above and I forgot to add.
    Id like to drop the changes first before applying the fix above for the sql.
    Thanks for the fix.

    Can anyone help with removing it first?
    Thanks

 

 

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