Closed jeeveser closed 11 years ago
The original GroupsCatalog extension doesn't work with Magento 1.6 or newer. It is still available on Magento Connect though, but it is no longer maintained or supported.
The new GroupsCatalog2 extension works fine with Magento 1.6 and also the newest 1.7.0.2.
In order to see the error messages please turn on developer mode, and enable the display_errors php setting. Also, please check the file var/log/exception.log
That is strange. You say the GroupsCatalog doesn't work with 1.6 or newer? Because I'm using in on my other store. My 1.7. Seems to work fine.
I'll try reinstalling the GroupsCatalog2 on the new store one more time.
NOPE, I just reinstalled it. It kills my backend of 1.7.2.
Something's gotta be wrong. Want to take a look?
GroupsCatalog 1.6 has a number of architectural issues (e.g. the paging and such). GroupsCatalog2 is much more reliable (plus more). Please follow the comments from my first answer and let me know the results: "In order to see the error messages please turn on developer mode, and enable the display_errors php setting. Also, please check the file var/log/exception.log"
"In order to see the error messages please turn on developer mode, and enable the display_errors php setting. Also, please check the file var/log/exception.log"
How do I do this?
My front end crashed too.
A simple google search provides plenty of answers on how to turn on developer mode. Here is one easy way to do so:
In the fine index.php in the Magento root directory, you find the code:
if (isset($_SERVER['MAGE_IS_DEVELOPER_MODE'])) {
Mage::setIsDeveloperMode(true);
}
Comment out the condition so it looks like this:
//if (isset($_SERVER['MAGE_IS_DEVELOPER_MODE'])) {
Mage::setIsDeveloperMode(true);
//}
After that error messages will be displayed.
Also, check the log I mentioned earlier.
Closing issue since no further input from original poster.
Please use this Issue instead of opening a new one for the same problem. I'll close #28 . Also, just asking for help isn't enough. Above I gave detailed instructions how to get more information, that is critical to enable me to help you. Posting useless screenshots is just a waste of pixels.
So, follow the instructions and I'll do my best to help. But you have to do your part.
I went to the index.php file and this is already commented out:
//if (isset($_SERVER['MAGE_IS_DEVELOPER_MODE'])) { Mage::setIsDeveloperMode(true); //}
I didn't have to do it, it already was.
how do I do this? enable the display_errors php setting
Heres what's currently in the exception log. I don't know what to look for:
2012-12-21T22:09:58+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/app/code/core/Mage/Adminhtml/Model/Config/Data.php on line 135
Trace: #0 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/Model/Config/Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2012-12-21T22:48:29+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/app/code/core/Mage/Adminhtml/Model/Config/Data.php on line 135
Trace: #0 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/Model/Config/Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T02:44:57+00:00 ERR (3):
exception 'Mage_Core_Exception' with message 'Error: couldn't connect to host' in /home3/northct6/public_html/app/Mage.php:594
Stack trace:
#0 /home3/northct6/public_html/includes/src/Mage_Linkpoint_Model_Linkpoint.php(919): Mage::throwException('Error: couldn't...')
#1 /home3/northct6/public_html/includes/src/Mage_Linkpoint_Model_Linkpoint.php(616): Mage_Linkpoint_Model_Linkpoint->_linpointapi(Array)
#2 /home3/northct6/public_html/includes/src/Mage_Linkpoint_Model_Linkpoint.php(114): Mage_Linkpoint_Model_Linkpoint->_postRequest(Object(Mage_Linkpoint_Model_Linkpoint_Request))
#3 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order_Payment.php(1026): Mage_Linkpoint_Model_Linkpoint->authorize(Object(Mage_Sales_Model_Order_Payment), 12.5)
#4 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order_Payment.php(311): Mage_Sales_Model_Order_Payment->_authorize(true, 12.5)
#5 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order.php(877): Mage_Sales_Model_Order_Payment->place()
#6 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order.php(1095): Mage_Sales_Model_Order->_placePayment()
#7 /home3/northct6/public_html/includes/src/Mage_Core_Model_Resource_Transaction.php(105): Mage_Sales_Model_Order->place()
#8 /home3/northct6/public_html/includes/src/Mage_Core_Model_Resource_Transaction.php(159): Mage_Core_Model_Resource_Transaction->_runCallbacks(Array)
#9 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Service_Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
#10 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Service_Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
#11 /home3/northct6/public_html/includes/src/Mage_Checkout_Model_Type_Onepage.php(774): Mage_Sales_Model_Service_Quote->submitAll()
#12 /home3/northct6/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(511): Mage_Checkout_Model_Type_Onepage->saveOrder()
#13 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Checkout_OnepageController->saveOrderAction()
#14 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch()
#15 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match('saveOrder')
#16 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch(Object(Mage_Core_Controller_Request_Http))
#17 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run()
#18 /home3/northct6/public_html/index.php(87): Mage::run(Array)
#19 {main}
2013-01-09T02:45:27+00:00 ERR (3):
exception 'Mage_Core_Exception' with message 'Error: couldn't connect to host' in /home3/northct6/public_html/app/Mage.php:594
Stack trace:
#0 /home3/northct6/public_html/includes/src/Mage_Linkpoint_Model_Linkpoint.php(919): Mage::throwException('Error: couldn't...')
#1 /home3/northct6/public_html/includes/src/Mage_Linkpoint_Model_Linkpoint.php(616): Mage_Linkpoint_Model_Linkpoint->_linpointapi(Array)
#2 /home3/northct6/public_html/includes/src/Mage_Linkpoint_Model_Linkpoint.php(114): Mage_Linkpoint_Model_Linkpoint->_postRequest(Object(Mage_Linkpoint_Model_Linkpoint_Request))
#3 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order_Payment.php(1026): Mage_Linkpoint_Model_Linkpoint->authorize(Object(Mage_Sales_Model_Order_Payment), 12.5)
#4 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order_Payment.php(311): Mage_Sales_Model_Order_Payment->_authorize(true, 12.5)
#5 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order.php(877): Mage_Sales_Model_Order_Payment->place()
#6 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Order.php(1095): Mage_Sales_Model_Order->_placePayment()
#7 /home3/northct6/public_html/includes/src/Mage_Core_Model_Resource_Transaction.php(105): Mage_Sales_Model_Order->place()
#8 /home3/northct6/public_html/includes/src/Mage_Core_Model_Resource_Transaction.php(159): Mage_Core_Model_Resource_Transaction->_runCallbacks(Array)
#9 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Service_Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
#10 /home3/northct6/public_html/includes/src/Mage_Sales_Model_Service_Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
#11 /home3/northct6/public_html/includes/src/Mage_Checkout_Model_Type_Onepage.php(774): Mage_Sales_Model_Service_Quote->submitAll()
#12 /home3/northct6/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(511): Mage_Checkout_Model_Type_Onepage->saveOrder()
#13 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Checkout_OnepageController->saveOrderAction()
#14 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch()
#15 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match('saveOrder')
#16 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch(Object(Mage_Core_Controller_Request_Http))
#17 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run()
#18 /home3/northct6/public_html/index.php(87): Mage::run(Array)
#19 {main}
2013-01-09T02:53:54+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T04:03:18+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T04:04:31+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T04:19:07+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T04:37:19+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T04:42:29+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
2013-01-09T04:58:52+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135
Trace: #0 /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php(135): mageCoreErrorHandler(8, 'Trying to get p...', '/home3/northct6...', 135, Array)
#1 /home3/northct6/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(165): Mage_Adminhtml_Model_Config_Data->save()
#2 /home3/northct6/public_html/includes/src/__default.php(13582): Mage_Adminhtml_System_ConfigController->saveAction()
#3 /home3/northct6/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('save')
#4 /home3/northct6/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5 /home3/northct6/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home3/northct6/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home3/northct6/public_html/index.php(87): Mage::run('', 'store')
#8 {main}
Thanks for the log data, might be useful. Good to know your developer mode already is enabled, someone must have commented out those lines already.
If the developer mode is enabled, the frontend will display a real error message and not the There has been an error processing your request page. Please tell me what that error message is.
Also, to enable php error display, put the following line into your .htaccess file (at the very end) in the Magento root directory:
php_flag display_errors 1
I took your extension off. Because I could not log in at all or access the back end.
Line has been added to .htaccess and the result is this: http://www.northcoastcreations.com
Do you want me to install this extension and break it again?
I can't access the site, I get a host name not found error. If possible, yes, reinstall the module while developer mode and display_error is turned on, and please post the error message, so I can follow up what is causing this issue for you.
Well it didn't crash the backend this time, but I'm still getting errors. On the config page it says 404 error.
Here is what the error logs say:
MAIN error_log:
[Fri Jan 18 18:17:06 2013] [error] [client 75.111.209.247] Failed loading /usr/lib64/php/modules/ZendOptimizer.so: /usr/lib64/php/modules/ZendOptimizer.so: undefined symbol: zend_throw_exception_internal [Fri Jan 18 18:17:12 2013] [error] [client 66.249.73.4] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace. [Fri Jan 18 18:17:12 2013] [error] [client 66.249.73.4] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace. [Fri Jan 18 18:17:13 2013] [error] [client 66.249.74.235] Premature end of script headers: index.php [Fri Jan 18 18:17:13 2013] [error] [client 66.249.74.235] Premature end of script headers: 500.php [Fri Jan 18 18:17:14 2013] [error] [client 66.249.73.194] File does not exist: /usr/local/apache/htdocs/index.php [Fri Jan 18 18:17:20 2013] [error] [client 89.36.197.202] Failed loading /usr/php/53/usr/lib64/php/modules/ZendGuardLoader.so: /usr/php/53/usr/lib64/php/modules/ZendGuardLoader.so: undefined symbol: gc_remove_zval_from_buffer, referer: https://zvelo.com/ [Fri Jan 18 18:17:20 2013] [error] [client 66.249.74.151] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace. [Fri Jan 18 18:17:20 2013] [error] [client 66.249.74.151] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.
PHP error_log: /home3/northct6/public_html/error_log: #4 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #5 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #6 /home3/northct6/public_html/app/c in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 144 [17-Jan-2013 16:30:15] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->construct('mysql:host=loca...', 'northct6_mgnN', 'XXXXXXXX', Array) #1 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(313): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /home3/northct6/public_html/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql->_connect() #4 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #5 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #6 /home3/northct6/public_html/app/c in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 144 [17-Jan-2013 16:30:15] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->construct('mysql:host=loca...', 'northct6_mgnN', 'XXXXXXXX', Array) #1 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(313): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /home3/northct6/public_html/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql->_connect() #4 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #5 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #6 /home3/northct6/public_html/app/c in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 144 [17-Jan-2013 16:30:15] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:host=loca...', 'northct6_mgnN', 'XXXXXXXX', Array) #1 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(313): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /home3/northct6/public_html/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql->_connect() #4 /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #5 /home3/northct6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #6 /home3/northct6/public_html/app/c in /home3/northct6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 144
Thank you for those, but none of these errors are from the Magento error log. Can you please check for the file var/log/exception.log and var/log/system.log in the Magento root directory? Thanks!
Hi Vinai,
i get this error. Maybe, they have the same error too:
[xdebug_message] => ( ! ) PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`magento`.`groupscatalog_product_idx`' already exists in C:\wamp\www\lib\Zend\Db\Statement\Pdo.php on line 228
Call Stack
10.0009378528{main}( )..\index.php:0 20.0117763656Mage::run( )..\index.php:87 30.02721998664Mage_Core_Model_App->run( )..\Mage.php:683 40.06693059320Mage_Core_Model_App->_initModules( )..\App.php:343 50.52526022992Mage_Core_Model_Resource_Setup::applyAllUpdates( )..\App.php:417 60.57018087040Mage_Core_Model_Resource_Setup->applyUpdates( )..\Setup.php:235 70.57038085104Mage_Core_Model_Resource_Setup->_installResourceDb( )..\Setup.php:327 80.57038085200Mage_Core_Model_Resource_Setup->_modifyResourceDb( )..\Setup.php:421 90.57378140096include( 'C:\wamp\www\app\code\community\Netzarbeiter\GroupsCatalog2\sql\netzarbeiter_groupscatalog2_setup\install-0.1.0.php' )..\Setup.php:624 100.97229052608Varien_Db_Adapter_Pdo_Mysql->createTable( )..\install-0.1.0.php:122 110.97339063200Varien_Db_Adapter_Pdo_Mysql->query( )..\Mysql.php:2039 121.74149064440Zend_Db_Adapter_Pdo_Abstract->query( )..\Mysql.php:419 131.74159064440Zend_Db_Adapter_Abstract->query( )..\Abstract.php:238 141.74249069328Zend_Db_Statement->execute( )..\Abstract.php:479 151.74249069328Varien_Db_Statement_Pdo_Mysql->_execute( )..\Statement.php:300 161.74249069360Zend_Db_Statement_Pdo->_execute( )..\Mysql.php:110 171.74249069392PDOStatement->execute( )..\Pdo.php:228
)
[xdebug_message] => ( ! ) PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`magento`.`groupscatalog_product_idx`' already exists in C:\wamp\www\lib\Zend\Db\Statement\Pdo.php on line 228
Call Stack
10.0009378528{main}( )..\index.php:0
20.0117763656Mage::run( )..\index.php:87
30.02721998664Mage_Core_Model_App->run( )..\Mage.php:683
40.06693059320Mage_Core_Model_App->_initModules( )..\App.php:343
50.52526022992Mage_Core_Model_Resource_Setup::applyAllUpdates( )..\App.php:417
60.57018087040Mage_Core_Model_Resource_Setup->applyUpdates( )..\Setup.php:235
70.57038085104Mage_Core_Model_Resource_Setup->_installResourceDb( )..\Setup.php:327
80.57038085200Mage_Core_Model_Resource_Setup->_modifyResourceDb( )..\Setup.php:421
90.57378140096include( 'C:\wamp\www\app\code\community\Netzarbeiter\GroupsCatalog2\sql\netzarbeiter_groupscatalog2_setup\install-0.1.0.php' )..\Setup.php:624
100.97229052608Varien_Db_Adapter_Pdo_Mysql->createTable( )..\install-0.1.0.php:122
110.97339063200Varien_Db_Adapter_Pdo_Mysql->query( )..\Mysql.php:2039
121.74149064440Zend_Db_Adapter_Pdo_Abstract->query( )..\Mysql.php:419
131.74159064440Zend_Db_Adapter_Abstract->query( )..\Abstract.php:238
141.74249069328Zend_Db_Statement->execute( )..\Abstract.php:479
151.74249069328Varien_Db_Statement_Pdo_Mysql->_execute( )..\Statement.php:300
161.74249069360Zend_Db_Statement_Pdo->_execute( )..\Mysql.php:110
171.74249069392PDOStatement->execute( )..\Pdo.php:228
( ! ) Zend_Db_Statement_Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento
.groupscatalog_product_idx
' already exists in C:\wamp\www\lib\Zend\Db\Statement\Pdo.php on line 234
Call Stack
10.0009378528{main}( )..\index.php:0 20.0117763656Mage::run( )..\index.php:87 30.02721998664Mage_Core_Model_App->run( )..\Mage.php:683 40.06693059320Mage_Core_Model_App->_initModules( )..\App.php:343 50.52526022992Mage_Core_Model_Resource_Setup::applyAllUpdates( )..\App.php:417 60.57018087040Mage_Core_Model_Resource_Setup->applyUpdates( )..\Setup.php:235 70.57038085104Mage_Core_Model_Resource_Setup->_installResourceDb( )..\Setup.php:327 80.57038085200Mage_Core_Model_Resource_Setup->_modifyResourceDb( )..\Setup.php:421 90.57378140096include( 'C:\wamp\www\app\code\community\Netzarbeiter\GroupsCatalog2\sql\netzarbeiter_groupscatalog2_setup\install-0.1.0.php' )..\Setup.php:624 100.97229052608Varien_Db_Adapter_Pdo_Mysql->createTable( )..\install-0.1.0.php:122 110.97339063200Varien_Db_Adapter_Pdo_Mysql->query( )..\Mysql.php:2039 121.76629150320Varien_Db_Adapter_Pdo_Mysql->_debugException( )..\Mysql.php:422
)
Error in file: "C:\wamp\www\app\code\community\Netzarbeiter\GroupsCatalog2\sql\netzarbeiter_groupscatalog2_setup\install-0.1.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento
.groupscatalog_product_idx
' already exists
Thanks for the response, @endidu. The error you are posting happens if the extension is reinstalled after an incomplete uninstall. The tables groupscatalog_product_idx and groupscatalog_category_idx already exist.
Actually, the install script handles that condition, see the highlighted lines here: https://github.com/Vinai/groupscatalog2/blob/master/app/code/community/Netzarbeiter/GroupsCatalog2/sql/netzarbeiter_groupscatalog2_setup/install-0.1.0.php#L72-L76
For some reason the tables can't be dropped, maybe missing privileges of the DB user?
To fix the issue, please remove the tables, wither through a GUI of your choice or by running the SQL DROP TABLE IF EXISTS groupscatalog_product_idx; DROP TABLE IF EXISTS groupscatalog_category_idx;
Then try reloading any page to trigger the update script again.
Thanks for your quick response. Yes, you're right. I have reinstalled. I already tried to drop the tables. But I can not find them: "MySQL lieferte ein leeres Resultat zurück (d.h. null Datensätze)". I have privileges, i can drop any other table. How can i fix this problem?
I don't know what is going on there in your instance. Are you working in the correct database? The error message indicates the tables already exist. Sorry, can't be of further help . If you find out anything new please let me know.
Hi, I finally located the logs you are referring to.
here is the exception log: [...many of the following...]
`2013-01-09T04:58:52+00:00 DEBUG (7): Exception message: Notice: Trying to get property of non-object in /home3/northct6/public_html/includes/src/Mage_Adminhtml_Model_Config_Data.php on line 135 Trace:
and the system log:
[...many of the following...]
2012-12-20T02:39:55+00:00 DEBUG (7): HEADERS ALREADY SENT: [0] /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Response/Http.php:52 [1] /home3/northct6/public_html/lib/Zend/Controller/Response/Abstract.php:766 [2] /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Response/Http.php:83 [3] /home3/northct6/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php:188 [4] /home3/northct6/public_html/app/code/core/Mage/Core/Model/App.php:354 [5] /home3/northct6/public_html/app/Mage.php:683 [6] /home3/northct6/public_html/index.php:87
Thank you for the logs (I have removed the duplicate entries from the post to make it more readable).
It shows that you are using the Magento compiler. Every time you install an extension or upgrade anything, you have to recompile the Magento source. Follow the following steps:
I do that. Every time I install it.
And every time I Compile it it CRASHES!!! Just after installing!
Frustrating.
So does it run without compiling?
No.
Without hands-on debugging there is nothing I can do. I would need access to the Magento admin area, the source, and the database for that. If you are willing to provide that (either remotely or as a tar archive) I can have a look, otherwise I'm afraid there is nothing I can do to help. If you want to send credentials or private links you can do so via email to vinai@netzarbeiter.com.
Just following up with this. I sent my info to your email... did you get it?
Hi jeeveser, sorry, I haven't responded earlier. Now I'll hopefully have a little space to have a look - also sent you an email. Could you please give me a heads-up if this is still current for you?
hi, we don't seem to be having an issue with it now. Thanks Michelle Laycock
Hi, We are using the original Netzarbeiter_GroupsCatalog on our first store (ver. 1.7.2) we built in August. It is working fine. We are building a 2nd store and I manually installed (not through Magento Connect) the upgraded Netzarbeiter_GroupsCatalog2 and it turns our backend into a blank page with only the admin header.
Is there anywhere I can download the original Netzarbeiter_GroupsCatalog (I can't use Magento Connect because that function for some reason isn't working) or do you happen to know why the Netzarbeiter_GroupsCatalog2 doesn't work on our ver 1.7.2?
Thanks in advance.
Michelle