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...
Totally blank pages like this are almost always PHP errors!
If you can, turn on error reporting or look at your error logs and post what you've got!
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
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
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
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...
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...
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...
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...
Let's go on and fix us some php... here goes
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
This is that file.... vq2-catalog_controller_product_category.php
Here is the code from lines 160-166
What's the problem?
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
); Hey - that's great! I'm glad you got your site up & running again!
[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
Who is online
Users browsing this forum: No registered users and 33 guests
