Post by The Alchemist » Mon Jul 26, 2010 11:53 pm

Im trying to update to a higher version and not finding it easy.

I had to restore my site back to its original form because I failed my first attempt to update to 1.4.8.

Now the admin works, but the front end doesnt.

I get this code.

Code: Select all

Error: Table 'axidworks.store' doesn't exist
Error No: 1146
SELECT * FROM store WHERE url = 'http://axidworks.com/' OR url = 'http://axidworks.com/'
Someone help?

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by The Alchemist » Mon Jul 26, 2010 11:55 pm

Another thing that is weird is that on the admin section you can log in under anything at all, not password protected or anything

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by i2Paq » Tue Jul 27, 2010 12:00 am

Start over?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by The Alchemist » Tue Jul 27, 2010 12:22 am

You know what I did that.


A complete fresh install for the site.

When I tired to upload my pre saved data base, I needed to create a new database to start this new version to.

But since the database names are different, from the orignal to the new, it did not take.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by Qphoria » Tue Jul 27, 2010 12:50 am

1.4.8 doesn't support (or at least ive never tested) uploading your old db to a fresh install. I created the db upgrade script instead.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Xsecrets » Tue Jul 27, 2010 1:24 am

well you might be able to upload your old db then run the upgrade script against it right?

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by The Alchemist » Tue Jul 27, 2010 4:12 am

Okay I am pretty confused as to what is going on here.

I had 1.4.0 and I want to go to 1.4.8.

I installed the new 1.4.8 and tried to install the old database which is named axidworks

The new database I added is called acidthealchemist

I think that was the issue.

Since I have 2 databases I want to delete the old data base entitled axidworks, than recreate an empty database called axidworks as well.

Than upload my old saved data base from 1.4.0 to the 1.4.8

But you are telling me that the 2 are not compatible. So I need to run some script in the database to make them compatible.

My site is down at the moment, and is pretty nerve racking, Im at my other job for the next 8 hours. I would like to get something back up so that my site works again.

If someone can assist me in a succesful install to 1.4.8 using my old data base, I can compensate. If no one is intrested Ill continue on my own here, but dont know exactly what Im doing here and just hacking in stuff really.


Thanks

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by Xsecrets » Tue Jul 27, 2010 5:06 am

look at the upgrade documentation for 1.4.8b It tells you how to do an upgrade. Basically all the upgrade does is modify the database to be compatible with the new version. So all you really need to do an upgrade is the config files from the root and admin and the db. So what you can do is upload all the files from 1.4.8b except the configure files. then run the upgrade script as described in the upgrade documentation. That should get you upgraded to 1.4.8b

if you don't have any of the old files I suppose you could do a fresh install into an empty database and once you are done drop that database and import your old one then run the upgrade script.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by The Alchemist » Tue Jul 27, 2010 12:15 pm

Well this is what I am going to do now.

Upload the fresh version to the site. Delete the one database called axidworks, than open a new database with the same name, and go from there.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by The Alchemist » Tue Jul 27, 2010 9:38 pm

Ok, site is uploaded and when I tried to upload my old DB backup I got this message

Code: Select all

Error: Table 'axidworks.faq' doesn't exist
Error No: 1146
TRUNCATE TABLE `faq`
Where can I find the script to run?

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by The Alchemist » Wed Jul 28, 2010 1:27 pm

What is the script I need to run?

I PMed Q, but he didnt bother responding.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by Xsecrets » Wed Jul 28, 2010 1:58 pm

you need to read the files included with the download. in particular for your case the upgrade.txt file

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by The Alchemist » Thu Jul 29, 2010 9:57 pm

I have read threw the directions that come with the upgrade.txt.

I think I did what it wanted me to do.

Keep the old config files from 1.4.0 and just edit them.

Well that didnt work to good.

Code: Select all

Notice: Constant HTTP_SERVER already defined in /home/content/a/x/i/axidworks/html/index.php on line 54

Notice: Constant HTTP_IMAGE already defined in /home/content/a/x/i/axidworks/html/index.php on line 55

Notice: Constant HTTPS_SERVER already defined in /home/content/a/x/i/axidworks/html/index.php on line 61

Notice: Constant HTTPS_IMAGE already defined in /home/content/a/x/i/axidworks/html/index.php on line 62
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/a/x/i/axidworks/html/index.php:54) in /home/content/a/x/i/axidworks/html/system/library/session.php on line 11Notice: Undefined index: token in /home/content/a/x/i/axidworks/html/admin/controller/error/not_found.php on line 15Notice: Undefined index: token in /home/content/a/x/i/axidworks/html/admin/controller/error/not_found.php on line 21
Fatal error: Call to a member function isLogged() on a non-object in /home/content/a/x/i/axidworks/html/admin/controller/common/header.php on line 69
Is on the front page and

Code: Select all

Fatal error: Call to a member function getProducts() on a non-object in /home/content/a/x/i/axidworks/html/catalog/controller/module/cart.php on line 22
Is on the admin.

Here is a copy of my config file in the root.

Code: Select all

<?php

