Problem: mysql SQL Install file does not exist

[cnymike]

I've had a disastrous time attempting to upgrade from 1.2 to 1.3.7.1

First off, I attempted to backup my original database before attempting any of the upgrade steps and I also did a backup of the zencart installation directory.

Even though my control panel indicated the the database was backed up and even though I downloaded and duplicated that backup to my computer, I have discovered to my horror that the backup did not either complete or something else happened but I discovered that the backup failed for reasons I do not understand. IN any case, to compound this error, I accidentally dropped the database tables for my original database when in fact I was attempting to drop the tables for the newly installed database, into which I was going to import the old database.

Fortunately all is not a total loss because I have a backup of the database from earlier in the year and although it is somewhat out of date, I still have something to work with.

So I installed a fresh version of Zen Cart 1.3.7.1 in a test directory. I had already created a new "test" database. I tried to import my old database into the new one but as I've already stated, that did not work because of the mistakes and errors that occurred. So instead I imported the much older backup of the database which I had and was then attempting to go through the database upgrade script. But I immediately encountered an error that said
"mysql SQL Install file does not exist" I checked the directory and it does exist, so the script is not seeing it for some reason.

I checked my configure.php file and it seems to be correct but I'm no expert, so maybe something is wrong in there.

Can someone point me in the direction I should be heading here to help my figure this out?

[cnymike]

Here is some additional information regarding inspection results and other system information that was flagged during installation of zen cart...

# Webserver = Apache/2.2.4
# HTTP Host = www.xxxxxx.com
# Path_Translated = /usr/www/users/xxxxxx/store-v1371/zc_install/index.php
# Server Free Disk Space = 12.12 GB
# PHP O/S = FreeBSD
# PHP API Mode = cgi Click here for more info
# PHP Max Execution Time per page = 30
# Register Globals = ON Click here for more info
# MySQL Version = 5.0.45-log Click here for more info
# PHP Output Buffering (gzip) = OFF

[cnymike]

Things have only gotten worse as I bludgeon my way through this...

My webhost said they were able to restore an older backup of the database. So I deleted the old database entirely and created a new database. I then used phpmyadmin to Import the old database into the new. As soon as I attempted this I got the following error in phpmyadmin

I fear I am screwed but am hoping someone more knowledgeable can chime in.

Michael

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 6
STR: />
SQL:
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in <b>/usr/www/users/xxxxxx/MyAdmin/libraries/ob.lib.php</b> on line <b>64</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in <b>/usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php</b> on line <b>13</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in <b>/usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php</b> on line <b>14</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in <b>/usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php</b> on line <b>15</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in <b>/usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php</b> on line <b>16</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in <b>/usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php</b> on line <b>19</b><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?server=6&amp;token=xxxxxxxx&amp;js_frame=right&amp;nocache=xx xxxxxx" />
<link rel="stylesheet" type="text/css" href="./css/print.css?server=6&amp;token=xxxxxxxx" media="print" />
<script type="text/javascript" language="javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'xxxxxx.xxxx.com / topiary_store / topiary_store / zen_whos_online | phpMyAdmin 2.10.2';


SQL query:


Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in /usr/www/users/xxxxxx/MyAdmin/libraries/ob.lib.php on line 64

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in /usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php on line 13

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in /usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in /usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php on line 15

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in /usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php on line 16

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/xxxxxx/MyAdmin/export.php:187) in /usr/www/users/xxxxxx/MyAdmin/libraries/header_http.inc.php on line 19

[DrByte]

attempting to go through the database upgrade script. But I immediately encountered an error that said
"mysql SQL Install file does not exist" I checked the directory and it does exist, so the script is not seeing it for some reason.

The script attempts to load the sql upgrade files from the zc_install/sql folder. It cycles through each required file based on all the checkboxes you select on the database-upgrade screen.

Try checking only one box at a time, doing each step individually. Otherwise it's very difficult to know "which" one it's having a problem with.

Also, check to be sure that all your zc_install files were uploaded and that none of them are 0-bytes in size, esp the files in zc_install/includes/classes, zc_install/includes/functions, zc_install/includes/modules/pages, zc_install/includes/templates ... ya, basically everything.

[cnymike]

I reinstalled the zencart zip file v.1.3.7.1 and unzipped. All files appear to be in directories.

I dumped the old database tables.

I imported a database which I believe to be 1.1.4 patch 1, into the new database using phpmyadmin. I immediately got the same errors as I reported in my first post.

Dead end and not any further along.

[cnymike]

I ended up reinstalling 1.3.7.1 again and found an older backup of my database that I was finally able to upgrade based on DrByte suggestions in another thread. So although I can't specifically say what the problem was, I have gotten past this problem.