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...
If you can, turn on error reporting or look at your error logs and post what you've got!
[module] PayPal Pro w/Recurring Profiles FREE
[module] 1 Click "Amazon Style" Checkout w/PayPal Pro FREE
[module] Adjustable PayPal Pro Fee FREE
[module] Add Sample To Cart LITE FREE
The guide to fixing just about everything wrong with OpenCart FREE!
Add INFINITE SCROLL to your homepage for FREE!
Live update product price for FREE!
Dynamic generation of Opencart coupon, FREE!
Hire me
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
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...
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...

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

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
);
[module] PayPal Pro w/Recurring Profiles FREE
[module] 1 Click "Amazon Style" Checkout w/PayPal Pro FREE
[module] Adjustable PayPal Pro Fee FREE
[module] Add Sample To Cart LITE FREE
The guide to fixing just about everything wrong with OpenCart FREE!
Add INFINITE SCROLL to your homepage for FREE!
Live update product price for FREE!
Dynamic generation of Opencart coupon, FREE!
Hire me
Users browsing this forum: No registered users and 34 guests