Post by svavrek » Thu Jan 23, 2014 5:43 am

OC 1.5.5.1 and vQmod 2.4.1
Installed DAP and ever since then, the site is messed up.
Kept getting weird 1054 errors, found out that people just added tables to the sql file or something that was missing, so I did that, got the site to at least load now, but when you click on product categories, NOTHING works - just loads a blank white page...

http://www.aquaticasuperstore.com/superstore/

Advise, please... so pissed, 2 months of learning and work down the drain with 1 install...
Last edited by svavrek on Thu Jan 23, 2014 11:19 pm, edited 1 time in total.

New member

Posts

Joined
Sat May 11, 2013 12:05 am

User avatar
Active Member

Posts

Joined
Sat Mar 30, 2013 12:27 am
Location - Springfield, MA

Post by svavrek » Thu Jan 23, 2014 10:37 am

Holy crap I have a lot of errors today... LOL! So... these errors came up and what I found on google and opencart forums was that the "unknown column" of "discounts" in the database "yfa_category" did not exist, so the posts all said to make them... so I opened up phpMyAdmin and found the yfa database associated here (listed) and added the tables "discounts" and others listed... I probably f'ed something up but I have no idea how to get it back... I at least got the site working to the point where it's online again but now I have no idea how to get categories to work. Thank you, in advance, for your help!

2014-01-22 13:05:00 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '109' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:08:56 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:09:22 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:11:36 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:13:29 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:18:36 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:22:43 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '109' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:23:14 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:24:58 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:25:05 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:27:24 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:27:32 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:28:05 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:28:09 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:28:57 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:29:14 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:29:15 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:32:29 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '85' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:32:35 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '137' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:40:43 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts, parent_id as cid FROM yfa_category WHERE category_id = '74' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:41:37 - PHP Notice: Error: Unknown column 'discount' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discount FROM yfa_customer_group WHERE customer_group_id = '1' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:41:58 - PHP Notice: Error: Unknown column 'discount' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discount FROM yfa_customer_group WHERE customer_group_id = '1' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:42:26 - PHP Notice: Error: Unknown column 'discount' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discount FROM yfa_customer_group WHERE customer_group_id = '1' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50
2014-01-22 13:46:01 - PHP Notice: Error: Unknown column 'discounts' in 'field list'<br />Error No: 1054<br />SELECT DISTINCT discounts FROM `yfa_option` WHERE option_id = '47' in /home/public_html/aquaticasuperstore/superstore/system/database/mysql.php on line 50

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by svavrek » Thu Jan 23, 2014 10:39 am

keep in mind this STARTED when I put in that damn Display as Percentage discount extension that I wasted $12.00 on... and that I have very little SQL experience, more php experience, and that the mysql.php file on line 50 is a blank line...

Adding on... I also found that if these two tables - 'discount' and 'discounts' are NOT in the yfa_category sql thingy that the ENTIRE SITE fails with these 1054 errors... if these tables are in, the site works, individual products work, but category display does not... as you can see on the site. I can click it, the URL shows up, but never loads a page...

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by svavrek » Thu Jan 23, 2014 8:21 pm

One more thing I noticed... if I have these tables in the sql database as listed above, the categories still don't work - just blank pages - but it does not log an error... if I remove the tables 'discount' and 'discounts', it logs a ton of errors... Really unhappy at the moment. I backed up the whole deal via System-->Backup-->Select All-->Backup. Have the DB on the PC now, even tried to install a whole new version of OC in a different area and restore this backup (the one prior to me screwing with it) and it won't load...

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by svavrek » Thu Jan 23, 2014 10:45 pm

Added some code this morning to the index.php file and found this....

Parse error: syntax error, unexpected 'else' (T_ELSE) in /home//public_html/aquaticasuperstore/superstore/vqmod/vqcache/vq2-catalog_controller_product_category.php on line 160

ITS VQMOD... >:D

Let's go on and fix us some php... here goes :)

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by svavrek » Thu Jan 23, 2014 10:47 pm

This is that file.... vq2-catalog_controller_product_category.php

Here is the code from lines 160-166

Code: Select all

			} else {
				$image = $this->model_tool_image->resize($result['image'], 125, 125);
				$this->data['categories'][] = array(
					'name'  => $result['name'],
					'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url),
					'thumb' => $image
				);	
What's the problem?

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by svavrek » Thu Jan 23, 2014 11:20 pm

Just deleted vQmod. Screwed everything up, no longer care. Removed it, replaced with original index.php files in root and admin, works like a freakin charm.

New member

Posts

Joined
Sat May 11, 2013 12:05 am
Who is online

Users browsing this forum: No registered users and 6 guests