Forums / Installing on a Linux/Unix Server / SQL issue viz mySQL db v5, or other problem?

SQL issue viz mySQL db v5, or other problem?

Locked

Views: 3,837

Results 1 to 20 of 23
This thread is locked. New replies are disabled.
13 Jul 2007, 1:19 PM
#1
australdata avatar

australdata

New Zenner

Join Date:
Jul 2007
Posts:
6
Plugin Contributions:
0

SQL issue viz mySQL db v5, or other problem?

Hi,

I wonder if anyone might be able to help. I did a fresh install on Unix/apache using suExec (therefore no permissions issues). Ensured all files uploaded OK. Did installation but during the process got a "MySQL 5 not fully supported" warning. My host's tech admins tell me there are no issues running Zencart under v.5 on their servers.

On completing installation (into site root) I get:

Fatal error: Cannot instantiate non-existent class: notifier in /home/express/www/www/includes/autoload_func.php on line 79

I am no PHP'er, so cannot figure out the problem. Seems to me it's not an SQL issue. Any suggestions?

Any help will be greatly appreciated.
:blush:

13 Jul 2007, 9:08 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

australdata:

Fatal error: Cannot instantiate non-existent class: notifier in /home/express/www/www/includes/autoload_func.php on line 79This suggests that some of the class files in the /includes/classes folder may not be fully uploaded.

Did you use v1.3.7 or v1.3.7.1 ? There are a few small fixes in v1.3.7.1 that might also help prevent that error ... although the most common cause of the error you mention is just that several of the /includes/classes files are not uploaded properly ... either missing or only 0 bytes, etc.

.
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.

13 Jul 2007, 10:08 PM
#3
australdata avatar

australdata

New Zenner

Join Date:
Jul 2007
Posts:
6
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

DrByte, thanks for your reply :D

I thought that I might have some files missing and have gone through each and every folder (all 5 zillion of them!) to check. I had a few missing, but did not consider the zero bytes issue. I did upload the very latest file set.

I will go through it all again. Will come back to post outcome.

Thanks for your help.

:blink:

13 Jul 2007, 10:45 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

Sometimes the approach documented in this link can be helpful too:
http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues

.
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.

14 Jul 2007, 6:37 AM
#5
australdata avatar

australdata

New Zenner

Join Date:
Jul 2007
Posts:
6
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

Thanks DrByte,

I've looked up wiki and I've downloaded and used Winmerge. No errors.

I've seen your name in config.core.php! Not that I had been looking for it, but while trying to backtrace the error message, I looked at this config.core.php and noted:

/**
*

  • require(DIR_WS_CLASSES . 'class.base.php');
  • require(DIR_WS_CLASSES . 'class.notifier.php');
  • $zco_notifier = new notifier()'
  • require(DIR_WS_CLASSES . 'mime.php');
  • require(DIR_WS_CLASSES . 'email.php');
  • require(DIR_WS_CLASSES . 'boxes.php');
  • require(DIR_WS_CLASSES . 'category_tree.php');
  • require(DIR_WS_CLASSES . 'cache.php');
  • require(DIR_WS_CLASSES . 'sniffer.php');
  • require(DIR_WS_CLASSES . 'shopping_cart.php');
  • require(DIR_WS_CLASSES . 'navigation_history.php');
  • require(DIR_WS_CLASSES . 'currencies.php');
  • require(DIR_WS_CLASSES . 'message_stack.php');
  • require(DIR_WS_CLASSES . 'template_func.php');
  • require(DIR_WS_CLASSES . 'split_page_results.php');
  • require(DIR_WS_CLASSES . 'breadcrumb.php');
  • require(DIR_WS_CLASSES . 'language.php');

*/

I am assumed at first that all of these classes have to be loaded when entering the site. So I searched both the downloaded files and the uploaded-then-downloaded files from the server - I didn't find:

email.php and mime.php

Do these files have to be present?

Looking just below these lines in the said script, I see:

$autoLoadConfig[0][] = array('autoType'=>'class',
'loadFile'=>'class.base.php');

I gather these are instructions to load the files, but there is no referrence to the two "missing" files. I know that with the /* and the */ before and after these rows it means these lines are not to be acted on (i.e. ignored). In which case I am barking up the wrong tree about the "missing" two files being the issue here.

As you can tell, I am still none the wiser how to fix the problem. At this stage the best solution seems to just delete everything and not install a cart at all :lookaroun

Anyone?

15 Jul 2007, 12:51 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

The "email.php" and "mime.php" were old scripts used in a prior version of Zen Cart. Apparently we haven't gotten their references out of the comments yet.

.
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.

15 Jul 2007, 12:52 AM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

