Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2005
    Location
    way south
    Posts
    23
    Plugin Contributions
    0

    Default Database or template issue?

    Our forum suddenly (today) was unable to load the main template -- i.e., it came up with no formatting, like with no html. SiteGround support changed something unspecified (couldn't get them to tell me what it was) and the template loaded but without any of the template overrides in place, so it looked like the unmodified thing you get when first installing 1.3.x. We use overrides in "our site" folders with a custom css file, which has been working just fine for months.

    I uploaded new files and now get this error. I have no idea why?

    "Fatal error: Call to a member function sql_cache_exists() on a non-object in /home/metalboa/public_html/ZenCart/includes/classes/db/mysql/query_factory.php on line 105"

    Can anyone give me a clue? We're current with 1.3.7, and the updated store was working fine before this.

  2. #2
    Join Date
    Nov 2005
    Location
    way south
    Posts
    23
    Plugin Contributions
    0

    red flag Re: Database or template issue?

    BTW, this is the line in query_factory.php the error is referring to:

    if ( $zf_cache AND $zc_cache->sql_cache_exists($zf_sql) AND !$zc_cache->sql_cache_is_expired($zf_sql, $zf_cachetime) ) {

    Store is down -- any help appreciated.

    Thanks

  3. #3
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Database or template issue?

    Need to narrow down "where" this is coming from ...
    1. where on the screen is the error appearing?
    2. can you post a copy of View Source from the browser?
    3. what mods are installed on your site?
    4. if you switch to Classic template, do the problems remain?
    5. what is your PHP version? (see Admin->Version Info)
    6. what is your MySQL version?
    .

    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
    Nov 2005
    Location
    way south
    Posts
    23
    Plugin Contributions
    0

    Default Re: Database or template issue?

    The error message appears at the top of the screen, which is otherwise blank.

    View source gives exactly the same, with some added html codes.

    Mods: cc_accept v1.2, first_last_name_required, better categories, about_us_page 1.3, paypal wwp update Mar 20.

    Switching templates has no effect.

    ZenCart 1.3.7
    PHP 5.0.5
    MySQL 4.1.21

    Thanks,
    Steve

  5. #5
    Join Date
    Nov 2005
    Location
    way south
    Posts
    23
    Plugin Contributions
    0

    Default Re: Database or template issue?

    Re the previous, the site is now working after having been completely restored from a backup. No idea why it began malfunctioning, although I'm a bit suspicious that an event occurred on our webhost's shared server that may have resulted in files being corrupted. But, as I say, that's only a guess.

  6. #6
    Join Date
    Nov 2005
    Location
    way south
    Posts
    23
    Plugin Contributions
    0

    Default Re: Database or template issue?

    And a belated thank you for your help.
    S

  7. #7
    Join Date
    Oct 2006
    Posts
    137
    Plugin Contributions
    0

    Default Re: Database or template issue?

    was there ever an answer here because I have the same problem, and seems others do too

  8. #8
    Join Date
    Jan 2006
    Location
    Vancouver, BC
    Posts
    71
    Plugin Contributions
    0

    Default Re: Database or template issue?

    Yes:
    Quote Originally Posted by steve4820 View Post
    the site is now working after having been completely restored from a backup
    Sadly, my backups went missing in all of this. I had installed the back up contribution and used it all the time but it has vanished. Of course, I only had it in the Admin, I have never downloaded any of them to my pc. Let that be a lesson to everyone - backup backup backup... and save to somewhere other than just the Admin lest your host undo all your good intentions.

  9. #9
    Join Date
    Jul 2006
    Posts
    50
    Plugin Contributions
    2

    Default Re: Database or template issue?

    Dr Byte,

    I am also having this issue, but I am only having this issue when using the single_sidebox contribution that is found in the downloads area.

    I am attempting to use the single sidebox with Drupal and am trying to get a sidebox from Zen-Cart into a block in Drupal, to have a more seamless look between Zen-Cart and Drupal.

    I also changed the cache type from none to database. Haven't tried File yet.

    The error messages makes me believe that the $zc_cache object is not being instanced or created properly while using the single_sidebox inside of Drupal, which Drupal uses the php eval function to encapsulate all php code that is entered via submitted pages that are marked as php pages.

    I know that it works standalone as I made a file to check it, but I was wondering if you might be able to point me in the right direction on getting it to work with Drupal, and get rid of this message. If we need to start a new thread, let me know. I'm tempted to just make new code to pull the information out of the zen db, but then I'd also have to include the define pages for ZC variables, which I don't want to do.

    any help you can provide would be great

  10. #10
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Database or template issue?

    I suspect it may be a clash of variable names between applications, in which case you'll have to get very creative in how you rewrite things to use alternate variable names.
    .

    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.

 

 

Similar Threads

  1. v150 Database Setup Issue: Connection to Database failed, on iPage
    By tempoart in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jul 2012, 07:43 AM
  2. Database issue
    By s_developer in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 26 Apr 2009, 03:29 PM
  3. database issue
    By lucianman in forum General Questions
    Replies: 3
    Last Post: 8 Apr 2009, 06:05 PM
  4. CSS Validator issue - Peek-a-boo? Template Monster template
    By Mickmo68 in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 14 May 2008, 02:51 AM

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