// DIR
define('DIR_APPLICATION', '/home/content/a/x/i/axidworks/html/admin/');
define('DIR_SYSTEM', '/home/content/a/x/i/axidworks/html/system/');
define('DIR_DATABASE', '/home/content/a/x/i/axidworks/html/system/database/');
define('DIR_LANGUAGE', '/home/content/a/x/i/axidworks/html/admin/language/');
define('DIR_TEMPLATE', '/home/content/a/x/i/axidworks/html/admin/view/template/');
define('DIR_CONFIG', '/home/content/a/x/i/axidworks/html/system/config/');
define('DIR_IMAGE', '/home/content/a/x/i/axidworks/html/image/');
define('DIR_CACHE', '/home/content/a/x/i/axidworks/html/system/cache/');
define('DIR_DOWNLOAD', '/home/content/a/x/i/axidworks/html/download/');
define('DIR_LOGS', '/home/content/a/x/i/axidworks/html/system/logs/');
define('DIR_CATALOG', '/home/content/a/x/i/axidworks/html/catalog/');

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'xxxx');
define('DB_USERNAME', 'xxxx');
define('DB_PASSWORD', 'xxxx');
define('DB_DATABASE', 'xxxxxx');
define('DB_PREFIX', '');
?>
And here is a copy of the admin/config

Code: Select all

<?php

// HTTP

define('HTTP_SERVER', 'http://www.axidworks.com/');

define('HTTP_IMAGE', 'http://www.axidworks.com/image/');



// HTTPS

define('HTTP_SERVER', 'http://www.axidworks.com/');

define('HTTP_IMAGE', 'http://www.axidworks.com/image/');



// DIR

define('DIR_APPLICATION', '/home/content/a/x/i/axidworks/html/catalog/');

define('DIR_SYSTEM', '/home/content/a/x/i/axidworks/html/system/');

define('DIR_DATABASE', '/home/content/a/x/i/axidworks/html/system/database/');

define('DIR_LANGUAGE', '/home/content/a/x/i/axidworks/html/catalog/language/');

define('DIR_TEMPLATE', '/home/content/a/x/i/axidworks/html/catalog/view/theme/');

define('DIR_CONFIG', '/home/content/a/x/i/axidworks/html/system/config/');

define('DIR_IMAGE', '/home/content/a/x/i/axidworks/html/image/');

define('DIR_CACHE', '/home/content/a/x/i/axidworks/html/system/cache/');

define('DIR_DOWNLOAD', '/home/content/a/x/i/axidworks/html/download/');

define('DIR_LOGS', '/home/content/a/x/i/axidworks/html/system/logs/');



// DB

define('DB_DRIVER', 'mysql');

define('DB_HOSTNAME', '');

define('DB_USERNAME', '');

define('DB_PASSWORD', '');

define('DB_DATABASE', '');

define('DB_PREFIX', '');

?>
If it makes any difference I did get the success from step 5 and 6 on my site.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by The Alchemist » Thu Jul 29, 2010 10:00 pm

Since its a fresh install on 1.4.8 which means that 1.4.0 is non existant on my site, is the upgrade script looking for the 1.4.0 files?

Does that mean I have to upload 1.4.0 to my site, than reupload 1.4.8 to my site once again.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by Xsecrets » Thu Jul 29, 2010 10:05 pm

the upgrade script only acts on the database not the files.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by The Alchemist » Thu Jul 29, 2010 10:07 pm

Ok, thanks for the reply but the site is still non-functional after I followed the directions, I need this problem fixed.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by Xsecrets » Thu Jul 29, 2010 11:15 pm

The Alchemist wrote:I have read threw the directions that come with the upgrade.txt.

I think I did what it wanted me to do.

Keep the old config files from 1.4.0 and just edit them.

Well that didnt work to good.

Code: Select all

Notice: Constant HTTP_SERVER already defined in /home/content/a/x/i/axidworks/html/index.php on line 54

Notice: Constant HTTP_IMAGE already defined in /home/content/a/x/i/axidworks/html/index.php on line 55

Notice: Constant HTTPS_SERVER already defined in /home/content/a/x/i/axidworks/html/index.php on line 61

Notice: Constant HTTPS_IMAGE already defined in /home/content/a/x/i/axidworks/html/index.php on line 62
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/a/x/i/axidworks/html/index.php:54) in /home/content/a/x/i/axidworks/html/system/library/session.php on line 11Notice: Undefined index: token in /home/content/a/x/i/axidworks/html/admin/controller/error/not_found.php on line 15Notice: Undefined index: token in /home/content/a/x/i/axidworks/html/admin/controller/error/not_found.php on line 21
Fatal error: Call to a member function isLogged() on a non-object in /home/content/a/x/i/axidworks/html/admin/controller/common/header.php on line 69
doesn't look like you read the file too good. from the upgrade.txt file

Code: Select all

STEP 3. If using 1.4.0 or earlier, Edit your config.php file in the root path of your store. 
Remove the following lines:

	//HTTP

	define('HTTP_SERVER', 'http://www.mysite.com/');

	define('HTTP_IMAGE', 'http://www.mysite.com/image/');



	// HTTPS

	define('HTTPS_SERVER', '');

	define('HTTPS_IMAGE', '');

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by The Alchemist » Thu Jul 29, 2010 11:25 pm

They are removed I attached a copy of my root config file above you will notice it is removed

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am

Post by Xsecrets » Fri Jul 30, 2010 12:57 am

well if they were removed you would not be getting the duplicate constant error. so you must be getting new errors. what are they? Also are you using the default theme? cause if you are trying to use a theme that is written for 1.4.0 on 1.4.8 there will be lots of problems.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by The Alchemist » Fri Jul 30, 2010 12:47 pm

I am using a fresh install on 1.4.8. Nothing is modded.

User avatar
Active Member

Posts

Joined
Sun Nov 22, 2009 11:04 am
Who is online

Users browsing this forum: Ahrefs [Bot], barnettgs and 110 guests