In your /includes/application_top.php, around line 18 or so, you'll see this:```
/**

  • boolean if true the autoloader scripts will be parsed and their output shown. For debugging purposes only.
    */
    define('DEBUG_AUTOLOAD', false);
Then refresh your browser.
What do you see ?

.
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.

15 Jul 2007, 1:03 AM
#8
brisbanetimeout avatar

brisbanetimeout

Zen Follower

Join Date:
Jul 2006
Posts:
108
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

Hi all,

After editting that false to true and refresh... I now get...

actionPoint=>0 include('/home/express/www/wwwincludes/classes/class.base.php');
actionPoint=>0 include('/home/express/www/wwwincludes/classes/class.notifier.php');

Fatal error: Cannot instantiate non-existent class: notifier in /home/express/www/www/includes/autoload_func.php on line 79

I changed it back as it was....

Should we try and install a previous version ? Is this happening to everyone ?

15 Jul 2007, 1:19 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

brisbanetimeout:

Is this happening to everyone ?

No. It typically only happens when files don't upload properly.

.
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.

15 Jul 2007, 1:21 AM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

Try replacing your /includes/autoload_func.php with the one attached, as it provides a bit of additional debug info.

Then set the DEBUG_AUTOLOAD to true again.

.
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.

15 Jul 2007, 1:22 AM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

What's the filesize of the /includes/classes/class.notifier.php on your server ?

.
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.

15 Jul 2007, 3:59 AM
#12
brisbanetimeout avatar

brisbanetimeout

Zen Follower

Join Date:
Jul 2006
Posts:
108
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

I saved the file and uploaded your file and then refreshed the screen and I go this error...

Fatal error: Cannot instantiate non-existent class: notifier in /home/express/www/www/includes/autoload_func.php on line 79

I will change back to the original autoload_fun.php file.

Oh I hope this can be sorted... I like Zen...

15 Jul 2007, 4:07 AM
#13
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

brisbanetimeout:

I saved the file and uploaded your file and then refreshed the screen and I go this error...

Fatal error: Cannot instantiate non-existent class: notifier in /home/express/www/www/includes/autoload_func.php on line 79wasn't that the same error you were getting?

Did you set the DEBUG_AUTOLOAD to true after using the new file ?

.
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.

15 Jul 2007, 5:46 AM
#14
australdata avatar

australdata

New Zenner

Join Date:
Jul 2007
Posts:
6
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

Hi DrByte,

As you probably reaslise both brisbanetimeout and I are trying to get the cart to work.

Regarding your question about file size for 'class.notifier.php' - its 632 bytes.

We do both very much appreciate your time and effort. One day, maybe, we'll get that cart to work :blush:

15 Jul 2007, 5:51 AM
#15
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

Where can I see these errors in action?

.
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.

15 Jul 2007, 5:54 AM
#16
australdata avatar

australdata

New Zenner

Join Date:
Jul 2007
Posts:
6
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

DrByte:

In your /includes/application_top.php, around line 18 or so, you'll see this:```
/**

  • boolean if true the autoloader scripts will be parsed and their output shown. For debugging purposes only.
    */
    define('DEBUG_AUTOLOAD', false);
> Then refresh your browser.
> What do you see ?

Regarding your suggestion above, DrByte, I changed it to 'true' again in order to see the error. Based on the outcome, as shown by brisbanetimeout's post, I checked for the presence and content of the two referenced files. I found them intact (i.e. the same as the ones I downloaded from zen).

Thanks :) any other suggestions?
15 Jul 2007, 6:35 AM
#17
brisbanetimeout avatar

brisbanetimeout

Zen Follower

Join Date:
Jul 2006
Posts:
108
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

Doctor...

The web URL is https://www.expressshopper.com.au ... you can view the errors there...

Is there something else for me to try ??

Thanks for your help
Dave

15 Jul 2007, 8:06 AM
#18
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

Is that using the newer autoload_func.php file ? (unzipped and uploaded to your server)?

.
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.

15 Jul 2007, 8:21 AM
#19
brisbanetimeout avatar

brisbanetimeout

Zen Follower

Join Date:
Jul 2006
Posts:
108
Plugin Contributions:
0

Re: SQL issue viz mySQL db v5, or other problem?

goto https://www.expressshopper.com now... it is with the file you have supplied...

ta
Dave

15 Jul 2007, 8:25 AM
#20
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: SQL issue viz mySQL db v5, or other problem?

what's in your /includes/configure.php file ?

Your path info looks odd:> '/home/express/www/wwwincludes/classes/class.base.php'

  1. Why the /www/www repetition ?
  2. Why is there a missing / between www and includes ?

.
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.