1054 Error

[maggiesmom1]

I've got this error & don't know what it means:

1054 Unknown column 'startdate' in 'field list'
in:
[select startdate, counter, session_counter from counter_history where startdate='20060927']

[DrByte]

You just upgraded your site from v1.2.x to v1.3.x but didn't upgrade the database too.

Run zc_install/index.php and choose "Database Upgrade" on the system-inspection page (NOT "install").

[maggiesmom1]

Okay, I'm trying to do that, and this is what I get:

Warning: main(includes/modules/pages/index/header_php.php) [function.main]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/zc_install/index.php on line 38

Warning: main(includes/modules/pages/index/header_php.php) [function.main]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/zc_install/index.php on line 38

Warning: main(includes/modules/pages/index/header_php.php) [function.main]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/zc_install/index.php on line 38

Fatal error: main() [function.require]: Failed opening required 'includes/modules/pages/index/header_php.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bfpvrjqf/public_html/store/zc_install/index.php on line 38


The index.php from zc_install is:

<?php
/**
* index.php -- This is the main hub file for the Zen Cart installer *
* @package Installer
* @access private
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: index.php 4022 2006-07-25 01:07:37Z drbyte $
*/

define('IS_ADMIN_FLAG',false);
require('includes/application_top.php');

/* This is for debug purposes to run installer from SSH command line. Set to true to enable it: */
if (false) {
if ($argc > 0) {
for ($i=1;$i<$argc;$i++) {
$it = split("=",$argv[$i]);
$_GET[$it[0]] = $it[1];
// parse_str($argv[$i],$tmp);
// $_REQUEST = array_merge($_REQUEST, $tmp);
}
}
}

if (!isset($_GET['main_page']) || !zen_not_null($_GET['main_page'])) $_GET['main_page'] = 'index';
$current_page = $_GET['main_page'];
$page_directory = 'includes/modules/pages/' . $current_page;
$language_page_directory = 'includes/languages/' . $language . '/';
require('includes/languages/' . $language . '.php');

// init vars:
$zc_first_field = '';

// lang must be loaded before the header module
require('includes/languages/' . $language . '/' . $current_page . '.php');
require($page_directory . '/header_php.php');

require(DIR_WS_INSTALL_TEMPLATE . 'common/html_header.php');
require(DIR_WS_INSTALL_TEMPLATE . 'common/main_template_vars.php');
require(DIR_WS_INSTALL_TEMPLATE . 'common/tpl_main_page.php');
?>

[DrByte]

The error is:

main([zc_install/]includes/modules/pages/index/header_php.php) [function.main]: failed to open stream: No such file or directory

(note, I added the [zc_install/] for clarification, since in "this" particular case, you're working from within the zc_install folder already).

Re-upload that file, as your FTP program must have missed it. It may have missed others too.

I recommend FileZilla , and I discourage against use of smartftp or cuteftp due to their frequent timeout problems

[maggiesmom1]

Thank you - that worked & I got the upgrade done. However now when I rediredted to the store, I get this error:

Warning: main(includes/auto_loaders/config.core.php) [function.main]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90

Warning: main(includes/auto_loaders/config.core.php) [function.main]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90

Warning: main(includes/auto_loaders/config.core.php) [function.main]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90

Warning: main() [function.include]: Failed opening 'includes/auto_loaders/config.core.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90

Warning: dir(includes/auto_loaders) [function.dir]: failed to open dir: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 91

Fatal error: Call to a member function on a non-object in /home/bfpvrjqf/public_html/store/includes/counter.php on line 23

[DrByte]

Same type of problem:

includes/auto_loaders/config.core.php) [function.main]: failed to open stream: No such file or directory

[maggiesmom1]

Can you tell me exactly what file/folder I'm missing?
store/ncludes/auto_loaders/config.core.php is there. Is there a different folder I'm missing?? I deleted the zc_install folder after the upgrade was successful & the screen told me to delete it.

[DrByte]

just like the error message says:

/includes/auto_loaders/config.core.php


Perhaps you have set your file-permissions too tight for your server.
Normally 755 for folders and 644 for files is suitable.
Who knows what *your* web host requires.

What is your server's errorlog saying when you get these messages?

[maggiesmom1]

Server's errorlog says this:

[Thu Sep 28 20:02:53 2006] [error] [client 68.249.171.166] File does not exist: /home/bfpvrjqf/public_html/404.shtml
[Thu Sep 28 20:02:53 2006] [error] [client 68.249.171.166] File does not exist: /home/bfpvrjqf/public_html/favicon.ico
[Thu Sep 28 20:02:11 2006] [error] [client 68.249.171.166] File does not exist: /home/bfpvrjqf/public_html/404.shtml
[Thu Sep 28 20:02:11 2006] [error] [client 68.249.171.166] File does not exist: /home/bfpvrjqf/public_html/favicon.ico
[Thu Sep 28 20:02:10 2006] [error] [client 68.249.171.166] File does not exist: /home/bfpvrjqf/public_html/404.shtml
[Thu Sep 28 20:02:10 2006] [error] [client 68.249.171.166] File does not exist: /home/bfpvrjqf/public_html/favicon.ico
[Thu Sep 28 20:02:10 2006] [error] PHP Fatal error: Call to a member function on a non-object in /home/bfpvrjqf/public_html/store/includes/counter.php on line 23
[Thu Sep 28 20:02:10 2006] [error] PHP Warning: dir(includes/auto_loaders) [<a href='function.dir'>function.dir</a>]: failed to open dir: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 91
[Thu Sep 28 20:02:10 2006] [error] PHP Warning: main() [<a href='function.include'>function.include</a>]: Failed opening 'includes/auto_loaders/config.core.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90
[Thu Sep 28 20:02:10 2006] [error] PHP Warning: main(includes/auto_loaders/config.core.php) [<a href='function.main'>function.main</a>]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90
[Thu Sep 28 20:02:10 2006] [error] PHP Warning: main(includes/auto_loaders/config.core.php) [<a href='function.main'>function.main</a>]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90
[Thu Sep 28 20:02:10 2006] [error] PHP Warning: main(includes/auto_loaders/config.core.php) [<a href='function.main'>function.main</a>]: failed to open stream: No such file or directory in /home/bfpvrjqf/public_html/store/includes/application_top.php on line 90

[DrByte]

Please post your /includes/configure.php file here, without the password

Who's your host?