Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2005
    Location
    Lamar, MO
    Posts
    69
    Plugin Contributions
    0

    Auto-switching DB login to end 1226 Error

    Hi!

    Dr. Byte stated in another thread that there was a way to make your zen-cart roll over from one DB username to another to avoid the dreaded 1226 exceeded DB access limit. (see: http://www.zen-cart.com/forum/showth...ght=1226+Error)

    Can anyone tell me exactly how this is accomplished (by what code, where I need to put it, etc)

    Thanks for your help in advance!

  2. #2
    Join Date
    Apr 2005
    Location
    Lamar, MO
    Posts
    69
    Plugin Contributions
    0

    Default Re: Auto-switching DB login to end 1226 Error

    *polite bump*

    Just talked to Ipower... sadly they won't up the amount of requests my db can handle so this seems to be my only option, other than changing services and god what a hassle that will be and costly to boot! Please, tell me someone out there has an answer to this problem.

  3. #3
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Auto-switching DB login to end 1226 Error

    Don't know who your host is(opps you did state who they were) but it would seem that they are not very ZenCart friendly.

    Check the tab at the top for ZenCart Certified hosting... what you might think will be costly and a real hassel might turn out to be a 'god send'.

    Many of the hosts will transfer your Zen site 'free of charge' so that you end up on a certified host with little intervention from you and this is normally a rapid transfer.

    An added benefit is that these hosts are fully ZenCart savy and will assist with some of the problems, albeit you should attack it first as they cannot do it all for you for free. But it can be reassuring that any ZenCart requirements will be supported by them like in this case the # of DB requests.

    Or you can continue to attempt to work around these problems...it is your site and choice.
    Zen-Venom Get Bitten

  4. #4
    Join Date
    Apr 2005
    Location
    Lamar, MO
    Posts
    69
    Plugin Contributions
    0

    Default Re: Auto-switching DB login to end 1226 Error

    I'm sorry I thought I had said it... *oops* Ipower.com is my host. Thanks for the advice. Trust me if I were the final say in whether we moved our site or not, I might just do that... sadly my boss gets to make that call and I'm not sure he will. *shrugs* we'll see. For now, I need to find out if there is any way to make this work without the moving.

    Thanks for the advice just the same. :)

  5. #5
    Join Date
    Apr 2005
    Location
    Lamar, MO
    Posts
    69
    Plugin Contributions
    0

    Default Re: Auto-switching DB login to end 1226 Error

    Does anyone know a way to make this work besides moving to a new host?

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Auto-switching DB login to end 1226 Error

    What versoin of Zencart is installed??
    Zen-Venom Get Bitten

  7. #7
    Join Date
    May 2004
    Location
    Hong Kong
    Posts
    1,291
    Plugin Contributions
    1

    Default Re: Auto-switching DB login to end 1226 Error

    The following may be what you want.

    Rotating Db Users

    But as kobra said, the best is still a ZenCart Certified hosting. It keep you away from the problems which always find in other hosts for keep lowering their costs.
    A New Starter again

  8. #8
    Join Date
    Apr 2005
    Location
    Lamar, MO
    Posts
    69
    Plugin Contributions
    0

    Default Re: Auto-switching DB login to end 1226 Error

    You are a god, may all that is good and fluffy grace your days eternally! :)

    (ie: thanks!)

    *big hugs*

 

 

Similar Threads

  1. v151 Switching templates front end
    By philip937 in forum General Questions
    Replies: 3
    Last Post: 29 Aug 2014, 10:16 PM
  2. i got foll error: 1226
    By vr4indian in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 9 Dec 2006, 03:04 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR