[BETA] Upgrade Script: 1.4.0 to 1.4.3

Post by PCwhoop » Thu Mar 25, 2010 6:16 am

Post by srunyon1 » Sat Mar 27, 2010 2:42 pm

Post by allenshea » Sun Mar 28, 2010 10:51 am

I know nothing about PHP and SQL, but I still try my best to understand it.

Post by basics » Mon Mar 29, 2010 9:17 pm

allenshea wrote:

Qphoria wrote:I am working on a way to make it a bit easier to automate the differences and pass that diff script into an upgrade template for future upgrades.

Hi, Q, can you kindly update this Script? Since Daniel released new version, 1.4.5. he changed Database again.

Thanks!

Allen

This would be great if you could do it, I have just had to restore my shop after making a right old hash of the upgrade

........................................................................
http://www.basicsdesignerclothing.co.uk
........................................................................

Post by allenshea » Thu Apr 01, 2010 10:37 am

// Add "invoice_id" to order table
$sql = "DESC `" . DB_PREFIX . "order` invoice_id";
$query = $db->query($sql);
if (!$query->num_rows) {
	$sql = "
	ALTER TABLE `" . DB_PREFIX . "order` ADD COLUMN `invoice_id` int(11) collate utf8_unicode_ci NOT NULL Default '0';
	";
}
$db->query($sql);

// Add "invoice_prefix" to order table
$sql = "DESC `" . DB_PREFIX . "order` invoice_prefix";
$query = $db->query($sql);
if (!$query->num_rows) {
	$sql = "
	ALTER TABLE `" . DB_PREFIX . "order` ADD COLUMN `invoice_prefix` varchar(10) collate utf8_bin NOT NULL;
	";
}
$db->query($sql);

I know nothing about PHP and SQL, but I still try my best to understand it.

Post by Mouka » Thu Apr 01, 2010 6:20 pm

Post by allenshea » Thu Apr 01, 2010 7:16 pm

I know nothing about PHP and SQL, but I still try my best to understand it.

Post by fmucar » Fri Apr 02, 2010 8:45 am

Post by Qphoria » Fri Apr 02, 2010 11:54 am

Post by fmucar » Sat Apr 03, 2010 6:44 am

Post by Qphoria » Sat Apr 03, 2010 7:47 am

Post by GhostHunt » Wed Apr 07, 2010 5:04 am

Post by i2Paq » Wed Apr 07, 2010 5:09 am

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.

Post by GhostHunt » Wed Apr 07, 2010 5:16 am

Post by SiteE@se » Wed Apr 07, 2010 5:38 am

GhostHunt wrote:I modify the admininstrator to allow access. So I think I figured that problem out
but the store is bascially blank, I can see my data is still there but the store is not displaying
any categories or products?

I seem to recall having a similar problem and, if I remember correctly, I simply went into my root category and then saved it again. Warning - at my age memories fade quickly!

Post by GhostHunt » Wed Apr 07, 2010 6:43 am

Post by zch0071 » Wed Apr 07, 2010 10:23 pm

Post by Qphoria » Thu Apr 08, 2010 12:01 am

Post by tigerton » Fri Apr 09, 2010 4:56 pm

Post by HKOCH » Fri Apr 09, 2010 5:42 pm